Forum Discussion

kalwabharath44's avatar
kalwabharath44
Frequent Visitor
5 years ago

Hierarchy Row Level security with cascading functionality

Hi All, I have a report which requires Hierarchy Row Level security with cascading functionality L1 - Director L2 - Manager L3 - Supervisor L4 - Regular user When an L1 loges in then he nee...
Data Protection
Tips and Tricks
kalwabharath44's avatar
kalwabharath44
Frequent Visitor
5 years ago

Thank you for the response Denis. Also, i have an excel file with L1 L2 L3 and L4 data. can you please guide me on how to build the security model?

selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

That depends a lot on the Excel file. Do you have a PowerPivot model or do you "only" have the data in tables? How would you provide the Excel file to your users? What are your data sources?

 

For example if you do a live connection to an SSAS Tabular with PowerPivot in Excel the security from the SSAS works perfectly fine. If you do a direct query connection to a relational database also the security on the database works.

So it really depends.