Extraction from SAP Cube

Thu, 11 Mar 2010 12:51:18 GMT

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

Extraction from SAP Cube

Fri, 07 May 2010 19:56:46 GMT

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

Extraction from SAP Cube

Thu, 10 Mar 2011 12:34:42 GMT

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

topic Extraction from SAP Cube in QlikView

Extraction from SAP Cube

Extraction from SAP Cube

Extraction from SAP Cube