topic Re: Dynamically linking to WRS with parameters from Stored Process .. how to ?? in SAS Web Report Studio

Dynamically linking to WRS with parameters from Stored Process .. how to ??

TwanManders — Fri, 04 Jun 2010 12:20:13 GMT

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?

Re: Dynamically linking to WRS with parameters from Stored Process .. how to ??

Madelyn_SAS — Fri, 04 Jun 2010 19:43:22 GMT

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?

Re: Dynamically linking to WRS with parameters from Stored Process .. how to ??

AngelaHall — Fri, 04 Jun 2010 19:48:33 GMT

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

Re: Dynamically linking to WRS with parameters from Stored Process .. how to ??

TwanManders — Tue, 08 Jun 2010 12:49:07 GMT

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;

Re: Dynamically linking to WRS with parameters from Stored Process .. how to ??

jplarios — Wed, 09 Jun 2010 18:56:24 GMT

Angela,
will row level work the same way for a cube source?

Re: Dynamically linking to WRS with parameters from Stored Process .. how to ??

AngelaHall — Tue, 15 Jun 2010 13:32:02 GMT

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/en/bisecag/61133/HTML/default/a003139312.htm

~ Angela
http://sas-bi.blogspot.com

Re: Dynamically linking to WRS with parameters from Stored Process .. how to ??

jplarios — Fri, 18 Jun 2010 14:04:51 GMT

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.

Re: Dynamically linking to WRS with parameters from Stored Process .. how to ??

AngelaHall — Fri, 18 Jun 2010 14:35:25 GMT

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