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.
Our requirement is to create a graph and drill down the detail report based on the section of graph.
Steps which we followed.
Procedure1: Two parameters
#1 Created hold file which will have the data with computed values. #2 Created a graph with hold file. #3 stored the parameters as global parameters. #4 hyper link the procedure 2 to graph with section of graph selected(only one parameter).
Procedure 2: Three parameters
#1 created detail report which will have the two parameters of procedure 1 (graph) and third parameter is the section of graph area.
Created HTML page using HTML composer and call the above proc 1 in HTML page.
Issue:
Select the value from listbox one and two and click on submit.
page shows Graph and detail report successfully for the first time.
When we reselect list box and try to run the report.it shows the previous selection data not the current one.
we stored the params as global paramas in graph and using global params in proc#2.
global params are not refreshing each run of proc #2.
Please help us on this issue.This message has been edited. Last edited by: <Kathryn Henning>,
it's good practice to add a dummy parameter ( usually named RND or NOCACHE) with a random value to prevent caching in the first place. No matter what the browser settings are.
e.g.
-SET &NOCACHE = 1000000000 * RDUNIF(I1);
And add this as a paramter to the drill. ( NOCACHE=&NOCACHE )
g'luck, Dave
_____________________ WF: 8.0.0.9 > going 8.2.0.5
Posts: 668 | Location: Veghel, The Netherlands | Registered: February 16, 2010