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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.