CODEWITHSUNDEEP
c#ssasmdx
Micah Armantrout
Micah Armantrout

Reputation: 6971

possible Intercept MDX Query

Say I wanted access the following OLAP cube but I wanted to limit my users to only see specific product category of "bikes" and not "clothing" because of security. Is there a way to modify the MDX query going to the cube or make a C# dll that would recieve all the data then modify all of the MDX query ?

http://sampledata.infragistics.com/olap/msmdpump.dll

if you want to see the actual data

https://www.igniteui.com/pivot-grid/remote-adomd-provider

Upvotes: 0

Views: 96

Answers (1)

Danylo Korostil
Danylo Korostil

Reputation: 1484

SSAS has roles. You add user and restrict "bikes" member within a cube for the role.

See this article, for example.

Upvotes: 1

Related Questions