You use the Filter Editor window to create or edit security filters. After you create a filter, you assign the filter to users or groups.
The Filter Definition tab of the Filter Editor window contains the following fields:
Filter name—For a new filter, enter a name (letters, numbers, and spaces; for length limits, see the Oracle Essbase Database Administrator's Guide). If the name of an existing filter is displayed, the field is read only.
Access: Apply an access level to the current member specification:
None: No data can be retrieved or updated.
Read: Data can be retrieved but not updated.
Write: Data can be retrieved and updated.
MetaRead: Metadata (dimension and member names) can be retrieved and updated.
Note: | The MetaRead access level overrides all other access levels. Additional data filters are enforced within existing MetaRead filters. Filtering on member combinations (using AND relationships) does not apply to MetaRead. MetaRead filters each member separately (using an OR relationship). |
Member Specification—Using the following guidelines, specify the dimensions or members to which to the level selected in the Access column is applied:
Specify dimension or member names; alias names; member combinations; member sets that are defined by Essbase functions; or substitution variable names, which are preceded by ampersands (&)
Separate multiple entries with commas.
Enter names manually, or select members or functions from the outline tree or the function tree. Names selected from the outline tree are automatically enclosed in double quotation marks (“name”). It is best practice to enclosed manually entered names in quotation marks.
In the Filter Editor window, you can select from the following trees:
The database outline with which the filter is associated. The outline can display member names or aliases. If you want to display the aliases of members that have aliases, select the “Use aliases” option, and, in the “Alias table” box, select an alias table.
Essbase member set functions, which define dimensions and members. You can view functions by category or by alphabetical order. If you want to insert an argument template into a function, select the Insert arguments option.
The Filter Editor window provides the following buttons:
Verify—To verify names and function syntax. Results are displayed in the Messages pane.
Delete—To delete a row from the Filter area
Save—Filter information is stored in the Essbase security file (essbase.sec).
alter filter (MaxL) in the Oracle Essbase Technical Reference