Source Manager
- Click here to see an overview of Pyramid's Application Security Framework
At the data model level, admins can manage access to given hierarchies, measures, and member elements by enabling or disabling selected user roles. Admins can also edit the metadata overlay of hierarchies and measures.
Materialized Data Manager for End Users
A slimmed down version of the Data Source Manager - the "Materialized Data Manager" or "MDM" - is available for proficient end users (who are not admins) who have been granted the right to build their own data models. Admins who access the MDM will be able to access almost identical functionality to the Data Source Manager.
Interface
The Data Source Manager presents users with a point and click interface, allowing you to set the required security and metadata preferences easily.
- Server management: review general information about the selected server, set security for the server, and review and manage its databases.
- Database management: review general information about the selected database, configure database security, and manage the database's models.
- Data model management: review general information about the model, set model security, and manage model elements and security (hierarchies, measures, levels and members).
Note: To configure data security and metadata for MS OLAP, Tabular, SAP Hana and BW models, the Use 'Security & Metadata' Overlays option must be enabled from the server setup page.
Data Catalog
The meta data presented to end users through the various models in Pyramid very much perform a centralized data cataloging function. By allowing admins and developers to annotate and categorize all the various columns of data in a data model, and then present this unified description of these elements to end users within the main data discovery tools, Pyramid fulfills the key functions of a data catalog for data models.
If this is further combined with the metadata and data lineage capabilities of the different analytic content items found through the platform, Pyramid offers a robust, self-bulding data catalog engine.
- Users can then view the catalog through interactive tool-tips or via exporting the catalog to PDF.