Re: Qlikview Direct Discovery - Qlik Community

pkpandey · ‎2014-08-01

How to use DIRECT DISCOVERY to Extract Data from SAP through Qlikview Extractor?

avinashelite · ‎2014-08-01

hi Pradeep,

Please go through the below document. if you face any issue please let me know.

pkpandey · ‎2014-08-02

no documents received, please send as this is urgent.

avinashelite · ‎2014-08-02

Please find the attachment

pkpandey · ‎2014-08-04

Hi Avinash

I am getting Syntax Error on the following

CUSTOM CONNECT TO

"Provider=QvSAPConnector.dll;ASHOST=192.168.100.18;SYSNR=03;CLIENT=200;KeepCasing=1;NullDate=1;XUserId=

EaeKQYRNJbaMXUVMXDMA;XPassword=BETFRIRNJbaMXUVMXDQCDZMGBE;";

TableName1:

Direct Select DOCID, MANDT from ;

TableName2:

Load ITEMCAT, QTY;

SQL Select ITEMCAT QTY from /SCDL/DB_PROCI_O;

while extracting data from SAP SCM Sql connector. Please advise.

On Sat, 02 Aug 2014 19:30:04 +0530 Avinash R wrote

Qlik Community

Re: Qlikview Direct Discovery

reply from Avinash R in Integration - View the full discussion

Please find the attachment

Reply to this message by replying to this email, or go to the message on Qlik Community

Start a new discussion in Integration by email or at Qlik Community

Following Re: Qlikview Direct Discovery in these streams:

Inbox

Copyright & Trademarks | Privacy | Terms of Use | Software EULA

avinashelite · ‎2014-08-04

Hi,

Which version of Qlikview your using???

avinashelite · ‎2014-08-04

Hi,

If your using Qlikview 11.2 sr5 and above

try like this

TableName1:

Direct Query

Dimension

DOCID

Measure

MANDT from ;

if its below QV 11.2 SR5 then :

TableName1:

Direct Select

EXPLICIT //act as Dimension

DOCID

IMPLICIT //act as Measure

MANDT from ;

pkpandey · ‎2014-08-05

Hi Avinash

We are using Qlikview 11 SR6 and am using the following syntax :

CUSTOM CONNECT TO

"Provider=QvSAPConnector.dll;ASHOST=192.168.100.18;SYSNR=03;CLIENT=200;KeepCasing=1;NullDate=1;XUserId=

EaeKQYRNJbaMXUVMXDMA;XPassword=BETFRIRNJbaMXUVMXDQCDZMGBE;";

TT:

Direct Select DOCID, MANDT from ;

T1:

Load ITEMCAT, QTY;

SQL Select ITEMCAT QTY from /SCDL/DB_PROCI_O;

Please suggest what is wrong with the above statement.

Best Regards

P.K.Pandey

On Mon, 04 Aug 2014 16:08:07 +0530 Avinash R wrote

Qlik Community

Qlikview Direct Discovery

reply from Avinash R in Integration - View the full discussion

Hi,Which version of Qlikview your using???

Reply to this message by replying to this email, or go to the message on Qlik Community

Start a new discussion in Integration by email or at Qlik Community

Following Qlikview Direct Discovery in these streams:

Inbox

Copyright & Trademarks | Privacy | Terms of Use | Software EULA

pkpandey · ‎2014-08-05

Hi Avinash

My QLIKVIEW Version is 11.2 SR6 64 BIT.

Best Regards

P.K.Pandey

On Mon, 04 Aug 2014 16:12:05 +0530 Avinash R wrote

Qlik Community

Qlikview Direct Discovery

reply from Avinash R in Integration - View the full discussion

Hi,If your using Qlikview 11.2 sr5 and abovetry like thisTableName1:Direct

QueryDimensionDOCIDMeasureMANDT from ;if its below QV 11.2 SR5 then :TableName1:Direct SelectEXPLICIT

//act as DimensionDOCIDIMPLICIT //act as MeasureMANDT from ;

Reply to this message by replying to this email, or go to the message on Qlik Community

Start a new discussion in Integration by email or at Qlik Community

Following Qlikview Direct Discovery in these streams:

Inbox

Copyright & Trademarks | Privacy | Terms of Use | Software EULA

avinashelite · ‎2014-08-05

Hi Pradeep,

Your QV 11.2 SR6 so the syntax has changed for it, try like this

its not Direct Select its Direct Query and its not EXPLICIT its Dimension and for IMPLICIT its Measure

TableName1:

Direct Query

Dimension

DOCID

Measure

MANDT from ;

Regards,

@vi