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)    Stratmap color misunderstanding

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Stratmap color misunderstanding
 Login/Join
 
Gold member
posted
Hi,

We thing have a strategy map misunderstanding.

Our parameter:
We have some measures with no target but only with benchmark, the target field are the value 0. For this kind of measures the Theshold/flex type is in percent and the target default field in PMF is Target.

Strategy map behavior:
When we look at objective that contains this kind of measures (with no target) the objective is red and when we clic in “show measure” the measure is green ?
We are expected a green objective too or red measure...

Questions:
How to you determine the color of an objective and the color of a perspective in the strategy map?
Is the goal of the “show measure report “ to explain the color of the clicked objective, isn’t it ?


Thanks


WebFOCUS 7.7.03
Windows 2008 srv
PMF 5.3.1 HF5


strategy map
 
Posts: 54 | Registered: January 05, 2010Report This Post
Master
posted Hide Post
Hi Carlos

Strategy Map uses PMF's "Default Target" to determine *which* target PMF will use by default - and which strategy map will use - to calculate Percent Reached. The setting is in:

Manage tab > Settings > System.

This is a global setting.

If you don't want this to be globally determine and are customization-minded, you could try to change it contextually using a setting override in the security exit for PMF with a little code. The amper is &DEFAULT_TARGET_FIELD and it can be set to T,B,S, or F (Target/Benchmark/Stretch/Forecast). For example, you might want to change it for a particular Scorecard (&SCORECARD_ID).

In future PMF, we could consider making this a Scorecard level setting if there's demand for that.

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
Gold member
posted Hide Post
Hi Bob,

Sorry may be my previous post was not enough clear.


We are aware about the target default field in the system params. (previous post : "our target default field in PMF is Target").

This is a global setting and we want this to be globally determine. That's OK for us.



What we don't understand :

Why the perspective and objective is red despite the fact that when we clic to show measure all of them are greens ? (print screen below)


Stratmap



Could you check that problem with your team please.


Our parameter (previous post) :
We have some measures with no target but only with benchmark. For this kind of measures all the rows are a target field = 0 and the Theshold/flex type is in percent. Beside the target default field in PMF is Target.



Thank you.


WebFOCUS 7.7.03
Windows 2008 srv
PMF 5.3.1 HF5
 
Posts: 54 | Registered: January 05, 2010Report This Post
Platinum Member
posted Hide Post
Hi Carlos,

Did you weight all the Measures within your PNB Objective? If the PNB Measure is the only Measure in that Objective, then PNB Measure should be weighted 100% within the PNB Objective.

EricH
 
Posts: 164 | Registered: March 26, 2003Report This Post
Gold member
posted Hide Post
Hi Eric,

I'd check, in the print screen stratmap (previous post) the PNB Measure is the only Measure in that Objective and PNB Measure is weighted at 100%.

The print screen come from our standalone PC with PMF 5.2.3 HF2 but with have the same behavior in production (PMF 5.2.1 HF1).

Thx for getting involved.


WebFOCUS 7.7.03
Windows 2008 srv
PMF 5.3.1 HF5
 
Posts: 54 | Registered: January 05, 2010Report This Post
Gold member
posted Hide Post
quote:
Originally posted by Carlos Da Costa:
Hi Eric,

I'd check, in the print screen stratmap (previous post) the PNB Measure is the only Measure in that Objective and PNB Measure is weighted at 100%.

Check on your side, but normally, you will have the same behavior.

The print screen come from our standalone PC with PMF 5.2.3 HF2 but with have the same behavior in production (PMF 5.2.1 HF1).

Thx for getting involved.


WebFOCUS 7.7.03
Windows 2008 srv
PMF 5.3.1 HF5
 
Posts: 54 | Registered: January 05, 2010Report This Post
Platinum Member
posted Hide Post
Carlos - Is this a descending Measure?
 
Posts: 164 | Registered: March 26, 2003Report This Post
Gold member
posted Hide Post
This is an ascending measure. When we put it on descending just for testing. The objective and the measure is red.

But we are expected a green objective and measures in both case, because de target is always 0.


WebFOCUS 7.7.03
Windows 2008 srv
PMF 5.3.1 HF5
 
Posts: 54 | Registered: January 05, 2010Report This Post
Platinum Member
posted Hide Post
The anomalous behavior you are seeing is due to some subtle differences in the way we calculate red-yellow-green on the Measure level vs. the Objective level. This only happens on ascending Measures when both the Actual and Target values are 0, so it's a pretty obscure situation.

We may address this in the next release of PMF, but it the meanwhile, my suggestion is to simply set the Target to some large value GT 0. Then both the Measure and Objective will show Red.

EricH
 
Posts: 164 | Registered: March 26, 2003Report This Post
Gold member
posted Hide Post
Is not "only happening on ascending Measures when both the Actual and Target values are 0" because in the picture above the measure are OF COURSE actual values and benchmarks, else why are we putting a measure in the tools... Only the target value is zero.

There are some issues with the strategy map, but fixing a target with a value GT 0 is not a workaround, because:
-First of all, if we change the target we have to change it at the lower level. A measure like PNB represents more than 200 thousand rows per month. So if we put “1” instead of “0”, at the top level the target will be 1 * 200 000 ! So the target “200 000” is totally wrong and don’t mean anything.

-We are around 3 millions rows per months and about 40 measures without target (only with a benchmark) we are already 12 months loaded. So we cannot imagine recalculate and reload all this measure only because is missing a “IF” in a fex so the color red instead of green.

Can you tell when the next release is scheduled ?

An order questions Eric :

How do you determine the color of the perspective in a strategy map ? One objective is red so the perspective is red ? We didn’t find this information in the documentation.



Thanks


WebFOCUS 7.7.03
Windows 2008 srv
PMF 5.3.1 HF5
 
Posts: 54 | Registered: January 05, 2010Report This Post
Platinum Member
posted Hide Post
Maybe I am not understanding your situation. In the original post you said:

"We have some measures with no target but only with benchmark, the target field are the value 0"

If there is no Target at all, then it should be irrelevant what the value is since you are not using it. In other words, any value - even 0 - is totally wrong and meaningless.

That said - you do not have to re-load your Measures. You can switch this to a Fixed Target on the Measure Panel. Make sure to un-check Benchmark (since you are using Benchmark). If you are using Forecast and/or Stretch Target, make sure to uncheck those as well. Try experimenting with different Target values - you may prefer to use a very low value - 0.01. You can easily switch back and forth from the Measures Panel to the report and re-run the report.

If this does not solve your problem, please open up a case with IBI Customer Support and we will work directly with you.

EricH
 
Posts: 164 | Registered: March 26, 2003Report This Post
Gold member
posted Hide Post
Hi Eric,

Good to know. To be honest we didn't known that we can fix target value for a loaded measure.

Yes this can be a work around thank you.

You are aware about the "target = 0" issue so we won't open any case for this.


Last question :

How do you determine the color of the perspective in a strategy map ? One objective is red so the perspective is red ? We didn’t find this information in the documentation. Just to be sure.



Thank you.


WebFOCUS 7.7.03
Windows 2008 srv
PMF 5.3.1 HF5
 
Posts: 54 | Registered: January 05, 2010Report This Post
Gold member
posted Hide Post
Hi Carlos,

At a high level the color of a perspective is calculated based on a combination of two separate weightings.

Objectives within a Perspective
If you open up the scorecard form and click “Adjust Objective Weights” you will see where these weightings are setup. You will notice each perspective is broken out by a prefixed character (ie. F – for Financial, C – for Customer, etc)

Measures within an Objective
Each Objective can be supported by many measures. This can be found on the objectives form if you click on “Adjust Measure Weights” tab.

This calculation then weights the percent reached on each supporting measure to come up with an aggregate percent reached value for the perspective. An aggregate threshold and flex from each measure are also weighted and used to calculate the actual color shown.

The color of perspectives shown on the strategy map are calculated the same as elsewhere in PMF such as stoplight, scorecard overview, etc reports.

Hope this helps,
Mike
 
Posts: 57 | Registered: December 03, 2007Report This Post
Gold member
posted Hide Post
Hi Carlos,

The strategic level calculation for Hi-Mid-Low (or Green-Yellow-Red) is mentioned in the developers guide.

This can be found in:
52 Developers Guide

Check out pages 12-14.

Thanks,
Mike
 
Posts: 57 | Registered: December 03, 2007Report This Post
Gold member
posted Hide Post
Thanks you, I missed this part.


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)    Stratmap color misunderstanding

Copyright © 1996-2020 Information Builders