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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    Understanding Targets & Percentage Reached.

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Understanding Targets & Percentage Reached.
 Login/Join
 
Member
posted
Apologies if this has been answered before, we are new to PMF and are only begining to get to grips with it all.

We are strugling to understand how the targets and especially 'percentage reached' elements of PMF work.

Given this example

Dimension is Gender
GENDER_CODE|GENDER_DESCRIPTION

Measure data has the following fields
REPORT_YYYY|REPORT_MM|PERSON_ID|GENDER_CODE|GENDER_RECORDED_YN|DENOMINATOR_COL*

(*Where denominator_col is a default 1 for each row)

When creating the measure, we have linked this to gender dimension using GENDER_CODE.

There are 10 records where 6 female and 4 male.

When setting up the measure,
the ACTUAL = GENDER_RECORDED_YN
the TARGET = DENOMINATOR_COL

When displaying the output through a pie chart, grouped by dimension 'gender', we expect to see Male = 40% and Female = 60%

This is working fine, however the percentage reached is showing 100% for both Male and Female. Which appears to be dividing the actual / actual.

Either that or it is the (Male actual = 4)/ (Male denominator =4) which results in 100%.

Any tips on how we can fix this such that the percentage reached is 4 out of 10 and 6 out of 10?

Thank you.
 
Posts: 3 | Registered: October 18, 2010Report This Post
Master
posted Hide Post
Percent reached compares actual to target.

If you have a ratio or percent type measure, numerator value and denominator value will of course involve division (constitute a fraction) to ensure aggregation works.

But this is not how percent reached is calculated.

There are many postings about this question here on the forum. Try a search there on 'percent reached' and it will bear much fruit.

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
Platinum Member
posted Hide Post
Hi Bob,
We have opened a case to handle this one as the boys have tried various suggestions after searching on 'percent reached' but to no avail. Here is the link:- https://techsupport.informatio...se.jsp?case=10513517.

Regards,
Ian


_______________________
*** WebFOCUS 8.1.05M ***
 
Posts: 196 | Location: London, UK | Registered: December 06, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    Understanding Targets & Percentage Reached.

Copyright © 1996-2020 Information Builders