Scribd Logo
Upload

Welcome to Scribd!

  • 71 views

    SAP Bi/Bw: Anas Mohammed

    Uploaded by

    Satish Kumar
    SAP BI is a business intelligence solution that allows flexible reporting and analysis of business data integrated from various source systems. It uses an ETL process to extract, transform, and load data into data stores and info cubes for analysis. Key objects in SAP BI include data sources, persistent staging areas, data store objects, info providers, and info cubes. Data is extracted from sources and loaded into these objects using data transfer processes and info packages for reporting and decision making.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd

    SAP Bi/Bw: Anas Mohammed

    Uploaded by

    Satish Kumar
    71 views25 pages
    SAP BI is a business intelligence solution that allows flexible reporting and analysis of business data integrated from various source systems. It uses an ETL process to extract, transform, and load data into data stores and info cubes for analysis. Key objects in SAP BI include data sources, persistent staging areas, data store objects, info providers, and info cubes. Data is extracted from sources and loaded into these objects using data transfer processes and info packages for reporting and decision making.

    Original Description:

    sample ppt sap bi

    Original Title

    sap bi

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    SAP BI is a business intelligence solution that allows flexible reporting and analysis of business data integrated from various source systems. It uses an ETL process to extract, transform, and load data into data stores and info cubes for analysis. Key objects in SAP BI include data sources, persistent staging areas, data store objects, info providers, and info cubes. Data is extracted from sources and loaded into these objects using data transfer processes and info packages for reporting and decision making.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    71 views25 pages

    SAP Bi/Bw: Anas Mohammed

    Uploaded by

    Satish Kumar
    SAP BI is a business intelligence solution that allows flexible reporting and analysis of business data integrated from various source systems. It uses an ETL process to extract, transform, and load data into data stores and info cubes for analysis. Key objects in SAP BI include data sources, persistent staging areas, data store objects, info providers, and info cubes. Data is extracted from sources and loaded into these objects using data transfer processes and info packages for reporting and decision making.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    of 25

    P

    A
    S

    W
    B
    BI/

    ANAS MOHAMMED

    SCOPE/ AGENDA

    What is BI ?
    SAP BI
    History of SAP BI
    ETL Process
    Typical Data Flow in SAP BI
    Data Model Info Object
    DSO
    Infocube

    What is Business
    Intelligence?

    PROCESS

    Gathering

    Storing

    Analyzing

    Providing Access to data

    Make better Decisions

    SAP BI

    SAP BI Data Warehousing Solution by


    SAP

    Flexible reporting and analysis tool for


    evaluating and interpreting the data.

    Business data integrated, transformed, and


    consolidated in Sap BI.

    History of SAP BI

    SAP launched the product in 1997 by the


    name Business information Warehouse
    (BIW), Version 1. 2A

    Product Name Changed to Business


    Warehouse (BW) with version 3.0A

    Named Business Intelligence BI with


    version 7.0

    Key Functionalities of SAP


    BI

    ETL (Extraction, Transformation, Loading)

    Data Analysis & Planning

    Tools for accessing and visualizing data

    Publishing content from SAP BI

    Performance

    Security

    BI Content

    ETL Process

    The process of the extracting data from


    Source systems and making it useful for our
    needs is ETL

    Source Systems

    SAP systems (S-API Service Application


    Programming Interface)

    BI systems

    Flat files

    Database management systems (DB Connect)

    Relational or multidimensional sources (UD


    Connect)

    Web Services

    Transformation

    Direct assignment

    Constants

    Reading master data

    Routines

    Formula

    Initial

    DATA STORAGE
    AND
    DATA FLOW

    Typical Data Flow in SAP BI


    DTP

    Transformation
    2

    Transformation 1
    DTP

    Infopacka
    ge

    DATASOURCE

    Data Source is a set of fields that are


    provided to transfer data into BI

    1)DataSource for transaction data


    2) DataSource for master data

    PSA

    The Persistent Staging Area (PSA) is the


    storage area for data from the source
    systems in BI.

    The requested data is saved, unchanged


    from the source system.

    Starting point (entrance) of data into BI


    system

    DSO

    A DataStore object serves as a storage


    location for consolidated and cleansed data.

    The data in DataStore objects is stored in


    transparent, flat database tables.

    TYPES OF DSO
    Standard

    DataStore Object

    Write-Optimized
    DataStore

    DataStore Objects

    Objects for Direct Update

    DATA TRANSFER PROCESS

    The data transfer process (DTP) to transfer data from


    source objects to target objects in BI.

    You can also use the data transfer process to access


    Info Provider data directly.

    DTP Types:1.Standard DTP


    2. Direct Access
    3. Error DTP

    Standard DTP:

    You use the data transfer process (DTP) for real-time data
    acquisition to transfer data to the DataStore object from
    the PSA. In the DataStore object, the data is available for
    use in reporting.

    Direct Access DTP:

    You use a data transfer process for direct access to access


    the data in an InfoProvider directly.

    Error DTP:

    The error DTP uses the full update mode to extract data
    from the error stack (in this case, the source of the DTP)
    and transfer it to the target that you have already defined
    in the data transfer process.

    INFOPROVIDER

    An InfoProvider is an object for which queries can be


    created or executed in BEx. InfoProviders are the
    objects or views that are relevant for reporting

    INFOOBJECT

    Info Objects are the smallest units of BI.

    Using Info Objects, information is mapped in a


    structured form. This is required for constructing Info
    Providers.

    They are divide into characteristics (for


    example, customers), key figures (for
    example, revenue), units (for example,
    currency, amount unit), time characteristics
    (for example, fiscal year) and technical
    characteristics and technical characteristics
    (for example, request number)

    INFOPACKAGE

    Infopackage is Data loading Scheduler from


    where You can execute your extraction of
    data from Source system

    INFOCUBE

    An InfoCube is a set of relational tables


    arranged according to the star schema: A
    large fact table in the middle surrounded
    by several dimension tables

    InfoCubes are filled with data from one or


    more InfoSources or other InfoProviders.
    They are available as InfoProviders for
    analysis and reporting purposes.

    TYPES:
    1. Physical data stores:
    BasicInfoCubes
    TransactionalInfoCubes

    2. Virtual data stores:


    RemoteCube
    SAPRemoteCube
    VirtualInfoCube with Services

    Major Differences between Sap


    Bw 3.5 & sapBI 7.0 version

    Infosets now can include Infocubes as well

    Remodeling. This is only for info cube.

    The BI accelerator (for now only for infocubes) helps in


    reducing query run time

    Search functionality hass improved. You can search


    any object.

    The Data Warehousing Workbench replaces the


    Administrator Workbench

    Advantages of SAP BI

    Covers Major Business Processes

    Simple access to business information via a


    single point of entry

    High performance environment.

    Standardized structuring and display of all


    business information

    You might also like