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  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Chart .fex File Results Keep Varying, Incorrect Results 75% of the Time

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Chart .fex File Results Keep Varying, Incorrect Results 75% of the Time
 Login/Join
 
RC@WB
Member
posted
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
 
Posts: 16 | Registered: June 19, 2017Report This Post
MartinY
Virtuoso
posted Hide Post
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
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Chart .fex File Results Keep Varying, Incorrect Results 75% of the Time

Copyright © 1996-2020 Information Builders