Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
paddyw
Explorer
0 Kudos

These days I am exploring the different scenarios about Data Access Control in SAP Datasphere, but I cannot find a detailed configuration online. So I would like to share my learning stories. There are different types of DAC patterns currently supported in Datasphere

  • Single value DAC
  • Operator and values DAC
  • Hierarchy DAC

This article will show a step-by-step configuration for Single value DAC and the outcome of the configuration

The other two types of DAC configuration will be explained in the upcoming two blogs

Blog of  

 

Disclaimer: all the data which created are for demo purpose, the approach is used to demo the functionality of the DAC configuration, not intended for production design or usage

  • Single value DAC

Create a dimension view based on a local table, there are four countries in place

paddyw_1-1716089994544.png

Create a local fact table containing transaction data posted against four different counties, with different types of spending

paddyw_2-1716091625001.png

Create a local table that serves as DAC single filter, the masked part is the email id, the allowed value this email address can see is 'gas'

paddyw_3-1716091959763.png

Go to define Data Access Control section and create a DAC artifact, select the DAC single filter table as source

paddyw_5-1716092123438.png

Create a fact view using the transaction data local table and add DAC single filter table, when we browse data from the local table, we can see all the data for each type, while browsing data on the fact view, we can only see one TYPE of spending (gas) which we defined in the DAC single filter table

Local table view:

paddyw_0-1716092600801.png

Fact view has DAC configured will apply the single filter automatically:

paddyw_1-1716092943609.png

Please feel free to share your comment or any questions you may have. Thank you

 

 

 

 

 

 

 

 

 

Labels in this area