OLAP Delta Load - SAP

[mike_garcia]

Hello,

I hope someone can help me out with this. I'm trying to do a Delta Load from an InfoCube via the QvSAPOLAPConnector.

If I load the cube with all the dimensions and measures, it fetches the Data appropriately (using Slices). But I understand I need to load the info object named 0REQUID as a Dimension to let QlikView know what records have been updated.

The problem is that I can't seem to be able to load that Dimension. I tried this code:

[$ZADGACM05]:
Load *;
Select PseudoMDX (
 Dimensions (
 [0REQUID] ()),
 Measures (
 [0MEASURES0000000000000000].[0QUANTITY0000000000000000], //Cantidad
 [0MEASURES0000000000000000].[0AMOUNT000000000000000000], //Importe
 [0MEASURES0000000000000000].[ZAMO9CORR0000000000000000]), //Importe Pesos Corrientes
From ($ZADGACM05));

but got this error when debugging:

That happens when I use v5.3 of the Connector. If I use v5.4, I get an error that says "Axis Info could not be Retrieved for MDX".

Do I need to have specific permissions somewhere in SAP? What might cause this?

These are the log messages generated by QV SAP Connector (the first one is when I use 5.3 and the second when I use 5.4)

v5.3:

2010-05-24 15:31:46 Progress Connected to SAP with C:\Program Files\Common Files\QlikTech\Custom Data\QvSAPConnector\QvSAPOLAPConnector.dll 5, 3, 7758 IR

2010-05-24 15:31:46 Progress Statement is: SELECT PSEUDOMDX ( DIMENSIONS ( [0REQUID] ()), MEASURES ( [0MEASURES0000000000000000].[0QUANTITY0000000000000000], [0MEASURES0000000000000000].[0AMOUNT000000000000000000], [0MEASURES0000000000000000].[ZAMO9CORR0000000000000000]), FROM ($ZADGACM05))

2010-05-24 15:31:46 Progress Disconnected

2010-05-24 15:31:46 Progress Connected

2010-05-24 15:31:46 Progress GetAxisData called for

SELECT NON EMPTY {Distinct([0REQUID].ALLMEMBERS)}

ON AXIS(0),

{[0MEASURES0000000000000000].[0QUANTITY0000000000000000],[0MEASURES0000000000000000].[0AMOUNT000000000000000000],[0MEASURES0000000000000000].[ZAMO9CORR0000000000000000]} ON AXIS(1)

FROM [$ZADGACM05]

2010-05-24 15:31:46 Progress Reply received from GetAxisData

2010-05-24 15:31:46 Progress Reply received from GetAxisData: [0REQUID] has 0 members

2010-05-24 15:31:46 Progress Disconnected

2010-05-24 15:31:47 Progress Connected

2010-05-24 15:31:47 Progress SELECT NON EMPTY

{Distinct(Descendants([0REQUID].[All],[0REQUID].[LEVEL00],AFTER))}

ON AXIS(0),

{[0MEASURES0000000000000000].[0QUANTITY0000000000000000],[0MEASURES0000000000000000].[0AMOUNT000000000000000000],[0MEASURES0000000000000000].[ZAMO9CORR0000000000000000]} ON AXIS(1)

FROM [$ZADGACM05]

2010-05-24 15:31:47 Compiling Progress Calling GetAxisInfo

2010-05-24 15:31:47 Compiling Progress Reply from GetAxisInfo

2010-05-24 15:31:47 Warning Axis Info could not be Retrieved for MDX statement! Key = ()

2010-05-24 15:31:47 Progress GetCellData called

2010-05-24 15:31:47 Progress Reply received from GetCellData with 0 rows

2010-05-24 15:31:47 Progress GetCellData called

2010-05-24 15:31:47 Progress Reply received from GetCellData with 0 rows

2010-05-24 15:31:47 Progress GetCellData called

2010-05-24 15:31:47 Progress Reply received from GetCellData with 0 rows

2010-05-24 15:31:47 Progress GetAxisData called

2010-05-24 15:31:47 Progress Reply received from GetAxisData with 0 rows

2010-05-24 15:31:47 Progress Disconnected

2010-05-24 15:31:47 Progress Connected

2010-05-24 15:31:55 Progress Disconnected

______________

v5.4:

2010-05-24 13:08:33 Progress Connected to SAP with C:\Program Files\Common Files\QlikTech\Custom Data\QvSAPConnector\QvSAPOLAPConnector.dll 5, 4, 8282 IR

2010-05-24 13:08:34 Progress Statement is: SELECT PSEUDOMDX ( DIMENSIONS ( [0REQUID] ()), MEASURES ( [0MEASURES0000000000000000].[0QUANTITY0000000000000000], [0MEASURES0000000000000000].[0AMOUNT000000000000000000], [0MEASURES0000000000000000].[ZAMO9CORR0000000000000000]), FROM ($ZADGACM05))

2010-05-24 13:08:37 Progress SELECT NON EMPTY {Distinct(Descendants([0REQUID].ALLMEMBERS,1,LEAVES))}

ON AXIS(0),

{[0MEASURES0000000000000000].[0QUANTITY0000000000000000],[0MEASURES0000000000000000].[0AMOUNT000000000000000000],[0MEASURES0000000000000000].[ZAMO9CORR0000000000000000]} ON AXIS(1)

FROM [$ZADGACM05]

2010-05-24 13:08:37 Progress BAPI_MDDATASET_GET_AXIS_DATA returned after 00:00:00

2010-05-24 13:08:37 Progress BAPI_MDDATASET_GET_AXIS_DATA returned 0 rows in MNDTRY_PRPTYS

2010-05-24 13:08:37 Progress BAPI_MDDATASET_GET_AXIS_DATA returned 0 rows in OPTION_PRPTYS_KEYS

2010-05-24 13:08:37 Progress BAPI_MDDATASET_GET_AXIS_DATA returned 0 rows in OPTION_PRPTYS_VALS

2010-05-24 13:08:37 Progress Reply received from GetAxisData: [0REQUID] has 0 members

2010-05-24 13:08:37 Progress SELECT NON EMPTY

{Distinct(Descendants([0REQUID].[All],[0REQUID].[LEVEL00],AFTER))}

ON AXIS(0),

{[0MEASURES0000000000000000].[0QUANTITY0000000000000000],[0MEASURES0000000000000000].[0AMOUNT000000000000000000],[0MEASURES0000000000000000].[ZAMO9CORR0000000000000000]} ON AXIS(1)

FROM [$ZADGACM05]

2010-05-24 13:08:37 Progress BAPI_MDDATASET_GET_AXIS_INFO returned after 00:00:00

2010-05-24 13:08:37 Progress BAPI_MDDATASET_GET_AXIS_INFO returned 0 rows in AXIS_INFO

2010-05-24 13:08:37 Progress BAPI_MDDATASET_GET_AXIS_INFO returned 0 rows in AXIS_DIMENSIONS

2010-05-24 13:08:37 Progress BAPI_MDDATASET_GET_AXIS_INFO returned 0 rows in AXIS_LEVELS

2010-05-24 13:08:37 Progress BAPI_MDDATASET_GET_AXIS_INFO returned 0 rows in DIM_PRPTYS

2010-05-24 13:08:37 Warning Axis Info could not be Retrieved for MDX statement! Key = ()

2010-05-24 13:08:37 Progress BAPI_MDDATASET_GET_CELL_DATA returned after 00:00:00

2010-05-24 13:08:37 Progress BAPI_MDDATASET_GET_CELL_DATA returned 0 rows in CELL_DATA

2010-05-24 13:08:37 Progress BAPI_MDDATASET_GET_CELL_DATA returned after 00:00:00

2010-05-24 13:08:37 Progress BAPI_MDDATASET_GET_CELL_DATA returned 0 rows in CELL_DATA

2010-05-24 13:08:37 Progress BAPI_MDDATASET_GET_CELL_DATA returned after 00:00:00

2010-05-24 13:08:37 Progress BAPI_MDDATASET_GET_CELL_DATA returned 0 rows in CELL_DATA

2010-05-24 13:08:37 Progress BAPI_MDDATASET_GET_AXIS_DATA returned after 00:00:00

2010-05-24 13:08:37 Progress BAPI_MDDATASET_GET_AXIS_DATA returned 0 rows in MNDTRY_PRPTYS

2010-05-24 13:08:37 Error No Axis Information Received

2010-05-24 13:11:50 Progress Disconnected

_______

Any help is greatly appreciated.

Mike.

[Lars_Wahlstedt]

Hi Mike,

it seems from the log that the Data Package dimension is empty. Are you sure the InfoCube hasn't been compressed?

Regards / Lars Wahlstedt

[pover]

I'm getting the same error with the OLAP Delta Load. I doubled checked with the BW user and he showed me the values in the 0REQUID field in the cube that we're using to test the delta load. I will attach the log later, but the error showed 0 members in the 0REQUID field and then failed.

Is it correct that I don't even see the 0REQUID field in the list of characteristics under the same cube in the OLAP Connector wizard?

Thanks.

[mike_garcia]

Hi Karl,

We have not yet figured out why this happens, but I can tell you that we tried a different approach to do the Delta Load, using QvSAPConnector.

We still used 0REQUID, but read from the Dimension Table DcubenameP and using a for loop on every new ID to read the Fact Tables. Then storing those IDs in a qvd for further use.

It is a different way of doing the same, but I have been told that the performance is better and does not have the restriction of 1 million records, as the QvSAPOLAPConnector does.

Please, if you find the answer to the original question, post it back.

Hope this helps.

Mike.

[pover]

Hi Mike,

I confirmed with another consultant this same error so I think it is a bug.

We ended up using the SAP SQL Connector and it had the added benefit of reloading all the cubes in 40 minutes instead of the 8 hours the OLAP Connector took, so the customer was happy.

Thanks, Karl.

[suniljain]

Pls Try Attached Application for Delta load.