BookmarkSubscribeRSS Feed
sasrac
SAS Employee
Hi All,

Is it possible to create a static report using WRS version 3.1 that has a cube source. The clients wants to prevent some users from drilling down the report. By if this is not possible in the WRS is it possible with the Portal 3.1?

Thanks,
5 REPLIES 5
Jenn2
SAS Employee
Dear Sasrac,
If I am understanding you correctly, one say is to export the report to an excel file where it becomes static. You can also print it to a PDF file.

I am hoping someone else chimes in to offer other suggestions within v3.1.
sasrac
SAS Employee
Hi Jenn2,

The client wants to see the report in the portal to be static. But the problem is the source is an OLAP cube that is drillable. Is there a way that we can block certain user from drilling down the report?

Thanks,
AngelaHall
SAS Employee
SASRAC,

Can you deselect the 'drill down' option within the Information Map?
This will not allow anyone to drill down into the detail data.

However, this will not affect the drill through capabilities of OLAP Cross-Tabular view. I haven't come across a way to 'lock' the cross-table view from modification.

Angela Hall
http://sas-bi.blogspot.com
Madelyn_SAS
SAS Super FREQ
In the information map, you can disable permission to "Navigate (drill up/drill down and expand/collapse)" for each hierarchy. Select Properties and then click the Permissions tab. This would be in effect for all users, however.
Madelyn_SAS
SAS Super FREQ
Just a note that WRS 4.2 allows you to prevent specific users from expanding, drilling down, refreshing data, etc. by using the new Roles capabilities.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 924 views
  • 0 likes
  • 4 in conversation