Description
Modelling
- SAP Applications Basics.
- ERP Topic Basics
- ERP Modules.
- Data Warehouse solution.
- Difference between BW 3.5 and BI7.0
- ASAP Methodology.
- Client Architecture.
- Modeling steps: Star schema &extended star schema Info objects and properties, characteristics, key figure, time And units.
- Administration Workbench Functions: Info Area, InfoObjects, Info package, Transforamtion, DTP. Scheduler, Data monitoring Transport connection. Metadata repository.
- OLTP/OLAP Functions.
- External Data Extraction.
- Creation of Info cube,
- Virtual Infocube or dtp for direct acess and remote cube.
- Creation of DSO,
- Creation of Write optimized DSO,
- Creation of Multiprovider,
- Creation of Infoset,Info providers
- Creation of application component.
- Creation of Datasource for Transaction data and masterdata
- Creation of Hierarchie data source and loding.
- Difference between csv infopackage and r3 infopackage.Creation of Infopackage and scheduling.
- Creation of Transformations.Creation of source system for flat file.
- Creation of source system for r/3 system.
- Business content – Installation options, grouping options
Data Extraction
- BW Overview – R/3 Extraction.
- Types of Extractions.
- Tables and view and Function module creation and usage.
- Creation of data extraction from LO Cockpit(Only Direct delta)
- Applications in Lo Cockpit 11, 12. (R/3).
- Discussion about all data sources like purchasing, inventory, sales, billing, and delivery.
- Set up table and deletion.
- Delta and Full load.
- Generic data extraction from Tables and View.
- Flat file data extraction from NON-SAP CSV FILES.
Reporting
- BEX ANALYZER
- QUERIES
- ROW PROPERTIES
- COLUMN PROPERTIES
- QUERIE PROPERTIES
- RESTRICTION
- NAVIGATION BLOCK
- CONDITIONS
- RESTRICTED KEY FIGURES
- NEW SELECTION
- EXCEPTIONS
- CALCULATED KEY FIGURES
- STRUCTURE & CELL DEFINITIONS
- DEFINE CELLS
- TABLE DISPLAY
- VARIABLES
- CHARACTERISTICS VARIABLE
- WORK BOOKS.
- WAD.
- WEB TEMPLATES.
- BEX REPORTING.
- 3.X and 7.x BEX REPORTING.
- 3.X and 7.x WAD REPORTING.
- 3.X and 7.x WEBTEMPLATE.
- DIFF B/W 3.X QUERY AND 7.X QUERY.
Reviews
There are no reviews yet.