Sap Bi Bw Bo Syllabus 3r1g3a

WEBDYNPRO SYLLABUS ± THINGS IN RED ARE NEEDS TO BE LEARNT.

 Introduction  Introduction to Web & Net weaver Technologies  Introduction to WebDynPro for ABAP  WebDynPro Architecture  WebDynPro components  View  Window  Controller-Context  Event-Action  Interfaces of WebDynPro ±components  WebDynPro Application  WebDynPro model  WebDynPro: Development in detail  WebDynPro vie  UI Elements of the view  Structure of the view Context  Data Binding  UI Element Actions  Parameter Mapping  Action Event Handlers  Component Controller  Context mapping  Programming controller methods  Methods of the local controller interface  Events & event Handlers  Cross Controller method call  WebDynPro Runtime APIS  Filling the context  Phase model  WebDynPro window  Navigation between two views  WebDynPro application  URL of a WebDynPro application  Full Qualified domain names (FQDN)  URLs and Namespaces  Calling a WebDynPro Application using Parameters  Cross component Programming  Controller of a WebDynPro Component

 Component Usages  Component Usages without controller Access  Navigation through window Plugs  Cross-Component Context mapping  External Context Mapping  Creating a WebDynPro component interface definition  Implementing a WebDynPro interface definition  Dynamic Programming  Dynamic layout manipulation  Dynamic context manipulation  Dynamically creating component usages  Advanced concepts  Working with the assistance Class  Service call in a WebDynPro application  Creating a service call  Messages  Modification-free Enhancements  Debugging WebDynPro ABAP applications  Version comparisons in WebDynPro for  ABAP  File export  Working with dialog boxes  Input help  Configuration of an included ALV component  Portal integration  Binding to portal : prerequisites  Integrating an application to portal  Integrating a PDF form in a WebDynPro  application  Inserting forms  Inserting existing Forms  ed Elements of the Adobe Library  Interactive form use  Forms with function module-Based  interface  SAP list viewer in WebDynPro for ABAP  Integration of ALV in your Application  Managing ALV output area  Methods and events of the interface Controller  DATA_CHECK  GET_CONFIG_DATA  GET_MODEL  GET_MODEL_EXTENDED  SET_DATA  ON_AFTER_CONFIG  ON_CLICK

 ON_DATA_CHECK  ON_FUNCTION_ON_LEAD_SELECT  ON_STD)FUNCTION_AFTE

ON_STD_FUNCTION_BEFO  WebDynPro Trace Tool  ICM Tracing  Http browser tracing  Http Proxy  WebDynPro Tools in the ABAP  workbench Component Editor  Controller Editor  View Editor  Window Editor  Display an interface view  Displaying and defining the interface  Controller WebDynPro application  The WebDynPro code Wizard

INDEX IT SYLLABUS

BW-BI-BO Introduction to data warehouse concept • • • • • • • • • • BW

Data warehouse definition, concept and methodologies ERP Systems and SAP OLTP System Architecture, Data Details and Uses Drabacks in OLTP/ERP Systems OLAP System Architecture, Data Details and Uses ER Modeling, Dimensional modeling Advantages of Dimension modeling OLAP systems Star Schema, Extended Star Schema Integrated Star Schema Data Marts and Warehouse Schema

Introduction to BW System • Difference between BW and BI system • Sourse systems Info sourse • Transfer Structure • Communication Structure • Update Rules • Direct Data loading in Master Data • Master data Attributes • Master data Text • Master data Hierarchies BI SAP BI Introduction • ETL (Extracting, Transforming, Loading) • Data Storage and Data Flow in BI • Enterprise Data warehouse Layer • Archtecture and data mart layer Modelling • Data Acquisition • Sourse System • Data Extraction from SAP System • Discussion of other data transfer using WEB Services/UD Connect/DB Connect Persisting Staging Area • Data Sourse • Need of PSA • Info Package • DB Memory Parameters • Deleting request from PSA Enterprise Data Warehouse Layer • Creating Info area • Creating Info Object • Creat Characteristics with Master Data • Info provider theory • Types of Components in Info provider • Creating Info Cubes • Info Cube Types (Standard/Real time/Virtual) • Creating Data Sourse Object (DSO) • Standard DSO • Write optimized DSO • Direct Update DSO • Loading the Data from standard DSO into target info cube using data marts

• Real time Loading procedure using DSO Concept • Transformation • Rule Type • Rule Group • Aggregation Type • Creating Transformation • Copying Transformation • Error Analysis in Transformation • Routines in Transformation • Start Routine • End routine • Field Routines • Expert routines • Info Source • Migration of Update Rules, 3.X Info sources and Transfer Rules • Old Transformation Concept Business Content • Introduction to Business Content • Activation of Business Content • Simulation of Business Content Architected Data Mart Layer • Creating Info Cubes • Creating Info Sets • Creating Multi prividers Exchanging Data between BI Systems • Using Data Mart Interface • Generating Export Data Source • Data Transfer Using Data Mart Layer Exchanging Data from BI Sys to External Systems • Creating open Hub Destination • Database tables and Destination • Files as Destination APD (Analysis Process Designer) • Loading the data into Direct Update DSO • File to File Data loading • Loading the data from DSO into Files • Loading the data from info cube into target files • s concept in APD • Filers concept in APD • Applying formulas in APD Extractions • Generic Data Extractions

• Table Extraction • View Extraction • Info set Extraction • Function Module extraction • BI concept • LO Extraction • LO Cockpit • FI-SL Extraction • COPA Extraction Remodeling • Info cube remodeling • Remodeling partitions Process Chains • Single Level Process Chain • Multilevel Process Chain • Process Chain Creation • Process Chain Monitoring • General Tips for Loading the Data • Performance Tips for Master Data • Performance Tips for Info cubes • Performance Tips for Data Process • Performance Tuning for Info Provider Integrated Planning • Need of real time info Cube • Understanding the concept of real time load behavior • Planning aggregates • Planning Filters • Planning functions • Planning sequences Bex Query Designer and Analyzer • Creating queries • Variables Types • Calculated Key figures • Restricted Key figures • Filters, Structures • Conditions, Exceptions, Cell definition • Analyzing Bex Report • Workbook Creation • Table/ Chart Creation ABAP for BI • Basic ABAP

• •

ABAP Dictionary ABAP String functions * SHIFT * SPLIT * SEARCH * STRLEN * CONCATENATE * CONDENSE * OVERLAY * TRANSLATE * REPLACE * OFFSET CONCEPT • ABAP Internal tables • Manipulating the data in internal tables Enhancements • CMOD TCOD • Function module exits • Data source enhancements • Bex variables enhancements BO Business Object XI Architecture • DB Layer • Interface Layer • Server layer • Presentation layer • Security Domain • Universe Domain • Document Domain • CMC • s, Groups, folder Creation and Authentication • Setting preferences • Access Control • Voyager Connection • Scheduling Business Object XI Architecture for SAP BW and BI • BW architecture for BO • BI architecture for BO • BW and BI Sources for BO Reporting • Universe Architecture for BW and BI • Crystal reports architecture for BW and BI Central Management console • CMC Operations for BO • CMC Management • Starting and Stopping services • CMS and CMC operations Business Object Info View

• Info view introduction, Folders and Categories • Info View objects • Info view preferences Universe Designer • Universe Parameters • Insert Tables • Insert s • Inner s • Left outer • Right outer • Self restricted s • Theta s • Shortcut s • Detect loops • Resolving loops • Delete unnecessary s • Create alias tables • Creat context • Shortcut s • Creating classes and sub classes • Creating Objects • Dimension objects • Detail Objects • Measure Objects • Creating hierarchies • Default Hierarchies • Custom Hierarchies • Working with list of values • Formatting cell options • Using Query • Integrity Check • Setting Access Restrictions • ing and exporting universe Crystal reports 2008 • Introduction to crystal reports • B-B, B-C, C-B, C-C • Standard reports • Blank reports and Templates • Crosstab reports • OLAP Cube report wizard • Using SAP Connections

• • • • • • • • • • • • • • • • • • • • • • • • • •

Local Cube Files Mailing label wizard Crystal reports integrations using BW System Using Business Explorer from crystal reports Source Universe ADO ODBC Oracle Server SQL Server SAP BW SAP Bex Queries Group expert Sort expert Database expert Field Explorer Selection expert Section expert Running totals Formula fields SQL Expression fields Parameter fields Group field names Special fields Insert images, lines, boxes,pictures,charts Query Based reports

SAP BO Features • • • • • • • • • •

Creating Universe from SAP System BW Publisher Integrations Auto generated dimension and Fact Tables as Classes Creating Hierarchies Exporting Universe Dashboards using info view Xcelsius reports using source excel Condition based formatting options in Xcelsius reports Creating Crystal reports using source info cubes Creating Bex Queries using info cubes

Query As A Web Services (QAAWS)

• • •

Using Query as web service Configuring QAAWS Viewing Universe and WEBI reports using web service

Live Office • • •

Introduction Integrating BO services from MS office Extracting the data in Xcelsius using Live office.

Xcelsius • • • • • •

Introducing crystal Xcelsius with SAP Implementation Creating crystal Xcelsius dashboard from sap data stored from excel spread sheet Source crystal reports or WEBI reports Using Live office in Xcelsius Using web scrvices in Xcelsius Creating analytic dashboard from SAP data through universe

Web Intelligence Rich Client • • • • • • • • • • • • • • • • • • •

Introduction web reporting Report Creating Simple reporting Query based reporting Query filters Report filters Insert/Remove Breaks Creating sections Formatting options Complex reports Applying filterts on Measures Table Templates Horizontal, Vertical table, Crosstab, Form tab Charts Bar charts, line charts, Column charts, column line charts, pie charts, radar charts Alerts Ranking Filter Formula toolbal

• • • • •

Variables Edit query options Sort and Custom sort options Track and purge options Export options in WEBI

SAP BO Voyager • Getting started with Business Objects Voyager, using Queries to analyze cube data • Highlighting Exceptions in source data of BW and BI • Member selector with SAP data using variables SAP BO Widgets • • • • • •

using BI widgets to access BI services Logging into BI widgets Locating BI widgets explorer Using BI widgets with Xcelsius documents Importing Xcelsius documents as widgets Selecting and opening WEBI report

SAP BO Dashboard Builder • • • • • •

Getting started with Dashboard Builder Creating corporate dashboards Creating personal dashboards Analyzing dashboard contents Setting dashboard preferences Customizing dashboards

VISU IT SYLLABUS SAP-BI Modeling

• • • •

Overview of SAP BI What is an application? Types of Application: 1.OLAP,OLTP NETWEAVER Database designs 1. Basics of database 2. Database design in OLTP System- ER Model 3. Database design in OLAP System a. Star Schema b. Extended Star Schema

• • • •

• •

•

• • • •

SAP BI Architecture Info Objects Info Cubes Types: 1. Standard 2. Real Time 3. Remote Data Store Object (DSO) Types: 1. Standard DSO 2. Direct DSO 3. Write Optimized DSO DTP: 1. 2. 3. 4.

Standard Error RDA DTP Direct DTP

Transformations Data Source Info Package Business Content

Advanced Modeling • • • • • •

Multiprovider Info Set Open Hub Destination Re-modeling Query performance Load performance

• •

Types of Attributes Business Content

Process Chains • • •

process Types Monitoring Process Chains Scheduling Process Chains in Back ground

Eeporting • • • • • • • • • • • • • •

Query Designer Filters Restrictions Row and columns Free Characteristic Formulas Variables Exceptions Conditions Calculated Key Figures Restricted Key Figures Query Properties Report to Report Interface Variables and Process Types

Extraction • • •

• • • •

Overview of Data Dictionary Objects Extraction from R/3 to BW Generic Extraction 1. Table 2. View 3. Infoset 4. Function Module LO Extraction Other Business Content Extractions Data Source Enhancement Generic Delta