Course Timings: 8:00am to 3:00pm (Saturdays with 1 hour lunch break)
Number of weekends: 7
Hours: 42
DAY 1:
Introduction to SAP and ECC
Introduction to SAP BI
Modeling
Extended Star Schema vs. Classic Star Schema concept
Data Flow in BW: DataSource, Transformation,InfoPackage and Update Rules
InfoObjects: InfoObject Catalogue, Creating InfoObjects, Characteristics and KeyFigures
Master Data: Texts, Attributes and Hierarchies. Use and maintenance of Master Data
Cube: Star Schema, Dimensions, Creating and Maintaining InfoCubes
InfoProviders: MultiProviders, Virtual Cubes and InfoSet
FAQs
Test
Assignment
DAY 2:
Extraction Flat File
Source System: Connection with BI, Creating Source Systems (SAP, External, Flat File)
Extraction from R/3: Extract Structure, Transfer Structure, Delta Process
Extracting Master Data and Transaction Data
FAQs
Test
Assignment
DAY 3:
Extraction - LO-Cockpit
Extraction from SAP Source Systems: Standard, Customized, and Generic Extractors
Customizing: Enhancing Business Content, System Defined DataSources and LO Cockpit extractors
Extracting Master Data and Transaction Data
FAQs
Test
Assignment
DAY 4:
Extraction
Customizing: User Defined Extractor, and CO-PA extractors
FAQs
Test
Assignment
DAY 5:
Warehousing Management
Concepts of Transports: Transport Connection, BEx Objects and Roles, Versions of Objects
Business Content: Installing and Collecting Objects, BW Statistics
FAQs
Test
Assignment
DAY 6:
BI Suite: Business Explorer
BEx Query Designer
Queries: New queries, Restricting Characteristics, 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.
FAQs
Test
Assignment
Day 7:
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 v OLTP: The OLAP Concept and differences between OLAP and OLTP
OLAP Functions: Aggregation, Currency Translation, Report-to-Report Interface
MetaData Repository: Searching for MetaData
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, Assigning Settings, Variants, with Process Chains
FAQs
Test
Assignment
^ back to top | close window