Solved

PerformancePoint Filter Issue

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Problem with SqlConnection 5 121
SSRS Problems 9 27
Concatenating multiple comments into one row 16 46
Sharepoint KB 2 24
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

760 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

21 Experts available now in Live!

Get 1:1 Help Now