Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ***
You do the following to use script of QlikView:
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.
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 *** '
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;];
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.
do you mean this one ,in qlik sense???
No, I use Microsoft OLE DB Provider for Analysis Serves, like:
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
Can i just put the server IP only? like : 10.11.22.33 ?
I tried with that,. but it says connection failed.
Try steps from document attached in QlikSense - SAP Report Connector
It might help.