Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
jim_chan
Contributor III

Qlik Sense 3.2 - How to extract BW CUBE data?

hi guys,

I have to extract data out from BW DATA. I noticed that the Qlik Sense does not support OLAP connector.

Therefore, i have used QlikView to establish the OLAP Connector. So, is like:

CUSTOM CONNECT TO "Provider=QvSAPOLAPConnector.dll;ASHOST=10.0.11;SYSNR=......"

So, I copied the connection string and paste it on a Qlik Sense app, and click Load Data, then I hit the error. - as per the attachment.

The Error says - "CONNECTs other than LIB CONNECT are not available in this script mode".

The error occurred here:

CUSTOM CONNECT TO ***

9 Replies
hoangpm8
New Contributor II

Re: Qlik Sense 3.2 - How to extract BW CUBE data?

You do the following to use script of QlikView:

  1. Open C:\Users\{user}\Documents\Qlik\Sense\Settings.ini in a text editor.
  2. Change StandardReload=1 to StandardReload=0.
  3. Save the file and start Qlik Sense Desktop, which will run in legacy mode.
ogster1974
Honored Contributor II

Re: Qlik Sense 3.2 - How to extract BW CUBE data?

Have you tried looking at the additional web connectors for your solution? Go to the downloads site and look under connectors.

I went there for a connector to exchange server and used the mailbox connector for example.

jim_chan
Contributor III

Re: Qlik Sense 3.2 - How to extract BW CUBE data?

Hi there,

i have already changed it to StandardReload = 0. and i copied over the script i have created in QlikView.

And i still hit the error...saying " Connector Error *** '

hoangpm8
New Contributor II

Re: Qlik Sense 3.2 - How to extract BW CUBE data?

I think you can try an other connection string. I use OLE DB, like:

OLEDB CONNECT TO [Provider=MSOLAP;Data Source=10.88.16.46\QA2;];

jim_chan
Contributor III

Re: Qlik Sense 3.2 - How to extract BW CUBE data?

u mean instead of using SAP related connector, use a MSOLAP Connector?  that will connect to the BW Cube?

Do i still need to key in any SAP Connector license? client has bought the SAP Connector license.

jim_chan
Contributor III

Re: Qlik Sense 3.2 - How to extract BW CUBE data?

do you mean this one ,in qlik sense???

hoangpm8
New Contributor II

Re: Qlik Sense 3.2 - How to extract BW CUBE data?

No, I use Microsoft OLE DB Provider for Analysis Serves, like:

Untitled.png

OLEDB CONNECT TO [Provider=MSOLAP;Data Source=10.88.16.46\QA2;];

LOAD *;

SQL SELECT NON EMPTY { [Measures].[Closing Quantity] } ON COLUMNS, NON EMPTY { ([Product].[Hierarchy].[Product].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [EMSDW CAL] CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

jim_chan
Contributor III

Re: Qlik Sense 3.2 - How to extract BW CUBE data?

Can i just put the server IP only? like : 10.11.22.33 ?

I tried with that,. but it says connection failed.

shraddha_g
Honored Contributor III

Re: Qlik Sense 3.2 - How to extract BW CUBE data?

Try steps from document attached in QlikSense - SAP Report Connector

It might help.