Solved

PerformancePoint Filter Issue

Posted on 2013-06-10
2
392 Views
Last Modified: 2013-08-02
Hello,

I have a SharePoint 2010 instance that I am running PerformancePoint on.

As part of the PerformancePoint dashboard I have a filter that will switch between different measures that I want the user to be able to view.

The problem is if they have made any modifications, such as drilling down, changing the filter reverts them back to the default view. Is there any way to have it such that the filter does not exhibit this behavior, instead changing the measure on whatever customization they have already made, such as being drilled down to a particular view?

Thank you!
Joseph Irvine
0
Comment
Question by:jkeagle13
2 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 435 total points
ID: 39338909
Hi,
I am not sure and will have to re-test this.
There have been a lot of fixes with SP1 for SharePoint.
Can you perhaps explain a little bit more on what you mean with (perhaps with screenshots):
a filter that will switch between different measures that I want the user to be able to view.
A filter normally selects members for calculations hence just updating measure values but does not change anything in regards to the shown measure types.

Thanks and HTH
Rainer
0
 

Author Comment

by:jkeagle13
ID: 39357753
Hello,

We are running SP1.

The issue is that the filter is working, it will change the measures.

To illustrate, imagine that I have a measure for dollars per household, and another measure for dollars per individual. I then have data of country and city.

So I start by showing country and dollars per household. A user then does a "Show Only" on one of the countries. They then do a drill-down on City. Now, however, they want to see dollars per individual. When they click my filter to change the measure, it does successfully change the measure. However, it forgets its current drill-down and "show only" states, and reverts back the country level for dollars per individual. This forces someone to drill back down to city again to get back to the same location they were previously.

I would ideally like the measures to change in-place for more easy comparison, preventing the user from needing to re-navigate and drill back down to where they were. I am almost certain this is possible; just haven't figured it out yet. Some setting or variable I need, I am sure, that will let it stay at its current state and just change the measure.

Thanks,
Joseph Irvine
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to base a filter depending on fields contents? 15 49
TSQL DateADD update Question 4 29
SSRS troubles 4 20
Sql Query 4 16
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only seeā€¦
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now