Solved

PerformancePoint Filter Issue

Posted on 2013-06-10
2
393 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
DTS Connection Failed 7 66
Abstract Express Replacement Software 12 22
what are the unique tables in SQL master database 5 57
SQL view 2 26
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
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.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

816 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

10 Experts available now in Live!

Get 1:1 Help Now