Dynamic dimension-level security using many-to-many dimension

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Folks,

Our objective is to incorporate dynamic dimension-level security. Our fact
data is locked down by access control lists, of which the users are members.
Our source schema represents more of a snowflake than a star, so our
dimension that returns the USERNAME attribute has a many-to-many
appearance - a user can be a member of more than one ACL, and the ACL can
have more than one user. We can successfully lock down the DIM_User
dimension through the use of an MDX expression in the role for the dimension
data, but when we add in the other related tables that make up the ACL list
(hence snowflake), the data ends up with one ACL per user at most (seems
like it picks the first). So, dimension data is being dropped.

Any ideas?

Thanks,
Dan


.

Relevant Pages

  • RE: Calculating Max Usage with OLAP
    ... to answer your question about how to only build aggregations at ... dimension and then looking at the Advanced tab in the properties pane). ... The combined number of members on both these ... > Max Used Licenses means –how many concurrent licenses have been used during ...
    (microsoft.public.sqlserver.olap)
  • Re: Problem with Member Counts and applying filters using MDX in M
    ... Now i am trying to count the "members" in this big dimension based on ... various possible filters that the user might apply. ... So far i am able to get the count of members on this big dimenion with one ... Here is the MDX i am trying.... ...
    (microsoft.public.sqlserver.olap)
  • Re: MDX Compatibility Property
    ... It looks like a bug. ... Please do not send email directly to this alias. ... The dimension browser forms an integral part of our ... have hidden members work ok! ...
    (microsoft.public.sqlserver.olap)
  • Re: Help Needed with Dynamic Dimension Security
    ... business application for securing members. ... and the point in the hierarchy where the security ... > of using Dimension Security with a Virtual Cube. ...
    (microsoft.public.sqlserver.olap)
  • RE: Computing histograms / bins in MDX
    ... you can't define a new dimension for the scope of a query unfortunately. ... if you have too many buckets to define manually and you don't mind ... //OF MEMBERS IN AS THE NUMBER OF BUCKETS DESIRED ...
    (microsoft.public.sqlserver.olap)