Note: | This functionality does not apply if Essbase Server is in EPM System security mode. You must use the Shared Services Console to manage calculation permissions when Essbase Server is in EPM System security mode. |
If you have permissions to Create/Delete Users and Groups for an Essbase Server, you can grant specific calculation permissions to users and groups on a per-database basis. If you grant Calculation permissions to a user or group for a database, you can also specify which calculation scripts the user or group is allowed to execute. You can grant permission to execute all calculation scripts saved on the Essbase Server, or you can select from the calculation scripts that are associated with the database. If you grant permissions to execute all calculation scripts, any scripts defined thereafter are automatically added to the user's or group's calculation permissions. You can modify user and group calculation permissions at any time.
Selecting calculation scripts is relevant only for users or groups with Database Access permissions. By default, Administrators, Application Managers, and Database Managers can execute all calculation scripts.
You can define calculation permissions for a user different perspectives:
To grant calculation permissions to a user or group while editing user/group permissions::
From Enterprise View or a custom view, under the appropriate Essbase Server, expand the Security node.
Under the Security node, double-click the Users or Groups node.
In the Users window or the Groups window, select a user or group.
Right-click and select Edit properties.
If you selected a user, the User Properties window is displayed.
If you selected a group, the Group Properties window is displayed.
Note:
You cannot edit properties for multiple users or groups simultaneously.
Select App/Db Access.
If the user or group has Administrator permissions, the App/Db Access tab is not selectable because Administrators have full access to all applications and databases. All applications and databases on the Essbase Server are displayed in a navigation tree. For each application and database, the current permissions for the selected user or group are displayed.
Find the application that contains the appropriate database, and select Access Databases as the application permission.
Expand the application node and then find the database for which you want to grant calculation permissions.
Click next to the desired database, and select Calculation.
Expand the database node, and for the Calculations node, do one of the following:
To grant the user or group permission to execute all calculation scripts, select Allow all calculations.
To grant the user or group permission to execute only specific calculation scripts, select Select calculation scripts, and select the appropriate scripts.
Click Apply.
To grant database calculation permissions while working with databases:
From Enterprise View or a custom view, select the database.
Right-click and select User/group access.
The User/Group Access window displays a hierarchical tree view of applications and databases on the left and tables of users or groups on the right.
Select the option to display all users or groups or only to display users or groups with permissions to access the selected application or database.
Select a tab: Users or Groups.
Select a user or group.
For a user or group with the Application Access permission defined as Access Databases:
To grant permissions for performing calculations, in the Database Access column, select Calculations.
To remove permissions for performing calculations, in the Database Access column, select an option different from Calculations.
To make calculation script assignments for a user or group with Calculations permission, click Assign Calculations.
In Assign Calculations, to enable or disable use of all calculation scripts, click or clear Assign all calculations.
To assign individual calculation scripts, click the single-arrow or double-arrow buttons to move calculation scripts between Available Calculations and Selected Calculations.
When finished, click Close.