sskr reddy | SAP-BI (7.0) online training With Material Introduction General Introduction. SAP introduction. Data warehousing/ BW/ BI Introduction Data Modeling OLAP v OLTP ERM, MDM, Star schema, extended star schema Data warehouse workbench functions: Characteristics, Key Figures, Data Sources for File Source Systems, Info Package, PSA, Transformations, data transfer processes InfoCubes: Standards, real time, Virtual Providers Data Store objects (DSO): Standards, direct update, write optimized Infocube VS DSO Master data- texts, Attributes, Hierchies. Remodeling Infosets Multiprovider Open hub destination Process chains Metadata and Document Management BI Content: Definitions, How to install BI contents Defining extraction For SAP source systems: Creating Generic dataSource and maintaining SAP delivered dataSource. Or for files: Creating DataSources for File Source Systems
User management: Authorizations Transports: Real business scenarios on different system environments, Moving objects from one system to another.
Data Extraction: Business flow: SD, MM, PP, FI. BW overview –R/3 extraction Generic data extraction Data Extraction from LIS Data Extraction from LO cockpit Data Extraction from CO-PA Data Extraction from FI Delta Management
BEx Query Designer
Introduction to BW-Bex reporting (Bex analyzer, query designer, report designer, web application designer) Reporting features & properties Rows, columns, Free Characteristics, Filters, Exceptions, Conditions, Calculated and Restricted Key Figures, structures. Cell Definition New selection, new formula. Column&row properties. Query properties
Report-to-Report Interface Variables: (5 types) Characteristic value variables, Hierarchy Variables, Hierarchy node variables, Text variables, Formula variables Query designer Information broadcasting Design mode (web items) Web application designer Performance Line item dimension High cardinality Aggregates Partition Compression Indexes Olapcashe
ABAP (related to BI) Data source enhancements Start routine End routine Characteristics routine
Overview: Differences between 3.5 and 7.0 version. Upgradation from BW 3.5 to BI 7.0 Project: ASAP methodology Functional specifications Technical Specifications Responsibilities of BI consultant (implementation & support project) Unit testing |