5 Replies Latest reply: Sep 20, 2010 2:32 AM by s j RSS

    OLAP Delta Load - SAP

    Miguel �ngel Garc�a

      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:

      error loading image

      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.


        • OLAP Delta Load - SAP
          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

            • OLAP Delta Load - SAP
              Karl 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.

                • OLAP Delta Load - SAP
                  Miguel �ngel Garc�a

                  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.

                    • OLAP Delta Load - SAP
                      Karl 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.

                • OLAP Delta Load - SAP
                  s j

                  Pls Try Attached Application for Delta load.