QlikView on SAP

[#1]

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?

[disqr_rm]

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.

[#3]

Rakesh,

Do you have any SAP templetes you can shares?

thanks,

Stephen

[flavio_fazzano]

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

[disqr_rm]

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

[#6]

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

[disqr_rm]

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.

[#8]

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

[disqr_rm]

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.

[#10]

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