Filters control security access to data values, or cells, in a database. Filters are the most granular form of security available in Essbase.
When you use Filter Editor to create a filter, you designate a set of restrictions on particular database cells or on a range of database cells. You can then assign the filter to any users or groups on the Essbase Server. Filter information is stored in the Essbase security file (essbase.sec). For complete information about filters and controlling access to database cells, see the Oracle Essbase Database Administrator's Guide.
Your own security permissions determine how you can create, assign, edit, copy, rename, or delete filters:
If you have Administrator permissions, you can manage any filter for any user or group. Filters do not affect you.
If you have Create/Delete Applications permissions, you can manage filters for the applications that you created.
If you have Application Manager or Database Manager permissions, you can manage filters within your applications or databases.
To manage filters for a database:
From Enterprise View or a custom view, select a database.
Right-click and select Edit, then Filters.
The Filters window displays all filters for that database. From the Filters window, you can perform the following tasks:
“Controlling Access to Database Cells” in the Oracle Essbase Database Administrator's Guide
alter filter (MaxL) in the Oracle Essbase Technical Reference