Creating Security Filters

Security filters control access to data values or cells in the Oracle Essbase database. Filters are the most granular form of Essbase security access. While creating a filter, you designate restrictions on a database cell. Filter information is stored in essbase.sec on the Essbase server.

Filters can be assigned to Essbase users and groups.

To create a filter:

  1. Log in to Oracle Essbase Administration Services Console as a Functional Administrator or as a user provisioned with the Essbase Administrator role. See Accessing Administration Services Console.
  2. Under Essbase Servers, expand Applications.
  3. Expand the node representing the Essbase application for which you want to define security filters.
  4. Right-click the database for which you want to define security filters, select Create, and then Filters.
  5. Create the filter. Consult online help for assistance.