- This line was added.
- This line was removed.
- Formatting was changed.
The following repository objects provide a prepared connection to a data source for Ad Hoc view creation:
Topics: JRXML files created externally and uploaded to Zoola™ as a basis for Ad Hoc views.
DomainsData Sources: virtual views of a data source that present the data in business terms, allowing for localization and providing data-level security.
The Ad Hoc Editor contains the following panels, from left to right:
DomainData Source: [Domain Data Source Data Connection Name]: contains the fields, dimensions, and measures available in the source Domains Data Sources and/or Topic.
Ad Hoc View: the main view design panel.
Filters: Which defines a subset of data to retrieve from the data source.
You can also open and edit an existing Ad Hoc view to create a new Ad Hoc view.
Generally, an administrator creates a Topic. A Topic can also be created from a Domain Data Source 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 DomainData Source-based view).
To begin designing a Topic-based view, complete the following steps:
From the Home page, navigate to Create > Ad Hoc View.
In the Select Data Wizard, click the View As Tree icon .
Navigate to Ad Hoc Components > Topics.
Expand the Topics folder and select a Topic.
Click the OK button.
You can now begin working on your view in the Ad Hoc Editor.Domains
Administrators create Domains Data Sources that typically filter the data, create input controls, and manage the list of available fields and measures. A Domain Data Source 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 DomainData Source-based view, complete the following steps:
From the Home page, navigate to Create > Ad Hoc ViewViews > Create New.
In the the Select Data wizard, click the View As Tree icon . Expand the Domains folder and select a Domain Data Source.
Click the the Choose Data button, opening the Choose Data page.
From the Choose Data page, navigate through the left-panel options and 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 the the Save as Topic button to save the customized Domain Data Source Topic for later use.
You can now begin working on your view in the Ad Hoc Editor.