Aanmelden
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Target Values to be changed dynamically upon selection parameters in PPS Dashboard Designer

السؤال Target Values to be changed dynamically upon selection parameters in PPS Dashboard Designer

  • dinsdag 15 mei 2012 5:12
     
     
    Aanmelden om te stemmen
    0

    Can anyone please guide me how to change the Target values dynamically based on the selection parameters used in the Time filters?

    I have designed a KPI scorecard in which i have given some target values but those are numbers and may correspond to a specific time period like if i have specified 50 as the target value then it may be a target value for a month but what if the user selected multiple months from the filter? then this value should be multiplied by 2. I have no idea where to write the formula so that the data displayed in the scorecard is accurate as per selection parameters.

    Please help!

    Regards,

    Yasmeen Arshad

     

Alle reacties

  • woensdag 16 mei 2012 14:07
     
     
    Aanmelden om te stemmen
    0

    Hello Yasmeen

    Change som measures dynamically is OLAP "feature" where you have calculated measures with some aggregation and if you change data mappings from fixed value to to another data source (OLAP) you should dynamically display based on aggregation from OLAP. i m afraid that directly in dashboard designer you are not able to create this type o calculation with target define as fixed value.

    Tomas

     
  • donderdag 17 mei 2012 4:20
     
     
    Aanmelden om te stemmen
    0

    Thanks for your reply Tomas.

    You mean like other conventional dashboards we cannot change the target values dynamically? Other applications support this feature. am i right?

    whats the use of formulating dashboards using dashboard designer then?