Focal Point Banner


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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    Displaying the underlying numerator and denominator values of an Actual percentage

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Displaying the underlying numerator and denominator values of an Actual percentage
 Login/Join
 
Member
posted
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.


Paul Burridge
Senior Consultant
34 years with Information Builders
WebFOCUS 8.2.5 Win10
 
Posts: 17 | Location: The Netherlands | Registered: February 21, 2005Report This Post
Master
posted Hide Post
From 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


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!

 
Posts: 919 | Registered: March 26, 2003Report This Post
Silver Member
posted Hide Post
Does 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


Web Focus 7.7.0.2
Windows Server 2008 R2 Standard
HTML, AHTML, HTMLTAB, AHTMLTAB, SQLMSS
 
Posts: 30 | Registered: May 26, 2011Report This Post
Member
posted Hide Post
Unfortunately 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.


Paul Burridge
Senior Consultant
34 years with Information Builders
WebFOCUS 8.2.5 Win10
 
Posts: 17 | Location: The Netherlands | Registered: February 21, 2005Report This Post
Gold member
posted Hide Post
In our side, we x100 the actual value in the formula option in the load KPI screen.


WebFOCUS 7.7.03
Windows 2008 srv
PMF 5.3.1 HF5
 
Posts: 54 | Registered: January 05, 2010Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    Displaying the underlying numerator and denominator values of an Actual percentage

Copyright © 1996-2020 Information Builders