SAP Business One analytics powered by SAP HANA

SAP Business One analytics powered by SAP HANA An Overview

SAP Business One Analytics Platform What do Small Businesses expect? Small Business Owners need an analytics platform that is not a full-scale BI offering, but with : • Ready to use content • Ad-hoc analysis and Interactive analytics • Superior performance - “real time” access • A seamless user experience • Ease of use and rapid implementation • Affordability © 2012 SAP AG. All rights reserved. 2

SAP Business One Analytics Portfolio: Major Investment Areas Seamless user experience Semantic Layer Analytical Content Groundbreaking In-Memory Technology © 2012 SAP AG. All rights reserved. Interactive Analysis Row-based DBMS vs Column-based DBMS From application cache to In-Memory DBMS Real-Time Access to Transactional Data 3

The Technology Evolution for SAP Business One Analytics Clients (SAP Crystal Dashboard Design, SAP Crystal Reports) Easy to consume, business oriented terms Semantic Layer OINV 1 Abs. Id [PK] Sales. Name Card. Code Item. Code FK] … Slp. Id [FK] … OCRD OITM Card. Code[PK] Item. Code [PK] Card. Name Item. Name … … Example © 2012 SAP AG. All rights reserved. DB Layer OSLP Aggregation Layer RDBMS – Transactions Analytics Clients (SAP Crystal Dashboard Design, SAP Crystal Reports, Microsoft Excel) SAP HANA Views (OLAP cube models) Easy to consume, business oriented terms B 1 i Server Cache (for dashboards only) MS SQL Server Transactional raw data Actual Transactional data replicated from SAP Business One DB Server (SQL Server) to HANA DB HANA database For customer with massive data analysis requirements 4

SAP Business One analytics powered by SAP HANA Delivers in-memory technology and analytics innovations without disruption to the customer’s business à Benefits for both installed base and new customers à Seamless user experience CR Dashboard Excel Relea s Gene es with V ral A vaila ersion 8. 8 bility 2 in 20 12 SAP HANA studio SAP Business One Client à Semantic Layer SAP Business One Analytics Server à Interactive Analysis à Superior performance à New analytics content SAP Business One Database Server Administration Service: backup, restore, monitor Semantic Layer: Views & Cube Models B 1 Real–Time Replication Services Tomcat Server SAP HANA database MSFT SQL Server © 2012 SAP AG. All rights reserved. 5

Easy to Use A Seamless User Experience - Overview Demonstration Run “in-memory” reports from normal B 1 menu Run “in-memory” Dashboards from normal B 1 cockpit Run enterprise search from normal B 1 application SAP Business One Analytics Server SAP Business One SQL Server . Network © 2012 SAP AG. All rights reserved. 6

SAP Business One Enterprise Search SAP Business One App Powered by SAP HANA Functional Highlights Seamless SAP Business One client experience Hierarchical search in all SAP Business One modules (repositories) Full text search for all business object types Narrow down options per business object type Link to SAP Business One form Compliant with SAP Business One data ownership concept Ease navigation with business object map Report & printing © 2012 SAP AG. All rights reserved. 7

SAP Business One Analytics Content Powered By SAP HANA The solution that provides compelling SAP Business One based operational analytics - quickly and affordably • Migrate calculation intensive CR Reports (4) • Migrate current dashboards (3) • New dashboards (4) • Semantic Layer (8) i. Financial module ii. Sales module iii. Inventory module Delivery Analysis Purchase Quotations Inventory Status © 2012 SAP AG. All rights reserved. 8

SAP Business One Analytics Content Powered By SAP HANA In addition to Crystal Reports and dashboards we deliver pre-defined Semantic Layers to enable ad-hoc (interactive) analysis via Microsoft Excel and rapid content development based on dimensions & measures Financials Dashboard Customer Receivables Aging Cash Flow Forecast Semantic Layer Aging Cost Center Analysis Profit & Loss Analysis Dashboard Sales Analysis Delivery Analysis Crystal Report Periodic Sales Analysis by Customer Open Item List Dashboard Inventory Status Crystal Report Inventory Turnover Analysis Semantic Layer Sales Opportunity Analysis Service Dashboard Liquidity Analysis Purchasing Service Call Dashboard Purchase Quotations Cross Module Crystal Report Monthly Customer Report (order, invoice, payment, return) © 2012 SAP AG. All rights reserved. Sales & Marketing Inventory 9

Easy to Use Interactive Analysis – Empowering Business Users © 2012 SAP AG. All rights reserved. 10

Quick Time to Implement Semantic Layer, Easy to Extend Predefined Models • Cost center analysis • Cost account vs. financial accounting • Budget analysis • Aging analysis • Inventory turnover analysis • Dynamic cash prediction • Sales opportunity analysis • Sales revenue analysis © 2012 SAP AG. All rights reserved. 11

Rapid Design based on existing tools and content Develop Crystal Reports and Dashboards based on HANA DB Crystal Reports Dashboards • Crystal Reports 2008 SP 5 (end of Nov. 2011) Runtime: same user experience • Runtime: same user experience • Content Management: same user experience Design: same user experience except only one difference - Info. xml of dashboard package: • Design: user can have HANA views or procedures or direct query as data source (user is not able to query over B 1 tables in HANA-DB) © 2012 SAP AG. All rights reserved. <Is. IMDB>Y</Is. IMDB> Content Management: same user experience, but no B 1 i 12

In-Memory Technology drives Business Opportunities In-Memory Computing Address Known Pain Points • Performance constraints • Database size impact • Redundant aggregates • Limited flexibility in drill down • High resource consumption by batch jobs © 2012 SAP AG. All rights reserved. Create New Value with New Apps Leverage consumer and devicerelated data Sophisticated yet interactive forecasting & simulation Integrated business planning 13

In-Memory Technology Drives Business Opportunities New SAP Business One App: Payment optimization and liquidity forecast § Forecast Accounts Receivable based on historical data § Liquidity forecast to ensure healthy operations § Best payment strategy to maximize discounts § Propose the right financing services at the right time © 2012 SAP AG. All rights reserved. 14

SAP Business One on HANA-DB: Hybrid Solution Architecture B 1 Client Application Web Browsers HTTP Analytic Server Tomcat Server Web Tier ODBC JSP Pages Dashboards / Flash Deployment Business Tier Analytic Service ODBO Freestyle search Service Configuration Business One Server Authentication & Authorization Dashboard Package Master Data JDBC Trans Data Replication Service* SQL Server SQL / MDX HANA-DB Server JDBC Master Data Trans Data Semantic Layer: View / Cube models Data Replication Note: n Semantic layer (OLAP cubes) consists of analytic views and calculation views, which can be consumed by both SAP and Partner apps © 2012 SAP AG. All rights reserved. 15

SAP Business One, Analytics powered by SAP HANA Strong Early Customer Adoption Positive reaction from proof of concept customers and partners: ➔ Each of the proof of concept customers were up and running in 3 hours, using live data from their SAP Business One systems ➔ With limited use, customers, ranging in size from 11 -200 employees, we are seeing tangible benefits and future possibilities “ During the proof of concept we experienced an improvement of 120 x in running a sales analysis report – from 240 seconds to just 2 seconds. ” Niek Veldhuijzen Managing Director Hoenderdaal Fasteners © 2012 SAP AG. All rights reserved. “ We see great benefits coming from the interactive analysis, because of the flexibility and speed of slicing and dicing the full data available. ” André Engel Geschäftsführer/CEO tde - trans data elektronik Gmb. H “ In our pilot environment, set up by Versino, we are testing business-critical reports, which are up to 100 times faster. This will be invaluable to the way we run our business in the future. ” Florian Pöhner Leiter IT/ Organisation Alpha Inno. Tec Gmb. H 16

Thank You! For more information visit: www. sap. com/businessone or contact your Local Product Expert (LPE)

© 2012 SAP AG. All rights reserved. No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice. Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors. Microsoft, Windows, Excel, Outlook, and Power. Point are registered trademarks of Microsoft Corporation. IBM, DB 2 Universal Database, System i 5, System p 5, System x, System z 10, System z 9, z 10, z 9, i. Series, p. Series, x. Series, z. Series, e. Server, z/VM, z/OS, i 5/OS, S/390, OS/400, AS/400, S/390 Parallel Enterprise Server, Power. VM, Power Architecture, POWER 6+, POWER 6, POWER 5+, POWER 5, POWER, Open. Power, Power. PC, Batch. Pipes, Blade. Center, System Storage, GPFS, HACMP, RETAIN, DB 2 Connect, RACF, Redbooks, OS/2, Parallel Sysplex, MVS/ESA, AIX, Intelligent Miner, Web. Sphere, Netfinity, Tivoli and Informix are trademarks or registered trademarks of IBM Corporation. Linux is the registered trademark of Linus Torvalds in the U. S. and other countries. Adobe, the Adobe logo, Acrobat, Post. Script, and Reader are either trademarks or registered trademarks of Adobe Systems Incorporated in the United States and/or other countries. Oracle is a registered trademark of Oracle Corporation. UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group. Citrix, ICA, Program Neighborhood, Meta. Frame, Win. Frame, Video. Frame, and Multi. Win are trademarks or registered trademarks of Citrix Systems, Inc. HTML, XHTML and W 3 C are trademarks or registered trademarks of W 3 C®, World Wide Web Consortium, Massachusetts Institute of Technology. Java is a registered trademark of Sun Microsystems, Inc. Java. Script is a registered trademark of Sun Microsystems, Inc. , used under license for technology invented and implemented by Netscape. SAP, R/3, SAP Net. Weaver, Duet, Partner. Edge, By. Design, SAP Business. Objects Explorer, Stream. Work, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries. © 2012 SAP AG. All rights reserved. Business Objects and the Business Objects logo, Business. Objects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects Software Ltd. Business Objects is an SAP company. Sybase and Adaptive Server, i. Anywhere, Sybase 365, SQL Anywhere, and other Sybase products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Sybase, Inc. Sybase is an SAP company. All other product and service names mentioned are the trademarks of their respective companies. Data contained in this document serves informational purposes only. National product specifications may vary. The information in this document is proprietary to SAP. No part of this document may be reproduced, copied, or transmitted in any form or for any purpose without the express prior written permission of SAP AG. This document is a preliminary version and not subject to your license agreement or any other agreement with SAP. This document contains only intended strategies, developments, and functionalities of the SAP® product and is not intended to be binding upon SAP to any particular course of business, product strategy, and/or development. Please note that this document is subject to change and may be changed by SAP at any time without notice. SAP assumes no responsibility for errors or omissions in this document. SAP does not warrant the accuracy or completeness of the information, text, graphics, links, or other items contained within this material. This document is provided without a warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability, fitness for a particular purpose, or non-infringement. SAP shall have no liability for damages of any kind including without limitation direct, special, indirect, or consequential damages that may result from the use of these materials. This limitation shall not apply in cases of intent or gross negligence. The statutory liability for personal injury and defective products is not affected. SAP has no control over the information that you may access through the use of hot links contained in these materials and does not endorse your use of third-party Web pages nor provide any warranty whatsoever relating to third-party Web pages. 18