Creating Filters

You can create a filter for each set of access restrictions you need to place on database values. You need not create separate filters for users with the same access needs. After you have created a filter, you can assign it to multiple users or groups of users. However, only one filter per database can be assigned to a user or group.

Note:

If you use a calculation function that returns a set of members, such as children or descendants, and it evaluates to an empty set, the security filter is not created. An error is written to the application log stating that the region definition evaluated to an empty set.

Before creating a filter, perform the following actions:

  To create a filter, use a tool:

Tool

Topic

Location

Administration Services

Creating or Editing Filters

Oracle Essbase Administration Services Online Help

MaxL

create filter

Oracle Essbase Technical Reference