Is it possible to limit access to limit access to dimension members, but include them in totals via TARGIT Security?
Scenario is a general ledger account hierarchy where accounts related to employee expenses (i.e. payroll) are grouped under a level called "Employee Expenses". The request is to use security role forced criteria to prevent users from seeing the individual employee expense accounts, but still allow users to see the total "Employee Expenses" and include all the details in totals. This was something that was possible in the SSAS environment by disabling access to the members, but then leaving the Enable Visual Totals box unchecked. I believe I can accomplish this in the front end via things like Visibility and maybe alternate account hierarchies, but this would require having multiple versions of the same report (one that has the employee accounts visible, and one that does not). Thanks!
Comments
Hi Mark,
You can achieve this by combining a couple of TARGIT features: 'Initial criteria' and 'Required criteria'.
User1 can see details:
User 2, in the same document and the same spot, can only see totals:
Steps:
Notes:
BR / Ole
Please sign in to leave a comment.