Alberg Software Inc. has trained over 100 SAP-consultants in the standard R/3-Modules, as well as in new solutions like CRM or BW. The courses can take several days up to several months depending on the pre knowledge of the participants. Especially for employed consultants in industrial enterprises, the brushing up on knowledge and the verification by a SAP certificate is to be recommend.
We are Globally recognised and hire extensively and highly qualified Professionals with real time experience to serve clients like Students,IT Professionals/Corporates round the globe who wish to upgrade/acquire newskills in their respective fields of interest. We Provide training on all the high end courses and especially on CRM – SAP & Siebel/ Datawarehousing / Microsoft and Sun technologies.
SAP BW (Business Ware Housing)
Data Modeling :
 |
Extended Star Schema vs. Classic Star Schema concept |
|
Data Flow in BW: Data Source, Info Source, Transfer Rules, Update Rules |
|
Info Source: Info Source Types, Creating and Maintaining Info Sources |
|
Update Rules: Creating Update Rules for Data Targets and the Options available |
|
Info Objects: Info Object Catalogue, Creating Info Objects, Characteristics and Key Figures |
|
Master Data: Texts, Attributes and Hierarchies. Use and maintenance of Master Data |
|
Cube: Star Schema, Dimensions, Creating and Maintaining Info Cubes |
|
Data Targets: Info Object, Basic Info Cube, ODS Object |
|
Info Providers: MultiProviders, Virtual Cubes Info Set |
Data Extraction :
|
Source System: Connection with BW, Creating Source Systems (SAP, External, Flat File) |
|
Extraction from SAP Source Systems: Standard, Customized, and Generic Extractors |
|
Extraction from R/3: Extract Structure, Transfer Structure, Delta Process |
|
Customizing: Enhancing Business Content |
|
User Exits: Transaction Data, Master Data, Texts and Hierarchies |
Reporting :
BEx Query Designer :
|
Queries: New queries, Restricting Characteristics, Formulas and Exception Cells |
|
Query Design: Defining Exceptions, Conditions, Restricted and Calculated Key Figures |
|
Variables: The Variable Wizard, Variable Types and Processing Types, query Properties |
|
Component Properties: Properties of Characteristics, Attributes, Structure, Formula, Key Figures |
|
Structures: Creating Re-usable structures |
Web Application Designer :
|
WAD: Functions of WAD, Web Items Window, Template Window, Properties Window |
|
Web Applications: Creating Web Applications, Settings, Style sheets, 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. |
Warehouse Management :
|
Transports: Transport Connection, BEx Objects and Roles, Versions of Objects |
|
Business Content: Installing and Collecting Objects, BW Statistics |
Performance :
|
Data Model for Performance: Line Item Dimensions, Navigational attributes, Time-Dependent |
|
BW Statistics: Query Analysis Tools, Performance Tables |
|
Reporting Performance: Effective query design, Line-Item, Compression, Partitioning |
|
Aggregates: Creating Aggregates, Finding effective aggregates |
|
Data Load Performance: Parallelism, Impact of Aggregates |
|
Partitioning: Logical Partitioning, Table Partitioning |
Authorizations :
|
Introduction to the SAP BI authorization concept |
|
Common features and differences in the SAP R/3 and SAP BI security requirements |
|
Common features and differences in the SAP R/3 and SAP BI security requirements |
|
