Call Us: +91-9000011489

Register for Free Demo

Touchbase on BW 3.5, BI 7.0, BI 7.3

  • General Introduction.
  •  SAP introduction.
  •  Data warehousing/ BW/ BI Introduction
  •  Master Data; Attributes, Texts, and Hierarchies.
  •  Standard Naming conventions in SAP and BI

Data Modeling

  • Info Objects: Definitions
    • Types: Characteristics, Key Figures, Time, and Unit.
  •  Info Cubes: Definitions.
    • Types: Standards, real time, virtual.
    • Design of Infocube: Extended Star Schema concepts. Precautions.
  • Data Store objects (DSO):
    • Types: Standard, Write Optimized, Direct Update.
  • Info Sets
  • Multi Providers: Scenarios to create Multi providers.
  •  Info cube VS DSO

Metadata and Document Management

  • BI Content: Definitions, How to install BI contents,

Defining extraction

  • For SAP source systems: Creating Generic dataSource and maintaining SAP delivered Data Source.
  • Or for files: Creating DataSources for File Source Systems

Defining transformations

  • Transformations and different scenarios.

Defining the data flow:

  • Creating data transfer processes
  • Creating process chains

Scheduling and monitoring:

  • Checking process chain runs
  • Monitor for extraction processes and data transfer processes

Performance optimization:

  • Creating the first aggregate for an InfoCube
  • Using the BIA index maintenance wizard

User management:

  • Setting up standard authorizations
  • Defining analysis authorizations

Transports:

  • Real business scenarios on different system environments, Moving objects from one system to another.
  • BI SUITE: Business Explorer

BEx Query Designer

  • Queries: New queries, Restricting Characteristics, Formulas and Exception Cells
  • Query Design: Defining Exceptions, Conditions, Restricted and Calculated KeyFigures
  • Variables: The Variable Wizard, Variable Types and Processing Types, query Properties
  • Component Properties: Properties of Characteristics, Attributes, Structure, Formula, KeyFigures
  • Structures: Creating Re-usable structures
  • Functions on BW Server: Copying queries between Cubes, Deleting Query Elements

BI Platform

  • Information Broadcasting
  • Functions of the Broadcaster: Pre calculating and Exporting into Enterprise Portal
  • User Guide: Distributing Queries and Web Templates, Scheduling Broadcasting Settings
  • Example Scenarios: Monthly Sales Reports, Ad-hoc Distribution Options.

OLAP

  • OLAP v OLTP: The OLAP Concept and differences between OLAP and OLTP
  • OLAP Functions: Aggregation, Currency Translation, Report-to-Report Interface
  • Meta Data Repository: Searching for MetaData

Advanced Topics

  • Data Model for Performance: Line Item Dimensions, Navigational attributes, Time-Dependent
  • Query Analysis Tools, Performance Tables
  • Reporting Performance: Effective query design, Line-Item, Compression, Partitioning
  • Aggregates: Creating Aggregates, Finding effective aggregates
  • Data Load Performance: Parallelism, Impact of Aggregates
  • Partitioning: Logical Partitioning, Table Partitioning.