Previous Page | Next Page

OLAP Member-Level Permissions

How to Assign an OLAP Permission Condition

  1. Access the Authorization tab of the dimension [icon] for which you are defining a permission condition.

    Note:   In SAS Management Console, you can access dimensions on the Plug-ins tab under Authorization Manager [arrow] Resource Management [arrow] By Location [arrow] <your application server> [arrow] <your OLAP schema> [arrow] <your cube> [arrow] Dimensions. In SAS OLAP Cube Studio, navigate to the dimension on the Inventory tab.  [cautionend]

  2. Select (or add) the user or group whose access to measures you want to limit.

  3. In the permissions list, add an explicit [white check box] grant of the Read permission for that user or group.

  4. Click the Add Authorization button.

    Note:    If the Edit Authorization button is displayed, a condition already exists for the selected user or group.   [cautionend]

  5. In the Add Authorization dialog box, select the Create an advanced MDX expression radio button and click Build Formula.

    [untitled graphic]

  6. Use the Build Formula dialog box to create a filter that limits the current dimension as appropriate for the user or group that you selected on the Authorization tab. Identity-driven properties are available on the Data Sources tab under the Identity Values folder. See Identity-Driven Properties.

    [untitled graphic]

See Also

About OLAP Member-Level Permissions

Example: Using Member-Level Permissions

Previous Page | Next Page | Top of Page