Is there a way to turn off the Drilling or Expanding options in a web report?
Specifically, I'd like to turn off the Expanding option (little blue '+' sign) in our production environment for one of our reports.
Thanks!
-Jeff
You should be able to control this functionality using the Web Report Studio roles. The capabilities that you want to control are beneath the "OLAP" category. In this category you can enable or disable the following: Drill, Drill to Detail, Expand and Collapse, and Expand And Collapse All.
Note that if you want to enable or disable specific features for certain users, we recommend that you create a custom role. We recommend this because there is no way to return to the 'out of the box' settings after you have modified one of the built-in roles.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
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.