Read/Write Access SAP Analytics Cloud

[#1]

Hi All,

I have a business requirement to restrict view/write access to individual product costs but allow the user to perform a calculation (Dataaction) using the individual product cost.

In other words, the user should never see the individual product costs but they should see the total amount calculated after the dataaction has been run.

The first screen shot shows the calculation for each product: Product Unit Cost * Volume = Cost $

The second screen shot shows the restricted view aim, i.e. the total is stored on a "dummy product", but the cost per product is not visible to the user.

If I use DAC to remove access to Unit Cost then the calculation does not work, even when the write back dimensions are not restricted.

Any help on this would be appreciated.

Seamus  

[William_Yu1]

Run the data action by admin user and retrict end user to only product/measure he is entitled. 

[seamustaylor]

Thanks for your reply William, is it possible for the user with less access to trigger the Admin data action? The User with less access needs to be able trigger the calculation rather than using a scheduled event.

[William_Yu1]

That's not possible.

[Chuma]

Hello @seamustaylor 

In SAP Analytics Cloud, product cost visibility is restricted using data access control on the product dimension. Use a Data Action to calculate and write only the aggregated total to a visible dummy product.

 SAP Help: Configure Data Access Control

SAP Help: Data Actions – Advanced Scripting

SAC Best Practices for Sensitive Data Modelling

With kind regards

Chuma