SAP BI ABAP

BI-ABAP ONLINE TRAINING COURSE

Course Outline:

• Introduction to BI/BW
• Overview of BI objects
• Infoobjects
• Infocubes
• Data sources
• Infosources etc
• Data loading process in BI
• Transformation and Mapping in BI
• Using ABAP code for development of Start routines, end routines and transformation routines.
• Debugging the loading process.
• Tables / Data access in BI in ABAP programming.

BI-ABAP OVERVIEW – CAREER:
With the increase in number of BI/BW/BO implementations, many projects need specialized BI-ABAP resources on the technical side to customize the functionality by implementation of BADI/Userexits, debug the extraction/ load process, write the conversion routines, transformation routines, start routines etc.
The BI system uses certain special tools and transactions in ABAP to help the developers and BI-ABAP for ABAP Professionals.
This course is mainly geared towards providing an overview of the BI system to the candidates and then help them learn the special tools and techniques for working in BI. The overview helps the candidates to understand how the BI system works, its architecture and get a hang of the jargon related to BI/BW like Info-objects, info cubes, DTP, Info packages etc.
This will also provide a platform to allow the ABAP professionals to leverage their existing knowledge of SAP and combine that the knowledge from this course to get into more details on the BI projects and use it for making a subsequent switch in to functional side.

SAP BI

Business Intelligence Online Training Course

Overview:

SAP Business Intelligence (formerly known as BW) is the enterprise data mining and reporting tool specifically suited for extracting and reporting out of SAP.

SAP BI not only provides the capability to analyze data from the various SAP modules and other
business applications but also facilitates the extraction and analysis of data from external sources

After some intense research you may be able to make a decision but from someone who has been engulfed in the field for a while I am convinced that BI Solutions, by nature, brings all the various functional modules together. BI serves as a central repository where business owners pull information if they are interested in seeing all aspects of a project.

Prerequisites:

SAP BI course for individuals with at least a college degree or several years of work experience. Do NOT need programming knowledge.

Course Outline:

I. Introduction to SAP Business Intelligence

• BI Architecture / BI Platform
• Enterprise Data warehousing / Data Modelling
• Enterprise Reporting, Query and Analysis
• Data Acquisition / Data Extraction
• Star Schema and Extended Star Schema
• Multidimensional Modelling
• Entity Relationship Modelling

II. Enterprise Data warehousing

• Master Data Loading Attributes, Texts and Hierarchies
• Transaction Data Loading
• Types of Info provider
• Info cubes
• DSO/ODS Objects(Standard DSO, WriteOptimized DSO, Direct Update DSO)
• Info objects as Info providers
• Info sets (Inner-Joins, Outer-Joins, Temporial-Joins, Equi-Joins)
• Multi providers
• Virtual Providers
• Differentiating between 3.x version and 7.0 version.
• Open Hub Destination
• InfoSpokes
• Routines
• Business Content and its Relevance
• Performance Tuning
• Aggregates
• Compression
• Rollup
• Reconstruction
• Indexing etc.
• Analysis Process Designer

III. Data Acquisition / Data Extraction

• Logistics Extraction
• Generic Extraction (View AND Infoset Query and FM)
• Enhancing Standard Data Sources
• Delta Mechanism
• COPA Extraction

IV. Enterprise Reporting, Query and Analysis

• Introduction to BEX Query Designer/ BEX Analyser and other Reporting Tools
• Free Characteristic and Filter
• Restricted Key Figures and Calculated Key figures
• Variables and Structures
• Exceptions, Conditions, RRI
• Information Broadcasting and other Reporting Features
• Performance Tuning of Query
• Web Application Designer
• Bex Broadcaster
• Workbook features
• Roles and authorization

V. SAP BI Advanced Topics

• Creating Process Chains, Scheduling and Monitoring
• Remodeling of InfoCube
• Partition and repartition of InfoCube
• Transportation
• Support Project Issues

SAP BPC

BPC 10.0 NW Administration and Planning

Course Overview

• Course Goals
• Course Objectives

Unit 1: Concepts and Objects in BPC Administration

• Business Objects – Overview and Advantages of BO PC
• Business Planning and Consolidation – Some Modeling Aspects
• Terminology
• Environment Management
• Dimension Management
• Creating Models
• Security

Unit 2: SAP EPM 10.0 add-in

• Creating a Planning and Consolidation Connection

Unit 3: EPM Client – Microsoft Office Excel

• Create a Report
• Create a Input Form

Unit 4: Comments

• Enable Comments
• Input and Retrieve Comments

Unit 5: Multi-Reporting and Axis Sharing

• Create a Multi-Reporting Spread Sheet
• Share axis from one report with another report

Unit 6: Formatting

• Dynamic formatting
• Link a formatting sheet to one or several reports
• EPM Function to apply formats

Unit 7: EPM Cell-based formulas

• EPMAxisOverride Cell-based formula
• EPMDimensionOverride Cell-based formula
• EPMInsertCellsBeforeAfterBlock Cell-based formula

Unit 8: Books

• Create a Book Template
• Validate the Book Template
• Publish a book to the Web Library
• View the book in the Book Viewer

Unit 9: New Web Client

• Create a Planning and Consolidation Web Report
• Change the Report Behavior
• Add a Chart to Report
• Create a Web Input Form
• Entering Comments via Web
• Creating Document Types and Sub Types

Unit 10: Data Acquisition, Transformation, ECC and BW 

• Data Acquisition, Transformations, Packages, and Package Links

Unit 11: Working with Logic Scripts

• Logic Script and Online Execution
• Logic Script and Central Execution
• Logic Script and Allocation
• Logic Script and ABAP Integration
• Dimension Member Formulas

Unit 12: Drill Through

• New Drill Through features
• Create a new Drill Through
• Specify the specific parameters of a Drill Through
• Delete any parameter
• Test Drill Through

Unit 13: Business Process Flows

• How to manage Life Cycle of BPF Instances: Create/Start, Suspend, Reset, Archive
• How to manage assignment of Process and Activity Instances
• E-Mail notification

Unit 14: Crystal Dashboards

• Design a Dashboard and Export it to Flash format in SAP Business Objects dashboard design
• Insert a Flash object into a report
• Publish a Flash objects into the Web
• Creating Crystal Dashboards Using EPM Connector
• Explain Crystal Dashboards functions with BPC Data
• Display the content of a .txt file stored in Content Library
• Input data in BPC from Dashboards

Unit 15: Word and Powerpoint Integration

• Explain MS Word Integration with BPC 10.0
• Explain MS PPT Integration with BPC 10.0

Unit 16: BPC 7.5 Migration

• How to migrate BPC 7.5 Reports built with former EV Functions
• How to migrate BPC 7.5 EVDRE Reports

Unit 17: Others

• Work Status
• Audit
• Work Spaces

BOPC 10.0, NW Consolidation
Unit 1: SAP Business Objects Planning and Consolidation Framework

• Environment and Models
• Dimensions, Properties, and Loading Master Data
• Consolidation Logic

Unit 2: Data Collection and Preparation

• Transaction Data Collection
• Journal Entries and Balance Carry Forward
• Account Transformation

Unit 3: Consolidation Controls

• Execute Controls
• Review Controls

Unit 4: Currency Translation

• Currency Translation

Unit 5: Ownership Manager

• Setup Master Data to support Ownership Manager Calculations
• Setup Business rule Methods to support Ownership Manager Calculations
• Access the Ownership Manager Web Interface
• Create an Ownership Structure
• Execute Ownership Calculations

Unit 6: Consolidation of Investments

• Consolidation of Investment Concepts
• Consolidation of Investments Architecture

Unit 7: Inter Company Eliminations

• Inter Company Matching
• Inter Unit Elimination and US Elimination

Unit 8: Consolidation Monitor

• Explain Status information displayed in the Monitor
• Describe the running rules
• Describe incremental consolidation