Source Manager

The Data Source Manager is where admins manage user access to data source servers, databases, data models and all related elements. This is also where admins can edit metadata overlays within data models, enabling them to ensure that the data is named and described to each user role in the required way. As security and metadata is role-based, the admin simply needs to assign the relevant roles to the selected items.

  • 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.


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.