BookmarkSubscribeRSS Feed
Manish
SAS Employee
We have following requirements for one of the largest FMCG customer in India

1.Ability to download data into read-only pivot table in excel.
2.Disable drill to detail data in pivot table
3.Disable some of the SAS Menu options like ‘Open SAS datasets in worksheets’ and server connection

We would like to know whether it's possible to implement above in Sp4. If not then is there any plans to incorporate above features in any of the future releases?
1 REPLY 1
Bill_SAS
SAS Employee
To answer your three issues:

1.Ability to download data into read-only pivot table in excel.
If by read-only you mean the user can't write back changes to the OLAP server, then yes this works in SP4. If you instead mean precluding the modification of OLAP data behind the pivot table, the addin does not have the ability to stop that from happening.

2.Disable drill to detail data in pivot table
Drill through to detail has not been enabled for the 2.1 version (SP4). We are planning on enabling drill though to detail in a future release and that will be limited to cubes that allow drill through (use Cube Studio to set this flag).

3.Disable some of the SAS Menu options like ‘Open SAS datasets in worksheets’ and server connection
Disabling these kinds of functions is not possible with the 2.1 release. We are working on this kind of IT admin controls in the next release. Can you explain why these specific items need to be disabled? I don't believe that the open SAS data item is currently on our list.

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!

Discussion stats
  • 1 reply
  • 760 views
  • 0 likes
  • 2 in conversation