Essbase Studio Roles

Table 31. Essbase Studio Roles

RoleDescription

cpViewer

Viewer

  • Views and previews all Essbase Studio artifacts, including metadata elements (dimension elements, hierarchies, data sets, alias sets, drill-through reports) and data source connections

  • Executes drill-through reports

cpDSAdmin

Data Source Administrator

  • Has all privileges of cpViewer

  • Creates, updates, and destroys data source connections

cpDM

Data Modeler (administrator of metadata elements)*

  • Has all privileges of cpViewer

  • Creates, updates, and destroys metadata elements (dimension elements, hierarchies, cube schemas, Essbase models, alias sets, drill-through reports)

  • Deploys Essbase cubes and updates cube linkage in Essbase cubes

cpDMDSAdmin

Administrator*

Has all privileges of cpDSAdmin and cpDM

Note:

This role is obtained by selecting both the cpDM and cpDSAdmin roles when provisioning.

cpAdmin

System Administrator*

  • Has all privileges of cpDMDSAdmin

  • Export/imports Essbase Studio catalog and selected Essbase Studio catalog artifacts

  • Upgrades Essbase Studio catalog

* To deploy cubes in Essbase Studio, cpDM, cpDMDSAdmin, and cpAdmin users must be provisioned for, at the minimum, the Shared Services Project Manager role. Users also require an Essbase Server role such as Create/Delete Application or Administrator.