locked
filters in mdx query reports RRS feed

  • Question

  • HI

    I am using performance point reports.How can i create custom filters? For ex:

     

    I have the following measurements :

    1. Actual Contract

    2. Target Contract

    3. Actual NPV

    4. Budget NPV

    5. Actual Revenue

    6.Budget Revenue

     

    Now i want to generate a report with a filter, where i select an option "Contract Value" should display the Chart report with Actual and Target Contracts. If i select "NPV Value" the results should be of Actual and Target NPV values

     

    Please help in acheiving this

     

    Regards,

    vinay

     

    Thanks and Regards,

    vinay


    Thanks and Regards, vinnu
    • Edited by vinnu_1981 Friday, January 13, 2012 10:19 AM
    Friday, January 13, 2012 8:04 AM

Answers

  • I can think of a couple of options for you.  One would be to use KPIs with the names you are looking for and you could create a scorecard that simply displays the KPI names of the labels you want such as Contract Value, NPV Value, etc.  The scorecard would look kind of like a Slicer in Excel 2010 where you could then define a Custom Property in each KPI to pass a Text property you define say MeasureName to the report.  The MeasureName would include the set of measures you want to pass to the report.  Here is an example to reference (an oldie but a slick setup) - http://blogs.msdn.com/b/performancepoint/archive/2007/12/21/passing-context-from-scorecards-to-other-report-views.aspx.

    The other option I can think of would be to create a Tabular data source in Excel or a database query that would have the Labels you want to display and then the measure set for the values that correspond with each Label.  You can display the label in the filter but still pass the measure values you want to the report.  Something along the lines like this setup - http://blogs.msdn.com/b/performancepoint/archive/2008/06/10/tabular-filters-passing-to-olap-views.aspx.


    Dan English's BI Blog
    • Proposed as answer by Teddy bejjani Monday, January 16, 2012 10:43 AM
    • Marked as answer by Heidi Tr - MSFT Tuesday, January 17, 2012 7:30 PM
    Friday, January 13, 2012 12:02 PM

All replies

  • I can think of a couple of options for you.  One would be to use KPIs with the names you are looking for and you could create a scorecard that simply displays the KPI names of the labels you want such as Contract Value, NPV Value, etc.  The scorecard would look kind of like a Slicer in Excel 2010 where you could then define a Custom Property in each KPI to pass a Text property you define say MeasureName to the report.  The MeasureName would include the set of measures you want to pass to the report.  Here is an example to reference (an oldie but a slick setup) - http://blogs.msdn.com/b/performancepoint/archive/2007/12/21/passing-context-from-scorecards-to-other-report-views.aspx.

    The other option I can think of would be to create a Tabular data source in Excel or a database query that would have the Labels you want to display and then the measure set for the values that correspond with each Label.  You can display the label in the filter but still pass the measure values you want to the report.  Something along the lines like this setup - http://blogs.msdn.com/b/performancepoint/archive/2008/06/10/tabular-filters-passing-to-olap-views.aspx.


    Dan English's BI Blog
    • Proposed as answer by Teddy bejjani Monday, January 16, 2012 10:43 AM
    • Marked as answer by Heidi Tr - MSFT Tuesday, January 17, 2012 7:30 PM
    Friday, January 13, 2012 12:02 PM
  • Thank you so much Dan

     

    I used second option and its working fine.

     

    Thanks

    vinay


    Thanks and Regards, vinnu
    Monday, January 16, 2012 3:50 AM