none
PerformancePoint Dashboard. Choose graph measure via filter. Could do it in 2007 not in 2010. RRS feed

  • Question

  • Hi.. I don't know if anyone else has noticed this.. but I've found something that has just stopped working for me in version 2010 (SP1 installed) of PerformancePoint, and used to work in 2007.

    I've created a graph and a MDX filter with the designer. Now I put them both in a dashboard and link them.

    In 2007, I could make an MDX filter and just define in the formula a group of measures separated by commas (,). With this, the user was able to select the measure he want's to be represented in the graph.

    Now in 2010, I get an error when I try this. Now it only seems to accept dimensions in the filter. There is a new feature in SP1, which is a measure selector in the graph, but this shows all the measures available in the cube. The 2007 behaviour was very useful and comfortable for our exquisite customers :) so they still want this feature.

    Anyone has noticed this and found a solution?? At the end of the day, what I need is an comfortable way for the user to select the measure he wants to see in the graph. Doing this with a filter was very convenient.

    Thanks.. Best Regards..

     

     

    Wednesday, August 24, 2011 1:44 PM

Answers

  • One option would be to create a measures dimension and have a single measure based on this dimension.  Of course this would mean redesigning your underlying cube.

    Another option would be to create a "fake" measures dimension with an approach similar to the Date Tool dimension, mapping your existing measures to a single measure/dimension slice.

    http://sqlblog.com/blogs/marco_russo/archive/2007/09/02/datetool-dimension-an-alternative-time-intelligence-implementation.aspx

    Again, meaning a cube redesign.  Could you try the set functionality to specify a group of measures {[measure1],[measure2]}?

    Looks like the PPS design team changed functionality and the fix was to show all measures.  Perhaps perspectives in the cube would be another approach, to show just measures specific to an audience.

    cheers,

    Andrew


    Andrew Sears, T4G Limited, http://www.performancepointing.com
    • Marked as answer by Ghetz Friday, September 2, 2011 1:21 PM
    Thursday, August 25, 2011 7:06 PM
  • Interesting and you are correct, now that the option for Cascasding Filters has been setup this does create a bit of an issue trying to use a set of Measure names as the query source.

    I did test this out and there is a way to resolve this.  I setup a NULL default measure (which is a good idea in general anyways) - http://sqlblog.com/blogs/jorg_klein/archive/2009/02/06/ssas-speed-up-dimensions-using-a-null-default-cube-measure.aspx.  Once I had that setup that is what I reference in the Filter Measure for defining the Filter for the drop-down selection.

    The one thing about PPS 2010 over 2007 is that in the Analytical Charts and Grids your users now have the ability to simply right-click on the Analytical reports in the dashboard page and choose the 'Select Measures...' option.  This will allow the user to pick and choose the measures that they would like to see displayed.  This would have to be done for each report, so having a page level filter might be a better option, depending on your needs and requirements.


    Dan English's BI Blog
    Sunday, August 28, 2011 1:46 PM

All replies

  • One option would be to create a measures dimension and have a single measure based on this dimension.  Of course this would mean redesigning your underlying cube.

    Another option would be to create a "fake" measures dimension with an approach similar to the Date Tool dimension, mapping your existing measures to a single measure/dimension slice.

    http://sqlblog.com/blogs/marco_russo/archive/2007/09/02/datetool-dimension-an-alternative-time-intelligence-implementation.aspx

    Again, meaning a cube redesign.  Could you try the set functionality to specify a group of measures {[measure1],[measure2]}?

    Looks like the PPS design team changed functionality and the fix was to show all measures.  Perhaps perspectives in the cube would be another approach, to show just measures specific to an audience.

    cheers,

    Andrew


    Andrew Sears, T4G Limited, http://www.performancepointing.com
    • Marked as answer by Ghetz Friday, September 2, 2011 1:21 PM
    Thursday, August 25, 2011 7:06 PM
  • Interesting and you are correct, now that the option for Cascasding Filters has been setup this does create a bit of an issue trying to use a set of Measure names as the query source.

    I did test this out and there is a way to resolve this.  I setup a NULL default measure (which is a good idea in general anyways) - http://sqlblog.com/blogs/jorg_klein/archive/2009/02/06/ssas-speed-up-dimensions-using-a-null-default-cube-measure.aspx.  Once I had that setup that is what I reference in the Filter Measure for defining the Filter for the drop-down selection.

    The one thing about PPS 2010 over 2007 is that in the Analytical Charts and Grids your users now have the ability to simply right-click on the Analytical reports in the dashboard page and choose the 'Select Measures...' option.  This will allow the user to pick and choose the measures that they would like to see displayed.  This would have to be done for each report, so having a page level filter might be a better option, depending on your needs and requirements.


    Dan English's BI Blog
    Sunday, August 28, 2011 1:46 PM
  • Could you try the set functionality to specify a group of measures {[measure1],[measure2]}?

    Actually this did the job!! Thanks!!

    Anyway.. all good tips.. and as always, learning something new.. Thanks Dan and Andrew!!

    Best Regards!

    Friday, September 2, 2011 1:26 PM