SAP BI online training.

  SAP BI ONLINE TRAINING

SAP BI Online Training.

Contact : skype id : keylabstraining ,US : +1-908-366-7933, India : +91 -9550645679

   SAP BI Online Training Content

                              

         Introduction:

• Data Ware Housing Concepts
• Over View Concepts of BW
• Over view of SAP R/3 Types of Applications 
• OLTP
• OLAP
• R/3 Architectures
• Landscape of SAP
• Types of Data
• Master data
• Transaction data
• Master Data
• Attribute data
• Text data
• Hierarchy data
• Transaction data
• Header data
• Item data
• Scheduled line data
• Star Scheme Concepts
• Classical star schema.(DW)
• Extended star schema.(BW)

• MODELLING

• Info area
• Info objects Catalog
• Info objects
• Info source
• Data source
• Source system
• Application component
• Transfer rules
• Transfer structure
• Communication structure
• Info providers
• Data targets
• Info cubes
• Standard Info Cube
• Real-Time Info Cube
• DSO
• Standard DSO
• DSO for Direct Update
• Write-optimize DSO
• DSO Structure
• New data table
• Active data table
• Change log type
• DSO SETTING
• Automatic
• Manual
• Data Mart
• Transformations
• Transformation Process
• Start Routine
• End Routine
• Expert Routine
• DTP – Data Transfer Process
• Standard DTP
• Error DTP
• RDA DTP
• Direct DTP
• Info package
• PSA
• Standard PSA
• Error Stack PSA
• Data Acquisition
• Standard
• Real Time
• Data loading using flat files
• Attribute data
• Text data
• Hierarchy data
• Transaction data
• Reusability of master data
• Info cube
• Types of Info cubes
• Physical data stores
• Virtual data stores
• Multi providers

• EXTRACTION
• Master data
• Transaction data
• Flat files
• LIS
• LO
• Generic Extraction
• CO-PA
• FI-SI
• DB connect
• Business content extraction

• REPORTING
• BEX Analyzer
• BEX Browser
• WAD
• BEX query designer
• Role maintains
• Creating a role
• Assigning a role
• Variables
• Types
• Processing types
• Conditions
• Formula
• Calculated Key Figures
• Restricted key figures
• Exceptions
• Filters
• Free characteristics
• Structures
• Cell definitions
• Query performance
• Information broadcasting
• Cache inactive
• Query Monitoring
• RRI (report-to-report interface)
• Query properties
• Debugging reports while Executing

• OTHER TOPICS
• Process Chain
• Direct Schedule
• Meta chain
• Error handling in process chain
• Monitoring process chain
• Message integration
• Success
• Error
• Always
• Scheduling process chain based on Periodic values
• Cancelling the process chain jobs
• Rescheduling the process chain
• Folder creation for a specific process chain
• Creating a variant for ABAP programs and integrating in process chain
• ALE Remote jobs
• Attribute change run

• Performance Tuning
• Roll up
• Aggregate
• Collapse
• Reconstruction
• Deletion of data from data Targets
• Complete deletion of data
• Deleting data by request id

• Partitioning
• Line items dimensions
• Selective deletions
• Re-modeling
• Re-partitioning

APD – Analysis Process Design

• Transportation
• Assigning object to the requests
• Releasing the Request No and their Dependency
• Return code
• Mail drafting to basis team regarding transportation
• Searching objects locally and business contents through Meta Data Repository
• Business content
• Definition
• Activation
• Open hub service
• Info spoke
• REAL TIME SCENARIO
• Product Issues 
• Ticket Handling
• Ticket tool tracker
• Error handling

SAP-BI/BW Project/Real-Time Training Contents

Modeling

·         Tasks in implementation project and support project

·         Hierarchy & Attribute loads

·         Attribute change run

·         Info sources in BW 3.x & BI 7.0?

·         Business Content

·         Info cube, ODS

·         Scenario for three types of ODS

·         Discuss about the staging (when to use ODS and Cube)

·         Types of DTP'S

·         What are Rule Groups, Rule Types?

·         Multi provider & Info set

·         Routines

·         Modeling approach - Dimension Design, Account Based Model & Key Figure Model

·         Difference between BW3.5 and BI7.0?

Reporting

·         Structures, Conditions, Exceptions, Cell Restrictions, Variables, Jump queries,  Information Broadcasting, Filters, Free Characteristics, Selections, Formula, RKF, CKF, Percentage functions, Data functions, Boolean Functions.

·         5 Variables,

·         5 Processing types with scenarios

Extraction

·         LO Extraction

·         FI, COPA extraction

·         Functional Process of MM,SD,FI

·         SD, MM,FI reports developed

·         Converting Functional Specifications to technical specifications with MM example

·         SD Case Study

·         Enhancement of data source

·         Steps to consider before doing transportation of enhanced data source

·         Update modes (Direct, Queued, Unserialized V3 update), V1, V2, V3

·         Generic extraction using Function Module and View

·         Delta Management

·         Performance (load performance & Query performance)

·         Aggregates

·         Transportation

·         Process Chains

·         Authorizations

·         BI Statistics

·         Remodeling & Reporting

·         Real time errors - Error Handling

·         Questionnaire for Interviews

• CV Preparation.  

 

SAP BI Online Training.

skype id : keylabstraining

US : +1-908-366-7933

India : +91 -9550645679