7/25/2019 Sao ba bn

1/13

Introduction (1 Hr.)

Introduction to ERP, SAP, Data Warehouse

Overview of BW, BI, Data Base.

Overview of BW Architecture, Landscape

Basic Modeling (2 hr.)

Muti!Di"ensiona Star Sche"a #$assica Approach%

Muti!Di"ensiona Star Sche"a in BW #E&tended star Sche"a%

'he OLAP $oncept and differences (etween OLAP and OL'P

Business Modeling (20 Hr.)

Info Area

Info O()ect $atao*s

Info O()ects

PSA

Appication $o"ponent

Info Source

Data Source

'ransfer Rues

+pdate Rues

'ransfer Structure

7/25/2019 Sao ba bn

2/13

$o""unication Structure

Info Paca*e

'ransfor"ation

Data 'ransfer Process

Loadin* 'ransactiona Data into BW info $u(e

Loadin* MD with 'D into BW S-ste"

BW and BI $o"parisons

Master data oadin*!new #BI% E'L process

Info cu(e '-pes

Standard Info cu(e and Loadin* with new E'L Process

/enerate Report with BI "aster and 'ransaction Data

Manua +poadin* of MD ie Attri(utes, 'e&t, and 0ierarch-

Different '-pes of Attri(utes

'ransfor"ations, Rue t-pes

Routines (2 Hr.)

Start Routine

End Routine

E&pert Routine

DTP (Data Transfer Process) (1 Hr.)

7/25/2019 Sao ba bn

3/13

Standard D'P

Error D'P

Direct Access D'P

Rea ti"e D'P

DS (Data Store !"ect) (1 Hr.)

Standard DSO

Write opti"i1ed DSO

Direct update DSO

APD #Ana-sis Process Desi*n%

#$date Methods (1 Hr.)

2u updates

Initiai1ation

Deta +pdates

Info Pro%iders (& Hr.)

Muti Providers

Info set

3irtua Providers

Re!Modein*

Re!Partitionin*

7/25/2019 Sao ba bn

4/13

Open!0u( Destination

Data Marts

Info 'u!e Maintenance (2 Hr.)

A**re*ates

Ro!up

$o"pression

Reconstruction

Process Manageent (2 Hr.)

Process $hains, Process '-pes

Scheduin*

Monitor #0eader, Status, Detais%

Re$orting (1&Hrs)

Business E&porer

BE4 5uer- desi*ner

BE4 Ana-1er

BE4 WAD

BE4 Report Desi*ner

unctional %er%ie* of Be+ ,uer- Designer

Reusa!le ,uer- leents

7/25/2019 Sao ba bn

5/13

5uer- $ontros with 3aria(es

$acuated 6e- 2i*ures

Restricted 6e- 2i*ures

2or"uae

Structures

/aria!le Definition in Detail

$haracteristic vaues varia(es

'e&t 3aria(es

2or"ua 3aria(es

0ierarch- 3aria(e

0ierarch- 7ode 3aria(e8

Process T-$es

Manual in$ut

'ustoer e+it

Re$laceent $ath

SP +it

uthoriation

Ana-sis 2unctions

o $onditions

7/25/2019 Sao ba bn

6/13

o E&ceptions

Reportin* Dridown

o

Dridown to DSO fro" Info $u(e #RRI%

o $op-in* 5ueries fro" $u(es

o Be& Ana-1er

o Be& WAD

o Be& Report Desi*ner

o Mi*ration O()ects fro" BW 9.& to BI :.;

o 'ransportation

E&traction

o /eneric Data E&traction usin* MD

7/25/2019 Sao ba bn

7/13

SP B .1 'ourse 'ontent

undaental 'once$ts

Definitions of Data warehouse

0istor- of Data warehouse

$haracteristics of Data warehouse

Data Marts

7/25/2019 Sao ba bn

8/13

'a(es #Di"ensions and 2act 'a(es%

Star Sche"a, Snowfae Sche"a

7/25/2019 Sao ba bn

9/13

Depo-"ent $hec ist

Pre re4uisites of B

7on SAP appications as (acend

o ODB$ $onnection #9? @ (it Operatin* S-ste"%

6nowed*e on SAP BW BI #$u(es, BE4 >ueries%

6nowed*e on 0A7A

B #ni%erses

Universe Designer Tool UDT Information Designer Tool IDT

Personal Connection Local Connection (.CNX)

Shared Connection Secured Connection (.CNS)

Secured ConnectionData Foundation (.DFX) Connection, Context

and Alias, Parameters and LO!s

Lin"ed uni#erses

$usiness La%er (.$LX) Classes & o'ects,

ueries,

Parameters and LO!s and Na#i*ation +aths

-ni#erse +arameters, %+es o/ $usiness O'ects 0oins and their im+ortance

(Shortcut oin, heta 0oin etc.,)

Creation o/ O'ects and t%+es o/ O'ects (Dimension, 1easure and Detail)

Creation o/ Conditions

ra+ issues (Chasm and Fan)

Deri#ed a'les

-sa*e o/ 2/unctions 2 Prom+ts, 23here, 2Select, 2A**re*ate A4areness

%+es o/ 5ierarchies and usa*e in Drillin* /unctionalities

7/25/2019 Sao ba bn

10/13

1ana*in* Securit% /rom -ni#erse 6o4 and O'ect Le#el Securit%

5idin* and un hidin* O'ects

Chec" 7nte*rit% o/ Data Foundation and $usiness la%er

Sin*le data sources and 1ulti+le data sources

Per/ormance unin* methods

Business Intelligence Re$orts BBI .1

Adhoc Reports Canned Reports Dashboards

3e' 7ntelli*ence Cr%stal 6e+orts Xcelsius

Li#e O//ice 8Plu* in

tool

dhoc Re$orts

Web Intelligence Report

7ntroduction o/ 4e' re+ortin* Charts, t%+es o/ charts and #arious usa*e

7n/o Pro#iders9Data Pro#iders (-ni#erse,Personal data Files )

3or"in* 4ith s+ecial Functions

Creation o/ re+ortin*Con#ertin* 5ori:ontal, ertical, Cross a's into

Charts

;eneratin*

7/25/2019 Sao ba bn

11/13

Di//erence 'et4een Section & $rea" 5%+er Lin"in* Functionalities

Alerter-sa*e o/ 3e' 7ntelli*ence 6ich Client

A++lication

6an"in* Schedulin* o/ 3e'i 6e+ort

Sortin* Foldin* and -n/oldin* o/ 6e+orts

1er*ed DimensionsCom'ined ueries (-nion, 7ntersection and1inus)

'anned Re$orts

Crystal Reports

7ntroduction to C6 Field =x+lorer

-se o/ C6 and its /eatures 6e+ositor% =x+lorer & Data'ase =x+ert

Di//erence 'et4een $O and C6 6e+ort em+lates

Standard 6e+orts 7n'uilt Functionalities

$lan" 6e+ortSAP Plat/orm interaction $=X, Cu'es, 7n/osets etc.,

Cross a' 6e+ort 6D$1S Data'ases interaction

Creation o/ Ne4 C6 1S Access interaction

Di//erent Data source Connections

1aintenance and schedulin* o/ Cr%stal

6e+orts #ia $7 Launch Pad a++lication

Creation o/ C6 4ith -ni#erse

Creation o/ C6 4ithout -ni#erse

Creation o/ ;rou+s and Calculations

3or"in* 4ith Su' 6e+orts

Charts

Dash!oards

Dashboard Design (Static Dynamic!

7ntroduction to Dash'oards Data 1ana*er Connections

%+es o/ Dash'oards Data La%er

Data Sources (or) 7n/o Pro#iders Can#as la%er

7/25/2019 Sao ba bn

12/13

;eneration o/ dash'oards Com+onents La%er

3or"in* 4ith Data $% 6an*e, $% Series Pro+erties La%er

3or"in* 4ith Dual Axis dash'oard O'ects $ro4ser

3or"in* 4ith Calendar & $ar Chart

dash'oard

Li#e O//ice (-ni#erse, 3e' 7ntelli*ence, Cr%stal

6e+ort)

3or"in* 4ith Filter and multi+le Chartsdash'oard

AA3S Connecti#it%

Data 7m+ort and =x+orts uer% $uilder

5e! Based $$lications of SP B

BI 3aunch Pad

/eneration of We( intei*ence reports

Scheduin* of We(i and $r-sta reports

Sendin* of We(i and $r-sta reports

Stora*e of Loca docu"ents #Or*ani1e and "aintain docu"ents%

2oder structurin* (ased on Line of Business

Perforance Tuning Methods of SP B

'unin* at +niverse Leve

'unin* at Report Leve

'unin* at Data(ase Leve

5uer- Opti"i1ation Methods

rror Handling Methods

0ow to hande errors across the environ"ents in Rea 'i"e

scenarios.

7/25/2019 Sao ba bn

13/13

'rou(e shootin* tips and trics

Pro"ect +$lanation in ters of Real Tie scenarios

Pro)ect Overview #Life $-ce%

Pro)ect Do"ain E&panation

Desi*nin* the worfow

Pro)ect 'e"pates

Report Re>uire"ent 'e"pates

ssistance in Resue $re$aration

Resu"e preparation tips and trics

B rchitecture