Qlikview Direct Discovery

[pkpandey]

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

[jagan]

HI,

Direct Discovery works in QV 11 SR6 so, use below sample query syntax

DIRECT QUERY

DIMENSION

Dimension1,

Dimension2,

Dimension3

MEASURE

Measure1,

Measure2,

Measure3

FROM TableName;

Regards,

jagan.

[pkpandey]

Hi

This is not accepting DIRECT QUERY, DIMENSION, EXPLICIT etc.

Best Regards

P.K.Pandey

On Tue, 05 Aug 2014 12:21:06 +0530 Avinash R wrote

Qlik Community

Qlikview Direct Discovery

reply from Avinash R in Integration - View the full discussion

Hi Pradeep,Your QV 11.2 SR6 so the syntax has changed for it, try like thisits not Direct Select its

Direct Query and its not EXPLICIT its Dimension and for IMPLICIT its MeasureTableName1:Direct

QueryDimensionDOCIDMeasureMANDT from ;Regards,@vi

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

© 1993-2014 QlikTech International AB

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

[avinashelite]

Can you please post your app, lets have a check.

[pkpandey]

Please find the attached for your doing the needful.

Best Regards

P.K.Pandey

On Tue, 05 Aug 2014 12:39:13 +0530 Avinash R wrote

Qlik Community

Qlikview Direct Discovery

reply from Avinash R in Integration - View the full discussion

Can you please post your app, lets have a check.

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

© 1993-2014 QlikTech International AB

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

[avinashelite]

Hi Pradeep,

I got your problem you cannot give table name for this, please refer the attached QVW file i have edited the script.

//Try like below....one more thing you cannot give the table name for this

DIRECT QUERY

dimension

DOCID

measure

  MANDT

from [/SCDL/DB_PROCI_O];

[pkpandey]

Hi

Many thanks for your quick reply but while running the etl I am getting the error, the screen shot

attached.

Best Regards

P.K.Pandey

On Tue, 05 Aug 2014 15:22:04 +0530 Avinash R wrote

Qlik Community

Re: Qlikview Direct Discovery

reply from Avinash R in Integration - View the full discussion

Hi Pradeep,I got your problem you cannot give table name for this, please refer the attached QVW file i

have edited the script.//Try like below....one more thing you cannot give the table name for this

DIRECT QUERYdimension DOCIDmeasure MANDT 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 Re: Qlikview Direct Discovery in these streams:

Inbox

© 1993-2014 QlikTech International AB

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

[avinashelite]

Hi,

I dont have the access to load your data...

The error is because your not using qualified name for the DB or the path has got changed. Please recreate the from path by using the Select in the edit script.

try like this:

FROM DBNAME."tablename";

In your case:

DIRECT QUERY

dimension

DOCID

measure

  MANDT

from DBNAME.[/SCDL/DB_PROCI_O];

[pkpandey]

Hi

I have run the etl as per you instruction and getting the following error attached.

Best Regards

P.K.Pandey

On Tue, 05 Aug 2014 18:04:11 +0530 Avinash R wrote

Qlik Community

Qlikview Direct Discovery

reply from Avinash R in Integration - View the full discussion

Hi,I dont have the access to load your data...The error is because your not using qualified name for

the DB or the path has got changed. Please recreate the from path by using the Select in the edit

script. try like this:FROM DBNAME."tablename";In your case:DIRECT QUERYdimensionDOCIDmeasure MANDTfrom

DBNAME.[/SCDL/DB_PROCI_O];

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

© 1993-2014 QlikTech International AB

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