We have a scenario where are looking some help without compromising security. Please let me know if anyone has any pointers
Scenario :
Table1[A] is confidential column. Which user should not be able to access directly.
Calculated Aggregated Column Table1[B] (on Top of Table1[A]), should only return Value if there are more than 2 combination of record present in table else it should Blank. (we have a DAX to control this as it should be done on run time based on slicers).
Requirement :
Table1[A] should not be accessed by user in any scenario. User should be able to access Table1[B] . (Dax will take care of exposing the value or blank)
Problem :
Hiding the column Table1[A], does not guarantee confidentiality as technically there are ways to pull hidden columns.
Security Roles (Column Level) are also not help because if base column is restricted then derived measures are also not accessible.
Tried Approaches :
• Column Level Security : This is restricting the access of Table1[B] as well as it is dependent on Table1[A].
• Access control via Perspectives.
Looking forward for some suggestions to control it via inbuilt capability of SSAS or any custom design suggestions.
Please reply me if you have any pointers.
