Hi,ALL When I run report in olap. I drilldown from title and get the result. I use right click from HTML view the resource file to see the fex file run in background. now I want to change the IF Statement to WHERE Statement.
for example. I run the fex: -OLAP ON -* File carolap.fex
SET GRAPHEDIT=SERVER TABLE FILE CAROLAP SUM 'CAROLAP.BODY.SEATS' BY 'CAROLAP.ORIGIN.COUNTRY' BY 'CAROLAP.BODY.BODYTYPE' ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON GRAPH SET HAXIS 300 ON GRAPH SET VAXIS 100 ON TABLE SET AUTODRILL ALL ON TABLE SET OLAPPANE TABBED ON TABLE SET STYLE * INCLUDE = endeflt, $ LEFTMARGIN=0.500000, RIGHTMARGIN=0.500000, TOPMARGIN=0.500000, BOTTOMMARGIN=0.500000, $ TYPE=REPORT, TOPGAP=0.000000, BOTTOMGAP=0.013889, $ ENDSTYLE
END
and drilldown on england then I view the HTML resource
< !-- original FOCEXEC -OLAP ON SET GRAPHEDIT=SERVER SET FOCEXURL='/ibi_apps/WFServlet?IBIF_webapp=/ibi_apps&IBIC_server=EDASERVE&IBIWF_msgviewer=ON&IBIAPP_app=SESSION SESSION ibisamp baseapp&' TABLE FILE CAROLAP SUM CAROLAP.BODY.SEATS BY CAR BY CAROLAP.BODY.BODYTYPE IF COUNTRY CONTAINS 'ENGLAND' ON TABLE SET PAGE-NUM OFF ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET AUTODRILL ALL ON TABLE SET OLAPPANE TABBED ON TABLE SET STYLE * INCLUDE=endeflt,$ LEFTMARGIN=0.500000,RIGHTMARGIN=0.500000,TOPMARGIN=0.500000,BOTTOMMARGIN=0.500000,$ TYPE=REPORT,TOPGAP=0.000000,BOTTOMGAP=0.013889,$ END -->
so I want to change "IF COUNTRY CONTAINS 'ENGLAND'" to "WHERE COUNTRY CONTAINS 'ENGLAND'"
HOW can I do that.
thanks all.This message has been edited. Last edited by: Kerry,
Landerman
WebFOCUS 7.7.01 Windows 2003 server all output
September 06, 2010, 11:18 PM
Landerman
does anybody have suggistion?
Landerman
WebFOCUS 7.7.01 Windows 2003 server all output
September 17, 2010, 12:56 PM
Kerry
Hi Landerman,
Has this issue been resolved? If not, the suggestion would be to open a case with Information Builders' Customer Support Services to see if there is any way to change the generated code, and/or why you will need this. To open a case, please either call 1-800-736-6130, or access online at InfoResponse.
Cheers,
Kerry
Kerry Zhan Focal Point Moderator Information Builders, Inc.