Focal Point

Use of Constants

This topic can be found at:

http://forums.informationbuilders.com/eve/forums/a/tpc/f/1461084022/m/2027007376

http://forums.informationbuilders.com/eve/forums/a/tpc/f/1461084022/m/2027007376

November 26, 2014, 11:14 AM

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

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