IICT Chromepet

                                 Facebook Linked In Twitter Pinterest Blogspot Youtube   Phone

90038 53466

Course Content (Duration : 45 Hrs)


  • General Introduction

  • ERP introduction

  • Data warehousing/ BW/ BI Introduction

  • Master data; Attributes, Texts, and Hierarchies

  • Standard Naming conventions in ERP and BI

Data Modelling

  • InfoObjects: Definitions

  • Types: Characteristics, Key Figures, Time, and Unit

  • InfoCubes: Definitions

  • Types: Standards, real time, remote

  • Design of Infocube: Star Schema concepts Precautions

  • DataStore Objects (DSO):

  • Types: Standards, Real time

  • InfoSets

  • MultiProviders: Scenarios to create MultiProviders

  • Infocube VS DSO

Metadata and Document Management

  • BI Content: Definitions, How to install BI contents

Defining extraction

  • For ERP source systems: Creating Generic DataSource and maintaining ERP delivered dataSource

  • Or for files: Creating DataSource 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


  • Real business scenarios on different system environments, Moving objects from one system to another

BI SUIT: 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

Web Application Designer

  • WAD: Functions of WAD, Web Items Window, Template Window, Properties Window

  • Web Applications: Creating Web Applications, Settings, Stylesheets, Symbols and Properties

  • Design: Designing the Layout of Web Templates, working with Library for Web Items

  • Web Items: Tables, Filters, and Checkboxes, Dropdown Box and other web items and their attributes


  • BEx Analyser

  • BEx Web Application Designer

  • BEx Report Designer

BI platform

  • Information Broadcasting

  • Functions of the Broadcaster: Precalculating 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 v OLTP: The OLAP Concept and differences between OLAP and OLTP

  • OLAP Functions: Aggregation, Currency Translation, Report-to-Report Interface

  • MetaData Repository: Searching for MetaData


Latest Reviews of IICT- " Students Are Brand Ambassadors "

Road Map of IICT

IICT Chromepet Address, IICT Contact, IICT Location, IICT Chrompet address, IICT Chennai Address, IICT

IICT - Chrompet Head Office

Click Here For Google Map


Are you located in any of these areas - Abiramapuram, Adambakkam, Adyar, Agaram, Alandur, Alwarpet, Alwarthirunagar, Ambattur, Ambattur Industrial Estate, Aminjikarai, Anakaputhur, Anna Nagar, Anna Nagar East, Anna Nagar West, Anna Salai, Arumbakkam, Ashok Nagar, Avadi, Ayanavaram, Besant Nagar, Broadway, Chengalpet, Chennai Others, Chetpet, Chintadripet, Chitlapakkam, Choolai, Choolaimedu, Chromepet, Egmore, Ekkaduthangal, Ennore, Flowers Road, George Town, Gopalapuram, Gowrivakkam, Guduvanchery, Guindy, Iyyapanthangal, Jafferkhanpet, Jawahar Nagar, K.K. Nagar, Kattupakkam, Kellys, Kilpauk, Kodambakkam, Kodungaiyur, Kolathur, Korattur, Korrukupet, Kottur, Koyambedu, Kundrathur, M.K.B. Nagar, Madhavaram, Madipakkam, Manali, Manapakkam, Mandaveli, Mangadu, Maraimalai Nagar, Medavakkam, Meenambakkam, Minjur, Mogappair, Mogappair East, Moulivakkam, Mudichur, Mylapore, Nandambakkam, Nandanam, Nanganallur, Neelangarai, Nungambakkam, Old Washermenpet, Orgadam, Padi, Palavakkam, Palavanthangal, Palavayal, Pallavaram, Pallikaranai, Pammal, Park Town, Parrys, Pattabiram, Perambur, Periyar Nagar, Perungalathur, Perungudi, Poonamallee, Porur, Potheri, Pozhichalur, Pudupet, Purasawalkam, Puzhal, R.A. Puram, Redhills, Royapettah, Saidapet, Saligramam, Santhome, Selaiyur, Sembiam, Shenoy Nagar, sholavaram, Sholinganallur, Singaperumalkoil, Sowcarpet, Sri Iyappa Nagar, St. Thomas Mount, T. Nagar, Tambaram, Teynampet, Thiruninravur, Thiruvanmiyur, Thiruverkadu, Thiruvotriyur, Thousand Lights, Tondiarpet, Triplicane, Urapakkam, Vadapalani, Valasaravakkam, Vandalur, Velachery, Vepery, Villivakkam, Virugambakkam, Vyasarpadi, Washermanpet and West Mambalam

IICT Training is NOT affiliated or associated with SAP AG. IICT Training does NOT sell or distribute any SAP Copyrighted materials or software. IICT Training does NOT provide SAP IDES Access. IICT Training is NOT an official Training Partner of SAP AG.

RSS Sitemap   |   Sitemap  ©IICT, CHENNAI , TN. All rights reserved.