BW

Standard Functions : Click HERE
TCodes                    : Click HERE
Tables                      : Click HERE


Performance Tuning in BW :  Click HERE

BW Administration              : Click HERE

3.X Flow related                    : Click HERE

Process Chains : Click HERE

BW TOPICS

1. Data Modeling
• Schemas
• Star Schema ; Extended Star Schema ; Master Data Tables
2. DataStore Objects
• Write Optimized DSO ;Standard DSO ; Direct Update DSO ; DSO Issues
3. InfoCubes
• Designing an Infocube ; Line Dimension; High Cardinality; Number Range Buffering; InfoCube Administration; Indexes; DB Statistics; Aggregates; Roll Up; Change Run; Collapse/Compression ; Reconstruction; Partitioning; Remodeling
4. Datasources
• Source Systems - SAP systems ; File system; UD Connect ; DB Connect
5. Infoproviders
• MultiProviders; Infoset; Difference between MP and IS
6. Semantically Partitioned Objects(SPO)
7. Misc
• Attribute Change Run; InfoPackages ; Data Transfer Process (DTP) [Error Handling DTP , Semantic Groups]; Transformations ; Display/Navigational Attributes ; Cumulative/Non Cumulative Key Figures ; BW Accelerators ; APD ; Transports ;  Infosource ; BW Content ; Process Chains
8. Bex
• Key Figures and Filters ; Filters ; Restricted Key Figure ; Calculated Key Figure ; Formula ; Virtual Key Figures ; Conditions ; Structures ; Offset ; Bex Variables ; Aggregations [ Normal Aggregation , Exceptional Aggregation , Currency and Units Aggregation ] WorkBooks ; Broadcasting of Reports
9. Performance Tuning
• InfoCube ; Query Performance
10. Production Support
• Moving Extractor to Production
11. Interview Questions
12. Things to Talk
13. Interview Questions
14. Common Issues/Erros
15. Currency / Tranfer exchange rates handling
16. UPGRADE