none
Unable to pass filter values when nonempty used in Mdx RRS feed

  • Question

  • I am using an MDX filter in the performance point server dashboard to restrict the rows which does not have any value.
    I will summarize the steps.
     
    1. First in the dashboard, I create one mdx filter with following query


    SELECT
    { [Measures].[Avaliability] }
    ON COLUMNS,
    Nonempty(
    { <<Resource>> } * { [MSP Epm Project User View].[Project Name].[Project Name].ALLMEMBERS }
    )
    ON ROWS

    FROM [Project Server Reporting 1]

     When I check this query in the SSMS it works pretty well.

    But at the end of filter creation in PPS I get following message:

    Errors:

    1.       When I use nonempty function in mdx not able to pass filter values in pps. It shows Error message: "Unable to pass filter values. Don't have permission to view this data"

    Any help on this would be really appreciated.

    Thanks & Regards

    Kailas

    Thursday, March 21, 2013 2:13 PM

All replies

  • Are you using the complete query as you mentioned? If so, it will not work. Just use this line in the MDX Filter:

    Nonempty(
    { <<Resource>> } * { [MSP Epm Project User View].[Project Name].[Project Name].ALLMEMBERS }
    )

    There are other ways to get non empty set, cross joining will not be the most optimal. FILTER can be one option.


    http://dailyitsolutions.blogspot.com/

    Friday, March 22, 2013 4:27 PM