Database Manager Permission

If your user role in Essbase is User and you have Database Manager permission for a particular application, you can manage the cubes within the application.

With Database Manager permission for an application, you can do everything that a user with Database Update permission can do. Additionally, you can upload files to the cube directory, edit the cube outline, export the cube to an application workbook, and start/stop the cube using the web interface. Job types you can run include building dimensions, exporting data, and exporting the cube to a workbook.

As a Database Manager, you also have access to the database inspector, which gives you control of even more cube operations. To open the database inspector from the web interface, start with the Applications page, and expand the application. From the Actions menu to the right of the name of the cube you want to manage, click Inspect to launch the inspector.

Using the database inspector, you can:

• Enable scenarios or change the number of scenarios allowed
• Manage dimensions, including generation and level names
• Access and manage files related to the database
• Create and edit calculation scripts, drill through reports, MaxL scripts, MDX scripts, report scripts, and rules files for dimension building and data loading
• Assign users permissions to execute calculation scripts
• Create and assign filters to grant or restrict data access for specific users and groups. You can assign filters, for your cube, to any users or groups who are already provisioned to use the application (an Application Manager or higher must provision users).
• Manage cube-level substitution variables
• View locked cube objects and data blocks
• View and change database settings
• View database statistics
• View and export audit records from the web interface