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

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.