Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

QvSAPOLAPConnector 0 lines fetched

Hi All,

I hope somebody could help me with using SAP OLAP Connector, I'm not familiar with SAP (I don't have SAP background) so please guide me.

I can't fetch SAP data using SAP OLAP Connector (I'm using OLAP Connector to get access on their cubes).

Below are the screenshots and log files.

1. We successfully connected qlikview to their SAP system using SAP OLAP

01.PNG.png

2. I selected 1 Dimension (Fiscal year/period), 1 Metric (Gross Up Sales), and set Calendar Month Input = ALL as SAMPLE (just to see if the connection is okay)

02.PNG.png

3. LOG FILE IS GENERATED

------

2014-02-25 16:39:03 Progress Connected to SAP with C:\Program Files\Common Files\QlikTech\Custom Data\QvSAPConnector\QvSAPOLAPConnector.dll 5.80 SR2, 2014

2014-02-25 16:39:03 Progress Log: 1

2014-02-25 16:39:03 Progress Logpath:

2014-02-25 16:39:03 Progress LogFile: QvSAPOLAPConnector

2014-02-25 16:39:03 Progress Connected

2014-02-25 16:39:03 Progress Creation of function OCS_GET_SYSTEM_INFO returned after 00:00:00

2014-02-25 16:39:04 Progress SystemVersion is 701. Support pack level is 0008

2014-02-25 16:39:12 Progress Creation of function BAPI_MDPROVIDER_GET_DIMENSIONS returned after 00:00:00

2014-02-25 16:39:13 Progress Creation of function BAPI_MDPROVIDER_GET_MEASURES returned after 00:00:01

2014-02-25 16:39:13 Progress Creation of function BAPI_MDPROVIDER_GET_VARIABLES returned after 00:00:00

2014-02-25 16:39:13 Progress BAPI_MDPROVIDER_GET_VARIABLES returned 2 rows in VARIABLES

2014-02-25 16:39:51 Progress Creation of function BAPI_MDPROVIDER_GET_HIERARCHYS returned after 00:00:01

2014-02-25 16:39:51 Progress Creation of function BAPI_MDPROVIDER_GET_PROPERTIES returned after 00:00:00

2014-02-25 16:40:02 Progress Creation of function BAPI_MDPROVIDER_GET_MEMBERS returned after 00:00:01

2014-02-25 16:40:05 Progress Creation of function BAPI_MDPROVIDER_GET_MEMBERS returned after 00:00:00

2014-02-25 16:40:30 Progress Disconnected

------

4. Then OLAP Connector generates the below script (I didn't run the "STORE" and "DROP" since this is only a test)

03.PNG.png

5. When I run the script, I get "0 lines fetched"

04.PNG.png

6. LOG FILE IS AGAIN GENERATED

------

2014-02-25 16:40:59 Progress Connected to SAP with C:\Program Files\Common Files\QlikTech\Custom Data\QvSAPConnector\QvSAPOLAPConnector.dll 5.80 SR2, 2014

2014-02-25 16:40:59 Progress Log: 1

2014-02-25 16:40:59 Progress Logpath:

2014-02-25 16:40:59 Progress LogFile: QvSAPOLAPConnector

2014-02-25 16:41:00 Progress Connected

2014-02-25 16:41:00 Progress Creation of function OCS_GET_SYSTEM_INFO returned after 00:00:00

2014-02-25 16:41:00 Progress SystemVersion is 701. Support pack level is 0008

2014-02-25 16:41:00 Progress Statement is: SELECT PSEUDOMDX D ( DIMENSIONS ( [0FISCPER] ()), MEASURES ( [4OTWP8VC18IRKSTU81THW5ISU].[4OTWPAD3PYQQ76LZCW9VUJ9TA]), VARIABLES ( [CMIM_VSM] (I = [0CALMONTH].[All])), FROM (Z0SD_M07/ULBO_SD_Z0SD_M07_CPP_Q4))

2014-02-25 16:41:00 Progress GlobalOptions: m_TryWithoutSlicing - Yes

2014-02-25 16:41:00 Progress GlobalOptions: m_OptimizeByReducingOnCharacteristic - No

2014-02-25 16:41:00 Progress Creation of function BAPI_MDPROVIDER_GET_DIMENSIONS returned after 00:00:00

2014-02-25 16:41:00 Progress Creation of function BAPI_MDPROVIDER_GET_DIMENSIONS returned after 00:00:00

2014-02-25 16:41:00 Progress BAPI_MDPROVIDER_GET_DIMENSIONS returned after 00:00:00

2014-02-25 16:41:01 Progress Creation of function BAPI_CUBE_GETDETAIL returned after 00:00:01

2014-02-25 16:41:01 Progress BAPI_CUBE_GETDETAIL returned after 00:00:00

2014-02-25 16:41:01 Progress BAPI_CUBE_GETDETAIL returned 86 rows in DIMENSIONINFOOBJECTS

2014-02-25 16:41:01 Progress Creation of function BAPI_CUBE_GETLIST returned after 00:00:00

2014-02-25 16:41:01 Progress BAPI_CUBE_GETLIST returned 388 rows in INFOCUBELIST

2014-02-25 16:41:01 Trace Cube Type is: M

2014-02-25 16:41:01 Progress Creation of function BAPI_MDPROVIDER_GET_LEVELS returned after 00:00:00

2014-02-25 16:41:01 Progress Creation of function SRTT_GET_TABLE_SIZE_RFC returned after 00:00:00

2014-02-25 16:41:02 Progress Creation of function BAPI_MDPROVIDER_GET_MEASURES returned after 00:00:01

2014-02-25 16:41:02 Progress BAPI_MDPROVIDER_GET_MEASURES returned after 00:00:00

2014-02-25 16:41:02 Trace Time Characteristic: [0FISCPER], Dimension: Z0SD_M07T, Key for seperate load: [0FISCPER]

2014-02-25 16:41:02 Progress Creation of function RSR_MDX_CREATE_OBJECT returned after 00:00:00

2014-02-25 16:41:02 Trace Checking syntax for: SELECT NON EMPTY {DISTINCT (DESCENDANTS ([0FISCPER].[All],[0FISCPER].[LEVEL00],AFTER))} ON AXIS(0) FROM [Z0SD_M07/ULBO_SD_Z0SD_M07_CPP_Q4] SAP VARIABLES

[CMIM_VSM] INCLUDING [0CALMONTH].[All]

2014-02-25 16:41:02 Progress Creation of function BAPI_MDDATASET_CHECK_SYNTAX returned after 00:00:00

2014-02-25 16:41:02 Progress SELECT NON EMPTY {DISTINCT (DESCENDANTS ([0FISCPER].[All],[0FISCPER].[LEVEL00],AFTER))} ON AXIS(0) FROM [Z0SD_M07/ULBO_SD_Z0SD_M07_CPP_Q4] SAP VARIABLES

[CMIM_VSM] INCLUDING [0CALMONTH].[All]

2014-02-25 16:41:02 Progress Creation of function RSR_MDX_GET_AXIS_DATA returned after 00:00:00

2014-02-25 16:41:02 Progress RSR_MDX_GET_AXIS_DATA returned after 00:00:00

2014-02-25 16:41:02 Progress RSR_MDX_GET_AXIS_DATA returned 0 rows in MNDTRY_PRPTYS

2014-02-25 16:41:02 Progress RSR_MDX_GET_AXIS_DATA returned 0 rows in OPTION_PRPTYS_KEYS

2014-02-25 16:41:02 Progress RSR_MDX_GET_AXIS_DATA returned 0 rows in OPTION_PRPTYS_VALS

2014-02-25 16:41:02 Progress Creation of function RSR_MDX_CREATE_OBJECT returned after 00:00:00

2014-02-25 16:41:02 Trace Checking syntax for: SELECT NON EMPTY SUBSET (

{Distinct(Descendants([0FISCPER].[All],[0FISCPER].[LEVEL00],AFTER))}, 0, 2000000) ON AXIS(0),

{[4OTWP8VC18IRKSTU81THW5ISU].[4OTWPAD3PYQQ76LZCW9VUJ9TA]} ON AXIS(1)

FROM [Z0SD_M07/ULBO_SD_Z0SD_M07_CPP_Q4]

SAP VARIABLES

[CMIM_VSM] INCLUDING [0CALMONTH].[All]

2014-02-25 16:41:02 Progress Creation of function BAPI_MDDATASET_CHECK_SYNTAX returned after 00:00:00

2014-02-25 16:41:03 Progress Creation of function RSR_MDX_GET_CELL_DATA returned after 00:00:01

2014-02-25 16:41:03 Progress RSR_MDX_GET_CELL_DATA returned 0 rows in CELL_DATA

2014-02-25 16:41:03 Progress Creation of function RSR_MDX_GET_AXIS_DATA returned after 00:00:00

2014-02-25 16:41:03 Progress RSR_MDX_GET_AXIS_DATA returned 0 rows in MNDTRY_PRPTYS

2014-02-25 16:41:03 Trace 0 Data items successfully retreived.

2014-02-25 16:41:03 Progress Resetting Server Context

2014-02-25 16:41:03 Progress Disconnected

------

SAP developers said they did the step by step setup from "Connector Manual" QlikTech gave us for the SAP Connector (Roles assignment *QTQVCBWACCESS*, transport installation, etc)

I hope someone can help me with this.

Thank you for your time

-Alex

18 Replies
Highlighted
Not applicable

Re: QvSAPOLAPConnector 0 lines fetched

try using single calendar month.

Highlighted
Not applicable

Re: QvSAPOLAPConnector 0 lines fetched

Hi aamir,

Thanks for answering... but I still get "0 lines fetched"

Z0SD_M07/ULBO_SD_Z0SD_M07_CPP_Q4 << Select PseudoMDX D (

Dimensions (

  [0FISCPER] ()),

Measures (

  [4OTWP8VC18IRKSTU81THW5ISU].[4OTWPAD3PYQQ76LZCW9VUJ9TA]),

Variables (

  [CMIM_VSM] (I = [0CALMONTH].[201307])),

From (Z0SD_M07/ULBO_SD_Z0SD_M07_CPP_Q4)) 0 lines fetched

Highlighted
Not applicable

Re: QvSAPOLAPConnector 0 lines fetched

whats your cube size

Highlighted
Not applicable

Re: QvSAPOLAPConnector 0 lines fetched

SAP dev told me its 3,452MB

Highlighted
Not applicable

Re: QvSAPOLAPConnector 0 lines fetched

do you can anyother cube and have you tried that cube.

Highlighted
Not applicable

Re: QvSAPOLAPConnector 0 lines fetched

Yes I tried other cubes (Info Provider) from the list, but I get "0 lines fetched" for them all

Highlighted
Not applicable

Re: QvSAPOLAPConnector 0 lines fetched

I hope all the transports have been done to all the clients of SAP BW

Highlighted
Not applicable

Re: QvSAPOLAPConnector 0 lines fetched

Sorry for my late reply...

They only did the set up of SAP OLAP since that's the only connector we need.

Do we need to set up all roles, assignments, and transports of all the SAP Connector?

I thought we'll only need to set up the specific connector we need?

Highlighted
Not applicable

Re: QvSAPOLAPConnector 0 lines fetched

There is a transport for roles. Assign that roles to user you are using. Also make sure that this transport is transported to all the clients in the system you are using.