Focal Point
Use of Constants

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1461084022/m/2027007376

November 26, 2014, 11:14 AM
jsp_lbf
Use of Constants
In legacy releases of PMF, we used a technique for percentage measures to ensure an accurate rollup when looking at yearly & quarterly summaries. For example, I have a measure called Bookings GP Pct, and when computing the actual value, I would use the following fields from my source table:

Actual Numerator = Bookings_GP_Actual_Dollars
Actual Denominator = Bookings_Sales_Dollars

This computes the GP Pct accurately and also translates perfectly into 5.3.2 using the new measure setup methodology.

However, I previously calculated the target percentage this way:

Target Numerator = Target_Bookings_GP_Pct
Target Denominator = TARGET_DENOMINATOR/D20.2=1;

I would change the selection from field to code and input the above formula, basically to mimic dividing by 1, since the target pct was already calculated and stored in my source table.

I cannot figure out how to replicate the procedure in 5.3.2, baslcally I want to enter a constant of 1 for the denominator instead of entering a datapoint name for the target.

Any suggestions welcome.

Thanks in advance.

WebFOCUS 7.7.04m/PMF 5.32 HF 4 ,Tomcat,IIS,Windows/iseries,sql server 2005,Excel/ PDF/HTML
November 26, 2014, 04:03 PM
Bob Jude Ferrante
Here's how to do it.

Create a new Derived Datapoint.

Use a formula like the following:
Target_Bookings_GP_Pct - Target_Bookings_GP_Pct + 1

You can name this Derived Datapoint something simple like Averaging Denominator, or even Constant 1.0

In the future we will support pure constants with a little less work.

Hope this helps.


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!

December 01, 2014, 01:10 PM
jsp_lbf
Thank you Bob, I appreciate the help as always.