1. Using Oracle Essbase
  2. Calculate Cubes
  3. Access to Calculations

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 Applications page, open the application.
  2. Click Customization, and then 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 Image of the Redwood Add icon. next to a user.
  5. Click Close Image of the redwood close icon. 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 Image of the Redwood Add icon..
    5. Click Add Image of the Redwood Add icon. next to the user name.
    6. Click Close Image of the redwood close icon..
    7. The user is displayed as a member of the script.
  1. On the Applications page, click the Actions menu to the right of the application name.
  2. Select Inspect, and then select Permissions.
  3. Click Add Image of the Add icon. on the right-hand side of the dialog box.

    A list of users and groups is displayed.

  4. Click Add Image of the add icon. next to a user.
  5. Select Database Update.
  6. Grant calculation script access.
    1. On the Applications page, expand the application and click the Actions menu to the right of the cube name.
    2. Select Inspect, and then select Scripts.
    3. Select Calculation Scripts.
    4. Click on the script name.
    5. Select Roles.
    6. Click Add Image of the Add icon..
    7. Click Add Image of the Add icon. next to the user name.
    8. Click Close.

      The user is displayed as a member of the script.
      Image of the Roles tab in the calc script editor, showing calcuser1 as being a provisioned user for the script.