From my SAS Portal i have to make a stored process that can capture an employee's department ( i use (_metaperson) and lookup in metadata for the department). Now i want to open automatically a Web Report with a parameter that holds the department and uses this information to show a Web Report with a filter for department.
for the membel-level ( OLAP source) will WRS be able to know who is entering ( like the _metaperson)? We have a table that explodes the hierarchy -between manager and supervisor which we currently use in an STP along with _metaperson. We eventually will use it with IM for row level ( but relational source). But will it work with an OLAP source? the 9.2 doc you pointed me too was not clear whether this member-level permissions are hard-coded or dynamic.
The MDX expression is hard coded within the 'Add Authorization' window, but the 'user' the expression is assigned to could be a group of people instead of an individual (in step 2b of the 9.2 Example referenced above).
Managing the users within the group could then be completed via SAS Management Console User Manager, and no additional modifications are required to the cube/report when data or users within the group change. WRS will use this metadata authorization to determine what the user can or cannot see.