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 ?
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:
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:
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
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 ?
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:
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.