Assigning Database Calculation and Filter Access

Note:

This topic does not apply to Essbase native security mode.

After provisioning users for Essbase applications in Shared Services Console, you can assign access permissions to users and groups for a specific Essbase application and database. For example, after assigning a user access and a role for the application, you can assign an Essbase filter to the user, or assign the user access to a specific calculation script. The Shared Services Console displays Essbase-specific screens that allow you perform these tasks.

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

Note:

The calculation scripts and filters must be created using Essbase.

For information about how to provision users in Shared Services, see the Oracle Hyperion Enterprise Performance Management System User and Role Security Guide.

  To assign database calculation and filter access to users and groups:

  1. In Shared Services, expand the Projects node and select an Essbase application.

  2. Right-click, and select Assign Access Control.

  3. From Available Users and Groups, select an item to display only users, only groups, or both.

    Essbase Administrators and Application Managers are not listed.

  4. Select the users, groups, or users and groups that you want to work with for the application.

  5. Optional: To make sure all recently provisioned users and groups are displayed, click Refresh.

  6. Click the arrow button to move selections to Selected Users and Groups. To move all users and groups, click the double arrow button.

  7. Click Next.

    This screen lists the users who have access to the application and displays their user roles.

  8. From Database, select an Essbase database.

  9. To assign an Essbase filter to users and groups:

    1. Select the check box next to each user and group to which you want to assign a filter.

    2. From Filter, select a filter.

      The filter list shows the filters for the selected database on Essbase Server.

  10. To assign users and groups access to an Essbase calculation script:

    1. Select the check box next to each user and group you want to assign calculation script access to.

    2. From the Calc drop-down, select the appropriate calculation scripts, or select All or None as appropriate.

      The calculation list is populated with the calculation scripts that exist for the selected database on Essbase Server.

  11. Optional: Perform an action:

    • To assign only calculation access, from Filter, select No update.

    • To assign only filter access, from Calc, select No update.

  12. Click the apply check mark next to Calc to apply your selections.

    Note:

    If you have not clicked Save, you can click Reset to revert to the original settings (or the last saved settings).

  13. Click Save.

    Status messages are displayed on a new screen. The changes are reflected immediately in Administration Services Console.

Related Information

Related Commands

grant (MaxL) in the Oracle Essbase Technical Reference