Skip to Content
User Experience Insights
Author's profile photo Sahil Taneja

SAC (SAP Analytics Cloud) Access to export DATA from Models

I encountered a problem, where few SAP Analytics Cloud super users wanted to export data from the model. They were seeing the export button greyed out :

Export%20button%20greyed%20out

Export button greyed out

I read multiple articles, which talked about disabling the restriction of exporting the data from Model, but none talked about the exact application right needed for export. I will mention both here:

1st -> Disabling the restricted Export option at model level.

Disable%20restriction%20to%20Export%20Data%20%28Model%20level%20setting%29

Disable restriction to Export Data (Model level setting)

 

This configuration comes handy when you want to restrict export from the models, which are being used just for storing raw data/baseline data to populate data in actual working model, so that users don’t export data from those models accidently.

 

2nd -> Apart from Read Access at folder and Analytical/Planning model level, users will also need Execute permission at Other Data sources level.

Needed%20Access%20levels

Needed Access levels

 

Since we are using only import connection, hence this access wasn’t given to anyone, so took a while to figure this out.

 

Hope this helps…

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Aswani Kumar
      Aswani Kumar

      Good info Sahil. Thanks for sharing.. One grey area for me while exporting to Excel. In the optimized mode, if I export the report to excel, I cannot change/edit the downloaded excel for example the date format. we have alternates to tweak but that's not a wise option for business users. Any thoughts.