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)    Controlling pmf_booklet_data, when there is no data found.

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Controlling pmf_booklet_data, when there is no data found.
 Login/Join
 
Mika Keranen
Gold member
posted
Is there a way, other than customizing/modifying the fex itself, to tell pmf_booklet_data that if there is no data found, continue the main fex? For example, in the following case we get a PMF 'No Data Found' message, although there is data for current year. This is a simplified version, I didn't copy all -SET commands, but could we control the behaviour with any &variable?

-SET &TIME_RANGE = '12MM' ;
...
-SET &MEASURES_HOLD_FILE = 'CURR_PRD';
-INCLUDE PMF_BOOKLET_DATA

And the the same thing for Prior year.
-SET &TIME_RANGE = '12MM_PRI' ;
...
-SET &MEASURES_HOLD_FILE = 'PRIOR_PRD';
-INCLUDE PMF_BOOKLET_DATA

We have data for current year for all metrics, but some don't have prior year. When this happens, we get 'No Data'. We could pf course try doing this with a different timerange (e.g. PRI_CUR_Y), but that would also require changing the program logic.

The customer is using PMF 513.

Thanks,
Mika


WebFOCUS 7.6.x
PMF 5.2.x
 
Posts: 58 | Location: Sydney, Australia | Registered: April 22, 2005Report This Post
Bob Jude Ferrante
Master
posted Hide Post
pmf_booklet_data is going to throw an error and jump to the :ERROR_XT label if there is a WebFOCUS error message thrown, or the :NODATA label if there is no data returned from a request.

You could "hook" those labels with modifications to handle these errors differently if you needed, that would be a customization.

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
Michael Paul
Gold member
posted Hide Post
Hi Mika,

There is a switch that you can set before calling pmf_booklet_data to tell it to ignore the NODATA page and continue to the end.

-SET &DISP_NO_DATA = 'N' ;

If this is set the NODATA page will not be displayed and it will finish to success in pmf_booklet_data. To catch this you will need to put in a check to see if any lines exist using "-IF (&LINES EQ 0) THEN GOTO".

Good luck!
Mike
 
Posts: 57 | Registered: December 03, 2007Report This Post
Mika Keranen
Gold member
posted Hide Post
Gentlemen, thanks for the answers. And Mike, thanks, good to know about &DISP_NO_DATA parameter. I ended up rewriting the program and using a time period that gives me the data for current and prior year with one go (PRI_CUR_Y). So no worries here anymore Wink .

Thanks,
Mika


WebFOCUS 7.6.x
PMF 5.2.x
 
Posts: 58 | Location: Sydney, Australia | Registered: April 22, 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)    Controlling pmf_booklet_data, when there is no data found.

Copyright © 1996-2020 Information Builders