Home Forums Data Warehousing Performance Point Add filter to only show countries that user has access (SSAS) RE: Add filter to only show countries that user has access (SSAS)

  • July 16, 2012 at 2:22 pm

    #1513312

    Thank you for your quick response. I am using Share Point 2010. Here is the MDX query that is defined in the SQL Role in the SSAS cube. I am not sure how to answer your questions, but maybe this query will...

    NonEmpty

    (

    [Dim Local Drilldown Cube].[Fact Key].Members,

    (

    STRTOMEMBER("[Security Users].[User Name].[" + CustomData() + "]"),

    [Measures].[CUBE SECURITY Count]

    ))