BookmarkSubscribeRSS Feed
TwanManders
SAS Employee
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.

How to do this?
7 REPLIES 7
Madelyn_SAS
SAS Super FREQ
You can use the stored process to dynamically generate data for an information map and then use the map for the report. Will that work?
AngelaHall
SAS Employee
Why not skip the stored process altogether and use the 'derive identity values for row-level permissions' in the information map filter screen?

There is a SAS note that might be useful:
http://support.sas.com/kb/31/563.html


~ Angela
http://sas-bi.blogspot.com
jplarios
Quartz | Level 8
Angela,
will row level work the same way for a cube source?
AngelaHall
SAS Employee
The information map 'Derive identity values (for row-level permissions)' only works for relational tables, for OLAP cubes the reference provided by SAS for 9.1.3 =
http://support.sas.com/onlinedoc/913/getDoc/en/bisecag.hlp/a003139257.htm

for 9.2 =
http://support.sas.com/documentation/cdl/en/bisecag/61133/HTML/default/viewer.htm#/documentation/cdl...

~ Angela
http://sas-bi.blogspot.com
jplarios
Quartz | Level 8
Angela,
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.
AngelaHall
SAS Employee
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.

~ Angela
http://sas-bi.blogspot.com
TwanManders
SAS Employee
Thanx for your input ..

i'm still working on a pemanent solution but found out how to make a
direct link from within stored process on portal where i get fx. a portalside from metadata

file _webout;
put '';
run;

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 7 replies
  • 1326 views
  • 0 likes
  • 4 in conversation