- 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.
- Acquire extended knowledge and skills in SAP BW Operations
- Acquire extended knowledge and skills in SAP BW Perfomance Optimization
- Database Administrator
- Solution Architect
- Technology Consultant
Essential
BW310
Extensive SAP Data Warehousing Experience"
Content
- An Overview of SAP NetWeaver Business Warehouse (BW), BW Accelerator, and SAP HANA
- Identifying the Components and architecture of SAP NetWeaver BW, BW Accelerator, and SAP HANA
- InfoProvider Administration
- Managing InfoCubes
- Managing DataStore Objects
- Managing MultiProviders
- Managing HybridProviders
- Managing Semantically Partitioned Objects (SPOs)
- Managing TransientProviders
- Managing Analytical Indexes
- Managing VirtualProviders
- Managing Real-Time Providers
- Creating a DataStore Object for Direct Update
- Process Chain Administration
- Designing Process Chains
- Maintaining Process Chains
- Monitoring Process Chains
- Data Acquisition Administration
- Describing the Data Load Cycle
- Examining the Technical Details of Data Loading
- Loading Master Data
- Using Transformations
- Monitoring Data Load
- Working with the BW Trace Tool
- Working with the BW Trace Tool
- Information Lifecycle Management
- Classic Archiving in Information Lifecycle Management
- Making Archived Data Available for Queries Using BW Near-Line Storage
- BW Transports
- Describing the BW Transport System Landscape
- Determining Object Versions and Metadata
- Managing BW Transports
- Transporting BEx Objects
- Transporting Roles and Workbooks
- Investigating Transport Strategies and Troubleshooting
- Performance Management with BW InfoProvider Indexes
- Determining Relational DBMS Indexes
- Indexing for InfoProviders
- Optimizing Performance for InfoProviders
- Optimizing Performance for DataStore Objects
- Optimizing Performance for InfoCubes
- Optimizing Performance Using Semantically Partitioned Objects
- Optimizing Performance Using Analytical Indexes
- Optimizing Performance Using TransientProviders
- Working with Aggregates
- Optimizing Performance Using MultiProviders
- Optimizing Performance Using HybridProviders
- Optimizing Data Acquisition Performance
- Configuring Data Acquisition Parallel Processing
- Improving Data Acquisition Performance
- Loading and Activating DataStore Objects
- Performance Through Partitioning
- Performing Table Partitioning
- Reporting Performance
- Designing Queries for Optimal Performance
- OLAP Caching
- Maintaining Query Properties
- Managing Performance with BW Statistics
- Getting an Overview of BW Statistics
- Implementing Technical Content for BW Statistics
- Administering and Analyzing BW Statistics Data
- Monitoring with BW Administration Cockpit and BO Dashboard
- Performance Management with BW Accelerator
- Performance Optimization with BW Accelerator
- Determining BW Accelerator Architecture
- Increasing Query Read Performance Using BW Accelerator Indexes
- Monitoring BW Accelerator
- Envisioning the Future of SAP HANA with BW
Updating ....
- Learn how to extract data from SAP source systems with Service API and how to manage delta data
- Acquire data from other source systems using different interfaces such as: DB Connect, Universal Data Integration, XML, and Data Services
- Application Consultant
- Business Analyst
- Business Process Architect
- Business Process Owner / Team Lead / Power User
- Enterprise Architect
- Program / Project Manager
- Technology Consultant
Essential
Sound knowledge of the content that is covered in the BW310 – Data Warehousing course, especially working with the Data Warehousing Workbench
Content
- SAP BW Data Acquisition Process
- Explaining Data Acquisition in SAP BW
- Creating SAP BW 3.x Data Flow
- Comparing and Migrating 3.x / 7.x SAP BW Data Flows
- Directly Accessing Source System Data
- Loading Directly Without Persistent Staging Area (PSA)
- Reviewing Details of Real-Time Data Acquisition (RDA)
- Data Acquisition with the SAP BW Service API
- Connecting SAP Source Systems to SAP BW
- Displaying the Configuration of SAP BW Service API
- Explaining BI Content
- Examining the Transfer of GL Data
- Examining Generic DataSources
- Enhancing BI Content DataSources
- Configuring Logistics Data Extraction
- Delta Data Flow Management
- Describing Delta Management
- Explaining Terms and Basic Processes of Delta Enabled DataSources
- Analyzing Delta Management
- Data Acquisition with Operational Data Provisioning (ODP) and SAP Landsape Transformation (SLT)
- Describing Data Acquisition with ODP
- Analyzing Operational Delta Queue (ODQ)
- Replicating Data with SLT
- Acquiring Data in Real Time with SLT
- Flat File Data Transfer
- Loading Data from a Flat File
- Loading Hierarchies in SAP BW Using the Hierarchy Framework
- Exporting a hierarchy using OpenHub
- Data Acquisition with DB Connect
- Creating a DB Connect DataSource
- Data Acquisition with Universal Data (UD) Integration
- Creating UD Connect DataSources
- XML-Based Data Acquisition
- Explaining XML-Based Extraction
- Acquiring Data Using an XML-Based Web Service
- Creating HybridProviders
- Data Acquisition with SAP Business Objects Data Services
- Integrating SAP Business Objects and SAP BW
- Data Mart Interface and Open Hub
- Examining the Data Mart Interface for Data Transfers
- Implementing OpenHub Destinations
Updating ....
- Learn the procedures within modeling of the BW Enterprise Data Warehouse and acquire deep knowledge about modeling and implementation of data warehousing with SAP BW 7.4.
- Learn procedures within modeling of SAP Business Warehouse
- Learn how to create a Layered Scalable Architecture"
- Application Consultant
- Business Analyst
- Business Process Architect
- Business Process Owner / Team Lead / Power User
- Enterprise Architect
- Program / Project Manager
- Technology Consultant
Essential
BW310
Basic knowledge of data modeling
Content
- Enterprise Data Warehouse (EDW) Architecture
- Determining EDW Architecture
- Planning the Architecture of an EDW
- Using the EDW Layers
- Determining the Purpose of the Data Mart Layers
- Determining the Purpose of the Operational Data Store Layer
- The Modeling Process
- Identifying Decision Areas within SAP BW Projects
- Performing Requirements Analysis
- Creating a Logical Data Model
- Developing the SAP BW Data Model
- Creating Graphical Data Models and Templates
- Data Modeling Practice
- Drafting a Data Model
- Summarizing Data Modeling Practice
- BI Content Analysis
- Listing the Uses of BI Content
- Comparing a Data Model with BI Content
- InfoObject Models
- Listing the Tables in the SAP BW Data Model
- Implementing Tracking History Scenarios
- Using Reference Characteristics
- Using Hierarchies
- Using Key Figures
- Creating Translation Types for Currency Translation
- Creating Translation Types for Quantity Conversion
- Creating a Data Model for Mapping Non-Cumulative Values in SAP BW
- Modeling DataStore Objects
- Modeling DataStore Objects
- Using Real Time Data Acquisition (RDA)
- Multi-Dimensional Modeling
- Determining the SAP BW Star Schema
- Designing the Dimensions of the SAP BW InfoCube
- Enhanced InfoProvider Modeling
- Modeling MultiProviders
- Modeling an SPO
- Modeling an InfoSet
- Modeling a VirtualProvider
- Modeling a HybridProvider
- Explaining InfoProviders in SAP BW and the InfoProvider Decision Tree
- Data Model Remodeling
- Information Lifecycle Management
- Describing Information Lifecycle Management
- LSA++ with SAP BW on SAP HANA
- Determining the Advantages of SAP BW on SAP HANA
- Determining the Enhancements of LSA++ with SAP HANA
Updating ....
- Create complex Web Intelligence documents using advanced query and reporting techniques, including:
- Combined queries and sub-queries
- Character and date string functions
- Variables and calculation contexts
- Link documents using hyperlinks"
- Application Consultant
- Business Analyst
- Business Process Owner / Team Lead / Power User
Essential
BOW310 SAP BusinessObjects Web Intelligence: Report Design
Content
- Web Intelligence Core Report Design
- Reviewing Core Report Design Concepts
- Multiple Data Sources
- Synchronizing Data from Multiple Data Sources
- Creating Multiple Queries in a Document
- Synchronizing Data with Merged Dimensions
- Interacting with Other Data Providers
- Advanced Query Techniques
- Implementing Combined Queries
- Implementing Subqueries
- Creating a Query Based on Another Query
- Changing Data Sources
- Calculation Contexts
- Describing Calculation Contexts
- Redefining Calculation Contexts
- Implementing Extended Syntax Operators
- Implementing Extended Syntax Keywords
- Defining Calculation Context
- Formulas with Character and Date String Functions
- Creating Formulas with Character and Date String Functions
- Implementing the Right() Function
- Implementing the Replace() Function
- Implementing the SubStr() Function
- Implementing the Pos() Function
- Concatenating Character Strings
- Implementing Date Functions
- If Logic
- Grouping Data
- Executing the If() Function to Modify Calculation Behavior
- Additional Reporting Techniques
- Implementing Data Tracking
- Implementing Additional Report Functions
- Link Options in Web Intelligence Documents
- Managing Links in Web Intelligence Documents
- Using Element Linking to Filter Data
- Managing Hyperlinks in the Web Intelligence Interactive Panel
Updating ....
