topic Re: OLAP cube report creation in SAS Web Report Studio

OLAP cube report creation

MG18 — Thu, 07 Sep 2017 12:40:49 GMT

I have created the one report using OLAP cube later OLAP is used as resource in info-map and this info-map is used in WRS to generate report.

hierarchy is in cube is bank --> zone ---> district --> branch. and report is running fine except below error :-

zone has the value A,B,C . When A is logged in then also A is accessible to B and C data which is not required.

How to achieve same in above example ?

Re: OLAP cube report creation

Madelyn_SAS — Thu, 07 Sep 2017 13:23:58 GMT

If you are asking about limiting results based on the user who is logged in you would need to use MDX expressions to secure the cube. See "Securing Cubes" in the SAS OLAP Server User's Guide:

http://support.sas.com/documentation/cdl/en/olapug/69844/HTML/default/viewer.htm#p0o4012mg42akan1snu...

Re: OLAP cube report creation

MG18 — Fri, 08 Sep 2017 05:48:23 GMT

Whatever link u have forwarded to me is for SAS 9.4 but we are using SAS 9.3 could you please send me the link for SAS9.3 ?

Re: OLAP cube report creation

MG18 — Fri, 08 Sep 2017 11:59:03 GMT

For SAS 9.3 the below mentioned link worked 🙂 :-

If you are asking about limiting results based on the user who is logged in you would need to use MDX expressions to secure the cube. See "Securing Cubes" in the SAS OLAP Server User's Guide:

http://support.sas.com/documentation/cdl/en/olapug/63148/HTML/default/viewer.htm#n0kme6xgwhlfoyn1f5mcjcg5pi2w.htm