I have requirement where I want to add prefilter in the final report but that filter should be hidden from user.
I am using OLAP cube for that report and displaying in WRS through SAS Infomap. Is it possible to add prefilter in SAS OLAP cube as now the option is not available in SAS InfoMap. Any Info available are welcome to share?
The Hide from User option for filters in the information map is for use with prefilters. However, you cannot create prefilters for OLAP data. Your only option is to create an MDX expression directly on the cube. This is described in
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
Do you need the filter for security reasons? For example, SAS Demo User should be able to see only information for North Carolina. Or do you want to filter results in the report but not allow users to change the filter value?
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
Yes I want to filter results in the report but not allow users to change the filter value and also the filter which I applied should not be visible to the end user while seeing the report.
@LinusH I understand but I have one doubt we can create filter in Information map studio for Cube Based report but when I am trying to hide the filter from user it is not filtering the data rather I am getting all the recorods from the table. Can you help me with this?
Thnx
To apply the filter you created in the information map in Web Report Studio, you would have to select Section Filters from the Options menu on the Section Data pane on the left, and specifically select the filter. It is not applied automatically. However, information about the filter is displayed if the person viewing the report has the Display Applied Filter preference turned on.
You might want to consider MDX permissions on the cube. You can do that via SAS Management Console. See
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
@Madelyn_SAS My requirement is to filter the data from the column and the filter which I apply should not be visible to all the end user....I know there is option of hide from user in SAS Information Map studio but when I am trying to set that I am not getting the filtered data also I am not getting pre filter option in Information Map studio when I am using SAS Olap Cube as source in Information Map studio.
The Hide from User option for filters in the information map is for use with prefilters. However, you cannot create prefilters for OLAP data. Your only option is to create an MDX expression directly on the cube. This is described in
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
@Madelyn_SAS Thank you for your Info....Now I have given normal filter for my report
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.
Ready to level-up your skills? Choose your own adventure.