OLAP cube report creation

[MG18]

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 ?

[Madelyn_SAS]

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...

[MG18]

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 ? 

[MG18 · Accepted solution]

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#n0kme6xgwhlfoyn1f5m...