SAP BW

COURSE DETAILS & CURRICULUM

Basic Theory Topics

1. What is ERP?
2. What is SAP?
3. Different Modules of SAP
4. Master Data, Text Data, Transaction Data, Hierarchy Data
5. Star Schema 6. Extended Star Schema
7. Introduction to BI, it’s importance in SAP Netweaver Architecture 7.0
8. BI 7.0 and BW 3.5 Differences

Modeling

9. RSA1 BW Administration Work Bench
10. Types of Info Object
11. Data Flow in BW, BI
12. Creation of Info Object
13. Loading Master Data using Flat file and ECC SAP BI 7.0 Topics /101ERP
14. Loading Text Data using Flat file and ECC
15. Info cube Creation
16. Loading cube from Flat file
17. Transformations
18. Transfer Rules, Update Rules.
19. ODS Creation
20. Loading ODS from Flat file
21. Types of ODS / DSO
22. Info set 23. Multi-Provider
24. Data Target and Info Provider

Extraction

25. Types of Extraction
26. Cross Application using Table, View, Functional Module, Infoset
27. Application Specific – Logistics (using Business content extractors)
28. Application Specific – COPA (using Customized extractors)
29. Application Specific – Logist

Reporting

31. Reporting in BI : BEx
32. OLAP’s functions in reporting
33. Row Properties
34. Column Properties
35. Formula, Selection
36. Restricted Key Figure, Calculated Key figure
37. Variables
38. Types of Attributes
39. Work Books
40. Restrictions
41. Structures

Others

42. Performance Tuning
43. Compression
44. Aggregates
45. Indexing
46. Line Item Dimension
47. Cardinality
48. Process Chain, Meta Chain
49. System Landscap