Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    Controlling pmf_booklet_data, when there is no data found.
Go
New
Search
Notify
Tools
Reply
  
Controlling pmf_booklet_data, when there is no data found.
 Login/Join
 
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, 2005Reply With QuoteReport This Post
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, 2003Reply With QuoteReport This Post
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, 2007Reply With QuoteReport This Post
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, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

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-2018 Information Builders, leaders in enterprise business intelligence.