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
Technology Tips and News
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
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
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?