Skip to main content
Member
Jun 28, 2024 11:49 AM UTC

Dimension setup to meet different needs

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

2 replies

Veteran
Jun 28, 2024 1:52 PM UTC

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
Member
Jul 2, 2024 6:52 AM UTC

Thanks NicolasArgente