OLAP Member-Level Permissions |
Access the Authorization tab of the dimension 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 Resource Management By Location <your application server> <your OLAP schema> <your cube> Dimensions. In SAS OLAP Cube Studio, navigate to the dimension on the Inventory tab.
Select (or add) the user or group whose access to measures you want to limit.
In the permissions list, add an explicit grant of the Read permission for that user or group.
Click the Add Authorization button.
Note: If the Edit Authorization button is displayed, a condition already exists for the selected user or group.
In the Add Authorization dialog box, select the Create an advanced MDX expression radio button and click Build Formula.
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.
See Also
Copyright © 2011 by SAS Institute Inc., Cary, NC, USA. All rights reserved.