SAP BW 7.4

SAP BW is a Data Warehouse tool. In simple terms, it integrates data from different sources, transforms and consolidates, cleanse and stores data as well. It also includes data modeling, administration and staging area. The content-rich SAP BW sets a precedent for speed and ease of implementation and maintenance because it's pre-configured with intelligence about a company's business process, providing a faster return on information. SAP BW remains open to the different source system, and it will also come as a pleasant surprise for its ease of introduction and maintenance. The demand from end user companies needing expertise in the integration of ERP data into corporate data warehouses is growing exponentially. Thus resulting in great opportunities for certified SAP BW professionals in defining their career path.

This comprehensive course is meant for professionals who aspire to build a career or upgrade knowledge in SAP BW on HANA. This course is best suited for the following professionals:

• Business Intelligence and Data Warehousing professionals
• SAP Technical & OLAP Consultant
• Software Analysts and Mainframe professionals
• Project Managers and Business Objects Professionals
• Those aspiring for a career in SAP BI/BW

Internationally Accepted Certificate

Duration of Course:

• 40+ hours

Topics Covered are:

• SAP BW 7.4 COURSE CONTENT

Introduction:

• BI Introduction (SAP/OLTP vs OLAP/Types of Data/Architecture).

DATA MODELING:

• Info Objects: Definitions.
• Types: Characteristics, Key Figures (cumulative/Non-Cum), Time, and Unit.
• Data sources/Application component/Info area/Info objects Catalogue etc.).
• PSA-Maintenance scheduling the data.
• Data Packet by Packet.
• Scheduling in background.
• PSA-Processing Types
• Monitoring & scheduling data loading
• Scheduling the jobs on periodic values
• Cancellation & Deleting the back ground jobs.
• Transformation.
• Info package.
• DTP (Data transfer process)
• Types: Standard/Direct access/Error/RDA.
• INFO PROVIDERS: SAP BI 7.0
• Info object.
• Data Store Objects (DSO) Types: Standards, Write optimized, Direct update.
• Indexes
• Info sources.
• Info Cubes: Definitions
• TYPES: STANDARD/REAL TIME/VIRTUAL INFO CUBE.

DESIGN OF INFO CUBE: EXTENDED STAR SCHEMA:

• Precautions to designing info cube.
• Line Item Dimensions.
• Selective deletion.
• Transformation Rule Types.

TYPES OF ATTRIBUTES (DISPLAY/NAVIGATIONAL/COMPOUND/TIME DEPENDENT ETC.):

• Info Set.
• Multi Providers and selections.
• APD (Advanced Planning Optimizer).
• OPEN HUB DESTINATION/INFO SPOKE.

DATA FLOW/WHERE USED LIST:

• Remodeling/Re-Partitioning.
• SAP BI Content (Installation standard BI Objects).
• Meta data repository.

INFO PROVIDERS: SAP BW 7.4:

• Semantically partitioned DSO
• Semantically partitioned Info Cube
• Hybrid Provider based on a Data Store object.
• Hybrid Provider Based on Virtual info provider.
• Composite Provider.

BUSINESS EXPLORER:

• Bex Query Designer
• Rows, Columns, Free characteristics.
• Properties (Char/Key fig/Query).
• Filter - New Selection
• New Formula
• Restricted key figure
• Calculated Key figure
• Exceptions and conditions.
• Attributes.
• Structures
• Cells
• All Types of Variables
• Offset Variables.
• Variable Processing Types
• Report to Report Interface(RRI)
• Bex Analyzer.
• RSRT T-code.

EXTRACTION (MASTER AND TRANSACTION DATA):

• Flat File.

ECC:

• Generic Extraction.
• LO Extraction.
• FI Extraction.
• Repair full request.

SUPPORT ACTIVITIES:

• Process chained Processing types.
• Types of Process chains.
• Monitoring/scheduling of PC.
• How to handle Errors by PC.

LOADING/PERFORMANCE OPTIMIZATION:

• Aggregates.
• Partitions, Compression, Line Item Dimensions.
• Rollup, Dimensional Design Analysis, Indexes.
• Transport Request Management (Creation/Collection/Release/Unlock).
• SAP BI+ABAP
• Routines (Start/Field/End/Expert Routine).
• Customer exits.
• Data source Enhancements.
• Function module based Generic Data source.

Knowasap provides best online self learning SAP courses and high end technologies courses that maximizes learning outcomes and career opportunity for professionals and as well as students. Experienced consultants, project team members, support professionals, end users, executives and students will find courses to meet their needs that are accessible anytime, anywhere.