Dimension setup to meet different needs

Harry
New Contributor III

Hello,

Wondering if anyone knows how to set up dimensions in order to have the following requirement : 

  1. - Users with access to the cube Consolidation need access only to data from the dimension B
  2. - Users with access to the cube Accounting need access only to data from the dimension C
  3. - Users with access to the cube FP&A need both access to data from the dimensions B & C (dimension A)

The following setup does not yet meet our needs : 

Harry_3-1719575199863.png

Harry_2-1719575170630.png

Thanks for your help.

Harry

1 REPLY 1

NicolasArgente
Valued Contributor

Hi Harry, 
You can not do that from the dimension itself. You would need to use Slice Security. Go to Cube, Data Access.
Nic

Connect with me on:
LinkedIn: https://www.linkedin.com/in/nicolas-argente/
Website: https://aiqos.io
If you want to lift yourself up, lift up someone else.