Skip to main content
June 28, 2024

Dimension setup to meet different needs

  • June 28, 2024
  • 1 reply
  • 0 views

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

June 28, 2024

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

HarryAuthor
July 2, 2024

Thanks NicolasArgente