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    Performance Management Framework (PMF)    User Tip on Defining Measure entry formulas.

Read-Only Topic
 Go Search Notify Tools
 User Tip on Defining Measure entry formulas.
Gold member
 posted May 07, 2009 06:21 PM
Here's a quick tip on defining the measure entry formulas.

Most people don't realize that the measure entry formulas can do more than simple math as stated below.

TARGET/D20.2= [TARGET] + 100 ;

You can actually incorporate all the multitude of the WebFOCUS functions available. If perhaps you want to put a limit on the lowest available target number that could be entered you could simply enter a value to be forced to 80 if a value is entered lower than that.

TARGET/D20.2= IF ([TARGET] LT 80) THEN 80 ELSE [TARGET];

Alternatively if you want you can prevent numbers from being entered as negative numbers by using the WebFOCUS ABS() function.

TARGET/D20.2= ABS([TARGET]) ;

Feel free to try the unlimited number of possibilities.

I hope this helps!
Mike

 Posts: 57 | Registered: December 03, 2007 IP
Master
 posted May 08, 2009 09:33 AM Hide Post
Additional tips. As Mike says, you can use all kinds of logical operators such as IF THEN ELSE and LT, GT, LE, GE, etc.

Also as Mike says, you can use hundreds of WebFOCUS user functions, as documented in the WebFOCUS docs.

In a lot of senses, this capability is powerful and nearly unlimited.

But there are always limitations. Note that the RECAP type functions will not work since these require reference to data on other rows, and the nature of this is that you're only working with cells intra-row. So no recursion or cross references to values from any other rows. And no plans to allow for these... they tend to be fairly esoteric anyway. You'll have to build a custom app to handle this, or you can use a planning tool like Tagetik (that's really why you're using recursion anyway, right - you're doing planning?).

Questions...
In the recent past, we've had people ask for the ability to enter Y or N or Yes or No in the boxes, because they want to use it for survey type responses. Although theoretically this could work, there is active validation logic implemented in the Measure Entry sheet itself that forces all input to be numeric. Textual entries aren't possible. What this means is right now you have to phrase your Yeses and Nos as '0' for No and '1' for Yes. But they could be in the future... and would work provided you ultimately converted their values to numbers (they must be stored as numeric data ultimately). Is anyone planning to use PMF Measures Entry for this type of work today?

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, 2003 IP
 Powered by Social Strata

Read-Only Topic

Focal Point    Focal Point Forums    Performance Management Framework (PMF)    User Tip on Defining Measure entry formulas.

Copyright © 1996-2020 Information Builders