TARAN INFOTECH, Fremont

Course Details

Course

Course: SAP BI 7.0/BW 7.3, ABAP Duration: 50 hours

Highlights of our training:

 Real time Industry Experienced Trainer.

 Interactive Training session using web conferencing tool

 Normal track, weekend and fast track classes according to convenience

 Student will be provided session recording capability to record each session

 We provide Training Material, Exercises and Real Time Examples

 Resume preparation and Certification Guidance

 We will provide class and demo sessions at student flexible timings.

 In training case studies and real time scenarios covered.

Introduction to SAP Business Intelligence

 SAP Net weaver BI Architecture / BI Platform

 Star Schema and Extended Star Schema

 Multidimensional modeling

 Entity Relationship Modeling

 Enterprise Data Modeling

 Enterprise Reporting, Query and Analysis

 SAP BW vs Other Data warehousing Tools

 Data Acquisition / Data Extraction concepts

SAP BW Phases

 Modeling

 Extraction

 Reporting

Modeling

 Info Area ,Info Object Catalogs

 Info Objects(Characteristics & Key Figures)

 Application Component

 Data Source

 Transfer Rules

 Info Source

 Update Rules

Contact: training@kaceetech.com / 828-708-7631

 Different types of Routines

 Info Package

 Transformations

 Data Transfer Process(DTP)

 Error DTP

 Metadata Repository

BI 7.0 Info Providers

 Master Data – Attributes, Texts, Hierarchies

 Standard DSO

 Write-optimized DSO

 Direct Update DSO

 Standard Info Cube

 Virtual Providers

 InfoSet

 MultiProvider

 Aggregation Level

 Others

 Open Hub Destination

 Analysis Process designer

BW 7.3 Info Providers

 SAP NetWeaver BW 7.3 Features Overview

 Graphical Data Modeling

 Graphical Data Flow Modeling Basics

 Data Flow Copying

 Data Flow Generation

 Data Flow Migration

 Advanced InfoProviders

 Semantically Partitioned Object (SPO)

 Hybrid InfoProviders

 Transient Providers

 The New BW 7.3 Hierarchy ETL

Business Content

 Importance of Business Content

 Business Content Installation & Activation

 Business Content Data Source, DSO’s, Cubes, Reports, etc…

Contact: training@kaceetech.com / 828-708-7631

Data Acquisition / Data Extraction

 Flat file Extraction

 Business Content Extractions using MD/TD SD,MM and FI

 Logistics Extraction

 Generic Data Extraction using MD/TD Tables

 Delta mechanism

 CO-PA Extraction

 FI-SL Extraction

 Data source Enhancement

Process Chains

 Process Chains, Process Types

 Scheduling

 Monitor (Header, Status, Details)

 Real time scenarios from support projects

Transport Mechanism

 Review of system Landscape

 Collecting Objects

 Creating Transports

 Releasing Transport

 Importing and Monitoring Transport

Reporting

 Introduction of Various Reporting Tools

Functional Overview of Business Explorer Query Designer

 Introduction of BEx Query

 Reusable Query Elements

 Filters, Columns & Rows

 Characteristic Restrictions & Free Characteristics

 Formulas & Calculated Key Figures

 Restricted Keyfigures and Variables with Texts

 Report to Report Interface or Jump Starts

 Query Extracts using RSCRM_BAPI

 Exceptions, Conditions, Structures, Cell Definitions and others

Business Explorer Analyzer

 Introduction to BEx Analyzer

 Filtering Option

 Properties available in Analyzer

Contact: training@kaceetech.com / 828-708-7631

Performance Improvement

 Aggregates

 Compression

 Re-Modeling

 Re- Partitioning

 Indexes and DB Statistics

 Number Range Buffering

 Read Mode & OLAP cache

 Line Item Dimension & High Cardinality

 Read Mode & OLAP cache

 Business Warehouse Accelerator

 Others

Types of Projects

 Real Time Implementation Projects

 Up-Gradation project

 Enhancements to the existing Implementation project

 Support projects

Introduction to SAP ABAP

 What is SAP

 SAP Architecture and where ABAP fits in

 ABAP Development Workbench Tools

 Object Navigator

 Workbench Organizer

 Data Dictionary

ABAP Dictionary

 Tables

 Views

 Lock Objects

ABAP Programming Techniques

 Reports Statement

 Line Size

 Line-count

 Message

 Page Heading

 Report Comment Section

Contact: training@kaceetech.com / 828-708-7631

 Declarations

 Tables

 Includes

 Variables (Data Types and Data Objects)

 Structures

 Internal Table

 Constants

ABAP for SAP BI Consultant:

 Field level Routine

 Start Routine

 End Routine

 Expert Routine

 Infopackage level Routine

 DataSource Enhancements

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course

Course: SAP Business Objects XIR3.0/3.1, BI 4.0 & 4.1 Duration: 50 hours

Highlights of our training:

 Real time Industry Experienced Trainer.

 Interactive Training session using web conferencing tool

 Normal track, weekend and fast track classes according to convenience

 Student will be provided session recording capability to record each session

 We provide Training Material, Exercises and Real Time Examples

 Resume preparation and Certification Guidance

 We will provide class and demo sessions at student flexible timings.

 In training case studies and real time scenarios covered.

SAP Business Objects Web Intelligence and BI Launch Pad 4.0

 Introducing Web Intelligence

 BI launch pad: What's new in 4.0

 Customizing BI launch pad

 Creating Web Intelligence Documents with Queries

 Restricting Data Returned by a Query

 Report Design in the Java Report Panel

 Enhancing the Presentation of Reports

 Formatting Reports

 Creating Formulas and Variables

 Synchronizing Data

 Analyzing Data

 Drilling

 Filtering data

 Alerts

 Input Control

 Scheduling (email)

 Data Refresh introduction

 Sharing Web Intelligence Documents

SAP Business Objects BI Information Design Tool 4.0

 Create a project

 Create a connection to a relational database

 Create a data foundation based on a single source relational database

 Create a business layer based on a single relational data source

 Publish a new universe file based on a single data source

 Retrieve a universe from a repository location

 Publish a universe to a local folder

 Retrieve a universe from a local folder

 Open a local project

 Delete a local project

 Convert a repository universe from a UNV to a UNX

 Convert a local universe from a UNV to a UNX

Contact: training@kaceetech.com / 828-708-7631

Connecting to Data Sources

 Create a connection shortcut

 View and filter data source values in the connection editor

 Create a connection tan OLAP data source

 Create a BICS connection to SAP BW for client tools

 Create a relational connection to SQL Server using OLEDB providers

Building the Structure of a Universe

 Arrange tables in a data foundation

 View table values in a data foundation

 View values from multiple tables in a data foundation

 Filter table values in a data foundation

 Filter values from multiple tables in a data foundation

 Apply a wildcard to filter table values in a data foundation

 Apply a wildcard to filter values from multiple tables in a data foundation

 Sort and re-order table columns in a data foundation

 Edit table values in a data foundation

 Create an equi-join, theta join, outer join, shortcut join

 Create a self-restricting join using a column filter

 Modify and remove a column filter

 Detect join cardinalities in a data foundation

 Manually set join cardinalities in a data foundation

 Refresh the structure of a universe

Creating the Business Layer of a Universe

 Create business layer folders and subfolders

 Create a business layer folder and objects automatically from a table

 Create a business layer subfolder and objects automatically from a table

 Create dimension objects automatically from a table

 Create a dimension, attribute , measure

 Hide folders and objects in a business layer

 Organize folders and subfolders in a business layer

 View table and object dependencies

 Create a custom navigation path

 Create a dimensional business layer from an OLAP data source

 Copy and paste folders and objects in a business layer

Filtering Data in Objects

 Create a pre-defined native filter

 Create a pre-defined business filter

 Create a pre-defined native filter using multiple objects

 Create a pre-defined business filter using multiple objects

 Working with Derived Tables

 Visualizing Data in a Universe

 Building a Multi-Source Universe

 Working with Parameters and Lists of Values

 Resolving Loops in a Universe

 Managing and Deploying Universes

Contact: training@kaceetech.com / 828-708-7631

SAP Crystal Reports

 Planning a Report

o Define database concepts

o Plan and develop a report prototype

 Creating a Report

o Create a report

o Add tables

o Describe the design environment

o Insert objects on a report

o Preview a report

o Save a report

o Position and size objects

o Format objects

 Selecting Records

o Define the Select Expert

o Determine the criteria for record selection

o Understanding saved and refreshed data

o Apply record selection

o Apply additional record selection criteria

o Modify record selection

o Apply time-based record selection

 Organizing Data on a Report

o Sort records

o Group records

o Summarize data

 Formatting a Report

o Add graphical elements

o Combine text objects with database fields

o Apply specialized formatting

o Insert fields with pre-built functions

 Applying Section Formatting

o Format sections

o Create a summary report

 Creating Basic Formulas

o Define a formula and its purpose

o Create formulas

o Apply Boolean formulas

o Apply If-Then-Else formulas

o Apply date calculations

o Apply number calculations

o Apply string manipulation

 Applying Conditional Reporting

o Determine trends in data

o Format data conditionally

 Representing Data Visually

o Create a chart

 Distributing a Report

o Export a report

o Save a report to Business Objects™Enterprise

Contact: training@kaceetech.com / 828-708-7631

Crystal Reports - Business Reporting Solutions

 Using the Repository

o Use the repository

o Create a report from a repository data source

 Creating Formulas

o Use functions and operators

 Managing Reports

o Use the Workbench

o Publish reports to Business Objects Enterprise

 Using Variables and Arrays

o Use variables

o Use arrays

 Using Report Templates

o Apply report templates

o Build a template without a data source

o Remove a template

 Building Parameterized Reports

o Define and create parameters

o Build a report with multiple parameters

o Use edit masks and descriptions

o Create a date range parameter

o Group using parameters

 Summarizing Data with Crosstabs

o Build a basic crosstab

o Format a crosstab

 Using Report Sections

o Use sections

o Use group related functions to format sections

o Use section underlay

o Use multiple-column reporting

 Building Specialized Reports

o Use the Running Total Expert

o Create a form letter

o Add a hyperlink to a report

o Use Dynamic Graphic Locations

o Build a report with alerts

o Build a top N report

Crystal Reports: Report processing strategies:

 Report Processing

o Use multi-pass reporting

o Use evaluation time functions

o Use a dynamic array

 Using Subreports

o Define subreports

o Create an unlinked subreport

o Create a linked subreport

o Create an on-demand subreport

o Use shared variables with subreports

o Link "unlinkable" data with subreports

o Describe alternate solutions to using subreports

Contact: training@kaceetech.com / 828-708-7631

SAP Business Objects Dashboards 4.0

 What's new in SAP Business Objects Dashboards 4.0

 Creating a Visualization

 Producing interactive visualizations

 Getting around in Xcelsius

 Working with your Excel workbook

 Visualizing data with charts

 Using Xcelsius Components

 Formatting a Visualization

 Applying formatting options

 Using themes and templates to apply formatting

 Adding Interactivity to a Visualization

 Using selectors

 Adding dynamic visibility

 Troubleshooting interactivity

 Creating a Connected Visualization

 Using live data sources

 Connecting to XML Data

 Connecting to BO Universes using Query as a Web Service

 Using Live Office data

 Working with Business Requirements

SAP Business Objects BI 4.0 CMC (Central Management Console)

 Setting up groups and users

 Organizing and changing Folders & Categories

 Time Out sessions

 Authentication

 Managing Servers

 Connections

 Controlling Universes

 Scheduling through CMC

 Publication

 User Security

 Database Configuration

 Modify Settings for Applications

 Access Levels

 Security

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No

Course Details

Course

Course: SAP FICO Duration: 45-50 hours

Highlights of our training:

 Real time Industry Experienced Trainer.

 Interactive Training session using web conferencing tool

 Normal track, weekend and fast track classes according to convenience

 Student will be provided session recording capability to record each session

 We provide Training Material, Exercises and Real Time Examples

 Resume preparation and Certification Guidance

 We will provide class and demo sessions at student flexible timings.

 In training case studies and real time scenarios covered.

Introduction to SAP R/3

1. Introduction to Business Analysis

2. Advantages of SAP over other ERP packages

3. Introduction to SAP R/3 FICO

FINANCE

Financial Accounting Basic Settings

1. Enterprise Structure

2. Company

3. Company Code.

4. Assign Company Code to company

5. Fiscal Year

6. Posting Period

7. Field Status Variant

8. Posting Keys

9. Chart of Accounts

10. Assignment of chart of accounts.

11. Account group.

12. Retained Earnings

13. Document Number Range

14. Document Type

General Ledger

1. GL account creation.

2. GL account change

3. GL account blocking & unblocking.

4. GL accounts display.

5. GL accounts balance display.

6. Document Display

7. Document Change

8. Changed Documents Display.

9. Document Holding

10. Document Parking.

11. Document Reversal

12. Individual Reversal

13. Reversal of reversal Contact: training@kaceetech.com / 828-708-7631

14. Mass Reversal

15. Accrual/Deferral Reversal

16. Cleared Item Reversal

17. Sample Documents

18. Recurring Documents.

19. Interest Calculation

20. Foreign currency revaluation.

21. Open Item management

22. Tolerance group for GL accounts & employees.

Accounts Payables

1. Account Group Creation

2. Number Range Creation

3. Document Number Ranges

4. Assign Number Ranges

5. Tolerance group for vendors.

6. Vendor Master Data

7. Reconciliation Account

8. Purchase invoice posting

9. Payment to vendors.

10. Open Item management.

11. Own Payment Terms Creation

12. Automatic Payment Program

13. Discount Received

14. Special G/L Transactions

Account Receivables

1. Account Group Creation

2. Number Range Creation

3. Document Number Ranges

4. Assign Number Ranges

5. Tolerance group for Customers

6. Customer master data

7. Reconciliation Account

8. Sales invoice posting

9. Payments from Customers

10. Open Item management.

11. Discount allowed.

12. Special G/L Transactions:

13. Tax on Sales and Purchases

Reports

1. Financial Statement Version

2. Reports in GL accounting

3. List of accounts

4. Ledger

5. Financial Statements

6. List of Journal Entries

7. Reports in Accounts Payable.

8. Ageing Analysis

9. Vendors list

10. Vendor Open items list

11. Cleared items list.

12. Reports in Accounts Receivable.

13. Customers list

14. Customer Open items

15. Cleared Items list Contact: training@kaceetech.com / 828-708-7631

Asset Management Overview

Integration

1. SD-FI Integration

2. MM-FI Integration

CONTROLLING

Basic Settings of Controlling

1. CO. Org. Structure

2. Maintain Controlling Area

3. Maintain Number Ranges

4. Maintain Versions

Cost Element Accounting

1. Manual Creation of Cost Elements

2. Automatic Creation of Cost Elements

Cost Center Accounting

1. Creation of Cost Center

2. Define Cost Center Group

3. Cost Center Standard Hierarchy

4. Posting to the Cost Center,

5. Display CO. Document

6. Display Actual Line Items

7. Statistical Key Figures

8. Reposting Of Line Items

9. Reposting of Cost (Manually)

10. Periodic Reposting

11. Distribution, Distribution cycles

12. Run Distribution cycles

13. Assessment, Assessment Cycles

14. Run the assessment Cycles

15. Planning

16. Differences between periodic reposting& Distribution

17. Differences between distribution and assessment.

Internal Order

1. Activate Order Management in CO. Area

2. Maintain Settlement Profile, Number Ranges for Settlement Documents

3. Maintain Allocation Structure

4. Define Order Type

5. Number Ranges for Orders

6. Creation of Internal Orders

7. Define Settlement Rule in Order Master Data

8. Posting of Values – Statistical and Real

9. Settlement of order

Profit Center Accounting

1. Dummy Profit Center

2. Creation of Profit centers.

3. Assign Cost Center to Profit Center Contact: training@kaceetech.com / 828-708-7631

4. Automatic Account Assignment of Revenue Elements

5. Number Ranges for Documents

6. Posting – Revenue and Expenses

Profitability Analysis – Overview

Product Costing (Basics)

1. Define Material Master

2. Creation of work center

3. Define Routing

4. Costing sheet

5. Costing run.

6. Legacy System Migration Work Bench – It’s a Migration tool.

Other Information

Course Fee: Not Mentioned

Course Duration: Not Mentioned

Placement Provided: No