17 Replies Latest reply: Aug 6, 2014 12:52 AM by Pradeep Kumar Pandey RSS

    Qlikview Direct Discovery

    Pradeep Kumar Pandey

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

        • Re: Qlikview Direct Discovery
          Avinash R

          hi Pradeep,

           

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

            • Re: Qlikview Direct Discovery
              Pradeep Kumar Pandey

              no documents received, please send as this is urgent.

                  • Re: Qlikview Direct Discovery
                    Pradeep Kumar Pandey

                    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

                                                                                                    © 1993-2014 QlikTech International AB

                                 

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

                      • Re: Qlikview Direct Discovery
                        Avinash R

                        Hi,

                         

                        Which version of Qlikview your using???

                          • Re: Qlikview Direct Discovery
                            Pradeep Kumar Pandey

                            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

                                                                                                            © 1993-2014 QlikTech International AB

                                         

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

                          • Re: Qlikview Direct Discovery
                            Avinash R

                            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 ;

                              • Re: Qlikview Direct Discovery
                                Pradeep Kumar Pandey

                                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

                                                                                                                © 1993-2014 QlikTech International AB

                                             

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

                                  • Re: Qlikview Direct Discovery
                                    Avinash R

                                    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

                                      • Re: Qlikview Direct Discovery
                                        Pradeep Kumar Pandey

                                        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

                                          • Re: Qlikview Direct Discovery
                                            Avinash R

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

                                              • Re: Qlikview Direct Discovery
                                                Pradeep Kumar Pandey

                                                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

                                                  • Re: Re: Qlikview Direct Discovery
                                                    Avinash R

                                                    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];

                                                      • Re: Qlikview Direct Discovery
                                                        Pradeep Kumar Pandey

                                                        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

                                                          • Re: Qlikview Direct Discovery
                                                            Avinash R

                                                            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];

                                                              • Re: Qlikview Direct Discovery
                                                                Pradeep Kumar Pandey

                                                                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

                                                  • Re: Qlikview Direct Discovery
                                                    jagan mohan rao appala

                                                    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.