Access to Calculations

If you have the Database Update application permission, you have access to run the default calculation on the cube (from Smart View), and to run specific calculation scripts provisioned to you. If you have the Application Manager or Database Manager application permission, you have Calc privileges and rights to execute all calculations, and to provision access to execute specific calculation scripts.

To provision users access to execute calculation scripts in the Essbase web interface, first provision the user to that application with Database Update permission, then add the user on the Roles tab in the calc script editor.

1. On the Home page, open the application.
2. Click Permissions.
3. Click Add and a list of users and groups is displayed.

   Note:

   Clicking Add in this dialog does not allow you to add new users. Instead, you can add users that have already been provisioned using an identity provider. This topic assumes that you have users provisioned. There are several ways to provision Essbase users. See Manage Essbase User Roles and Application Permissions for independent deployments, or Manage Users and Roles for stack deployments.
4. Click Add user next to a user.
5. Click Close to close the user list.
6. Select Database Update for the added user.
7. Grant calculation script access,
   1. Select the General page of the open application, and open the database (cube).
   2. Click Scripts, and click Calculation Scripts.
   3. Click on the script name.
   4. Click Roles, and click Add members.
   5. Click Add user next to the user name.
   6. Click Close.
   7. The user is displayed as a member of the script.