CODEWITHSUNDEEP
sql-serverssasolap-cube
abnerfc01
abnerfc01

Reputation: 11

How to grant access to only one perspective

Sorry for the English translated by Google.

I created a cube in Analysis Services 2019 and from it some perspectives were created.

I would like a user to only be able to access a specific perspective only. Instead of this, the user visualizes all the cube and all perspectives.

IMAGE: User view of the cubes and perspectives.

Thank you for your time.

Upvotes: 0

Views: 936

Answers (1)

Gigga
Gigga

Reputation: 577

Perspectives are not a security feature, so you can't do that. You'll have to use Row Level Security (https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/roles-and-permissions-analysis-services?view=asallproducts-allversions)

Upvotes: 1

Related Questions