SAP Business Warehouse Topics for Interview Success
SAP Business Warehouse Topics :
1. Fundamentals:
• What is NetWeaver?
• What is BI?
• What is SAP BW or Business Information Warehouse?
• What is SAP R3? Decision support in an Enterprise.
• Decision support v/s Operational Reporting.
• OLTP v/s OLAP.
• Fundamentals about working of SAP R3.
• Fundamentals about working of SAP BW.
2. Functions of BW:
• Reporting (Decision Support and Operational).
• Open Hub (Supply Data to External Applications).
• Planning (Business Planning and Simulation – BPS).
• SEM–BPS is now BW-BPS.
• BW as EDW (Enterprise Data Warehouse).
3. Data Modeling:
• Data modeling concepts.
• Concepts behind various Data Models used in OLTP and OLAP.
• Why different Data Models?
• MDM v/s ERM.
• Extended Star Schema used in SAP BW.
4. SAP BW Terminology:
• Communication Structure in SAP R3.
• Extract Structure.
• User Exit.
• Transfer Structure.
• DataSource.
• Source System.
• PSA.
• Transfer rules.
• Communication Structure in BW.
• Update Rules.
• InfoCube.
• ODS (Operational Data Store).
• InfoObject.
• MasterData (Attributes. Texts and Hierarchies).
• Characteristics and Key Figures.
• InfoProvider.
• DataTarget.
• InfoProvider v/s DataTarget.
• InfoArea.
• Application Components.
• Administrator Work Bench.
• MultiProvider.
• InfoSet.
• BEx Query.
• InfoSet Query.
• Classic InfoSet.
5. Data Flow:
• How the data flows from Source System in to BW?
• Data Flow Diagram for SAP R3 OLTP System to SAP BW.
• Types of Updates – Direct v/s Flexible.
• How the elements described above are used in Data Flow?
6. InfoObject:
• How to create InfoObject?
• Types of InfoObjects.
• Characteristics and Key Figures.
• Master Data.
• Special types (Unit/Currency. Date).
• Data Structures in InfoObject.
• How to Load Data in to InfoObject?
• How is the InfoObjects used in Reporting? Global Transfer Routine – How to use Global Transfer Routine? Why it is used.
• Management of overlapping Master Data from Multiple Sources.
• Creating Direct Update InfoSources Automatically. InfoObject as InfoProvider.
7. Types of Updates:
• Additive.
• Overwrite.
• Where to maintain update type for DataSource?
• Which objects use these update types (ODS/InfoCube? Master Data)?
8. InfoCube:
• How to create an InfoCube?
• Types of InfoCube (Transactional. Basic. Remote/Virtual).
• Data Structures in an InfoCube.
• Update types for InfoCube.
• How is the data updated in the InfoCube?
• Virtual Key Figures.
9. ODS Object:
• How to Create ODS Object?
• Structure of ODS Object.
• Update types in ODS Object.
• Update Mechanism.
• Data structures in an ODS Object.
10. InfoSources:
• Creating InfoSource.
• Update and Transfer Rules.
• Update Routine.
• Transfer Routine.
• Start Routine.
• Start up Routine.
11. AWB – Administrator Work Bench:
• Functions of AWB – Modeling.
• Monitoring.
• Reporting Agent.
• Transport Connection.
• Documents.
• Business Content.
• Translation.
• Metadata Repository.
12. Transports:
• How transports work in BW.
• How to create Transports? Efficient ways to create Transports in Different Scenarios.
13. Business Content:
• Standard Business Content in R3 and BW.
• Transferring DataSources and Application Component Hierarchy in R3.
• Replication of DataSources.
• Activation of Business Content. How to Activate Business Content – various Scenarios.
14. Data Extraction Using Flat Files:
• How to generate Transfer Structure from Communication Structure?
• Loading Data using Flat File.
15. Data Extraction from SAP R3 – Data Collection:
• Transaction Processing in SAP R3.
• Update types in SAP R3. How “Delta” is managed? V3 Control.
• Direct and Queued Delta.
• Update Mechanism in SAP R3.
• Manipulation of Data in SAP R3.
• Transaction User Exits.
• LIS User Exits.
• BW User Exits.
16. Data Extraction from SAP R3 –Application Specific:
• Infrastructure needed for loading data – DataSource.
• LO-Cockpit DataSources.
• CO_PA. FI-SL. FI_Line Item Extraction.
• LIS Extraction.
17. LO-Cockpit Extraction:
• Demonstrate each step in data extraction by performing transactions in SAP R3.
18. Data Extraction from SAP R3 – Generic:
• How to Create Generic DataSource?
• Delta Management. Generic Delta.
19. Data Extraction from SAP R3 – Maintain DataSource:
• What is - Direct Access? Delta. Inversion. Selection. Field only…. Hide.
• How to Maintain DataSource?
20. Data Extraction from SAP R3 – Modifying Data:
• Manipulation of Transaction Data / Master Data / Texts / Hierarchies.
• How to program in User Exit?
• Concept of Project.
• Function Modules used for Data Manipulation.
21. Modify DataSource:
• Demo the process of modifying Master Data Source by adding additional field and filling it with Data in BW.
22. Data Extraction from XML Source:
• XML Integration.
• Creating Flat File DataSource and generating Myself DataSource.
• Create and Maintain “Delta Queue” in BW System.
23. DB Connect: Concepts.
24. Data Mart Interface:
• Extraction within BW System.
• ODS to ODS.
• ODS to InfoCube and
• InfoCube to InfoCube Extraction.
25. Open Hub Services:
• InfoSpoke.
• Create and Schedule InfoSpoke.
• BW as Open Hub or Data Hub.
26. Performance Management:
• How to improve performance of Data Load and Query?
Partitioning.
• Indexes in InfoCubes and ODS’s.
• Aggregates on InfoCubes.
• Compression.
27. Production Support:
• Monitoring Jobs.
• Process Chains.
• Event Chains.
• Info package Groups.
• Creating and Triggering Events. Common Problems. How to Fix them.
28. BW Presentation – Queries:
• BEx Analyzer.
• Query Designer.
• Queries in standard Excel Front end.
• Functions.
• Formulas. Calculated and Restricted Key Figures. Tabular Display.
• Query Views.
• Exception Reporting.
29. Web Interface:
• Launching Queries in Web Front end.
• Building simple Web site for launching Queries.
30. Web Application Designer:
• Web Templates. Creating Web Template with Company Logo. Adding more than one Query in a Web Page.
31. Reporting Agent:
• Demo - Scheduling a Query with exceptions to run at certain time and send e-mail with the result as attachment.
32. Report to Report Interface:
• Also known as RRI or Query Jump.
• Jump from Aggregate to Detailed Query with selections from the Aggregate Query.SAP Business Warehouse Topics
1. Fundamentals:
• What is NetWeaver?
• What is BI?
• What is SAP BW or Business Information Warehouse?
• What is SAP R3? Decision support in an Enterprise.
• Decision support v/s Operational Reporting.
• OLTP v/s OLAP.
• Fundamentals about working of SAP R3.
• Fundamentals about working of SAP BW.
2. Functions of BW:
• Reporting (Decision Support and Operational).
• Open Hub (Supply Data to External Applications).
• Planning (Business Planning and Simulation – BPS).
• SEM–BPS is now BW-BPS.
• BW as EDW (Enterprise Data Warehouse).
3. Data Modeling:
• Data modeling concepts.
• Concepts behind various Data Models used in OLTP and OLAP.
• Why different Data Models?
• MDM v/s ERM.
• Extended Star Schema used in SAP BW.
4. SAP BW Terminology:
• Communication Structure in SAP R3.
• Extract Structure.
• User Exit.
• Transfer Structure.
• DataSource.
• Source System.
• PSA.
• Transfer rules.
• Communication Structure in BW.
• Update Rules.
• InfoCube.
• ODS (Operational Data Store).
• InfoObject.
• MasterData (Attributes. Texts and Hierarchies).
• Characteristics and Key Figures.
• InfoProvider.
• DataTarget.
• InfoProvider v/s DataTarget.
• InfoArea.
• Application Components.
• Administrator Work Bench.
• MultiProvider.
• InfoSet.
• BEx Query.
• InfoSet Query.
• Classic InfoSet.
5. Data Flow:
• How the data flows from Source System in to BW?
• Data Flow Diagram for SAP R3 OLTP System to SAP BW.
• Types of Updates – Direct v/s Flexible.
• How the elements described above are used in Data Flow?
6. InfoObject:
• How to create InfoObject?
• Types of InfoObjects.
• Characteristics and Key Figures.
• Master Data.
• Special types (Unit/Currency. Date).
• Data Structures in InfoObject.
• How to Load Data in to InfoObject?
• How is the InfoObjects used in Reporting? Global Transfer Routine – How to use Global Transfer Routine? Why it is used.
• Management of overlapping Master Data from Multiple Sources.
• Creating Direct Update InfoSources Automatically. InfoObject as InfoProvider.
7. Types of Updates:
• Additive.
• Overwrite.
• Where to maintain update type for DataSource?
• Which objects use these update types (ODS/InfoCube? Master Data)?
8. InfoCube:
• How to create an InfoCube?
• Types of InfoCube (Transactional. Basic. Remote/Virtual).
• Data Structures in an InfoCube.
• Update types for InfoCube.
• How is the data updated in the InfoCube?
• Virtual Key Figures.
9. ODS Object:
• How to Create ODS Object?
• Structure of ODS Object.
• Update types in ODS Object.
• Update Mechanism.
• Data structures in an ODS Object.
10. InfoSources:
• Creating InfoSource.
• Update and Transfer Rules.
• Update Routine.
• Transfer Routine.
• Start Routine.
• Start up Routine.
11. AWB – Administrator Work Bench:
• Functions of AWB – Modeling.
• Monitoring.
• Reporting Agent.
• Transport Connection.
• Documents.
• Business Content.
• Translation.
• Metadata Repository.
12. Transports:
• How transports work in BW.
• How to create Transports? Efficient ways to create Transports in Different Scenarios.
13. Business Content:
• Standard Business Content in R3 and BW.
• Transferring DataSources and Application Component Hierarchy in R3.
• Replication of DataSources.
• Activation of Business Content. How to Activate Business Content – various Scenarios.
14. Data Extraction Using Flat Files:
• How to generate Transfer Structure from Communication Structure?
• Loading Data using Flat File.
15. Data Extraction from SAP R3 – Data Collection:
• Transaction Processing in SAP R3.
• Update types in SAP R3. How “Delta” is managed? V3 Control.
• Direct and Queued Delta.
• Update Mechanism in SAP R3.
• Manipulation of Data in SAP R3.
• Transaction User Exits.
• LIS User Exits.
• BW User Exits.
16. Data Extraction from SAP R3 –Application Specific:
• Infrastructure needed for loading data – DataSource.
• LO-Cockpit DataSources.
• CO_PA. FI-SL. FI_Line Item Extraction.
• LIS Extraction.
17. LO-Cockpit Extraction:
• Demonstrate each step in data extraction by performing transactions in SAP R3.
18. Data Extraction from SAP R3 – Generic:
• How to Create Generic DataSource?
• Delta Management. Generic Delta.
19. Data Extraction from SAP R3 – Maintain DataSource:
• What is - Direct Access? Delta. Inversion. Selection. Field only…. Hide.
• How to Maintain DataSource?
20. Data Extraction from SAP R3 – Modifying Data:
• Manipulation of Transaction Data / Master Data / Texts / Hierarchies.
• How to program in User Exit?
• Concept of Project.
• Function Modules used for Data Manipulation.
21. Modify DataSource:
• Demo the process of modifying Master Data Source by adding additional field and filling it with Data in BW.
22. Data Extraction from XML Source:
• XML Integration.
• Creating Flat File DataSource and generating Myself DataSource.
• Create and Maintain “Delta Queue” in BW System.
23. DB Connect: Concepts.
24. Data Mart Interface:
• Extraction within BW System.
• ODS to ODS.
• ODS to InfoCube and
• InfoCube to InfoCube Extraction.
25. Open Hub Services:
• InfoSpoke.
• Create and Schedule InfoSpoke.
• BW as Open Hub or Data Hub.
26. Performance Management:
• How to improve performance of Data Load and Query?
Partitioning.
• Indexes in InfoCubes and ODS’s.
• Aggregates on InfoCubes.
• Compression.
27. Production Support:
• Monitoring Jobs.
• Process Chains.
• Event Chains.
• Info package Groups.
• Creating and Triggering Events. Common Problems. How to Fix them.
28. BW Presentation – Queries:
• BEx Analyzer.
• Query Designer.
• Queries in standard Excel Front end.
• Functions.
• Formulas. Calculated and Restricted Key Figures. Tabular Display.
• Query Views.
• Exception Reporting.
29. Web Interface:
• Launching Queries in Web Front end.
• Building simple Web site for launching Queries.
30. Web Application Designer:
• Web Templates. Creating Web Template with Company Logo. Adding more than one Query in a Web Page.
31. Reporting Agent:
• Demo - Scheduling a Query with exceptions to run at certain time and send e-mail with the result as attachment.
32. Report to Report Interface:
• Also known as RRI or Query Jump.
• Jump from Aggregate to Detailed Query with selections from the Aggregate Query.
No comments:
Post a Comment