280 likes | 550 Views
SAP BusinessObjects Rapid Marts Prepackaged Analytics Know-How. Jumpstart your analytic needs with SAP BusinessObjects Rapid Marts. Agenda. SAP BusinessObjects Rapid Marts Overview Definition – what is a Rapid Mart Architecture Relationships between Rapid Marts Availability.
E N D
SAP BusinessObjects Rapid MartsPrepackaged Analytics Know-How Jumpstart your analytic needs with SAP BusinessObjects Rapid Marts
Agenda • SAP BusinessObjects Rapid Marts Overview • Definition – what is a Rapid Mart • Architecture • Relationships between Rapid Marts • Availability
SAP BusinessObjects Rapid MartsIntroduction Rapid Marts are flexible packaged data solutions that can be quickly deployed to jump start SAP ERP analytical projects to accelerate Time to Value Adjustmentswithin project Adjustmentswithin project SAP Business Objects Rapid Marts Standard System Standard System Traditional project With SAP BusinessObjects Rapid Marts
SAP BusinessObjects Rapid MartsSolution overview Rapid Marts Business Users SAP Solutions SAP BusinessObjects BI Universes, Initial reports + Dashboards + FI … HR Mfg Sales Reporting Content DB schema + Data Models + Data Marts ETL Mappings SAP BusinessObjects Data Services
SAP BusinessObjects Rapid MartsRobust, 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 BusinessObjects technology
SAP BusinessObjects Rapid MartsRobust, 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
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 Takes Months to Years!
Steps in Typical Analytical Project …with SAP Rapid MartsNo need to start from scratch thanks to Rapid Marts • 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 Prebuilt Takes Weeks!
Agenda • SAP BusinessObjects Rapid Mart Overview • Definition – what is a Rapid Mart • Architecture • Relationships between Rapid Marts • Availability
Definitionwhat is a Rapid Mart (1) SAP BusinessObjects Rapid Marts packages are modular blueprints for building data marts with SAP BusinessObjects Data Services and SAP BusinessObjects 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. • Standard SAP solutions data fields important for your specific business, but not included in the Rapid Mart templates. • Optimization and performance challenges unique to your environment. • Reporting requirements not covered within the Rapid Mart template reports.
Definitionwhat is a Rapid Mart (2) SAP BusinessObjects Rapid Marts packages are modular blueprints for building data marts with SAP BusinessObjects Data Services and SAP BusinessObjects 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.
Agenda • SAP BusinessObjects Rapid Mart Overview • Definition – what is a Rapid Mart • Architecture • Relationships between Rapid Marts • Availability
SAP BusinessObjects Rapid Marts - High-Level Architecture3 functional and technology layers supporting best practices • ETL Mappings • Subject matter experts have configuredsource- to-target mappings and data transformations for relevant source tables • ETL jobs were coded and optimized to perform initial and incremental data movements 1 Adjustmentswithin project Adjustmentswithin project
SAP BusinessObjects Rapid Marts - High-Level Architecture3 functional and technology layers supporting best practices • Data Marts • Set of target RDBMS objects and schemas based on best practices for dimensional data modeling. • The schemas are available for HANA , Oracle, MS SQL Server. 2 Adjustmentswithin project Adjustmentswithin project
SAP BusinessObjects Rapid Marts - High-Level Architecture3 functional and technology layers supporting best practices • Reporting Content • Preconfigured universes based on best practices to ensure optimized ad-hoc BI query generation and re-use • Set of sample reports showing the wealth of data available and best practice report design • Set of Dashboards available for SAP BusinessObjects Sales Rapid Mart 3 Adjustmentswithin project Adjustmentswithin project
SAP BusinessObjects 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 BusinessObjects 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 BusinessObjects 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 BusinessObjects Sales Rapid Mart
Integrated Data Model • Star approach design that fits best purposes of analytical reporting • Simplifies and shortens integration milestone for multiple Rapid Marts for SAP solution implementations • Standardized naming of database objects makes it easier to understand data content • Rapid Mart data modeling methodology – cookbook on how to extend out-of-the-box schema content • Total # of stars:~62 • Total # of fact tables: ~102 • Total # of dimension tables: ~592 • Total # of tables/views: ~702 *Example used: SAP Account Payable Rapid Mart Data Model
Semantic Layer • Focus on standardization • 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 • Total # of universes: ~23 • Total # of universe objects: ~36,000+
Integrated ETL Framework • Componentized job design approach: ‘mix-and-match’ fact and dimension Rapid Mart tables to load • All Rapid Mart jobs use the same framework: • Script to initialize variables and job execution status • Workflow sections to load the Rapid Mart stars • Script to update the job execution status • Integrated set of global variables • Total # variables: 230+ • Total 1,800+ ETL objects *Example used: Sales Rapid Mart for SAP solutions Data Model
Agenda • SAP BusinessObjects Rapid Mart Overview • Definition – what is a Rapid Mart • Architecture • Relationships between Rapid Marts • Availability
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 BusinessObjects Accounts Payable Rapid Mart are related to other SAP BusinessObjects Rapid Mart components. For example: • The vendor component, which contains information about vendors, is used in the SAP BusinessObjects Inventory Rapid Mart and SAP BusinessObjects 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 BusinessObjects General Ledger Rapid Mart.
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_VendorItems_Section
Agenda • SAP BusinessObjects Rapid Mart Overview • Definition – what is a Rapid Mart • Architecture • Relationships between Rapid Marts • Availability
SAP BusinessObjects Rapid Marts 4.0Rapid Marts available to date Financial Suite • General Ledger Rapid Mart • Accounts Payable Rapid Mart • Accounts Receivable Rapid Mart • Cost Center Rapid Mart • Fixed Assets Rapid Mart (New in 4.0 Release) Operational Suite • Inventory Rapid Mart • Purchasing Rapid Mart • Sales Rapid Mart Manufacturing Suite • Plant Maintenance Rapid Mart • Production Planning Rapid Mart • Project Systems Rapid Mart Human Capital Management Suite • HR Rapid Mart