Focal Point
[CLOSED] IF in OLAP DRILLDOWN

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

September 06, 2010, 09:26 AM
Landerman
[CLOSED] IF in OLAP DRILLDOWN
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.