Addendum SAP System

Performance Challenges in SAP Environment

Inability to Gain Access and Analyze Data “Complex system to gain access as single source, never mind multiple tables or other data sources.” “Only way to access data is through ABAP queries, SAP BW or module reports which present their own yet similar issues.” Complex Interface & Difficult to Use “Lacks an intuitive easy to use interface to analyze and interact with the data.” Slow Performance “Responsiveness is lacking in its performance against large volumes of data.” Inflexible Analysis Paths “Inability to explore across the entire data set across an unlimited number of dimensions within a tables never mind across tables or additional data sources.” “Drill paths need to be pre-defined within the Infocube limited the exploration of the data.”

QlikView for SAP

HR, R&D and IT • HR – Human Resources • PLM – Product Lifecycle Management • AM – Asset Management • BPM – Business Process Management • WF – Workflow Finance • FI & CO – Finance & Controlling • TR – Treasury • RE – Real Estate Management • IM – Investment Management • CFM – Corporate Finance Management Manufacturing Operations • PP – Production Planning • PM – Plant Maintenance • QM – Quality Management • MM – Material Management Dashboard Analysis Reporting Executive Management • SEM – Strategic Enterprise Management • EC – Enterprise Controlling • BPS – Business Planning & Simulation • EP – Enterprise Portal • KM/W – Knowledge Mgmt / Warehouse Sales, Marketing & Service • CRM – Customer Relationship Mgmt • SD – Sales & Distribution • CS – Customer Service • SM – Service Management • PS – Project System Supply Chain • SCM – Supply Chain Management • APO – Advanced Planner & Optimizer • BBP – B2B Procurement • SRM – Supplier Relationship Management • WM & LE – Warehouse Mgmt & Logistics

Run SAP and Sprint with QlikView

QlikView Connector Certified for SAP NetWeaver ®

Enables SAP customers to get easy and quick access to all the data hidden in different SAP systems SAP data can afterwards easily be combined with Non-SAP data within individual QV-analytical applications Speeds up information deployment and decision making Creates value out of SAP systems within a few days – rather than months/years

"QlikView adds significant value to our IT installation. At last, we can gain the insight necessary to make better strategic decisions with information in SAP, and we can do it quickly and with simplicity.”

Michael Neff, CIO, Heidelberger

QlikView Connector Certified for SAP NetWeaver ® Access to the tables of the data dictionary by certified QlikView Connector Source systems are unburdened, as users do all their analysis of SAP data within QlikView

Deployment Options

SAP R/3

QlikView can provide Business Intelligence applications against the R/3 data Great if you don’t want to invest the time and energy in BW

SAP BW

QlikView can provide a more intuitive front-end to data in BW Use QlikView for distributing data in BW

Different Data Sources

QlikView can combine data from R/3, BW and/or any other data source Get a single view of your most important data

Simplifying Analysis for Everyone Everyone Else

“Fast Implementation” “Easy-to-Use” “Powerful” “Flexible” “Integrated” “Low Cost” “Risk-Free” • • • • • • •

QlikView New Rules

Fast Implementation

… Customers are live in less than 30 days, and most in a week

Easy to Use

… End users require no training and enjoy “qliking” through the application

Powerful

… Near instant response time on data volumes as high as a billion records across thousands of users

Flexible

… Allows unlimited dimensions and measures and can be modified in seconds

Integrated

… Dashboards, analysis and reporting in a single solution and on a single architecture

Low Cost

… Less costly, shorter implementations result in fast return on investment

Risk-Free

… Fully-functional free trial download, and a seeing-is believing experience

QlikView Value Proposition: 1/4 the Time, 1/2 the Cost, 2x the Value

Select QlikView Customers in SAP System Environment More Than 100 Customers Are Leveraging QlikView with SAP

Next Step – Seeing is Believing

You Provide

• Agreement on project scope: Scoping document • Sample reports • Checklist Onsite setup prior to SiB: • Hardware configured • Internal data identified

We Engage

• Development scope: Software installation • Data connections • Application layout Participation scope: • Actively engage in 2-3 day workshop • User experience evaluation

You Receive

• Deliverables: QlikView application prototype • Immediate results from the data analysis • User evaluations to assess areas of improvement • No risk opportunity to assess business value

The Power of Simplicity

Appendix Material Customer Snapshot Please always check QlikOpedia for additional customer snapshots

QlikView Customer Snapshot – Atlas Copco

“In contrast to many other BI suppliers, with whom it would be necessary to start all over again, QlikView is able to deliver this kind of information in just a few clicks of the mouse. These seamless analysis paths are unique for a BI system .”

Pauli Arenram, Managing Director Atlas Copco Construction Tools

About Atlas Copco Construction Tools • Leading manufacturer of hydraulic, pneumatic, and gasoline powered breakers and drills • Headquartered in Stockholm, Sweden • Achieved ~$125 million in revenue with 300 employees • Industry: Industrial Machinery Challenges • Extend product leadership with continuous improvements in product innovation and quality • Consolidate data from a suite of disparate systems and improve availability, speed and accuracy of business data Solution • Deployed QlikView to ~ 100 users across 6 functions in Sweden and Germany:

Sales Analysis:

Analyze aftermarket spare parts business and inventory

Supply Chain Analysis:

Fully evaluate supplier performance scorecards

Operational Analysis

: Efficiently assess project checking and timing plus analyze SAP operational data hourly

Financial Analysis

: Measure product item revenue and profitability performance in sales scorecards

HR Analysis

: Quickly analyze workforce metrics - namely staff sick leave information

IT Analysis

: Rapidly check Lotus Notes support database and provide detailed analyses of SAP user behavior • Rapid implementation in less than 4 weeks • Leveraged QliKView Connector to aggregate more than 5 million records of data from SAP, Movex, Saphir, BPCS, Hyperion, Lotus Notes, Excel and EDI Benefits • Garnered annual IT cost savings of ~ $100,000 • Achieved a payback period of less than 9 months • Improved product quality and delivery performance

QlikView Customer Snapshot – Heidelberg

“QlikView adds significant value to our IT installation. At last, we can gain the insight necessary to make better strategic decisions with information in SAP, and we can do it quickly and with simplicity.”

Michael Neff, CIO Heidelberger Druckmaschinen AG Voted One of the "Premier 100 IT Leaders for 2007" by the U.S. Magazine Computerworld

About Heidelberg • Leading manufacturer of sheetfed offset printing machines for commercial and industrial customers in the print media industry • Achieved a global market share of more than 40% • Headquartered in Heidelberg, Germany • Achieved $5.1 billion in revenue with 19,150 employees • Supported by IT team of 450 employees • Prominent hallmark SAP customer • Industry: Industrial Machinery Challenges • Lack of flexibility for new reporting demands and ad hoc analysis - especially if including additional data sources • Provide a platform to leverage high quality data within SAP BW and complement analysis capabilities Solution • Deployed QlikView to ~200 users with more than 75 applications across 3 functions in Germany:

Sales Analysis

: Measure all aspects around a customer - orders, products, activities, services across time via a ‘Customer Cockpit’. Analyze consumables by product, category, customer and region

Financial Analysis

: Analyze IT costs and staffing over fiscal years and comparisons of actuals against plan

IT Analysis

: Monitor IT reporting of server and hardware infrastructure equipment with activity, costs, utlization, and versioning. Manage internal support to meet service levels to each business unit • Developed ‘Customer Cockpit’ prototype in 3 days with 6 million records from SAP BW • Leveraged QlikView Connector (64-bit) to aggregate and analyze data from SAP (MM, CO, FI, PS), Perform (IT planning tool), and several tools for incident tracking, change management, leasing and outsourcing, and network monitoring Benefits • Turbo charged SAP BW enabling flexible ad-hoc analysis and deeper insight for business users • Delivered fast prototyping to show early results with a steep improvement curve and a low TCO • Delivered integration across multiple data sources allowing for a more decentralized BI approach to be deployed

QlikView Customer Snapshot – LRP

“We are still very impressed on the easiness of use, the high adaptability and the performance of the system!"

Hans-Ulrich Hasse, Director of Trading Systems Landesbank Rheinland-Pfalz (LRP)

About Landesbank Rheinland-Pfalz (LRP) • State and municipal bank with focus on the State of Rheinland Pfalz, the Rhineland-Palatinate and the neighboring regions of Germany and Western Europe • Offers corporate, municipal and private clients in its core • regions innovative financing options and attractive investments Subsidiary of Landesbank Baden Württemberg (LBBW) • Headquartered in Mainz, Germany • With assets of ~$115 billion, LRP achieved $610 million in revenue with 1,500 employees • Industry: Banking (Retail) Challenges • Strengthen and expand existing market position in defined business areas through improved customer acquisition/retention • Improve sales discipline and performance • Standardize customer data from 12 data sources including data from its new CRM system without need for a data warehouse Solution • Deployed QlikView to ~200 users across 4 functions in Germany:

Executive Analysis:

Assess KPIs by customer, such as revenue, value, # of contracts, products, credit lines, current rating, and # of sales meetings

Sales Analysis:

Monitors sales activities / interactions with customers who visited the customer last time? What was discussed? How did the customer behavior develop over time?

Marketing Analysis:

Assess customer portfolios to identify and produce target list of customers for cross-sell and up-sell potential

Trading / Operational Analysis:

Analyze customer trading activity across accounts • Rapid implementation in less than 4 weeks • Leveraged QliKView (64-bit) and Connector to aggregate 5 million records on customers from SAP, SQL, Oracle, DB2 etc.

• Next steps include additional rollout within sales and finance Benefits • Improved customer visibility into products within portfolio to explore cross-sell and up-sell opportunities • Deployed an analysis platform requiring only weeks while avoiding the time and cost associated with a data warehouse • Business-led without dependence on IT; High user acceptance

QlikView Customer Snapshot – Marien Hospital

“With QlikView, we can identify related issues and solve problems, which would have previously been completely lost in the mass of data.”

Uschi Schäfer, Medicine Controlling Marien Hospital Gelsenkirchen

About Marien Hospital Gelsenkirchen • Leading academic training hospital and a pioneer of IT supported hospital management with approximately 500+ beds and ten specialized divisions • Headquartered in Gelsenkirchen, Germany • Achieved ~ $85 million in revenue with 1,100 employees • Industry: Healthcare Challenges • Amplify transparency within the clinic to achieve greater efficiency in administering internal services • Take proactive steps in preparation for the statutory demands of Diagnosis Related Groups (DRG) during annual budget negotiations with health insurance fund representatives Solution • Deployed QlikView to ~ 30 users across 4 functions in Germany:

Clinical Operations & Care Delivery Analysis

: Track nominal and actual comparison of DRG data such as dates of admission and discharge, primary / secondary diagnosis, operations, age, and weight of newborns

Financial & Revenue Cycle Analysis

: Analyze financials - actuals versus budget; Manage DRG reporting and negotiations with insurance funds

IT Analysis

: Evaluate interface protocols and firewall attacks as well as increase the safety of sensitive patient information

Six Sigma & Quality Management Analysis

: Analyze BQS quality assurance data submitted to the government to improve overall patient quality and compliance to meet statutory regulations • Rapidly developed DRG analysis in 3 weeks with Transact • Leveraged QlikView to extract all key clinical data for 27,000 annual patients from SAP HR, DRG system, KIS and Excel Benefits • Improved patient care through more transparency, efficient control and optimization of internal clinical processes • 80% reduction in audit time down from 3 weeks to 2-3 days through increased productivity during annual audits and budget negotiations with health insurance funds • Rapid and broad adoption by users thanks to exceptional user friendliness and flexible ad-hoc data analysis

QlikView Customer Snapshot – Merck Ltd., Japan

“QlikView dashboards serve as ‘command central’ for the management team, giving them an overall view of the business and the ability to drill into the details to identify issues and solve problems quickly.”

Business Analyst Merck, Sharp & Dohme (Asia)

About Merck Ltd.

• A subsidiary of Merck KGaA, Germany, one of the leading pharmaceutical and chemicals companies in the world. Merck Ltd. not only sells products, but also researches, develops and manufactures products. • The core businesses of Merck Ltd. are liquid crystals mixture, pigments, reagents and other laboratory chemicals • Headquartered in Tokyo, Japan for Asia Pacific region • Achieved ~$600 million in revenue with 475 employees • Industry: Pharmaceuticals; Oil, Gas & Chemicals Challenges • Maintain high-profile standing in an increasingly segmented market • Monitor operational performance against top and bottom line measures to ensure financial targets are met • Maximize sales performance against targets and customers Solution • Deployed QlikView to ~15 users across 4 functions in the Asia Pacific region:

Executive Analysis

: Conduct daily health check with sales, gross margin and EBIT month-to-date and year-to-date performance comparisons against previous year and current operating plan

Sales Analysis

: Analyze quotations, pricing, customer profile and individual sales performance against targets

Supply Chain Analysis

: Track open orders, vendor performance and lead times, which in turn supports sales reps ability to quote delivery dates; better manage stock planning with expiry analysis and inventory balances

Financial Analysis

: Monitor detailed P&L for more than 100 business segments; conduct “Top 10” sales and gross margin analyses; ensure account receivables on track and monitor finance-specific KPIs • Rapid implementation in less than a couple weeks • Leveraged QlikView Connector to aggregate data from SAP on sales targets, inventory levels and customer delivery dates Benefits • Improved predictability of financial performance • Increased sales performance within customer profiles • Gain overall view of the business and the ability to drill into the details to identify issues and solve problems quickly

QlikView Customer Snapshot – Sandvik Group

“One of the main reasons why we chose QlikView was the possibility to quickly develop what we call a ‘fast track solution’. The specifications for new applications are often defined at seminars where all concerned staff is represented. Today we have usually built a functional QlikView application by the time we close the seminar.”

Stefan Wesslegård, Data Warehouse Architect Sandvik Systems Development

About Sandvik Group • Global industrial group with advanced products and world leading positions in 3 selected areas – tools for metal cutting, mining and construction machinery for rock excavation, and materials technology including stainless materials, special alloys, metallic and ceramic resistance materials • Headquartered in Sandviken, Sweden • Achieved ~$10 billion in revenue with 42,000 employees • Industry: Industrial Machinery & Mill Products Challenges • Existing BI systems (SAP BW, BO) lacked the flexibility to handle the volume of dimensions and dynamic process for customer profitability measurement and price waterfall analysis Solution • Deployed QlikView to ~ 2,500 users across 8 functions within the mining and construction, and materials technology divisions spanning 3 servers supporting worldwide user community:

Executive Analysis:

Assess overall market trends and operational KPIs

Sales Analysis:

Track orders in Sopic and analyze price waterfall; Assess customer profitability / productivity supporting new pricing and negotiations

Service & Support Analysis:

Measure service responsiveness via Maximo

Supply Chain Analysis:

Conduct price waterfall analysis on orders to prioritize order fulfillment; Monitor stock levels and supplier performance

Operational Analysis:

Analyze production levels and line utilization

Financial Analysis:

Assess consolidated financial data in OutlookSoft; Previous attempts failed with Hyperion and OutlookSoft

HR Analysis:

Measure staffing, compensation/benefits, and vacation

IT Analysis:

Monitor system capacity and usage to optimize performance • Delivered short implementation times via interactive seminars resulting in a functional QlikView application in roughly 1 day • Leveraged QliKView Connector (64-bit) to aggregate data from multiple systems including SAP BW, Movex, OutlookSoft (financial consolidation), Maximo (service), SQL Server, Oracle, and Sopic (sales orders) application on IBM System i (AS/400) Benefits • Delivered customer value with profitability/productivity analysis • Increased order profitability through price waterfall analysis • Improved end user participation and IT / business collaboration with flexibility and ease of use

Appendix Material Customer Videos & Web Seminars Please always check QlikOpedia for additional videos and web seminars

Voices On The QlikView Experience with SAP

Michael Neff Chief Information Officer Industrial Machinery Stefan Wesslegård Business Intelligence Architect Industrial Machinery & Mill

Available Web Seminars on SAP

Experience The Power of Simplicity: How Heidelberg Turbo Charges Its Global SAP BI Strategy With Next Generation In-Memory Analysis

Speaker: Michael Neff, CIO, Heidelberg Includes overview of BI strategy and highlights several applications.

Experience The Power of Simplicity: How Sandvik Leverages In-Memory Analysis As Catalyst To Bridge Information Gap & Drive Business Value

Speaker: Stefan Wesslegård, Business Intelligence Architect, Sandvik Includes overview of BI strategy and rapid application deployment.