Div | ||
---|---|---|
| ||
Using a Domain allows you to create a virtual view that is made and stored in the server without modifying the original data source. Databases typically contain data in tables that are optimized for storage and retrieval. In order to be rendered for presentation, columns with data relevant to users need to be joined across several tables, filtered by business needs, secured against unauthorized access, and labelled using user-friendly names. In relational databases, a view can perform some of these functions. In the server, a Domain performs all of these functions, and more (such as the localization of report text and permissions based on data values).
Through a Domain, users see columns that have been joined, filtered, and labelled for their specific business needs. Security policies limit the data values accessible by users through a Domain. Administrators with organizational privileges define Domains for users to create reports using the Ad Hoc Editor.
Domains (and Topics) are used in the Zoola™ Ad Hoc Editor as a basis for designing reports. Users can save a report based on a Domain for others to run, and can also save the settings in a Domain Topic so that others can design similar reports.
Domains, like Topics, are used in the Ad Hoc Editor as a basis for designing reports. Users can save a report based on a Domain for others to run, and can also save the settings in a Domain Topic so others can design similar Reports.
Using a Domain instead of a Topic has the following advantages:
...