Security: Limit users to access Dimension elements in cube.
Posted: Mon Sep 02, 2013 7:47 am
Hi Team,
I have a requirement where i need to limit the access to users for certain dimension elements .
Destination.
Company
Business.
All cubes are reporting cubes that are published to the cognos connection.
Users need to access only dimension elements that they have access.
Users need to View/input only to the dimension elements that they have access to.
My Though was to create a table(Cube) with users and Destination.
Mark Y/N to the intersections.
Create a cube security cube.
Create a rule in Cube security cube.
Please help me ...
The right approach.
Performance impacts.
Thanks & regards,
Deepak
I have a requirement where i need to limit the access to users for certain dimension elements .
Destination.
Company
Business.
All cubes are reporting cubes that are published to the cognos connection.
Users need to access only dimension elements that they have access.
Users need to View/input only to the dimension elements that they have access to.
My Though was to create a table(Cube) with users and Destination.
Mark Y/N to the intersections.
Create a cube security cube.
Create a rule in Cube security cube.
Please help me ...
The right approach.
Performance impacts.
Thanks & regards,
Deepak