9398183729, 040 42407879

saptraining@adroitinfotech.com

Business Warehouse – Planning

Get Academy Details

CAPTCHA code
Course Code Description
BW305 SAP Business Warehouse Query Design and Analysis
BW310 BW - Enterprise Data Warehousing
BW370 BW - Integrated Planning
  • BW305 - SAP Business Warehouse Query Design and Analysis

    • Data Warehousing
      • Describing Data Warehousing
      • Describing Data Warehouse Architecture
      • Using Reporting Tools
    • Navigation Options in Reports
      • Using the Navigation Options in Reports
      • Saving Analysis Views and Workbooks
    • Simple Queries
      • Creating Simple Queries
      • Finding a Query
      • Filtering Query Definition Data
      • Configuring Query Properties
    • Key Figures and Structures in Queries
      • Creating Restricted Key Figures
      • Creating Calculated Key Figures
      • Creating a New Formula with Boolean Operators
      • Configuring Properties of Key Figures
      • Using Exception and Nested Exception Aggregation
    • Queries with Multiple Structures
      • Creating Structures
      • Resolving Formula Collision
      • Designing Detailed Queries with the Cell Editor
    • Characteristics and Hierarchies in Queries
      • Configuring the Properties of Characteristics
      • Running Display and Navigation Attribute Queries
      • Adding Hierarchies to Reports
      • Using Hierarchies and Structures
      • Adding External Hierarchies to a Report
      • Creating External Hierarchies
    • Variables in Queries
      • Using Variables
      • Creating Characteristic Value and Text Variables in Queries
      • Creating Hierarchy and Hierarchy Node Variables in Queries
      • Creating Formula Variables in Queries
      • Activating Business Content Variables
    • Exceptions and Conditions in Queries
      • Creating Exceptions in Query Design
      • Creating Conditions in Query Design
    • Report-Report Interface
      • Using the Report-Report Interface
    • Query Performance Optimization
      • Optimizing Query Performance
      • Configuring Query Read Mode
      • Using Performance Monitoring Tools
    • Queries Management and Authorizations Overview
      • Managing Query Objects
      • Describing Authorizations
    • Reporting Options
      • Outlining Reporting Options for SAP BW
  • BW310 - BW - Enterprise Data Warehousing

    • Data Warehousing
      • Describing Data Warehouse Systems
      • Describing Data Warehouse Architecture
      • Using the Data Warehousing Workbench
    • Master Data Modeling in SAP BW
      • Describing InfoObjects
      • Creating Characteristic InfoObjects
    • The Loading of Master Data from SAP Data Sources
      • Describing Data Flow
      • Modeling a Master Data Flow
      • Loading a Master Data Flow
      • Modeling with the Graphical Data Flow Tool
    • Loading of Transaction Data from SAP DataSources
      • Describing the Core InfoProviders
      • Creating a Key Figure InfoObject
      • Creating a DataStore Object (DSO)
      • Loading Transaction Data into a Data Store Object
      • Describing the Extended Star Schema of an InfoCube
      • Creating InfoCubes
      • Loading Transaction Data into an InfoCube
    • Master Data Loading from Flat File Data Sources
      • Loading Data From a Flat File
      • Describing the Data Flow in Detail
      • Describing the Data Loading Process in Detail
    • InfoProviders in SAP BW
      • Explaining the InfoProviders Used in SAP BW – Introduction
      • Creating MultiProviders
    • Usage of SAP BI Content
      • Using BI Content
    • Query Performance Optimization
      • Optimizing Query Performance
      • Monitoring Performance
      • Creating and Filling Aggregates
    • The SAP BW Administration
      • Describing Administrative Tasks and Tools
      • Administrating the InfoCubes
      • Administrating the DataStore Objects
      • Creating Process Chains
  • BW370 - BW - Integrated Planning

    • Defining BW-IP and PAK
    • Setting up planning structures with the ABAP Planning Modeler
    • Modelling, setting up and Testing planning functions via Planning Sequences
    • Configuring input ready queries with the BEx Query Designer
    • Adding comments to planning queries
    • Explaining Locking of Transaction Data
    • Creating an Analysis Office Workbook for Planning
    • Creating a Design Studio Web Application for Planning
    • Working with Characteristic Relationship
    • Using Aggregation and Disaggregation in Planning Scenarios
    • Setting up Advanced Planning Functions like FOX, ABAP and SQL- Script
    • Introducing Inverse Formulas