AMO Requirements

[Manish]

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?

[Bill_SAS]

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.