Cell Security with Distinct Counts RRS feed

  • Question

  • I have a large cube (many dimensions and measure groups) that I need to add specific security around salary information. I am adding cell level security because only employees salaries are going to be hidden. 
    Security Code:
    NOT(Measures.CurrentMember is [Measures].[Last Annualized Salary]
    AND [Eligibility Salary].[Eligibility Employee Record Indicator].&[Y])

    However, I have distinct counts on a related fact table which are showing up as #N/A when no security should be applied to them. This happens only when I add a filter to the dimension in BIDS (for example a date filter). Once the date filter is remove, the #N/A disappear and go back to being populated.

    Am I missing something? Why is an unrelated measure group being filtered?
    Thursday, August 13, 2009 4:30 PM


  • Hi,


    Is the filter related the denied member or distinct count is a calculated measure which related denied member? If so, this could be possible. I mean, create filter with other dimension, check if there is the same issue.


    Hope this helps.


    Monday, August 17, 2009 7:18 AM