Need Help with Column-Level Data Access Control in SAP Datasphere

[tejas_hatwalne]

Hi SAP Community,

I am currently working on a project in SAP Datasphere where I need to implement column-level data access control. Specifically, I want to restrict access to certain columns in my tables or models based on user roles. For example:

• The finance team should only see finance-related columns, while inventory-related columns should be hidden from them.

In addition, I have created a story where:

• Management can view all the KPI columns coming from the model in Datasphere.
• If the sales team accesses the same story, only the sales-related KPIs should be displayed, while the rest of the KPIs are hidden.

Questions:

1. How can I implement this scenario in SAP Datasphere?
2. Are there any detailed steps or best practices to dynamically filter columns based on user roles in stories?

Any guidance, resources, or similar use case examples would be extremely helpful!

Thanks in advance for your assistance.

[Martin_Kuma]

Object nor Column authorizations are not avl in DSP as of now. 

You can leverage SAC Teams and in the Story via script check the SAC Teams and based on that show/hide measures

In DSP I can imagine (I never needed this as I can use the SAC Teams approach) that you can miss-use the DACs by creating a dummy dimension (populate these in the model-view) for each group of measures (Sales/Inventory/Finance).