SAP BI Architecture & Star Schema, ETTL Process

Document Sample
SAP BI Architecture & Star Schema, ETTL Process Powered By Docstoc
					     SAP Business Intelligence


   SAP NW BW Architecture
   Data Warehousing Concepts..
    Star Schema, ETTL Process
Why SAP BI?
SAP BI…

   OLAP
   Separate Server with it’s own database
   Build On Data warehousing concepts
   Analytical and interactive reporting
   Web based graphical dashboards
   Up to date data analysis
   Data analysis from multiple source system
SAP BW Architecture…

                          Analytical Layer (Reporting)

        Warehousing Workbench

                                    Data mart Layer
                Data




                                      Staging Layer



       SAP CRM SAP ECC                   Oracle   Excel File
Data storage in SAP BI

   Basic Objects are called as ‘Infoobjects’
    corresponding to OLTP ‘fields’
    Ex: 0CUSTOMER,0PRODUCT
    Master data will be stored in Infoobjects.
   Transaction data will be stored in
    Infoproviders corresponding to Database
    tables in OLTP.
    Ex: Infocube, Datastore Object (DSO)
Introduction to System and SAP GUI
Data Warehousing Workbench…


   Transaction Code: RSA1



   Central Maintenance Tool
Data Warehousing Workbench…
Data Warehousing
Concepts…in SAP NW BW


   Star Schema

   ETL
Star Schema…
Extended Star Schema…

				
DOCUMENT INFO
Shared By:
Stats:
views:212
posted:12/23/2011
language:English
pages:11