locked
Dimension Data Security - dynamic & configurable RRS feed

  • Question

  • Hi,

    I have this requirement where Dimension Data Security will be tied to User Login account information and also configuration on Parent Child OR Regular User defined Hierarchy

    So Far, I configured User Account information by tagging it to employee table using below links:

    http://blogs.msdn.com/b/azazr/archive/2008/08/15/dynamic-security-in-ssas-cube.aspx
    http://hccmsbi.blogspot.ch/2007/08/implementing-user-specific-security-in.html
    http://blogs.msdn.com/b/azazr/archive/2008/08/15/dynamic-security-in-ssas-cube.aspx

    Please refer below Employee hierarchy structure for understanding the problem:

    Now say Shaun Peterson connects to Cube then he should see his (Self) totals, his subordinate's totals, his peer's / sibling's totals, his manager's totals and his manager's manager total till the top level.

    Issue is the I am unable to show total's for his Siblings using these below mdx statements:

    1]

    Union (NonEmpty([Position- Employee].[Level1 Emp Name].[Level1 Emp Name],
    (
    StrToMember("[User].[Login ID].[" + UserName() + "]"),
    [Measures].[Bridge User Emp Count]
    )
    ),

    NonEmpty([Position- Employee].[Level1 Emp Name].CurrentMember.Siblings,
    (
    StrToMember("[User].[Login ID].[" + UserName() + "]"),
    [Measures].[Bridge User Emp Count]
    )
    ))

    2]

    NonEmpty
    (
    [Position- Employee].[Level1 Emp Name].Members,
    (
    StrToMember("[User].[Login ID].[" + UserName() + "]"),
    [Measures].[Bridge User Emp Count]
    )
    ),
    NonEmpty
    (
    [Position- Employee].[Level1 Emp Name].Siblings,
    (
    StrToMember("[User].[Login ID].[" + UserName() + "]"),
    [Measures].[Bridge User Emp Count]
    )
    )

    Below is the sample hierarchy for illustration

    Thursday, September 26, 2013 11:20 PM