Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    [Closed] - Actual Metric a Ratio and Target a set Value (Aggregation Needed)
Go
New
Search
Notify
Tools
Reply
  
[Closed] - Actual Metric a Ratio and Target a set Value (Aggregation Needed)
 Login/Join
 
Gold member
posted
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: 72 | Location: Minnesota | Registered: December 28, 2012Reply With QuoteReport This Post
Platinum Member
posted 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, 2003Reply With QuoteReport This Post
Gold member
posted 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: 72 | Location: Minnesota | Registered: December 28, 2012Reply With QuoteReport This Post
Platinum Member
posted 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! Smiler

This message has been edited. Last edited by: EricH,
 
Posts: 164 | Registered: March 26, 2003Reply With QuoteReport This Post
Gold member
posted 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: 72 | Location: Minnesota | Registered: December 28, 2012Reply With QuoteReport This Post
Platinum Member
posted 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, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    [Closed] - Actual Metric a Ratio and Target a set Value (Aggregation Needed)

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.