Create Filters

You can create multiple filters for a cube. If you edit a filter, modifications made to its definition are inherited by all users of that filter.

See Controlling Access to Database Cells Using Security Filters.

1. On the Applications home page, expand the application.
2. From the Actions menu, to the right of the cube name, launch the inspector.
3. Select the Filters tab.
4. Click Add .
5. Enter a filter name in the Filter Name text box.
6. In the Filter Editor, click Add
7. Under Access, click and use the drop-down menu to select an access level.

   • 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

     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).

8. Select the row under Member Specification and enter member names.

   You can filter members separately, or you can filter member combinations. Specify dimension or member names, alias names, member combinations, member sets that are defined by functions, or substitution variable names, which are preceded by an ampersand (&). Separate multiple entries with commas.

9. Create additional rows for the filter as needed.

   If filter rows overlap or conflict, more detailed cube area specifications apply over less detailed, and more permissive access rights apply over less permissive. For example, if you give a user Read access to Actual and Write access to Jan, then the user would have Write access to Jan Actual.

10. Click Validate to ensure that the filter is valid.
11. Click Save.

On the Filters tab in the inspector, you can edit a filter by clicking the filter name and making your changes in the Filter Editor.

You can copy, rename, or delete a filter by clicking the Actions menu to the right of the filter name and choosing an option.