Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] IF in OLAP DRILLDOWN
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] IF in OLAP DRILLDOWN
 Login/Join
 
Silver Member
posted
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
 
Posts: 30 | Registered: January 29, 2010Reply With QuoteReport This Post
Silver Member
posted Hide Post
does anybody have suggistion?


Landerman

WebFOCUS 7.7.01
Windows 2003 server
all output
 
Posts: 30 | Registered: January 29, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
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.
 
Posts: 1950 | Location: New York | Registered: November 16, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] IF in OLAP DRILLDOWN

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.