cancel
Showing results for 
Search instead for 
Did you mean: 

Disable "Open Data Source"

Former Member
0 Kudos

We have a requirement to prevent end users from being able to create a query from SAP data from MSFT Analysis for Excel. These particular users will not be able to create reports, just view cubes/reports that have been created for them. Is this something that can be established with Access Level tweaking or will a macro need to be used?

Your advice/suggestions are appreciated.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Tammy,

Thank you for your great suggestion! I will get into this and reply with results.

Regards,

Alain

TammyPowlas
Active Contributor
0 Kudos

I am wondering if you could customize the Analysis Office ribbon - see http://scn.sap.com/thread/3495039

Another idea is to use the BW authorizations so they can only view/execute (03, 16) authorization activities