SAP Business Objects Rapid Marts Prepackaged Analytics KnowHow

SAP Business. Objects Rapid Marts Prepackaged Analytics Know-How Jumpstart your analytic needs with SAP Business. Objects Rapid Marts

Agenda 1. SAP Business. Objects Rapid Marts Overview 2. Definition – what is a Rapid Mart 3. Architecture 4. Relationships 5. Availability between Rapid Marts

SAP Business. Objects Rapid Marts Introduction Rapid Marts are flexible packaged data solutions that can be quickly deployed to jump start SAP ERP analytical projects to accelerate Time to Value Adjustments within project Standard System Traditional project © 2012 SAP AG. All rights reserved. SAP Business Objects Rapid Marts Standard System With SAP Business. Objects Rapid Marts 3

SAP Business. Objects Rapid Marts Solution overview Rapid Marts Business Users SAP Business. Objects BI SAP Solutions Universes, Initial reports + Dashboards Reporting Content + DB schema + Data Models HR Sales … Mfg FI Data Marts SAP Business. Objects Data Services + ETL Mappings © 2012 SAP AG. All rights reserved. 4

SAP Business. Objects Rapid Marts Robust, Modular, Mature Prebuilt data capture, data foundation and reporting content for an accelerated BI implementation with quick time to value Suitable for departmental standalone reporting or enterprise consolidated reporting and analysis needs Quick ROI and Low TCO Proven solution with 10+ years on the market with innovation roadmap Built on market leading SAP Business. Objects technology © 2012 SAP AG. All rights reserved. 5

SAP Business. Objects Rapid Marts Robust, Modular, Mature Deliver rapid insight Increase flexibility Start here with Rapid Mart SAP ERP Sources n Financial n Operational n Manufacturing n Human Capital Mgmt Resources Reduce costs Extension and Customization Time © 2012 SAP AG. All rights reserved. 6

Steps in Typical Analytical Project … ü ü ü Gather Business Requirements (Business Analyst) Define Data Content/Data Model (Data Modeler) Define Data Sources (ERP Expert) Define Source to Target Mappings (ETL Expert/Biz Analyst) Design Data Validation (ETL Expert) Design Error Recovery (ETL Expert) Write the relevant code (ETL Expert) Implement and Test (Project Manager) Gather Feedback Extend, Customize and Adopt Deploy © 2012 SAP AG. All rights reserved. Takes Months to Years! 7

Steps in Typical Analytical Project …with SAP Rapid Marts No need to start from scratch thanks to Rapid Marts ü ü ü Gather Business Requirements (Business Analyst) Prebuilt Define Data Content/Data Model (Data Modeler) Define Data Sources (ERP Expert) Define Source to Target Mappings (ETL Expert/Biz Analyst) Design Data Validation (ETL Expert) Design Error Recovery (ETL Expert) Write the relevant code (ETL Expert) Implement and Test (Project Manager) Gather Feedback Extend, Customize and Adopt Deploy © 2012 SAP AG. All rights reserved. Takes Weeks! 8

SAP Business. Objects Rapid Marts Summary Deliver Rapid Insight • Accelerate business analytics deployments • Implement in weeks instead of months/years • Get a proof of concept in days Increase Flexibility • Implement individually or in combination • Satisfy up to 80% of your reporting requirements • Expand to 100% with easy customization Reduce Costs • Downsize initial development effort • Minimize the need for specialized SAP skills • Reduce on-going maintenance costs © 2012 SAP AG. All rights reserved. 9

Agenda 1. SAP Business. Objects Rapid Mart Overview 2. Definition – what is a Rapid Mart 3. Architecture 4. Relationships 5. Availability between Rapid Marts

Definition what is a Rapid Mart (1) SAP Business. Objects Rapid Marts packages are modular blueprints for building data marts with SAP Business. Objects Data Services and SAP Business. Objects BI Rapid Marts packages deliver jump-start ETL (extract, transform & load) mappings, schema, and initial reporting content, accelerating the deployment of BI (business intelligence) for SAP applications Each Rapid Mart is designed to address the reporting needs of a specific business area (or department) like accounting, sales, or purchasing. A component-based framework allows conducting analysis across these selected business areas by combining different packages within the same source application suite. Rapid Marts focus on basic standard configuration of the enterprise applications. They are country and industry neutral templates meant to be easily modified and extended to suit customer specific application implementation and reporting needs. Rapid Marts incorporate best practices, and provide easily modifiable templates. With Rapid Marts total development time of a data mart solution is greatly reduced. Each customer situation is different. You will probably encounter one or more of these: Customizations you have made to SAP solutions the Rapid Mart does not cover. Optimization and performance challenges unique to your environment. Standard SAP solutions data fields important for your specific business, but not included in the Rapid Mart templates. Reporting requirements not covered within the Rapid Mart template reports. © 2012 SAP AG. All rights reserved. 11

Definition what is a Rapid Mart (2) SAP Business. Objects Rapid Marts packages are modular blueprints for building data marts with SAP Business. Objects Data Services and SAP Business. Objects BI Rapid Marts are flexible templates that you can adjust to account for these unique situations. It is expected that some customization and optimization will be needed to suit your individual environment. Rapid Marts are not an out-of-the-box solution. BI tools and analytic tools can access Rapid Mart data through SQL queries. Rapid Marts can be implemented individually, or in any combination, to form a single platform that delivers the infrastructure for your company’s internal and external information needs. They can also serve as a staging area for enterprise analytic applications. Rapid Marts provide your business with an accelerated time to value through rapid BI deployments because you can implement them quickly and easily customize them to meet specific analytic requirements. You can combine multiple Rapid Marts packages into a single environment to build the foundation for your data warehouse or use them as a staging area for business intelligence applications. © 2012 SAP AG. All rights reserved. 12

Agenda 1. SAP Business. Objects Rapid Mart Overview 2. Definition – what is a Rapid Mart 3. Architecture 4. Relationships 5. Availability between Rapid Marts

SAP Business. Objects Rapid Marts - High-Level Architecture 3 functional and technology layers supporting best practices 1 ETL Mappings Subject matter experts have configured source- to-target mappings and data transformations for relevant source tables Adjustments within project ETL jobs were codedwithin and project optimized to perform initial and incremental data movements © 2012 SAP AG. All rights reserved. 14

SAP Business. Objects Rapid Marts - High-Level Architecture 3 functional and technology layers supporting best practices 2 Data Marts Set of target RDBMS objects and schemas based on best practices for dimensional data modeling. Adjustments within project The schemas are available for Adjustments HANA , Oracle, MS SQL Server. within project © 2012 SAP AG. All rights reserved. 15

SAP Business. Objects Rapid Marts - High-Level Architecture 3 functional and technology layers supporting best practices 3 Reporting Content Preconfigured universes based on best practices to ensure optimized ad -hoc BI query generation and re-use Adjustments within project Set of sample reports. Adjustments showing the within project wealth of data available and best practice report design Set of Dashboards available for SAP Business. Objects Sales Rapid Mart © 2012 SAP AG. All rights reserved. 16

SAP Business. Objects Rapid Marts – Architecture Details Data Movement Jobs - packaged source-to-target mappings and data transformations. Each job is designed to perform initial and incremental data movement. Data Model & Schema - set of data mart database objects designed with dimensional data modeling approach. Rapid Marts packages have a single integrated data model. The schema are available for HANA, Oracle, MS SQL Server. Semantic Layer (Universes) - SAP Business. Objects metadata packages for efficient query generation. There can be one or more universes per Rapid Mart. Each universe is developed using Rapid Marts design principles to ensure compatibility, code readability, and component re-use. In addition, there is one Master universe for development/maintenance of multiple use objects (like Customer, Material, Currency, etc. ). Reports (Initial) - set of 15 -20 Web Intelligence reports per Rapid Mart. They represent answers to mostly asked business questions (for example, in the SAP Business. Objects Sales Rapid Mart, what is the monthly revenue trend by division for this year? '). The reports are developed using Rapid Mart color/layout templates. Reports are examples of Web Intelligence best practice development (trends, listing, guided analysis, roll ups and downs, etc. ). Dashboards - available for SAP Business. Objects Sales Rapid Mart © 2012 SAP AG. All rights reserved. 17

Integrated Data Model n Star approach design that fits best purposes of analytical reporting Simplifies and shortens integration milestone for multiple Rapid Marts for SAP solution implementations n Standardized naming of database objects makes it easier to understand data content n Rapid Mart data modeling methodology – cookbook on how to extend out-of-the-box schema content n • • Total # of stars: ~62 Total # of fact tables: ~102 Total # of dimension tables: ~592 Total # of tables/views: ~702 © 2012 SAP AG. All rights reserved. *Example used: SAP Account Payable Rapid Mart Data Model 18

Semantic Layer n Focus on standardization n All Rapid Mart dimension and fact table columns are exposed as objects Universe classes, subclasses and all objects they contain are organized alphabetically for ease of navigation Monetary measures are grouped by currency Extensive list of filters Master Universe contains common classes for ease of customization n n • • Total # of universes: ~23 Total # of universe objects: ~36, 000+ © 2012 SAP AG. All rights reserved. 19

Integrated ETL Framework n Componentized job design approach: ‘mix-and-match’ fact and dimension Rapid Mart tables to load All Rapid Mart jobs use the same framework: n Script to initialize variables and job execution status n Workflow sections to load the Rapid Mart stars n Script to update the job execution status n Integrated set of global variables n • • Total # variables: 230+ Total 1, 800+ ETL objects © 2012 SAP AG. All rights reserved. *Example used: Sales Rapid Mart for SAP solutions Data Model 20

Agenda 1. SAP Business. Objects Rapid Mart Overview 2. Definition – what is a Rapid Mart 3. Architecture 4. Relationships 5. Availability between Rapid Marts

Relationship between Rapid Marts Each Rapid Mart is composed of multiple components. A component is a stand-alone work flow that completes a particular task, such as loading a specific dimension table. Components can contain other components. A section is a set of components that address a particular business problem or subject area. A section is itself a component. Components of the SAP Business. Objects Accounts Payable Rapid Mart are related to other SAP Business. Objects Rapid Mart components. For example: The vendor component, which contains information about vendors, is used in the SAP Business. Objects Inventory Rapid Mart and SAP Business. Objects Purchasing Rapid Mart. Common dimensions are included in appropriate Rapid Marts. Vendor Financial Documents are a subset of the Financial Documents found in the SAP Business. Objects General Ledger Rapid Mart. © 2012 SAP AG. All rights reserved. 22

Relationship between Rapid Marts The same components can be used in multiple Rapid Marts. For example, a component that extracts information about materials bought, produced, and sold is needed for a Rapid Mart that supports sales analysis and also for a Rapid Mart that supports inventory analysis. Work flows that extract star schema “dimensions” are components. You can add a component to any Rapid Mart using a simple import procedure. A Data Services job can include multiple instances of a component. For example, each section includes all the required dimension components. Therefore, a job with several sections may include several instances of a particular dimension component. Components are set to execute only once within a job. This “execute once” feature ensures that shared components do not cause duplicate data extraction from SAP solutions. For more information about the “execute once” feature, see the Data Integrator/Data Services Designer Guide. You can identify a component within a Data Services job by a “C_” prefix before its name. For example, the component that contains vendor-related financial documents and the associated reporting dimensions is named C_Vendor. Items_Section © 2012 SAP AG. All rights reserved. 23

Agenda 1. SAP Business. Objects Rapid Mart Overview 2. Definition – what is a Rapid Mart 3. Architecture 4. Relationships 5. Availability between Rapid Marts

SAP Business. Objects Rapid Marts 4. 0 Rapid Marts available to date n General Ledger Rapid Mart Financial Suite n Accounts Payable Rapid Mart n Accounts Receivable Rapid Mart n Cost Center Rapid Mart n Fixed Assets Rapid Mart (New in 4. 0 Release) Operational Suite Manufacturing Suite Human Capital Management Suite © 2012 SAP AG. All rights reserved. n Inventory Rapid Mart n Purchasing Rapid Mart n Sales Rapid Mart n Plant Maintenance Rapid Mart n Production Planning Rapid Mart n Project Systems Rapid Mart n HR Rapid Mart 25

© 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, Power. Point, Silverlight, and Visual Studio are registered trademarks of Microsoft Corporation. IBM, DB 2 Universal Database, System i 5, System p 5, System x, System z 10, z/VM, z/OS, OS/390, z. Enterprise, Power. VM, Power Architecture, Power Systems, POWER 7, POWER 6+, POWER 6, POWER, Power. HA, pure. Scale, Power. PC, Blade. Center, System Storage, Storwize, XIV, GPFS, HACMP, RETAIN, DB 2 Connect, RACF, Redbooks, OS/2, AIX, Intelligent Miner, Web. Sphere, Tivoli, Informix, and Smarter Planet are trademarks or registered trademarks of IBM Corporation. Linux is the registered trademark of Linus Torvalds in the United States and other countries. Adobe, the Adobe logo, Acrobat, Post. Script, and Reader are trademarks or registered trademarks of Adobe Systems Incorporated in the United States and other countries. Oracle and Java are registered trademarks of Oracle and its affiliates. 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. Apple, App Store, i. Books, i. Pad, i. Phone, i. Photo, i. Pod, i. Tunes, Multi-Touch, Objective-C, Retina, Safari, Siri, and Xcode are trademarks or registered trademarks of Apple Inc. IOS is a registered trademark of Cisco Systems Inc. INTERMEC is a registered trademark of Intermec Technologies Corporation. Wi-Fi is a registered trademark of Wi-Fi Alliance. Bluetooth is a registered trademark of Bluetooth SIG Inc. Motorola is a registered trademark of Motorola Trademark Holdings LLC. Computop is a registered trademark of Computop Wirtschaftsinformatik Gmb. H. SAP, R/3, SAP Net. Weaver, Duet, Partner. Edge, By. Design, SAP Business. Objects Explorer, Stream. Work, SAP HANA, 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. 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. Crossgate, m@gic EDDY, B 2 B 360°, and B 2 B 360° Services are registered trademarks of Crossgate AG in Germany and other countries. Crossgate 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. RIM, Black. Berry, BBM, Black. Berry Curve, Black. Berry Bold, Black. Berry Pearl, Black. Berry Torch, Black. Berry Storm 2, Black. Berry Play. Book, and Black. Berry App World are trademarks or registered trademarks of Research in Motion Limited. Google App Engine, Google Apps, Google Checkout, Google Data API, Google Maps, Google Mobile Ads, Google Mobile Updater, Google Mobile, Google Store, Google Sync, Google Updater, Google Voice, Google Mail, Gmail, You. Tube, Dalvik and Android are trademarks or registered trademarks of Google Inc. © 2012 SAP AG. All rights reserved. 26