As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name. Connect to myibi
Focal Point    Focal Point Forums    Performance Management Framework (PMF)    [Closed] - Actual Metric a Ratio and Target a set Value (Aggregation Needed)

 Go Search Notify Tools
 [Closed] - Actual Metric a Ratio and Target a set Value (Aggregation Needed)
Gold member
 posted May 25, 2017 12:36 AM
Has anyone found an easy way to account for this situation?

An easy example is average hotel rate. We set a target of \$50 per night. The actual calculation is hotel costs / hotel nights.

I need to aggregate this from a machine level to a division level so I don't believe I can do the calculation as a datapoint and the measure as a number. It would not average the aggregation. With over 90 machine I don't want to have to trick the system by dividing by 1 for the target if it isn't needed.

This message has been edited. Last edited by: Jasen,

WebFocus 8.002
PMF 8.2.3
Windows, all output

 Posts: 76 | Location: Minnesota | Registered: December 28, 2012 IP
Platinum Member
 posted May 25, 2017 01:43 PM Hide Post
Jasen -

For Ratio & Percentage Measures, if you use a fixed Target the displayed value will automatically be averaged when you aggregate at a higher level.

So you will still see the target as \$50 at all levels of your dimension.

EricH

 Posts: 164 | Registered: March 26, 2003 IP
Gold member
 posted May 25, 2017 02:37 PM Hide Post
How do I use a fixed target though? It wants me to enter a ratio for the target.

WebFocus 8.002
PMF 8.2.3
Windows, all output

 Posts: 76 | Location: Minnesota | Registered: December 28, 2012 IP
Platinum Member
 posted May 30, 2017 04:09 PM Hide Post
Click in the check box under the # column. This opens up an entry box. Enter the fixed ratio value. It will be preserved on aggregation.

This is discussed in the PMF manual on p. 307 in the section "Working With Measures". Yes I know, the manual can be a bit overwhelming the first time you look at it, but it is your friend!

This message has been edited. Last edited by: EricH,

 Posts: 164 | Registered: March 26, 2003 IP
Gold member
 posted May 31, 2017 09:38 AM Hide Post
If the target was static I could do that, but the number changes from year to year and is different for each machine. The target can range from \$40 to \$90 per night based on location of the machine.

WebFocus 8.002
PMF 8.2.3
Windows, all output

 Posts: 76 | Location: Minnesota | Registered: December 28, 2012 IP
Platinum Member
 posted June 02, 2017 09:37 AM Hide Post
If the Target is not fixed (i.e. static), then you have to supply both a numerator & denominator - and you will have to do the "trick" of putting a 1 into the denominator.

The simplest way of getting that "1" is to create a User Defined Field on the Source and set it to 1.

 Posts: 164 | Registered: March 26, 2003 IP