Focal Point
[CLOSED] Chart .fex File Results Keep Varying, Incorrect Results 75% of the Time

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6237032786

July 14, 2017, 12:14 PM
RC@WB
[CLOSED] Chart .fex File Results Keep Varying, Incorrect Results 75% of the Time
I have 2 chart .fex files, and both of them run & return incorrect results the 1st couple of times they're run. After about the 3rd try, the results will populate correctly.
(Example of incorrect result for chart 1: Chart 1 is LOOKGRAPH VLINE, sometimes just 1 data point with shows up). Both chart .fex files have a COMPUTE in the GRAPH FILE "name", could this be the issue? I could move the COMPUTE(s) to a HOLD file before proceeding with the GRAPH FILE "name" code?

Thanks

App Studio
WF 8105m

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8

Windows, All Outputs
July 17, 2017, 07:42 AM
MartinY
Does the reports display correct result when you run them independently ?
If you run them as regular report instead of graph, does the result is correct ?
This is the first thing to insure that they both run ok by themselves. It is not clear if you run them together (from a HTML page per example) or if they have no relation together.

What is the source of your data ? Do they share the same source from a DB, a HOLD file build from another process, ... ?

A COMPUTE is applied once the data as been extracted from the source (WHERE clauses applied) and once the BY fields are performed.
It could be possible that if your data is not extracted the way you thing it should, that the result differ from the expected result.

Posting your code may help to understand your issue.


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007