Loading presentation...

Present Remotely

Send the link below via email or IM


Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.



Training Material

Heba Ayeldeen

on 22 January 2015

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of SAP BW

with SAP NetWeaver 7.0
Business Intelligence
1) BW310
2) BW350
3) BW305
4) BW370
5) BW380
6) BW330
7) BW306
8) BW360
Data warehousing
Data Acquisition
Reporting 1
Integrated planning
Data Mining
Reporting 2
• Positioning and Overview of SAP NetWeaver BW
• Working with the most important objects
(InfoObjects, InfoProviders etc.) of SAP NetWeaver BW
• Creating a simple data model plus data flow and loading data from
different source systems
• Using BI Content
• Optimizing query performance
• Administrating SAP NetWeaver BW
Data warehouse Evolution
In the early 1960s, the world of computation consisted of creating individual applications that were run using master files.

Around the mid 1960s, the growth of master files and magnetic tape exploded. And with the growth came huge amounts of redundant data. The explosion of master files and redundant data presented some very dangerous problems
By 1970, the day a new technology for the storage and access of data had dawned. The 1970s saw the advent of the disk storage, or the direct access storage device "directly accessing the required data"

With the direct access concept came a new type of system software known as database management system which is easily used to store and access data

By the mid 1970s, online transaction processing OLTP made even faster access to data possible
Data warehouse Evolution
* Data Integration
* Online Analytical processing OLAP
* Data Extraction
* Exploration and data mining
* Partitioning of data
•Simplification of data access
•Allows end users to perform extensive analysis
•Enhanced system performance "in accessing the data"
•Allows a consolidated view of the data
•Helps to maintain the data about the data
•Enhanced business knowledge
•Enhance customer service and satisfaction
easy access to data in an optimum acceptable time
•Facilitate decision making

•Easy to use
•Speedy information retrieval
•More information
•Better quality information
•Improved productivity
•Better decisions
A physical repository where relational data are specially organized to provide enterprise, cleansed data in a standardized format. It is a technique of gathering and collecting data from different systems. Data can be related or even unrelated. Data can be collected from file systems; computer systems; or even the internet
Factors affecting the data warehouse
• Compatibility with existing system
•How many users will be accessing the data warehouse
•The volume of data to be provided
•The speed with which data is needed
•Frequency of accessing the data
•What kind of analysis is to be performed on the data warehouse
Data - Information - Knowledge
Business Intelligence
The concept of Business Intelligence has existed since the 1960's more popularly known as Decision Support Systems (DSS) back then. Intelligence has a large impact on efficiency and effectiveness of the organization and Support to facilitate the application of intelligence agencies and companies such as online analytical processing, data mining, Business analysis, implementation of enterprise networks and enterprise knowledge management applications and other activities in the organization
a)Enables continuous data integration
b)Stored and retrieves historical data
c)Complex queries can be performed
d)Better business performance
e)Comprehensive data analysis
Supports platform-independent Web services, business applications, and standards-based development, enabling you to leverage existing technology assets for Web-services-oriented solutions
SAP NetWeaver Benefits
* Consolidate apps, servers, and /or hardware
* Unify different data sources into one consistent
* Help users work more effectively and efficiently
* Better transparency of company information
* Organizations can deploy a consolidated
technology platform based on a service-
* Define which users have access to which apps

SAP BW Schema
SID Benefits
SAP BW arhitecture
Classic star schema vs SAP BW
star schema

Administration Workbench
Data warehouse should be
How infoObjects are used in SAP BW
Classifying InfoObjects
* Key figures
* Characteristics
* Time Characteristics
* Units
*Technical Characteristics
InfoObjects Maintenace Menu
Business Explorer
Master data/Texts
General Tab Page
Business Explorer Tab Page
Master data/Texts Tab Page
Attributes Tab Page
Detail/Navigation Attribute
Attributes Tab Page
Hierarchy Tab Page
External Hierarchies
Version Dependent Hierarchy
Time dependant entire hierarchy
Time dependent hierarchy structure
Hierarchy Intervals
Version Dependent Hierarchy
External Hierarchies
Time dependant entire hierarchy
External Hierarchies
Time dependent hierarchy structure
External Hierarchies
Key Figures Maintenance Screen
Key Figures Maintenance Screen
Line Item Dimension
Line Item Dimension
Technical Information
Views of Master data table
Master data table/Time independent att
Master data table/Time dependent att
SID tables time independent att
SID table time dependent tables
Text tables
Hierarchy SID tables
Hierarchy tables
Changes to characteristics infoObjects
Operational Datastore objects
Operational Datastore objects
Types of DSO
Standard DSO
Transactional DSO
Comparison between
Architecture of DSO
Definition of DSO
Request Deletion
Virtual Cubes
and Multi-providers
Virtual cubes types
SAP Remote Cubes
General Remote Cubes
Virtual InfoCubes
Combinations possible:
Combinations possible:
Multiprovider Example
Multiprovider Query
BI Content
BI Content includes:

SAP andNon SAP Extractors
DataSources (Extract Structures)
Templates (Web-based reporting)
BI Content
object version
Technical BI Contents
1- BW Statistics
2- BW Data Slice
up-to-date data
access a small amount of data from time to time
few users execute queries simultaneously on the database.
SAP RemoteCube
InfoSets allow you to report on several InfoProviders by using combinations of master data-bearing characteristics and ODS objects.

The information is collected from the tables of the relevant InfoProviders. When an InfoSet is made up of several characteristics, you are able to map transitive attributes and report on this master data.
Data Acquisition layer
Connecting an ETL tool to SAP BW
1)In the administration Workbench, in the Modeling Source systems area, create a new source system. Choose a source system type (External system) – Data and Meta data transfer using Staging BAPIs.
2)Maintain the logical system name
3)Maintain the RFC (Remote Function Call) connection to the ETL tools
4)Assign a new source system to your info source
5)Maintain the transfer structure, communication structure and transfer rule
6)Import the info source definition in the ETL tool
7)Define an extraction job in the ETL tool
8)Create infopackage in SAP BW. When doing so, check the 3rd party selections tab page.
9)Schedule the infopackage
DB Connect
XML File
File system
Types of data update with PSA
Managing InfoCubes
Request Status
Full transcript