As posted earlier through some of similar posts on the forum I've come to know that filters (here WHERE/IF) and OLAP doesn't work together, is this true? Help me as its a blocker for me.

Below is the original post:

I am making a Report with a WHERE condition on Start Month/Year and End Month Year, also I have put the AUTOMATIC DRILLDOWN option ON. It works fine without the WHERE condition but when I apply WHERE condition DRILLDOWN doesn't work.
PLS HELP ME AS I AM NEW TO WebFOCUS!!!!

Following is the piece of code:

TABLE FILE TEST
SUM
CNT.CASEREFNUMBER AS 'CNT,CASEREFNUMBER'
BY
STATE AS 'State'
BY
REGION AS 'Region'
BY
PARISH AS 'Parish'
ACROSS
MONTH AS 'Month'

ON STATE SUBTOTAL
CASEREFNUMBER AS '*State Total: '

ON REGION SUBTOTAL AS '*Region Total:'
WHERE HDATE(INTAKERECEIVEDDT, 'MYY') GE HDATE(HINPUT(8, '&startYear.(2003,2004,2005).Start Year.' | '&startMonth.(01,02,03,04,05,06,07,08,09,10,11,12).Start Month.' | '01' , 8, 'HYYMDS'),'MYY')
AND
HDATE(INTAKERECEIVEDDT, 'MYY') LE HDATE(HINPUT(8, '&endYear.(2003,2004,2005).End Year.' | '&endMonth.(01,02,03,04,05,06,07,08,09,10,11,12).End Month.' | '01' , 8, 'HYYMDS'), 'MYY');

Hi,

I think following code may be helpful for you..
where you can do drilldown and also filtering using where condition...

-OLAP ON
-* File olap.fex
OLAP DIMENSIONS
-* DIMENSIONS FILE car
COUNTRY: COUNTRY, CAR, MODEL;
END
TABLE FILE CAR
PRINT
DEALER_COST
RETAIL_COST
BY
COUNTRY
WHERE ( COUNTRY EQ 'ENGLAND' );
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET AUTODRILL ON
ON TABLE SET OLAPPANE TOP
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
ENDSTYLE
END

Regards,
Goldy