1) Acquire extended knowledge and skills in SAP BW Operations
2) Acquire extended knowledge and skills in SAP BW Perfomance Optimization
Database Administrator
Solution Architect
Technology Consultant
- Essential: BW310; Extensive SAP Data Warehousing Experience"
- Recommended: Experience with SAP BW; Data Base Basics Experience; Data Dictionary Experience
- 1) An Overview of SAP NetWeaver Business Warehouse (BW), BW Accelerator, and SAP HANA
- a) Identifying the Components and architecture of SAP NetWeaver BW, BW Accelerator, and SAP HANA
- 2) InfoProvider Administration
- a) Managing InfoCubes
- b) Managing DataStore Objects
- c) Managing MultiProviders
- d) Managing HybridProviders
- e) Managing Semantically Partitioned Objects (SPOs)
- f) Managing TransientProviders
- g) Managing Analytical Indexes
- h) Managing VirtualProviders
- i) Managing Real-Time Providers
- j) Creating a DataStore Object for Direct Update
- 3) Process Chain Administration
- a) Designing Process Chains
- b) Maintaining Process Chains
- c) Monitoring Process Chains
- 4) Data Acquisition Administration
- a) Describing the Data Load Cycle
- b) Examining the Technical Details of Data Loading
- c) Loading Master Data
- d) Using Transformations
- e) Monitoring Data Load
- 5) Working with the BW Trace Tool
- a) Working with the BW Trace Tool
- 6) Information Lifecycle Management
- a) Classic Archiving in Information Lifecycle Management
- b) Making Archived Data Available for Queries Using BW Near-Line Storage
- 7) BW Transports
- a) Describing the BW Transport System Landscape
- b) Determining Object Versions and Metadata
- c) Managing BW Transports
- d) Transporting BEx Objects
- e) Transporting Roles and Workbooks
- f) Investigating Transport Strategies and Troubleshooting
- 8) Performance Management with BW InfoProvider Indexes
- a) Determining Relational DBMS Indexes
- b) Indexing for InfoProviders
- 9) Optimizing Performance for InfoProviders
- a) Optimizing Performance for DataStore Objects
- b) Optimizing Performance for InfoCubes
- c) Optimizing Performance Using Semantically Partitioned Objects
- d) Optimizing Performance Using Analytical Indexes
- e) Optimizing Performance Using TransientProviders
- f) Working with Aggregates
- g) Optimizing Performance Using MultiProviders
- h) Optimizing Performance Using HybridProviders
- 10) Optimizing Data Acquisition Performance
- a) Configuring Data Acquisition Parallel Processing
- b) Improving Data Acquisition Performance
- c) Loading and Activating DataStore Objects
- 11) Performance Through Partitioning
- a) Performing Table Partitioning
- 12) Reporting Performance
- a) Designing Queries for Optimal Performance
- b) OLAP Caching
- c) Maintaining Query Properties
- 13) Managing Performance with BW Statistics
- a) Getting an Overview of BW Statistics
- b) Implementing Technical Content for BW Statistics
- c) Administering and Analyzing BW Statistics Data
- d) Monitoring with BW Administration Cockpit and BO Dashboard
- 14) Performance Management with BW Accelerator
- a) Performance Optimization with BW Accelerator
- b) Determining BW Accelerator Architecture
- c) Increasing Query Read Performance Using BW Accelerator Indexes
- d) Monitoring BW Accelerator
- e) Envisioning the Future of SAP HANA with BW
- Notes
- 1) This course does not discuss SAP BW with HANA in depth. For more information about SAP BW with HANA, see BW362.
Course based on software release: SAP NetWeaver BW 7.4
Notes and announcements:
1) This course will help you get the most of your SAP BW implementation by not only giving you a detailed view of operations and InfoProviders, but also by helping you to optimize performance of data loads and query execution.
2) This course does not discuss SAP BW with HANA in depth. For more information about SAP BW with HANA, see BW362.
This is a SAP CERTIFIED Course. Your course will include Full Class Delivery of the comprehensive standard SAP curriculum agendas, SAP Certified Instructor, Demonstration and Presentation, Student Hands on exercises, Access to SAP Hosted servers/training environment, and SAP Certified participant guides.
This 5 day instructor led course qualifies for 40 CPE Credits. CPE Credits are currently available only for publicly scheduled courses delivered live at SAP locations and our Authorized Education Partner locations. CPE Credits are not available for virtual live classroom sessions.
With virtual live classroom training you get comprehensive training from SAP experts using seamless over-the Web connectivity. The same content delivered in SAP's traditional "brick and mortar" classrooms is presented during virtual live classroom deliveries. As in SAP's traditional classrooms, SAP virtual live classroom stresses hands-on learning providing each registered student with exclusive access to live SAP systems throughout each course. Each Virtual Live class is taught by a SAP Certified Instructor and will include an e-book student guide for you to download and keep. CPE Credits are currently available only for publicly scheduled courses delivered live at SAP locations and our Authorized Education Partner locations. CPE Credits are not available for virtual live classroom sessions.
Not finding any suitable dates? Contact us for additional available dates: training@dunnsolutions.com
