locked
KPI display for current month(its a Time independant) RRS feed

  • Question

  • Hi All,
    I have created a kpi as time independant.when I add month to the scorecard it will display for all the month.
    The requirement is to display for the current month only
    e.g

               Apr        March      Feb -----------

    KPI 1  1020       1020        1020


    My requirement is to dilpay given below

                Apr        March      Feb -----------

    KPI 1  1020       -               -

    Kindly give me the valuable suggestion.

    Thanks,
    Ravitamil
    Tuesday, April 28, 2009 8:50 AM

Answers

  • Instead of placing the date dimension information on the columns of the scorecard you can simply configure Time on your data source and set a time intelligence expression on your KPI within the dimension data source configuration - Map a KPI to a dimensional data source.  You could also setup a time intelligence filter to allow the user to control how this is displayed.
    Dan English's BI Blog
    _____________________________________________________
    Please mark posts as answer or helpful when they are.
    • Proposed as answer by Dan English Tuesday, May 5, 2009 10:21 AM
    • Marked as answer by AseemN Thursday, August 13, 2009 8:12 PM
    Tuesday, April 28, 2009 9:14 PM

All replies

  • Are you using any filter?
    Tuesday, April 28, 2009 3:40 PM
  • Instead of placing the date dimension information on the columns of the scorecard you can simply configure Time on your data source and set a time intelligence expression on your KPI within the dimension data source configuration - Map a KPI to a dimensional data source.  You could also setup a time intelligence filter to allow the user to control how this is displayed.
    Dan English's BI Blog
    _____________________________________________________
    Please mark posts as answer or helpful when they are.
    • Proposed as answer by Dan English Tuesday, May 5, 2009 10:21 AM
    • Marked as answer by AseemN Thursday, August 13, 2009 8:12 PM
    Tuesday, April 28, 2009 9:14 PM