Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

SAP BW OLAP Connector Issue

Hi Dears,

I have been trying to interface with SAP BW.

But I didn't succeed in connecting to SAP BW so far

So I really need your help.

[ Environments ]

  • Client OS : Windows7 64 Bit
  • QlikView Version : 11.2 SR8
  • SAP Connector : 5.80 SR3(QlikViewSAP_x64Setup5.8-SR3.exe)
  • SAP BASIS : 7.40

Followings are images that I captured the process of connection.

1. SAP-TEST-EditScript.png

2. SAP-TEST-Connection.png

2. SAP-TEST-Connection-Success.png

2. SAP-TEST-BW-OLAP-CUBE.png

2. SAP-TEST-BW-OLAP-Execution.png

2. SAP-TEST-BW-OLAP-Error.png

I welcome any comments.

Thank you for your help.

WanKi,

6 Replies
aoi
Contributor

Re: SAP BW OLAP Connector Issue

Have you looked at the log file (C:\ProgramData\QlikTech\Custom Data\QvSAPConnector\Log)?

Not applicable

Re: SAP BW OLAP Connector Issue

Yes, I got a log file.

Contents are below.

--------------------------------------------------------------------------------------------------------------------------------------

2014-09-25 PM 6:12:03:      Execution started.

2014-09-25 PM 6:12:03:      QlikView Version:11.20.12577.0

2014-09-25 PM 6:12:03:      CPU Target                    x64

2014-09-25 PM 6:12:03:      Operating System              Windows 7 Professional Service Pack 1 (64 bit edition)

2014-09-25 PM 6:12:03:      Wow64 mode                    Not using Wow64

2014-09-25 PM 6:12:03:      MDAC Version                  6.1.7601.17514

2014-09-25 PM 6:12:03:      MDAC Full Install Version     6.1.7601.17514

2014-09-25 PM 6:12:03:      PreferredCompression          2

2014-09-25 PM 6:12:03:      EnableParallelReload          1

2014-09-25 PM 6:12:03:      ParallelizeQvdLoads           1

2014-09-25 PM 6:12:03:      AutoSaveAfterReload           0

2014-09-25 PM 6:12:03:      BackupBeforeReload            0

2014-09-25 PM 6:12:03:      EnableFlushLog                0

2014-09-25 PM 6:12:03:      SaveInfoWhenSavingFile        0

2014-09-25 PM 6:12:03:      UserLogfileCharset            1200

2014-09-25 PM 6:12:03:      OdbcLoginTimeout              -1

2014-09-25 PM 6:12:03:      OdbcConnectionTimeout         -1

2014-09-25 PM 6:12:03:      ScriptWantsDbWrite            false

2014-09-25 PM 6:12:03:      ScriptWantsExe                false

2014-09-25 PM 6:12:03:      LogFile CodePage Used:        1200

2014-09-25 PM 6:12:03:       Reload Executed By QLIKVIEW-WKJEON\Administrator

2014-09-25 PM 6:12:03:       Process Executing: QlikView Desktop

2014-09-25 PM 6:12:03:       Process ID: 1568

2014-09-25 PM 6:12:03: 0002  SET ThousandSep=','

2014-09-25 PM 6:12:03: 0003  SET DecimalSep='.'

2014-09-25 PM 6:12:03: 0004  SET MoneyThousandSep=','

2014-09-25 PM 6:12:03: 0005  SET MoneyDecimalSep='.'

2014-09-25 PM 6:12:03: 0006  SET MoneyFormat='₩#,##0;-₩#,##0'

2014-09-25 PM 6:12:03: 0007  SET TimeFormat='TT h:mm:ss'

2014-09-25 PM 6:12:03: 0008  SET DateFormat='YYYY-MM-DD'

2014-09-25 PM 6:12:03: 0009  SET TimestampFormat='YYYY-MM-DD TT h:mm:ss[.fff]'

2014-09-25 PM 6:12:03: 0010  SET MonthNames='1;2;3;4;5;6;7;8;9;10;11;12'

2014-09-25 PM 6:12:03: 0011  SET DayNames='월;화;수;목;금;토;일'

2014-09-25 PM 6:12:03: 0014  CUSTOM CONNECT*Provider*QvSAPOLAPConnector.dll*XUserId*XPassword*

2014-09-25 PM 6:12:09: 0016  [ZMSDSALE1/ZMSDSALE1_Q0005]:

2014-09-25 PM 6:12:09: 0017  Load *

2014-09-25 PM 6:12:09: 0018  Select PseudoMDX D (

2014-09-25 PM 6:12:09: 0019   Dimensions (

2014-09-25 PM 6:12:09: 0020    [ZSITE__ZREGION] ()),

2014-09-25 PM 6:12:09: 0021   Measures (

2014-09-25 PM 6:12:09: 0022    [7MSFRJRYOEINYZYMUR9W4MW9X].[7MSFRJRYOEINYZYMUR9W4N2LH]), 

2014-09-25 PM 6:12:09: 0023   Slices (

2014-09-25 PM 6:12:09: 0024    [ZSITE__ZREGION].[05]),

2014-09-25 PM 6:12:09: 0025   From (ZMSDSALE1/ZMSDSALE1_Q0005))

2014-09-25 PM 6:16:15:       4 fields found: 지역(N) - 지역(N) Level 01 (Key), 지역(N) - 지역(N) Level 01 (Text), 판매수량, 판매수량 - Unit,

2014-09-25 PM 6:16:16:       QVX_UNEXPECTED_END_OF_DATA: (1)

2014-09-25 PM 6:16:16:       FROM [ZMSDSALE1/ZMSDSALE1_Q0005]

2014-09-25 PM 6:16:16:      

2014-09-25 PM 6:16:16:        resulted in the ErrorMessage:

2014-09-25 PM 6:16:16:        Error occurred when starting the parser: timeout during allocate / CPIC-CALL: 'ThSAPCMRCV'

2014-09-25 PM 6:16:16:       Error: Custom read failed

2014-09-25 PM 6:16:27: 0026  Store * from [ZMSDSALE1/ZMSDSALE1_Q0005] into ZMSDSALE1-ZMSDSALE1_Q0005.QVD

2014-09-25 PM 6:16:27: 0027  Drop table [ZMSDSALE1/ZMSDSALE1_Q0005]

2014-09-25 PM 6:16:27:      Execution finished.

--------------------------------------------------------------------------------------------------------------------------------------

Thank you for your reply.

WanKi,

yfe
Contributor III

Re: SAP BW OLAP Connector Issue

Hi Wanki

Did you check whether the connector user in BW has the proper authorizations ? (for infoprovider ZMSDSALE1 )

Thanks

Yaniv

Not applicable

Re: SAP BW OLAP Connector Issue

Hi Yaniv,

Yes, I confirmed that the user have the right authorization , admin, with a BW consultant.

He also didn't know the reason.

So I didn't find the way.

Thank you for your reply.

WanKi,

er_mohit
Honored Contributor II

Re: SAP BW OLAP Connector Issue

Not applicable

Re: SAP BW OLAP Connector Issue

Thank you so much.

I will try to set in SAP BW Trans sm59.

Thank you,

WanKi,

Community Browser