Sap bw overview
Download
1 / 15

SAP BW Overview - PowerPoint PPT Presentation


  • 206 Views
  • Updated On :

SAP BW Overview. Pennsylvania State System of Higher Education. Agenda. Reporting Comparison BW Overview BW Landscape & Architecture BW Reporting Tools Business Content BW Website Online Resources Discussions/ Q&A . Reporting Comparison. R/3. BW. Line Item Analysis

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'SAP BW Overview' - sissy


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Sap bw overview l.jpg

SAP BW Overview

Pennsylvania State System

of Higher Education


Agenda l.jpg
Agenda

  • Reporting Comparison

  • BW Overview

  • BW Landscape & Architecture

  • BW Reporting Tools

  • Business Content

  • BW Website

  • Online Resources

  • Discussions/ Q&A


Reporting comparison l.jpg
Reporting Comparison

R/3

BW

  • Line Item Analysis

  • Delivered Reports

  • Basic Reporting or Predefined (requires

  • ABAP programmers)

  • Consumes Resources from

  • Transaction Processing

  • Real-time Analysis

  • Function Specific

  • Relational & Multidimensional Analysis

  • Delivered Reports (aka Business Content)

  • Ad hoc or Predefined (can be designed

  • by users)

  • Significantly Faster Processing

  • Current (according to update schedule)

  • & Historical Analysis

  • Cross Functional


Bw overview l.jpg
BW Overview

  • The Business Information Warehouse (BW) is SAP’s architectural solution for data warehousing.

    • Seamless integration with R/3

    • Built-in functionality that substantially reduces DW design, development and maintenance

  • BW is a separate system from the R/3 transaction processing system

    • BW data structures are optimized for reporting data efficiently and quickly (analytical processing).

    • R/3 data structures are optimized for recording data efficiently and quickly (transaction processing).


State system bw landscape l.jpg
State System BW Landscape

BW Dev

DB1

BW QA

QB1

BW PRD

PB1

BW TRN

TB1

BW SB

SB1

Data

Data

Data

Data

Data

SAP R/3

DV1

DR1

DC1

SAP R/3

QA2

QR1

QC1

SAP R/3

PRD

PR1

PC1

SAP R/3

TRN

TR1

TC1

SAP R/3

SF1

SR1


Basic bw architecture l.jpg
Basic BW Architecture

BEx

SAP R/3

InfoCube

ODS

Non-SAP

Data Sources

(Flat file, XML

or DBConnect)

Data Detail

Business Content

Web

Based

BEx

SAP-BW

Data Sources

Business Explorer Tools


Bw reporting tools business explorer bex query designer l.jpg
BW Reporting ToolsBusiness Explorer (BEx) Query Designer

  • MS-Excel-Based Analyzer (Web or GUI)

  • Formatted Reporting

  • Web Application Designer


Business explorer bex analyzer l.jpg
Business Explorer (BEx) Analyzer

  • Queries and solution workbooks embedded in MS Excel

  • Excel functionality can be utilized (calculations, charts, VBA programming, etc.)

  • Queries are refreshed at each run; workbooks provide pre-calculated queries

  • Incorporates BW Security and, therefore, eliminates the need for an additional layer of security at the reporting level

  • Seamless integration with BEx Analyzer for the Web


Gui based or l.jpg
GUI Based or……

SAP Menu Bar Add-in



What is business content l.jpg
What is “Business Content?”

  • Advantages of using Business Content

    • Pre-Configured SAP-delivered objects allow rapid development(DataSources, Transfer Structures, ODSs, InfoCubes, Queries, etc.)

    • Based on Best Practices

  • A solution to build upon

    • Provides a good baseline for enhancements of functionality and data models.



Online resources l.jpg
Online Resources

  • SAP Online Documentation - help.sap.com

  • Service Marketplace - service.sap.com

    • OSS Notes

    • Installation and upgrade info

  • SAP Developers Network - sdn.sap.com

    • Online Forums

    • How Tos

  • SAP Fans – www.sapfans.com