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] Chaining does not work with PLUS sign

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Chaining does not work with PLUS sign
 Login/Join
 
dballest
Platinum Member
posted
Hi All,

We are having issues with chaining and it seems the cause is a "+" sign. I was able to replicate the issue with the CAR file. Below are 3 FEXES with output to XML and a HTML launch page. The value from the CAR dropdown is passed properly to the MODEL dropdown if the value does not have a "+" sign.

Your help is greatly appreciated.

UPDATE: We tried replacing + with - and it behaves the same way.

-* File test_param_country.fex
-*-SET ECHO = ALL;

TABLE FILE CAR
SUM COUNTRY
BY COUNTRY
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE PCHOLD FORMAT XML
END
-RUN


-* File test_param_car.fex
-*-SET ECHO = ALL;

-DEFAULT &COUNTRY = 'ITALY'

DEFINE FILE CAR
CAR/A20 = IF CAR EQ 'ALFA ROMEO' THEN 'ALFA + ROMEO' ELSE CAR;
END

TABLE FILE CAR
SUM CAR AS 'CAR'
BY CAR AS 'CAR'
WHERE COUNTRY EQ '&COUNTRY'
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE PCHOLD FORMAT XML
END
-RUN

-* File test_param_model.fex
-*-SET ECHO = ALL;

-DEFAULT &COUNTRY = 'ITALY'
-DEFAULT &CAR = 'ALFA + ROMEO'

DEFINE FILE CAR
CAR/A20 = IF CAR EQ 'ALFA ROMEO' THEN 'ALFA + ROMEO' ELSE CAR;
END

TABLE FILE CAR
SUM MODEL
BY MODEL
WHERE COUNTRY EQ '&COUNTRY'
WHERE CAR EQ '&CAR'
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE PCHOLD FORMAT XML
END
-RUN


HTML (test_chain_plus_sign.htm):
<!-- Generated by Report Layout Painter -->
<HTML>
<HEAD>
<SCRIPT id=IBI_OptionsScript type=text/javascript>
var rltVersion = "76";
var cgipath = "cgipath";
var ibirls = "ibirls2";

var rltdyncalendar = "rltdyncalendar";
var olap="olap";
var olappanebase="olappanebase";
var olapdrill="olapdrill";

var ibixmltree="ibixmltree";

var ibiOptions = new Array(cgipath,ibirls);
</SCRIPT>

<SCRIPT id=IBI_nls type=text/javascript src="/ibi_html/javaassist/nls.js"></SCRIPT>

<SCRIPT id=IBI_ibigbl type=text/javascript src="/ibi_html/javaassist/ibi/html/js/ibigbl.js"></SCRIPT>

<SCRIPT id=IBI_ibigblloadCss type=text/javascript>
ibigblloadCss(null);</SCRIPT>

<SCRIPT id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){
}
</SCRIPT>
<TITLE>HtmlPage</TITLE>
<SCRIPT id=clientEventHandlersJS type=text/javascript>
//Begin function window_onload
function window_onload() {
UpdateData();
// TODO: Add your event handler code here
}
//End function window_onload
</SCRIPT>

<SCRIPT for=window eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>
</HEAD>
<BODY style="OVERFLOW: auto" edaconnectionrequired="true">
<SELECT style="Z-INDEX: 1; POSITION: absolute; WIDTH: 330px; TOP: 80px; LEFT: 150px" id=COUNTRY tabIndex=1 name=COUNTRY newchainnumber="0" sourcetype="typeFex" datatype="1" datasource="test_param_country.fex" ibic_server="EDASERVE" ibiapp_app="dan_test" chainnumber="0" inchainindex="1" cacheruntimedata="1"></SELECT>
<SELECT style="Z-INDEX: 2; POSITION: absolute; WIDTH: 330px; TOP: 130px; LEFT: 150px" id=CAR tabIndex=2 name=CAR newchainnumber="0" sourcetype="typeFex" datatype="1" datasource="test_param_car.fex" ibic_server="EDASERVE" ibiapp_app="dan_test" chainnumber="0" inchainindex="2" cacheruntimedata="1"></SELECT>
<SELECT style="Z-INDEX: 3; POSITION: absolute; WIDTH: 330px; TOP: 180px; LEFT: 150px" id=MODEL tabIndex=3 name=MODEL newchainnumber="0" sourcetype="typeFex" datatype="1" datasource="test_param_model.fex" ibic_server="EDASERVE" ibiapp_app="dan_test" chainnumber="0" inchainindex="3" cacheruntimedata="1"></SELECT>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden inputcontrolids="COUNTRY;CAR;MODEL">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value=dan_test type=hidden name=ibiapp_app>
<SCRIPT id=IBI_ChainScript type=text/javascript>
<!--
window.chain0=new Array(1);
window.chain0[0]=new String("COUNTRY;CAR;MODEL");
window.chain0[1]=0
//--></SCRIPT>
</BODY></HTML>

This message has been edited. Last edited by: Kerry,


Dev: WebFOCUS 7.6.10, Data Migrator 7.6.10
QA: WebFOCUS 7.6.10, Data Migrator 7.6.10
Prod: WebFOCUS 7.6.2, Data Migrator 7.6.8
Windows 2K3, Tomcat 5.5.17, IIS 6
Usage: HTML, PDF, Excel, Self-serve, BID and MRE
 
Posts: 197 | Location: Roseville, CA | Registered: January 24, 2005Report This Post
Mary Watermann
Gold member
posted Hide Post
I was able to get you code to work.

1. In the HTML Composer select the PARAMETER tab
2. Click on the ARROW between COUNTRY and CAR
3. In the Properties and Settings window, select COUNTRY from the "..." for the "Resolves parameter" value.
4. Repeat #3 for the next chain (arrow) but this time select CAR.


WF 7.6.10, Windows, PDF, Excel
 
Posts: 75 | Location: Dallas, TX | Registered: February 12, 2004Report This Post
dballest
Platinum Member
posted Hide Post
Thanks for the reply Mary. I switched my DevStudio to 7.7.03 and updated the HTML file as per your suggestion but no luck. I then proceeded to re-create the file in 7703 and it works now. I need to convert test this file into Webfocus 7.6.2 (production version). I'll keep you posted.

Thanks,
Dan

This message has been edited. Last edited by: dballest,


Dev: WebFOCUS 7.6.10, Data Migrator 7.6.10
QA: WebFOCUS 7.6.10, Data Migrator 7.6.10
Prod: WebFOCUS 7.6.2, Data Migrator 7.6.8
Windows 2K3, Tomcat 5.5.17, IIS 6
Usage: HTML, PDF, Excel, Self-serve, BID and MRE
 
Posts: 197 | Location: Roseville, CA | Registered: January 24, 2005Report 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] Chaining does not work with PLUS sign

Copyright © 1996-2020 Information Builders