SAP BUSINESS WAREHOUSING AND REPORTING

UWIN Pro Business and Technology Solutions
Scarborough, Onatrio, Canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' To analyze data from diverse sources to support decision making. You will learn to use star schema to overcome poor system performance due to a large volume of data handling. Also, overcoming difficulties in extracting, transferring, transforming, and loading data (ETTL) from diverse sources into a data warehouse. You would feel the pain if you had ever tried to analyze SAP R/3 data without using SAP BW.

Participants should have minimum 1 year business experience and fair knowledge of reporting and MS Excel.

As per the training manual provided

Introduction to ERP and SAP

Introduction to SAP.
Overview of ERP and SAP - SAP Terminology
Introducing frequently used SAP terminology.
Logging in to a SAP system
SAP logon process for Windows
Basic SAP Navigation - the basic SAP screen components, moving between menus, T-code searches and other commonly used functions.
End User Customization - customizing some SAP screens. Using T-codes �View user information, logged in users, user creation, sending messages, technical and functional modules.
Various SAP functional modules, log off from SAP system - SAP logoff process for Windows, SAP services, co-operative business scenarios, mySAP.com
Enterprise Structure
Modeling

Extended Star Schema vs. Classic Star Schema. Data Flow in BW: DataSource, InfoSource, Transfer Rules, Update Rules. InfoSource Types, Creating and Maintaining InfoSources.
Update Rules: Creating Update Rules for Data Targets and the Options available.
InfoObject Catalogue, Creating InfoObjects, Characteristics and KeyFigures. Master Data: Texts, Attributes and Hierarchies. Use and maintenance of Master Data.
InfoCube: Star Schema, Dimensions, Creating and Maintaining InfoCubes.
Data Targets: InfoObject, Basic InfoCube, ODS Object
InfoProviders: MultiProviders, Virtual InfoCubes, InfoSet

Extraction

Source System: Connection with BW, Creating Source Systems (SAP, Extern al, Flat File)
Extraction from SAP Source Systems: Standard, Customized, and Generic Extractors
Extraction from R/3: Extract Structure, Transfer Structure, Delta Process
Customizing: Enhancing Business Content, Maintaining Generic DataSources
User Exits: Transaction Data, Master Data, Texts and Hierarchies

Warehousing Management

Transports: Transport Connection, BEx Objects and Roles, Versions of Objects
Business Content: Installing and Collecting Objects, BW Statistics
BI Suite: BEX Explorer

BEx Query Designer

Queries: New queries, Restricting Characteristics, Hierarchies, Formulas and Exception Cells.
Query Design: Defining Exceptions, Conditions, Restricted and Calculated KeyFigures.
Variables: The Variable Wizard, Variable Types and Processing Types, Query Properties.
Component Properties: Properties of Characteristics, Attributes, Structure, Formula, KeyFigures
Structures: Creating Re-usable structures
Functions on BW Server: Copying queries between Cubes, Deleting Query Elements

Web Application Designer

WAD: Functions of WAD, Web Items Window, Template Window, Properties Window
Web Applications: Creating Web Applications, Settings, Stylesheets, Symbols and Properties
Design: Designing the Layout of Web Templates, working with Library for Web Items
Web Items: Tables, Filters, Checkboxes, Dropdown Box and other web items and their attributes

BEx Analyzer

Functions of BEx Toolbar: Open, Save, Change and Refresh Queries
Evaluating Query Data: Navigating queries, Selecting Filter values, saving query variants
Workbooks: Cell Areas, Workbook Templates, Display options and more.
BI Platform
Information Broadcasting
Functions of the Broadcaster: Precalculating and Exporting into Enterprise Portal
User Guide: Distributing Queries and Web Templates, Scheduling Broadcasting Settings
Example Scenarios: Monthly Sales Reports, Ad-hoc Distribution Options.

OLAP

OLAP vs OLTP: The OLAP Concept and differences between OLAP and OLTP
OLAP Functions: Aggregation, Hierarchies, Currency Translation, Report -to-Report Interface
MetaData Repository: Searching for MetaData and exporting as XML Files

Reporting Agent

Exception Settings: Creating a setting and defining a follow up action
Print Settings: Defining Print Settings and Print Layout
Scheduling Packages: Creating Package, signing Settings, Variants, with Process Chains
Advanced Topics

Performance

Data Model for Performance: Line Item Dimensions, Navigational attributes, Time - Dependent
BW Statistics: Query Analysis Tools, Performance Tables.
Reporting Performance: Effective query design, Line-Item, Compression, and Partitioning.
Aggregates: Creating Aggregates, Finding effective aggregates.
Data Load Performance: Parallelism, Impact of Aggregates.
Partitioning: Logical Partitioning, Table Partitioning.

...''

Phone:(647) 436-8579

School Address:

705 Progress Avenue, Unit 105
Scarborough, Onatrio
M1H 2X1 Canada



Jobs & Resumes: Scarborough
Houses & Roommates: Scarborough

Search other schools for SAP BUSINESS WAREHOUSING AND REPORTING training resources.

Unix Engineer
CISCO Certified Network Professional
CompTIA Linux+
SAP Basis Administration 1 & 2
Sun Certified System Administrator for Solaris 10 OS
Veritas Volume Manager Operations
ERP with SAP
Veritas Cluster Server for Solaris
SAP Security Administration
Software QA Testing
CompTIA A+
keyboarding, computers, Operating Systems and Networks
Networking Technologies and Cisco®

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.