Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Guys,
Anyone knows whether QvSAPConnector.dll supports Direct Discovery at all or it is just JDBC? I see all examples in the forum use JDBC.
The script is this.
CUSTOM CONNECT TO "$(vConnectSAPBW)";
//
DIRECTDiscovery:
Direct QUERY
DIMENSION
MATERIAL
MEASURE
BASE_QTY
FROM
[/BIC/ARPA_OC1000];
Thanks,
Ram
Hi,
Direct Discovery does work with SAP Connector. Perhaps try the same syntax without table name:
CUSTOM CONNECT TO "$(vConnectSAPBW)";
Direct QUERY
DIMENSION
MATERIAL
MEASURE
BASE_QTY
FROM
[/BIC/ARPA_OC1000];
No Pravesh. It doesn't.
For SAP, Direct Discovery can be used only with the Qlik SAP SQL Connector, and it requires the following parameters in SET variables:
SET DirectFieldColumnDelimiter=' ';
SET DirectIdentifierQuoteChar=' ';