We have worked hard to compete with us every day to continually improve our method and skills. A time-honored process and experience in working with some leading brands in the world helps us to provide quality and customer-focused solutions.
SAP BW Overview & Concepts • Overview of SAP R/3 • Necessity of SAP BW & Version of BW • OLAP & OLTP • Data Ware Housing Concepts • Landscape of SAP BW • Integration of BW system with different systems • ERM, MDM, Star Schema & Extended Star Schema. Objects in SAP BW • Info Area, Info Object Catalogs • Characteristics • Key Figures-Cumulative & Non Cumulative • PSA- Transfer Structure/Data sources • Transfer Rules • Info Source/Communication Structure • ODS- Info Cubes • Types of Info Cubes- Update Rules Data Loading Using Flat Files • Master Data – Attributes, Texts, Hierarchies • Transaction data-Delta data loading Data Filtration Techniques • Transfer Rules level • Update Rules level • Start Routines PSA-Maintenance scheduling the data • Data Packet by Packet • Complete scheduling • Scheduling in background • Transfer Rules & Update Rules • PSA-Processing Types • Monitoring & scheduling data loading • Scheduling the jobs on periodic values • Cancellation & Deleting the back ground jobs
SAP-BI 7 Bi Concepts & Overview Modeling: Data warehousing workbench • Components of data warehousing workbench • InfoObjects, data source, • Types of DSO's , Data Source Repository • Migration of 3.X data sources & Recovery of 3.X Data sources • Difference between ODS & DSO • Data Loading – Master Data & Transactional Data. • Concepts of Transformation & Its Types • Controlling the data-flow with Infopackages (IP)& Data Transfer Process (DTP) • Data Loading into DSO & InfoCubes • Standard –Direct DSO –Write Optimized DSO.
Extraction • Flat file & LO Extraction • Generic Extraction & Generic Delta • Co-PA • Business Content Extraction • Data Enhancements- Tables, View, Query Process Chain • Types of Process Chains • Process Groups & Meta Chain, etc… Transport Mechanism • Review of system Landscape • Collecting Objects • Creating Transports • Releasing Transport • Importing Transport • Monitoring Transport
BI 7.0 Reporting BEx Query Designer • Introduction of BEx Query • Filters, Columns & Rows • Characteristic Restrictions & Free Characteristics • Formulas & Calculated Key Figures • Restricted Keyfigures & Variables with Texts. Business Explorer Analyzer • Introduction to BEx Analyzer • Filtering Option • Properties Available in Analyzer
Course Fee: Not Mentioned
Course Duration: Not Mentioned
Placement Provided: No
No Comments Posted