In my project, I have to apply security based on the dimension attribute. I think the best way to explain my scenario is through an example, if you need more information, please ask me and I will be happy to tell you if I can find a solution.
I have a basic dimension, dimcustomer, dimseller, fact, data and geographical. The fact table is associated with dimseller identifiers, dimcustomer is associated with dimseller based on one dimseller attribute (CNPJ) (other dimensions that I have not described are related identically).
So, my goal is to apply role protection based on dimseller CNPJ, so when a user associated with this seller tries to view the data, he will be allowed to view only the data associated with his CNPJ seller.
Example table:
DIM Seller: DIM Customer FactTable
id name cnpj id name dimseller.cnpj dimseller.id dimcustomerid measure
1 ME 1234 1 guest1 1234 1 1 50,00
2 you 5678 2 guest2 5678 2 2 100,00
So, if I log in as ME, I can say that I have a guest1 client with one product sold, which was sold 50 dollars.
Do I have my point?
What is the best way to do this?
I am currently reviewing the following guide: Require authentication using dynamic dimension security , but in this way I must determine its attribute by attribute.
Is there a way to identify this security need? I can easily filter data using sql statements, but I have no idea how I can apply such protection in ssas.
, , !