SAP BIW/BI Course Content online training and class room training

SAP BW / BI (7.4& 7.5) Training course contents 
Modeling:

1. SAP Net Weaver and BI: Overview, Positioning and Fundamentals

i.       Fundamentals of Data warehousing and Business Intelligence

ii.      SAP Netweaver Business Intelligence (BI) overview

iii.     SAP Netweaver Solution Delivery: IT Practices, scenarios and usage Types

iv      SAP NetWeaver Business Intelligence: Data Warhousing Overview.

 2.  Objects in the BI Data Warehouse Layer

i      Data Warehousing Workbench

ii     Infoproviders: Business Purpose

iii     Infoobjects: Characteristics

iv     Infoobjects: Key figures

v     The BI Infocube: An extended Star Schema

vi    Creating Infocubes

 ૩   Data Acquisition and Transformation from SAP Source Systems
aData Flow: Overview
 
bLoading Master Datasource from an SAP source System

cLoading Transaction Datasource from an SAP source System

4 Data Acquisition from other systems

aExtraction from Non sap systems: Overview

bFlat file Loading

5 BI Content

aBI content discovery

bBI content Activation

6 Other Infoproviders

aDatastore objects

bVirtual providers and Real time data acquisition

cMultiprovider and BI Infoset

7 Administration of Data Targets

aSystem administration tasks in BI: Overview

bAdministration of infocubes

cAdministration of Datastore objects

dProcess chains

8 Introduction to query Performance Optimization

aIntroduction to query Performance Optimization in BI

bBI Aggregates

cBI Accelerator

Reporting

1.         Introduction to BI Enterprise reporting

2.         Navigation in reports

3.         First steps in the Bex query designer

           Query designer

            Infoprovider in the Bex query designer

4.         Key figures

a.         Restricted Keyfigures

b.         Calculated keyfigures

c.         Properties of Keyfigures

d.         Structures and cells

5.         Characteristics

a.         Properties and attributes of characteristic

b.         Integrating hierarchies into report

c.         Creating user defined hierarchy

6.         Variables

7.         Exception and conditions

8.         Bex analyzer

9.         Bex web analyzer

10.       Information broadcasting

a.         Information broadcasting overview

b.         Bex broadcaster

c.         Workbook precalculator

11.       Enterprise portal integration

12.       Document integration

13.       Report –report interface

14.       Managing query objects

15.       Business content

16.       Further SAP BI reporting tool.

Advance Modeling and Extraction
1.         Overview of BI

a.         Overview of data acquisition

b.         Bi content

2.         Data flow in data acquisition

a.         Data flow summary

b.         Transformation process

c.         Direct access to source system

d.         Real time data acquisition

3.         Data acquisition in Service API

a.         Connecting SAP source system to BI system

b.         Basic of the BI S API

c.         Transfer of Business content

d.         Logistic data acquisition

e.         Generic data acquisition

f.          Enhancement of BI content data source

4.         Transfer of flat file

5.         Data acquisition with DB connect

6.         Process chain

a.         Process chain design

b.         Managing process chain

7.         Report performance

a.         Design

b.         OLAP caching

8.         BI statistic and monitoring

9.         Aggregates

10.       BI accelerator

11.       Security component in BI

12.       Security data access for report user

13.       Saving bex object in BI roles

14.       Securing data access for advance user

15.       Maintain authorisation

Additional functions in 7.5

CASH JOURNAL

CASH JOURNAL

1)    To view daily cash and ban opening balances, Receipts , Payments and closing balance  

2)    GL Cash account accepts negative cash balance –Cash Journal will not accept negative cash balance

3)    For petty cash purpose

1.   Creation of GL master –Petty cash account –Current assets-Loans & Advances (FS00)

Give the GL A/c No.                         :200101

Company code                                 :AML

Select with template button

Give the GL A/c No.                         :200100

Company code                                 :AML

Enter

Change short text and GL a/c long text to Petty Cash A/c

Select create /bank /interest tab

Select post automatically only check box

Save

Define number rage intervals for cash journal documents

Path :SPRO-Financial accounting –bank accounting –Business transactions-Cash journal –Define number range intervals for Cash journal Documents (FBCJC1)

Give the company code                  :AML

Select change intervals button

Select interval button

No.range                                           :01

From no.                                            :500001

To no.                                                 :600000

Enter & Save

Ignore the warning message press enter

Setup cash journal (FBCJC0)

Same path

Select new entries button

Company code                                 :AML

Cash journal no.                              :0001

GL A/c No.                                         :200101

Currency                                           :INR

Document type for GL A/c              :SA

Document type vendor payment              :KZ

Document type vendor receipt      :KZ

Document type customer payment          :DZ

Cash Journal name,                                   :AML HYD petty cash

Save

Press enter to save in your request

Create ,Change delete business truncations (FBCJC2)

Same path

Select new entries button

Company code                                 :AML

Business transaction type              :select R Revenue

G/L A/c                                               :300000

Cash journal business transaction          :Revenue

Select account modifiable check box

Company code                                 :AML

Business transaction type                          :select E Expenses

GL A/c No.                                         :400100 Salaries A/c

Cash journal Business transaction :Expenses

Select account modifiable check box

Save

Press enter to save in your request

Setup print parameters for cash journal

Select new entries button

Company code                                 :AML

Cash journal print program name            :RFCASH00

Report variant                                   :DEMOEN (Demo English)

Correspondence                              :select SAP18 Cash document

Save

Press enter to save in your request

Posting to Cash journal

Path :Accounting –Financial accounting –General ledger –Posting –Cash journal posting (FBCJ)

From the menu select Extras à Change Cash journal

Give your company code               :AML

Cash journal                                                 :0001

Enter

Select cash receipts tab

Business transaction                      :select Revenue

Amount                                              :5000

Business area                                  :AMLH

G/L A/c                                               :300000 Sales A/C

Text                                                     :Cash sales

Save

Select post button

Select print cash journal button

Ignore the message press enter

SAP FI Realted Sales

SALES

Sales invoice posting (F-22)

Give the document date     :Today’s date

Type                                       :DR

Company code                     :AML

Posting key                           :01

Reference bill no.                :2345

Account                                 :6600001

Enter

Amount                                  :100000

Business area                                  :AMLH

Text                                         :Sales invoice posting

Posting key                           :50

Account no.                          :300000 Sales a/c

Enter

Amount                                  :*

Business area                                  :AMLH

Text                                         :+

Document –simulate & Save

Manual check deposit

Path :Accounting –financial accounting –Banks –Incomings –check deposit –manual entry (FF68)

 From the menu select settings à Specifications

Start variant               :select AML1

Enter

Bank key                   :AMLIDBI1

Bank account                       ;AMLIDBI1234

Currency                   :INR

Group                                     :1 (paying slip no.)

Transaction               :select AML1 (check receipt clear customer )

Posting date              :Today’s date

Value date                 :Today’s date

Currency                   :INR

Enter

Amount                      :100000

Reference no.                      :2345 (bill no.)

Business area                      :AMLH

Customer no.                        :6600001

Enter & save

Save once again

From the menu select System –>services à Batch input à Sessions à select session name :IDBI-IDBI1

Select process button

Select Display errors only radio button

Select process button

We get a message processing of batch in put session completed

Select exit batch input button

Go and See the customer A/c FBL5N

Give the customer no.6600001

Company code         :AML

Select cleared items radio button

Select normal items check box

Execute

Double click on type DZ

Select column document overview button

Check deposit credit in bank statement

Path :Accounting –Financial accounting –Banks-Incoming –Bank statement –manual entry (Tr code is FF67)

From the menu select settings –specifications

Start variant                           :select AML2

Enter

Bank key                               :AMLIDBI1

Bank account                                   :AMLIDBI1234

Currency                               :INR

Give the statement no.                    :1

Statement date                     :Today’s date

Opening balance                 :0

Closing balance                   :100000

Posting date                          :Today’s date

Enter

Ignore the warning message press enter

Transaction                           :select AML2 check deposit in bank

Value date                             :Today’s date

Amount                                  :100000

Give the reference doc no. :1 (That is paying slip no.)

Business area                                  :AMLH

Enter & Save

Save once again

From the menu select System –Services –Batch input àsession

Select session name                      :IDBI –IDBI1

Select process button

Select display  errors only radio button

Select process button

Ignore the message and exit batch input button

Go and see the IDBI check deposit A/c (FBL3N)

Give GL A/c No.                    :200132

Company code                     :AML

Select cleared items radio button

Select normal items check box

Execute

Double click credit 100000

Select call up document overview button

1.         Purchases

Purchase invoice posting F-43

Give the document date                 :Today’s date

Type                                                   :KR

Company code                                 :AML

Posting key                                       :31

Account no.                                      :4200001

Enter

Give the amount                              :20000

Business area                                              :AMLH

Text                                                     :Purchase invoice posting

Posting key                                       :40

Account no.                                      :200120 Inventory RM

Enter

Amount                                              :*

Business area                                              :AMLH

Text                                                     :+

Document –Simulate and Save

2.         Outgoing payment with clearing (Tr code is F-53)

Give the document date                 :Today’s date

Type                                                   :KZ

Company code                                 :AML

Clearing text                                     :Outgoing payment

Account under bank data               :200131 (IDBI cheque issue date)

Business area                                  :AMLH

Amount                                              :20000

Text                                                     :Outgoing payment

Account under open item selection :4200001

Select process open item button

Double click on payable amount :20000

From the menu select Document --Simulate & Save

3.         Manual check creation (FCH5)

Give the  check no.100010

Save

4.         Enter manual bank statement (FF67)

Select overview button (F8)

Keep the cursor on AML IDBI Bank Ltd

Select new statement button

Closing balance (100000-200000)=800000

Posting date                          :today’s date

Enter

Transaction                           :AML3 check issue clearing in Bank

Value date                             :today’s date 

Amount                                  :20000 with minus

Bank reference                    :100010 (cheque no.)

Business area                                  :AMLH

Enter

Select save button , save once again

From the menu select System –Service –Batch input –Sessions

Select session name          :IDBI-IDBI

Select process button

Select Display errors only radio button

Select process button

Ignore the message exit batch input button

Go and see IDBI cheque issue account (FBL3N)

Give the GL account                       :200131 IDBI cheque issue account

Company code                     :AML

Select cleared items radio button

Select normal items check box

Execute

Double click on debit 20000

Select call up document overview button

Bank charges Direct debits 

Enter manual bank statement FF67

Select overview button

Keep the cursor on AML IDBI Bank Ltd

Select new statement button

Give the closing balance    :79500

Posting date                          :Today’s date

Enter

Transaction                           :AML4 Bank charges direct debits

Value date                             :Today’s date

Amount                                  :500-

Business area                                  :AMLH

Enter & Save

Save once again

From the menu select System –Services –Batch input –Session

Select session name :IDBI –IDBI-1

Select process button

Select display errors only radio button

Select process button

Ignore the message and select exit batch input button

To view the document posted (FB03)

Enter

To view bank statements in SAP FF67

Select overview button

Double click on AML IDBI Bank Ltd

To view the transactions in the statement

Double click on statement no.