Can I filter by value which is not displayed in grid columns?

In excel it is possible to filter by value of measure which is not displayed in the report.

How can I possibly do this in Performance Point Grid? (in filter by value there I only see the measures in columns).

Please

November 25th, 2014 1:27pm

I found it is possible to filter by value by changing the MDX in the query tab.

(I filtered by certain existing value in design, then switched to Query and changed to the measure which is not displayed). I shows up correctly.

The problem is, once I change the query, I get an error when tring to connect a filter on a grid column:

"consumer parameter no-longer exists in the consumer webpart"

The grid looks "frozen"- cannot drill up / down etc.

How can I filter by value which is not displayed without loosing the ability to attach a filter to the

Free Windows Admin Tool Kit Click here and download it now
November 26th, 2014 2:25pm

This is something I used to do frequently for our clients with ProClarity and am extremely disappointed that there does not seem to be a way to do it in PPS. I have tried a number of different tactics and have not found one that works. I certainly hope this is on the list for the next PPS update.
December 7th, 2014 9:00pm

I did find a way to attach filter to the mdx grid by using the parameters option under the mdx query. But still, as said, using MDX removes the ability of drilling. I've also found using MDX breaks the permissions which are set per user (in my cube it is by certain dimension which hold the domain name) probably because the dimension is no longer available externally without filters. 

Anyone has idea on how to re-enable the permissions after changing the MDX grid?

Free Windows Admin Tool Kit Click here and download it now
December 8th, 2014 9:27am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics