130 likes | 296 Views
INTRODUCTION. Agenda. BUSINESS CHALLENGES. FEATURES OF RAPID MARTS. SOLUTION OVERVIEW. DWH USING SAP RAPID MARTS. BENEFITS TO BUSINESS USERS. BUSINESS CHALLENGES. 1. A restrictive user interface No Customized Reporting capability Limited cross-module reporting
E N D
INTRODUCTION Agenda BUSINESS CHALLENGES FEATURES OF RAPID MARTS SOLUTION OVERVIEW DWH USING SAP RAPID MARTS BENEFITS TO BUSINESS USERS
BUSINESS CHALLENGES 1 A restrictive user interface No Customized Reporting capability Limited cross-module reporting No Graphical Views of the Reports Custom ETL development takes too long to implement High dependency on IT resources 2 3 4 5 6
SOLUTION OVERVIEW Rapid Marts • Prepackaged and flexible Data Mart solution (Readymade solution) on ERPs • All Rapid Marts are ERP specific and Application specific • Can be implemented in weeks instead of months and quarters • Accelerates Data Warehouse implementation process with low cost • Rapid Mart packages are available for ERPs – SAP, Oracle, PeopleSoft and Seibel • Rapid Marts Versions – XI R2, XI 3.0, XI 3.2 & XI 4.0
FEATURES OF RAPID MARTS • A Simple Solution to your Business Analytics Challenges are SAP Rapid Marts • SAP BusinessObjects Rapid Marts packages are modular blueprints for building data marts with SAP BusinessObjects Data Services and SAP BusinessObjects BI • Each Rapid Mart is designed to address the reporting needs of a specific business area (or department) like accounting, sales, or purchasing. • Rapid Marts provide your business with an accelerated time to value through rapid BI deployments • Preconfigured ETL mappings and data transformation logic reduces implementation time • Pre-built universes are configured to allow ad-hoc BI queries and re-use • Rapid Marts are flexible templates that you can adjust to account for these unique situations. • You can implement Rapid Marts quickly and easily customize them to meet specific analytic requirements.
FEATURES OF RAPID MARTS • SAP BusinessObjects Rapid Marts are Robust, Modular, Mature • Deliver rapid insight • Increase flexibility • Reduce costs • SAP ERP Sources • Financial • Operational • Manufacturing • Human Capital Mgmt Resources Start here with Rapid Mart Extension and Customization Time
SOLUTION OVERVIEW Business Users Rapid Marts SAP BusinessObjects BI Universes, Initial reports + Dashboards SAP Solutions FI … HR Mfg Sales DB schema + Data Models SAP BusinessObjects Data Services
SOLUTION OVERVIEW Rapid Marts for SAP Solution Following are the 12 Rapid Mart packages available for SAP ERP Solution 1 7 • Sales (SA) • Accounts Receivable (AR) • Accounts Payable (AP) • Cost Center (CC) • General Ledger (GL)* • Human Resource (HR) • Fixed Assets (FA) • Inventory (IN) • Purchasing (PR) • Production Planning (PP) • Plant Maintenance (PM) • Project Systems (PS) 2 8 3 9 4 10 5 11 6 12
SOLUTION OVERVIEW Rapid Marts Content Rapid Mart package contains the following content: • Data Model (SQL Script Files)* • DDL for Schema creation • Recommended Joins and Indexes • ETL workflows for initial and incremental data (ATL File) • Job Recovery framework • Sample Universes, SQL and Reports (BIAR File) • Technical and Business Analysis Documentation
Steps in Typical Analytical Project … SOLUTION OVERVIEW • 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 Takes Months to Years!
SOLUTION OVERVIEW Steps in Typical Analytical Project with Rapid Marts No need to start from scratch thanks to Rapid Marts Prebuilt • 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 Takes Weeks!
DWH USING SAP RAPID MARTS Time for Data Warehouse implementation using SAP BOBJ products, involved in putting efforts and risks in each function of a Data Warehouse i.e. data modeling, ETL design, Schema designing and reports development. We can reduce the risk, efforts, cost and time by using Rapid Mart packages in DWH implementation, this is because availability of • Ready made Data Model script files • Ready made ETL Transformations • Ready made schema (Universe) • Ready made Reports & Dashboards No SMEs and Architects required for implementation and takes less time to Go-Live DWH Implementation Time = t(Deployment of RM content) + t(Customization of RM)
BENEFITS TO BUSINESS USERS Benefits • Accelerates Data Warehouse implementation process with low cost • Timefor Data Warehouse implementation using SAP BOBJ Rapid Marts is much more faster than traditional approach • A fully customizable set of reports and dashboards • Preconfigured ETL mappings and data transformation logic reduce implementation time • Easily customizable components that reduce initial time-to-deploy and enable self-service analytics for users • Reduction of IT resources involvement • Reduce on-going maintenance costs.