This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 43%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Dear Team, Looking for help on below technical knowledge. This question is for MSBI - "SQL Server Analysis Server " Is it possible to create a security for entire dimension in "dimension data" tab of "Roles" window. For example for Adventure Works cube: I have two roles
Dear Team,
No "team" here, Question&Answer is community forum with volunteers. And the rest of your your post ist every unclear, mostly hypotetically, where no one can work on. You have to to provide clear, detailed informations.
Dear Sir, ok. and thanks for the information and your prompt response.
I will try to rephrase my problem here.
This is an example from AdventureWorks cube.
I have below 5 dimensions SET 1:
Reseller,
Reseller Sales,
Territory,
Currency and Customer
which should be only accessible to the Role 1 : Users_Regional.
And then I have another set of 3 dimensions SET 2:
Date,
Product,
Promotion
which should be only accessible to the Role 2 : Users_Customer.
In either of the case, users from each of the Role, should not be able to access , dimensions from other category unless they are part of the both the roles.
For example, Users from, Role 1 : Users_Regional, Should not be able to access , SET 2 dimension information and Users from, Role 2 : Users_Customer, Should not be able to access , SET 1 dimension information .
Users, only if they are part of both the roles, Role 1 : Users_Regional and Role 2 : Users_Customer can access all the dimension information i.e. SET 1 and SET 2.
I hope this is understandable now. I can provide more info if needed.
Is it solvable or any better way of achieving this?
Thank you all.