Assigning Database Calculation and Filter Access in Shared Services

After provisioning users for Essbase applications in Shared Services Console, you can assign more granular access permissions to users and groups for a specific Essbase application and database. For example, after assigning a user access to an application and assigning the user’s role for the application, you can assign an Essbase filter to the user, or assign the user access to a specific calculation script.

You must create the filters and calculation scripts in Essbase. See Controlling Access to Database Cells Using Security Filters.

When you select an Essbase application from Shared Services Console, you see a list of the users and groups provisioned to that application. You can select the users and groups to which you want to assign additional permissions. You then select the database to which a user or group needs access, and assign filter and calculation script access to selected users and groups. See the Shared Services Console online documentation.

  To specify access permissions in Shared Services, use a tool:

Tool

Topic

Location

Administration Services

Assigning Database Calculation and Filter Access

Oracle Essbase Administration Services Online Help

MaxL

grant

Oracle Essbase Technical Reference

When you assign database calculation and filter access, you automatically log on to Administration Services and Essbase as the Shared Services Console logged-in user. This user must be an Essbase Administrator, Application Manager, or Database Manager. The user must have the Provisioning Manager role for the appropriate applications.

You cannot assign database calculation or filter access to an Essbase Administrator or Application Manager.