OLAP Member-Level Permissions

How to Assign an OLAP Permission Condition

To assign an OLAP permission condition, complete these steps:

  1. In SAS Management Console, navigate to

    Environment Management
    [arrow]
    Authorization Manager
    [arrow]
    Resource Management
    [arrow]
    By Location
    [arrow]
    <your application server>
    [arrow]
    <your OLAP schema>
    [arrow]
    <your cube>
    [arrow]
    Dimensions
    and double-click the dimension for which you are defining a permission condition.
  2. In the dimension's Properties dialog box, select the Authorization tab.

  3. On the Authorization tab, select (or add) the user or group whose read access you want to limit with a permission condition.

  4. In the permissions list, add a direct grant of the Read permission for the identity that you selected. The Add Condition button is now enabled.

    [untitled graphic]

    Notice that the check box for the Read permission has no added background color; this indicates that the permission is directly granted.
  5. Click Add Condition to open the Permission Condition dialog box.

  6. In the Permission Condition dialog box, enter an MDX expression that filters the current dimension as appropriate for the identity that you selected in step 3.

  7. Click OK to save the permission condition.

Related Topics

Access Requirements for OLAP Data

Example: Denying Most Users Read Permission to a Particular OLAP Cube

space
Previous Page | Next Page | Top of Page