?
Solved

PerformancePoint Filter Issue

Posted on 2013-06-10
2
Medium Priority
?
399 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 1305 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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

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.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

764 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