October 21, 2011, 08:03 AM
paulburridgeDisplaying the underlying numerator and denominator values of an Actual percentage
How can we see the underlying numerator and denominator values of an Actual percentage as shown on a report?
What is required, either:
A report option that would show the underlying numerator and denominator values for all the (%) report cells.
or
A mouse-over or a drill option would solve this for a single (%) report cell.
or
Even better both options.
An example with the pmf_manufacturing database:
Using the ‘Measures - Rolling 5 Periods As of: 2006Q1’ report
The Actual value of Margins for 2005Q1 is shown as 10.4% [ 103.9% ]
How can I show the numerator and denominator values of the 10.4%?
(I know that they are kept in the PMF database as ACTUAL_NUMERATOR and ACTUAL_DENOMINATOR).
Suggestions?
Thanks in advance.
October 21, 2011, 10:46 AM
Bob Jude FerranteFrom where we sit, ACTUAL_NUMERATOR and ACTUAL_DENOMINATOR are kept in the HOLD stream all the way to the last mile and are present in the final HOLD used for reporting at the Measure level (which we call PASS1). So if you wanted you could write a custom report using PMF_BOOKLET_DATA to display these however you wanted.
We'll look into providing an option to display these in the future.
Note: As documented in the PMX Platform Developer Guide, PASS1 is Measure level aggregation and preserves Measure level values; PASS2 is Objective level aggregation and represents only aggregation on Pct Reached - since units of measure can't be blended. And PASS3 is Perspective level, or Theme level, two pathways there. Finally PASS4 is Scorecard level. Various PMF reports use these various levels of aggregation.
thanks
October 24, 2011, 09:35 AM
H8KDoes this help?
TABLE FILE CAR
PRINT
COUNTRY
CAR
BODYTYPE
MPG
SALES
COMPUTE FRAC/A13 = FTOA(MPG,'(D6c)','A6') || '/' || LJUST(6,FTOA(SALES,'(D6c)', 'A6'), 'A6');
END
October 24, 2011, 09:58 AM
paulburridgeUnfortunately not. The problem is much more complicated. One needs to work within the PMF framework. I need to capture the PASS1 data as Bob suggests.
Thanks.
October 24, 2011, 02:09 PM
Carlos Da CostaIn our side, we x100 the actual value in the formula option in the load KPI screen.