Extraction from SAP Cube

[#1]

Hi,

i am fetching the data through sap connector from cubes and how can i apply the where clause to prepared the Qvd for every year. on the Below Cubes what code i need to put.

Select PseudoMDX (
Dimensions (
[BUD_CTRY] G1(),
[BUD_LOC] G1(),
[0DOC_DATE] (),
[0NETDUEDATE] (),
[0PSTNG_DATE] (),
[0CALMONTH] ()),
Measures (
[3ZAJ9QPTM5D8U5L9A1RCNSWWE].[05N6UOUENHI2PSWMWNWV0HQS0],
[3ZAJ9QPTM5D8U5L9A1RCNSWWE].[6VMTYSJE733GVSGXA7WME01WO],
[3ZAJ9QPTM5D8U5L9A1RCNSWWE].[AN043YDNYQQUUJIIW73G7SLCX],
[3ZAJ9QPTM5D8U5L9A1RCNSWWE].[AYC6O2WD0MJ1CXERY8AHAKUVC]),
From (ZBUD_CUBE/ZZBUD_LWT));

1)i want to apply the where condition based on posting date like where [0PSTNG_DATE] () >= '01.01.2007'

and [0PSTNG_DATE] () <= '31.12.2007'

2) instead of >= i also try GE and LE but still it is not working and i also change the date format like

where [0PSTNG_DATE] () >= '20070101'

and [0PSTNG_DATE] () <= '20071231'

urgent pls provide support

[#2]

Did U find the answer ? If so can you please post the solution. I am trying to implement incremental load da from ODS .

[#3]

Did you ever get an answer for this? We're looking for the same thing