Docstoc

SAP NW BW BASICS

Document Sample
SAP NW BW BASICS Powered By Docstoc
					SAP Business Intelligence
Basics…

   Business      Query

   Data          Report

   ERP           OLAP

   OLTP          Data warehousing
Basics…Business

   Business..

        Exchange of products or services
    with money between the Company and
    customers.
Basics…Business
          Company


         FI        HR




         MM         PP



              SD
Basics…Data

   Data:
         Group of fields which gives a
    meaningful information.

    Ex: Bio-Data
Basics…Data

Data – two types

   Master Data

   Transaction Data
Basics…Master Data

   Personal Information about an entity.

Ex: Customer Name, Customer Address,
      Product Name, Product Color
Basics…Transaction Data

   Data generated at the time of a
    transaction takes place.

    Ex: Money withdrawal from an ATM
Basics…ERP

   ERP (Enterprise Resource Planning)
      Planning of resources i.e. FI,HR,
    MM, SD.. In an enterprise.

ERP Packages: Informatica, Oracle, JD
  Edward, Baan, SAP……
Basics…OLTP

   Online Transactional Processing

    …….ERP systems
    …….Transaction Data
    …….Large Volume Of Data
    …….Analytical reports not possible
Basics…Query

   Business Question

    What is the last 4 years sales
    Revenue?
Basics…Report

     Answer to a business question.

          Year      Revenue in Cr
          2007            160
          2008            150
          2009            180
          2010            190
Basics…OLAP

   Online Analytical Processing.

….Separate server.
….Free from transactions.
….Data available for analysis.
….No load on OLTP.
Basics…Data warehousing.

Process of
…..Extraction
…..Transfer
…..Storing
…..Maintenance for years
…..Analysis of Data.
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
Excel Integration…
Web Reports…
Data storage in OLTP…
   Basic objects are called as ‘Fields’
    Ex: 0CUSTOMER,0PRODUCT.
   Master data will be stored in master data tables.
    Ex: 0CUSTOMER Master data tables.
   Transaction Data will be stored in Database tables.
    Ex: Sales Orders Header –VBAK
        Sales Order Item --------VBAP
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)

				
DOCUMENT INFO
Shared By:
Stats:
views:102
posted:12/23/2011
language:
pages:20