Scribd Logo
Upload

Welcome to Scribd!

  • 29 views

    BIW Concept v2

    Uploaded by

    Murali Vemuluri
    The document discusses the concept and benefits of a Business Information Warehouse (BIW). It states that a BIW is a reporting and decision making tool that provides structured, centralized access to organizational data from multiple sources. It allows management to understand key metrics like sales, production, costs. With a BIW, data is extracted from SAP and other systems into a staging area and then loaded into the BIW database. Users can then generate dynamic, ad-hoc reports without IT assistance. This reduces load on operational systems and empowers users to access and analyze information more easily.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPT, PDF, TXT or read online from Scribd

    BIW Concept v2

    Uploaded by

    Murali Vemuluri
    29 views11 pages
    The document discusses the concept and benefits of a Business Information Warehouse (BIW). It states that a BIW is a reporting and decision making tool that provides structured, centralized access to organizational data from multiple sources. It allows management to understand key metrics like sales, production, costs. With a BIW, data is extracted from SAP and other systems into a staging area and then loaded into the BIW database. Users can then generate dynamic, ad-hoc reports without IT assistance. This reduces load on operational systems and empowers users to access and analyze information more easily.

    Original Title

    BIW concept v2

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PPT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document discusses the concept and benefits of a Business Information Warehouse (BIW). It states that a BIW is a reporting and decision making tool that provides structured, centralized access to organizational data from multiple sources. It allows management to understand key metrics like sales, production, costs. With a BIW, data is extracted from SAP and other systems into a staging area and then loaded into the BIW database. Users can then generate dynamic, ad-hoc reports without IT assistance. This reduces load on operational systems and empowers users to access and analyze information more easily.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    29 views11 pages

    BIW Concept v2

    Uploaded by

    Murali Vemuluri
    The document discusses the concept and benefits of a Business Information Warehouse (BIW). It states that a BIW is a reporting and decision making tool that provides structured, centralized access to organizational data from multiple sources. It allows management to understand key metrics like sales, production, costs. With a BIW, data is extracted from SAP and other systems into a staging area and then loaded into the BIW database. Users can then generate dynamic, ad-hoc reports without IT assistance. This reduces load on operational systems and empowers users to access and analyze information more easily.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    of 11

    Concept of BIW

    About BIW ?

     BIW (Business Information Warehouse ) is a


    Reporting Tool , Useful for Middle and Higher
    level Management .

     BIW tool will help to understand the health of the


    organization in the view of Sales , Production ,
    .
    Material Consumption and Cash flow etc..
     Various analysis aspects .
     BIW is decision making tool for all Management
    levels.
    Technical Speak about BIW

    • BIW is a DATA Warehouse, having all


    modules data in structured way .

    • Data will flow from SAP r/3 to BIW server.

    • We can extract & integrate the data from


    Other Platforms like Oracle , Ms-
    Access , MS Excel etc….
    With Out BIW ?
    • No central access:
    – Data relevant for decision-making are spread in different source
    systems across
    the Organization. Analyses are time consuming and not always
    consistent .
    • Time Consuming
    – Often, decision makers have to spend too much time on finding
    relevant, timely information before they can even analyze it.

    • Bad Performance
    – The response time of complex analyses in operational systems is often
    not acceptable.
    • Complexity / IT-Dependency
    – Transactional systems often require additional programming efforts to
    retrieve relevant information. Employees without programming know-
    how are not able to run ad-hoc analyses.
    Data Flow from R/3 to BIW

    ECC 6
    Cleaning
    FICO
    SD
    MM
    PP Final
    PM BIW
    PS
    QM DB

    Staging
    Tables

    Non
    SAP
    Source
    Data
    Reporting
    Data Source Extraction Warehouse
    KPI Dimensions

    1 Quantity Sold?
    2 What is the sales value?
    250
    3 Sold under which year – quarter – month
    – week?
    +
    4 Sold to which category of customer?
    5 Handled through which sales office?
    200
    6 Under Which Distribution Channel?
    + 7 Under Which Sales Organisation?
    8 Under which Division?
    150
    9 Export or Domestic?
    10 Which Product category?
    Data
    Grain 11 Shipped from which plant
    Info Cube

    Purchase Sales
    IF BIW is available…….

    • Using BIW can generate Dynamic reports, where as in R/3 only static
    reports are possible .
    • Users themselves can Generate the Reports based on the key fields .
    • User Friendly tool for Management to view or Generate the Reports by
    using Drag & Drop method as per required format.
    • With out Technical skills, we can generate BW reports with output format .
    Advantages…

    • Empowers end-users
    – Can build ad-hoc queries with no programming
    – Can slice and dice information using various business criteria
    and ‘what if scenarios .
    • Provides high-quality information to meet complex reporting needs.
    – Summarizes large amounts of data from different sources in a
    single view.

    • Can analyze trends over several months or years

    • Offloads ad-hoc and long running queries from production


    operational system to BI system
    – Should improve overall performance of operational system
    – Reduces frequency of server capacity upgrades
    Advantages…

    • Can process large volumes of information quickly


    • Can pull information from different R/3 modules or non-SAP source
    • Reports easily deployed across organization via the web.
    – No need for BW software on user desktop
    LANCO- Information Technology

    You might also like