The following repository objects provide a prepared connection to a data source for Ad Hoc view creation:
| • | Topics, JRMXL files created externally and uploaded to JasperReports Server as a basis for Ad Hoc views. |
| • | Domains, virtual views of a data source that present the data in business terms, allow for localization, and provide data-level security. |
| • | OLAP Connections, multi-dimensional views of data that allow users to analyze a large number of aggregate data levels. |
You can also open and edit an existing Ad Hoc view to create a new Ad Hoc view.
Topics
Generally, an administrator or Jaspersoft Studio user creates a Topic as a JRXML file. The JRXML topic is then associated with a data source in the server. A Topic can also be created from a Domain in the server. Both types of topics appear in the Select Data wizard when you create an Ad Hoc view.
Using a Topic as your source generates an empty view, which allows you to begin adding data to your view right away, without choosing, pre-filtering, or changing display names of the data (all of which are required steps when creating a Domain-based view).
To begin designing a Topic-based view:
| 1. | Launch the Ad Hoc Editor by clicking Create > Ad Hoc View. |
| 2. | In the Select Data wizard, click ![js-Dashboard-icon-ViewTree.png.a79751836976db0f77aa33eb45c131a8.png](https://community.jaspersoft.com/applications/core/interface/js/spacer.png) |
| 3. | Expand the Topics folder and select a topic. |
| 4. | Select the type of view you intend to create: table, chart, or crosstab. For an overview of view types, see Ad Hoc View Types. |
You can now begin working on your view in the Ad Hoc Editor.
Domains
Administrators create Domains that typically filter the data, create input controls, and manage the list of available fields and measures. A Domain specifies tables in the database, join clauses, calculated fields, display names, and default properties, all of which define items and sets of items for creating Ad Hoc views.
To begin designing a Domain-based view:
| 1. | Launch the Ad Hoc Editor by clicking Create > Ad Hoc View. |
| 2. | In the Select Data wizard, click ![js-Dashboard-icon-ViewTree.png.f42ca40e10636479092a8dfb2196b308.png](https://community.jaspersoft.com/applications/core/interface/js/spacer.png) |
| 3. | Expand the Domains folder and select a domain. |
| 4. | Click Choose Data..., and click the options on the left of the window to perform the following tasks: |
| • | Click Fields to select fields of data to use in the view. |
| • | Click Pre-filters to create filters to limit the data available in the Ad Hoc Editor. |
| • | Click Display to change the fields’ display names. |
| • | Click Save as Topic to save the customized topic for later use. |
| 5. | Select the type of view you want to create: table, chart, or crosstab. For an overview of view types, see Ad Hoc View Types. |
You can now begin working on your view in the Ad Hoc Editor.
OLAP Connections
Administrators create OLAP client connections that expose transactional data and define how the data can be seen as a multidimensional cube. An OLAP connection can expose multiple cubes in a single OLAP connection.
![note-icon-ns_28x28.png.06bffa98a35255191611be40e8fee8c6.png](https://community.jaspersoft.com/applications/core/interface/js/spacer.png) | With OLAP connections, you can create chart and crosstab views only. |
To begin designing an OLAP connection-based view:
| 1. | Launch the Ad Hoc Editor by clicking Create > Ad Hoc View. |
| 2. | In the Select Data wizard, click ![js-Dashboard-icon-ViewTree.png.761996eb60bc00b0f91b7779e4572919.png](https://community.jaspersoft.com/applications/core/interface/js/spacer.png) |
You can now begin working on your view in the Ad Hoc Editor.
For more information about OLAP-based view functionality, refer to the following sections:
Recommended Comments
There are no comments to display.