topic QlikView on SAP in QlikView

QlikView on SAP

Fri, 10 Jul 2009 22:28:40 GMT

Has anyone implemented QlikView for SAP customers? or does most of the SAP clients prefer their own BI reporting? Which SAP module did you implement QV on?

QlikView on SAP

disqr_rm — Fri, 17 Jul 2009 02:09:40 GMT

Hi Catherine,

QlikView is actually getting very popular with SAP customers. It's very well accepted due to the fact the it now provides a seamless connectivity (SAP Certified) to extract the data out of SAP.

Traditional BI reporting is still in place at most of the customers but they are mostly tired of the fact that it takes too long to build, deliver, and then enhance anything in BI.

I have implemented QlikView on top of SAP and have been very successful with that. I have implemented following without any major issues:

FI: P&L & Balance sheet, Cost center reporting. AP/AR reporting
CO: Various Cost reporting & dashbords
COPA: Profitability reporting, Financial margin trend and comparision, compar to budget/forecast
SD: Sales operation reporting, Margin reports based on Invoices
MM: Vendor analysis, PO Trend, PO compare to In-Stock, Inventory analysis
PM: Service order analysis, Personnel time reporting, Notification analysis
BASIS: SAP Monitoring, DB Groth, Stat reports

What are you looking for? PM me for further details.

QlikView on SAP

Fri, 17 Jul 2009 02:42:40 GMT

Rakesh,

Do you have any SAP templetes you can shares?

thanks,

Stephen

QlikView on SAP

flavio_fazzano — Fri, 17 Jul 2009 03:17:50 GMT

Catherin, sjcharles,

the partners of QlikTech have access to QlikOpedia where there are a couple of SAP Templates, please contact with your local reseller for it.

Flavio

QlikView on SAP

disqr_rm — Fri, 17 Jul 2009 04:04:18 GMT

This is correct. There are few good templates in Qlikopedia which you can get from your partner. The ones I have mentioned are my own developments.

You need to be little careful when you are working with SAP templates frovided by QlikView, as most of the templates are based on assumption that you (everyone) is using SAP standard business processes, which is not true in most implementations. For this reason, I usually get an idea from SAP templates (some published on demo.qv.com) and then build my own data model linking tables properly based on business processes configured on that individual SAP system I am woring with.

If you have any question on reporting for your specific SAP business process, please start a separate conversasion with me and I will respond to it.

Rakesh

QlikView on SAP

Fri, 17 Jul 2009 20:19:05 GMT

Rakesh - Thank You.

I don't have access to an SAP system yet to see if conectors actually work. What were some of your biggest obstacles in implementing QV for SAP customers? Have you had any issues with SAP/OLAP or ODS connectors and associated transports on the SAP/BW side?

Also as you mentioned the QV templates from QV looks good. But it might need lots of customization depending on the requirement. How do you extract all the Z* tables? Is it safe to assume that once the connectors are in place, you have access to all the Z tables and reports?

thanks

QlikView on SAP

disqr_rm — Fri, 17 Jul 2009 20:34:31 GMT

Yes, you will have access to all the tables, including sap tables and the "Z" tables. But you will not have access to any reports in SAP. Connector only gives you access to tables in SAP.

I had many issues with OLAP connector, but SAP SQL Connector works perfectly in every case.

Have fun with QV reporting on SAP.

QlikView on SAP

Sat, 18 Jul 2009 00:24:56 GMT

Would the SAP SQL connector work on the 'SAP Netweaver 7.0 Java & Abap trial version'? has anyone tried? It seems this version only give demo access with limited ability

QlikView on SAP

disqr_rm — Sat, 18 Jul 2009 02:53:05 GMT

Yes, it will work with test version of SAP install.

After you install SAP, you would need to import 2 transports coming from QV SAP Connector and you are good to go.

Now, trial version of SAP doesn't provide all the modules and business processes, but you will have access to all tables and their data whatever is available in trial vesion of SAP.

QlikView on SAP

Thu, 23 Jul 2009 01:27:13 GMT

What were the geographical location of your clients? any particular industry?

QlikView on SAP

Thu, 30 Sep 2010 01:44:30 GMT

Good day Sir Rakesh,

Can you give me a step by step procedure on how to import those transports?

Thank you very much!

QlikView on SAP

disqr_rm — Thu, 30 Sep 2010 03:09:28 GMT

Hi Mars,

Just like any other external transports, QV SAP Connector comes with CoFiles & DataFiles for 2 transports. These files are extracted and placed in the install directory (the install manual has the exact location). You can pick these files and place in your common transport directory under Cofiles and Data files diretories respectively. Then you would need to add them to the buffer with using "tp addtobuffer" or similar depending on your OS on SAP system. Then, by doing TP IMPORT you can simply import those transports in the system. Once imported, you would need to adjust some user profiles & create a new user you would need to use when extracting data. The install manual has step-by-step instructions.

Hopefully this gives you what you are looking for.

Rakesh

QlikView on SAP

Thu, 30 Sep 2010 04:05:28 GMT

I'm new to qlikview and sap that's why i don't have any idea on how to configure this..thanks a lot sir.if i have other questions regarding on this topic i'll ask you again..thanks again

QlikView on SAP

Thu, 07 Oct 2010 03:33:00 GMT

Mr. Rakesh,

I have another question is it normal that the database NSP has 49-50% data? and why is my Z Tables doesn't contain any record? I haven't encountered any errors during the installation..I'm using SAP NetWeaver 7.01 ABAP Trial Version..

Thanks,

QlikView on SAP

guytzumer — Thu, 07 Oct 2010 08:44:37 GMT

In addition to what Rakesh said , we have very successful projects on several SAP customers and it's grows popular no our markets is israel, both R\3 & BW date.

The templates of ClikTech are quite ok. I implemented Qlikview on SAP R\3 data in several customers with great successful on moduls as:

SD - Sales model with connection to COPA - Profitability

MM - Purchasing Model, Inventory Model

PP - Orders Model , Scrap & Hours(Machine, Workers) Model

CO - Cost reporting

my company make some several more Qlikview models Based on R\3 tables and BW Cubes.