https://communities.sas.com/t5/SAS-Web-Report-Studio/Static-WRS-Report-with-an-OLAP-Cube-source/m-p/29008#M448 Hi Jenn2,<BR /> <BR /> 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?<BR /> <BR /> Thanks, Mon, 14 Dec 2009 13:24:11 GMT sasrac 2009-12-14T13:24:11Z https://communities.sas.com/t5/SAS-Web-Report-Studio/Static-WRS-Report-with-an-OLAP-Cube-source/m-p/29005#M445 Hi All,<BR /> <BR /> 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?<BR /> <BR /> Thanks, Fri, 11 Dec 2009 01:10:55 GMT https://communities.sas.com/t5/SAS-Web-Report-Studio/Static-WRS-Report-with-an-OLAP-Cube-source/m-p/29005#M445 sasrac 2009-12-11T01:10:55Z https://communities.sas.com/t5/SAS-Web-Report-Studio/Static-WRS-Report-with-an-OLAP-Cube-source/m-p/29006#M446 Dear Sasrac,<BR /> 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. <BR /> <BR /> I am hoping someone else chimes in to offer other suggestions within v3.1. Fri, 11 Dec 2009 15:43:22 GMT https://communities.sas.com/t5/SAS-Web-Report-Studio/Static-WRS-Report-with-an-OLAP-Cube-source/m-p/29006#M446 Jenn2 2009-12-11T15:43:22Z https://communities.sas.com/t5/SAS-Web-Report-Studio/Static-WRS-Report-with-an-OLAP-Cube-source/m-p/29007#M447 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. Fri, 11 Dec 2009 21:27:33 GMT https://communities.sas.com/t5/SAS-Web-Report-Studio/Static-WRS-Report-with-an-OLAP-Cube-source/m-p/29007#M447 Madelyn_SAS 2009-12-11T21:27:33Z https://communities.sas.com/t5/SAS-Web-Report-Studio/Static-WRS-Report-with-an-OLAP-Cube-source/m-p/29008#M448 Hi Jenn2,<BR /> <BR /> 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?<BR /> <BR /> Thanks, Mon, 14 Dec 2009 13:24:11 GMT https://communities.sas.com/t5/SAS-Web-Report-Studio/Static-WRS-Report-with-an-OLAP-Cube-source/m-p/29008#M448 sasrac 2009-12-14T13:24:11Z https://communities.sas.com/t5/SAS-Web-Report-Studio/Static-WRS-Report-with-an-OLAP-Cube-source/m-p/29009#M449 SASRAC,<BR /> <BR /> Can you deselect the 'drill down' option within the Information Map?<BR /> This will not allow anyone to drill down into the detail data.<BR /> <BR /> 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.<BR /> <BR /> Angela Hall<BR /> <A href="http://sas-bi.blogspot.com" target="_blank">http://sas-bi.blogspot.com</A> Mon, 14 Dec 2009 20:42:26 GMT https://communities.sas.com/t5/SAS-Web-Report-Studio/Static-WRS-Report-with-an-OLAP-Cube-source/m-p/29009#M449 AngelaHall 2009-12-14T20:42:26Z https://communities.sas.com/t5/SAS-Web-Report-Studio/Static-WRS-Report-with-an-OLAP-Cube-source/m-p/29010#M450 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. Thu, 17 Dec 2009 18:41:21 GMT https://communities.sas.com/t5/SAS-Web-Report-Studio/Static-WRS-Report-with-an-OLAP-Cube-source/m-p/29010#M450 Madelyn_SAS 2009-12-17T18:41:21Z