SAP BW IP Some Sample Notes

Integrated planning---370-planing tool-------by sap in bi-----bw/////////bps----business planing and simulation////////outlooksoft5.0----bpc7.0(business planing and consolidation


bi--integrated planing

organization-----sales dept------------level1//2/3/4/------------level -----planing requiremnts


sales mgr-------regional mgr------------------divisional mgr---------salesmgr marketing

user level-----plang requiremnets


plang environment-------------------user cn plan-manual plang/////automated

1.design the plang environment
2.manual plang------analsyer(plang workbooks)/web application designer(plang web templates)
3.automated palng-------------anlyser/web application desinger

historical data-----------report-------report pland data-----variance 

1.planing enivironment---------elemnts-------------planing modeler------------------web based

 1.info provider
 2.aggergation level
 3.filter
 4.planing function
 5.planing seaquence

1.info providers:for planing real time info cube------------multi provider with real time info cube-----read nad write optimized



createion of a real time info cube:

2.aggergation level:it is the combinations of the chars and key figures on which user wants to go for plang,wrt each user levels we have to design one aggregation level

smgr-----teriirtory-----------aggr1
rsm-----terrritori---prd availability-----aggr2
dsm----terr/prd/sales returns-------------aggr3

 if u r going fro manaula planing or automated plang---the aggergation level is the base-----input ready queries--they can be designed on aggrgation levels


3.Filters:for selctions---------even if u want to go for plang wrt some specific values-------prd/prd group---(new)

4.plang functions:using plang function we can go for automated plang///ther r some sap deliverd plang functions,,,,usiing those we can go for automated plang

 sap///customer

for customer function-----------formulas-------

sap deliverd :
 a.Delete:if we want to delet the plang data--use this delet function
 2.copy-----------copy the actulas into plang info cube
 3.revaluate----------------100+10%--------------
 4.repost-----delet the existing plang data and to post new values use this function

5.plang seaquence:using this we can execute plang functions in a seaquence---delte/copy/revaluate--similar to process chains


note:plang environemnt/////manual plang///automated plang


MANUAL PLANING:
 1.DESIGN READY FOR INPUT QUERY---------ON AGGERGATION LEVEL
 2.DESIGN WORKBOOK/WEB TEMPLATE



aggr1-----user---query
aggr2--------user2------qu2
aggr3-------user3----------query3



integrated plang-------

1.Info provider-real time info cube/////multiprovider---real time info cube

 actuals data---std info cube
 plan data---real time info cube---multi provider

2.aggregation level:combinations of char and key figure on which each user level is planing

3.filter-----value selctions

4.plang functions-sap/customer------copy/delete/revaluate/repost/////customer---formulas

5.plang seaquence-----to execute theplang functions in a seaquence


MANUAL PLANING--READY FOR INPUT QUERY---AGGREGATION LEVEL



data source migartions---3.x data source must be migrated to new 7.0 data source concept

ss(ds)--ts---psa--tr--cs--ur--dt

ss---ip------ds---------trftn---dtp----dt

in 7.0 --no ts/tr---even when u migrtae the data source the transfer stru and transfer rules r deletd---migrated new netwevare data source concept


rsds------------to migrate the data source-------------with export////with out export
with export----------ts/tr-----taken back up
withyout export-----------------no recover 3.x ts/tr

3.x ds---square


bi accelerator----------indexing server----icubes data------mantin indexs---sap--hp/ibm----hardware component

bw accelerator-

bi------------sdn.sap.com----bi-bw------------------------7.2------bo toll-pioneer

bi server-------bi aceerator----------------------------rsadmin

planing modeler

info provider---real time inf ocube///multi provider

aggreagtion level

filter

plang functions-------------------automated plang--delet/copy/revaluate




copy-------actuals infocube/real time infocube

chars----------------chars
time charsnov2009--------tme chars(nov2010)
key figure-----key figure


us-------------------sales/cost/rev--------------nov2009////////////////nov2010

SAP BW Extraction Overview Basics -Sample Notes

Business inteligence---DELTAS-----DBW70E///DBW70R///DB70P
service orinted architecture----sap---Netweaver---2004(bw 3.5)/2004s(bi 7.0)


Netwevaer---------user integartion///information integration//process integration///devolopmnt plat forma


information integration---bi--------EDW///ERQA///BUSINESS PLANNING

1.EDW----------ENTERPRIZE DATA WAREHOUSE---DESIGNG THE DW//ACQURING THE DATA  TO DW//MAINTAING THE DW

2.ERQA--------ENTERPRIZE REPORTING AND QUERY ANALSYS---BEX SUITE--Query deisgner///Analyzer///web Application designer///web anlzyer////bex broadcaster///Report designer///visual composer

3.Business planing----Integrated plang


EDW:DELTAS

3.X DATA FLOW

SS(DS)---TS---PSA--TR---CS--UR---DT

IN 7.0

1.IN 7.0 NO TRNASFER STRU/NO PSA-----DATA SOURCE(NW DS)(UR DATA SOURCE IS PSA)----3 TYPES OF NW DS---TRNSACTION DATA LOADING///MDAT--ATTR/TEXT///NO HIERACHIES R SUPPORTED FOR NW DS ---3.X TS CONCEPT TO LOAD THE HIERACHYS

2.NO Transfer Rules(TR)/NO UPDATE RULES(UR)------------BOTH R REPLACED BY TRANSFORMATION-----TYPES OF TRANSFORMATIONS
---INFO OBJECT////CONSTANT/FORMULA///ROUTINE-----END ROUTINE///EXPERT ROUTINE

 End routine is used after the transformation
 start routine----before transformation
 Expert routine---used in with in the Transformation

3.Infosurce---communication stru---is optional--not mandatory

4.Dat targets-------Master data--------char table/////Trnsaction data---Ods//DSO(data store object)
 3.x(ods)  7.0(DSO)
 standard  standard
 transactional Direct update Dso
   Write-optimized dso

 info cube-----Std info cube///Virtual providers(remote cube)////Trnsactional infocube---Real time info cube

infosets-in 3.x---ods/chars but in 7.0 we can also include infocubes into the infosets(max of 2 info cubes)

Multi providers---ic/ods/chars/infosets in 3.x but in 7.0  Aggregation level in to multiporvider


SS------info package-----------DS---------transfromation-------------DT(Mdata---Insert char As Infoprovider///DSO/Icube)


5.in 3.x info package can load data to data targets--but in 7.o info package can load data till data source only

in 3.x only std info package//but in 7.o we have one more---i.e--real time/push enabled info package

6.using DTP (Data transfer process)---we can load data from data source to data targets
 1.standrd dtp
 2.dtp for direct acesss
 3.error dtp
 4.real time dtp

7.Error stack:but in 7.0 all the error record r updated to error stack--modify--error dtp load to data targets
8.Bi accelerator-------------indexing server---indexs(accelerator)--improves the query performance---server
9.Daemon:in 3.x minimum delta inetrval--hourly//but in 7.0 using Daemon we can trigger info package and Dtp every minute



SS(1)------IPACK(5)-----------DS(2)---------TRANSFERMATION-(4)--DTP(6)---------DT(3)(DSO/ICUBE/MDATA--CHAR)




1.Devolop the info objects---chars(attributes)/and key figures
2.Master data loading--attr/text
3.Transaction data loading--DS/info cube


Employee-----attr/text

SS(1)--IP(5)--------DS(2)-------------TRFTN(4)---DTP(6)--------DT(3)


emp----emp name///add/dsg

1.SEE TO THAT SOURCE IS AVAILABLE
2.CREATE DATA SOURCE--MDATA --ATTR
3.INSERT CHAR AS DATA TRGET
4.CREATE TRANSFROMATION-----TRFTN CAN BE CREATED FROM THE SOURCE AND TARGET ALSO
5.CREATE INFO PACKGE---SOURCE
6.CREATE DTP---SOURCE/TARGET

Trnsaction data loading

sys architecture------------DSo(data Source Object) to info cube

ss-----dso---info cube
2333333333333333333

1.create info cube---ext star schema
2.create dso
3.load data to dso///activate dso
4.DSo to info cube load the data


SS(1)------INFOPACK(5)-----------DS(2)------TRFTN(4)--DTP(6)---DT(3)


DSO------TARFTN--DTP--INFOCUBE



VIRTULA PROVIDER//////////REMOTE CUBE(DIRECT DATA ACQUISTION)

SS--- TO BI SYS--PHYSICALLY DATA IS MOVED--IN DDA-NO DATA IS STAGED---DATA IS THERE IN SOURCE ITSELF BUT FOR OUR REPORTS WE ACESS DIRECTLY SOURCE SYS DATA USING REMOTE CUBE

STOCK MARKET----

LESS VOLUME OF DATA
LESS NO OFUSERS ADVISABLE---------------------OLTP SYS PERFORMANCE IS DEGRADED



1.SS--SOURCE--FILE
2.CREATE DATA SOURCE-------ENABLE DIRECT ACESS
3.REMOTE CUBE--
4.CREATE TRANSFORMATION
5.CREATE DTP----DIRECT ACESS
6.ACTIVATE DIRECT ACESS

Error stack and Error dtp

psa---status--red

but in 7.0 all the error records r updated to error stack,,there u can modify the records and from there using error dtp we can load the data to target

1..source sys
2.Data source
3.Data target(icube)
4.Transformation
5.info package
6.stand dtp(ds to dt)---
7.error stack---eror records---modify the record
8.create error dtp--load it



REPARTIONING-----------------------------IN 3.X PARTIONING
THIS REPARTIONING IS NOT THERE IN 3.X


PARTIONING---------E FACT TABLE------2 TIME CHARS----------CALYERA/MONTH////FISCAL YEAR PERIOD

IF THE DATA IS MORE HISTORICAL--10 YRS OF DATA(1996---2005) ---QUERY-----IT HASE TO READ ALL THE DATA----PRESENT THE REQUIRED DATA


YEAR---PARTION----P1---TILL 96//////97-----P2//98--P3/-------------2005---P10----AFTER 2005--AFTER END DATE PARTION 

NO OF PARTIONS-------------SYS CREAET 2 ADDTIONAL PARTIONS---BEFORE STAR DATE///AFTER END DATE

PARTIONING IMPROVES QUERY PERFORMANCE-------QUERY---YEAR--2004-----MINIMIZE DATA BASE READ TIME


IN 3.X REPARTIONG IS NOT ALLOWED BUT IN 7.0--REPARTIONG IS ALLOWED---MERGING OLD PARTIONS///ADD NEW PARTIONS


1.BACK UP THE DATA BASE
2.STOP PROCESS CHIANS RUNNING ON THAT INFO CUBE
3.AFTER PARTIONING CHECK THE TRANSFROMATION
4.AGGREGATES
IN 3.5---PARTIONING IS NOT ALLOWED WITH DATA//////BUT IN 7.0--REPARTIONING IS ALLOWED WITH DATA



REMODELING:THIS IS NOT THERE IN 3.5////USING REMODELING WE CAN MAKE STRUCTURAL CHANGES TO THE INFOCUBE


ADD CHARS///KEY FIG
DELET A CHAR///KEY FIGURE
///REPLACE A CHAR /////KEY FIGURE


SAME PRECAUTIONS:

bex suite-----query deigner/analyser///report deisnger///bex broadcaster////visual composer///------enterprize portal


1.Query designer----to design the queries---query elemnts-----user interface

2.Analyser:excel based fronend tool------------Design mode///Analysys Mode
 Design mode---for user---design items like web items ---using this we can design the workbooks////---design items---table/dropdown/push button/checkbox/radiobutton

 Analsys mode--for buser---borwsoe all his workbooks


3.web application designer:using this we can design web template---html///but in 7.0 xml html scrpting
migrate 3.x templates to 7.0-migration tool

all the other reporting elements when they r opend with new toola they r automatically migrated


4.Report designer-------crystal reports----formated reporting---rows/columns/images/logos/headre/fotters//pdf 

visual composer---------------dashborads----iviews---customized by using ui controls

dropdown///pushbutton///radiobutton/checkbox

ui controls similar to web items-----iviews:-------visual composer------the input is from queries-sap bi sys---------sap sys---badi/bapi

sap bi sys--------------queries----------iview--------selections----input selctions/////////out put selections


iview------can be configured by using ui controls





sap erp-----applications------functional applications-----logistics///acounting/hr


logistics-----16 business applications---sd/mm/pp/qm

standard tables----vbak/vbuk/vbrk


sap erp----4.5/4.6c/4.7ee/ecc5.0/ecc6.0

4.7ee------------60000 tables--imp table

a to x------sap
y or z---customer specifc objects


sap erp--------applications---------logistics/accounting/hr

extractors-----application specific extractors///cross application extractors


ss(ds)--ts---psa--tr---cs--ur--dt

logistics--------applications




sap erp-------applications


1.logistics-------------16 applications----11--orders//12---deliveries///13---billing

02--purchasing
03--inventry controling
05---quality magt

2.Accounting----fi/co

fi--------accounts payable/accounts recievable///general ledger///specila ledger

co----profitability analsys///product cost controling//gneral cost controling

3.HR







cross application extraction-----generic extarction:


why do u go for generic extractors:

sap erp--std tables-but--ztables--new prdouct sales data---z table-----

sap extractor----------sap std tables

ztable-----generic extractors

view-----logical join of 2 or more table---cross application data---view
open order///current product stock level--std table///ztables---common fields

table---zds
view----zds
function modules-----zds

zextractor---zds(table/view/function modules)

3 types of zds----(trnsaction data///master data--attr/text)



1.for extracting cross application data
2.z tables---z extractors


ss(ds)---ts--psa--tr--cs--ur--dt(ODS)





step by step:
SAP ERP

1.see to that ---ztable/view(se11)/Function module(se37)
2.create a zds---RSO2///CHK THE EXTRACTOR----RSA3


SAP BW
3.REPLICATE DS---TS IS COPIED(SOURCE COLUMNS)

4.ASSIGN INFOSOURCE-------ZENRIC INFOSOURCE--------CS(BI OBJECTS/////TRANSFER RULES)

5.CREATE ODS/DSO

6.CREATE UPDATERULES(IS--ODS)

7.CREATE INFO PACKAGE-INITILIZE///DELTAS


GENERIC EXTRACTION USING A TABLE
SAP ERP
1.CREATE A TABLE---SE11
 DOCNO/EID/PID/CALDAY/SALES/UOM/REV/COST/CURR
2 APPROACHES TO BUILD A TABLE---BUILT IN TYPE///DATA ELEMNT APPROACH
BUILT IN TYPE---SAP DATA TYPES
DATA ELEMNT------DOMAIN/DATA ELEMNTS
BUILT IN TYPES--SAP DATA TYPES

nOTE:GENERIC DS CAN BE INTILIZED BASED ON A SINGLE FILED----TIME STAMP(ENTRY TIME//CALDAY(CREATED ON////NUMERIC POINTER---DOC NO/ITEM NO)


SAFETY INTERVALS----TO AVOID DATA INCONSISTENCY
CDELTA--1------------
SAFETY INTERVAL----LOWER LIMIT////UPPER LIMIT
IF THE DELTA SPECIFIC FILED IS RELATED TO TIME STAMP OR CALDAY---SAFETY INTERVAL---UPPER LIMIT
TIME STAMP---ENTRY TIME---UPPER LIMIT----1800SECS-----30MS
INIT---8AM
DELTA1--------10 AM----30MS----
8AM TO 9.30 AM-----DELTA1--------9.30AM


DELTA2-------11 AM---30MS
9.30------10 30 AM-----------DELTA2---TIME 10.30


INITILIZATION---SAFETY INTERVALS--TO AVOID DATA INCOSISTENCY
TIME STAMP----1800SEC---30MS

INIT--8AM
SYS--10 AM---30MS--9.30

8AM--9.30 AM------DELT1----9.30


DELTA2-----------11 AM---30MS--10 30

9.30 TO 10 30--D2


CALDAY---UPPER LIMIT----1 DAY

INIT---2ND----------DE1--5TH--1DAY--4TH
2 TO 4TH


NUMERIC POINTER--------LOWER LIMIT------100---------THEY R UPDATE-----ODS


1.SELECTION----------------SELECTIVE DATA LOADING-----APPERAS IN INFO PACKAGE DATA SELCTION---FROM /TO

DOC NO----------1 TO 5000
1 TO 3000--------SELCTIVE


2.HIDE:TO EXCLUDE THE UNWNATED FILEDS FROM THE DS----UOM


SS(DS)---TS


SAP ERP(R3BWCON)-------RFC(SM59)---------SAP BI SYS(B3TCLNT800)(TO FIND THE LOGICAL SYS--SCC4)



0UNIT-------------TO/GAL/CAN/EA

FT--DT--SID---MDATA TABLES

DIM TABLE--DATA PACKAGE DIMENSION-----0UNIT--SID-------T006/0CURRENCY--SID----TCURC

TO---SID----T006

ONCE INTILIZATION IS DONE IF U Want to go for full load---use reapair full request

repair full request





Generic extraction using --------------view

1.create a view(se11)----2 or more table---view---common field

2.create a ds---rso2//chk the extractors---rsa3


sapbw
3.replicate ds

4.assign info source

5.create ods

6.create ur

7.schedule---init///deltas


common fileds--from only one table

amount///quantity------------referencing object---table/column


co---pa data extraction-----------------------controling and profitability analsys

types of extractors----application specifc ///cros appplication specific

cross application---genric extarctor


application specific-----business content////////generic(customer)------co/pa


ss(ds)---ts---psa--tr---cs--ur--dt

data source?


in controling----create  the data source on operating concern

what is an operating concern---root node of ur controling organizational stru---simialr to ur info cube--chars/key figures

opearting concern also---char values(chars)///value fileds-----key figures

operating concern is created by controling consultat------4 tables-----ce1(operating concn name)///ce2(operating concern name)////ce3(opconcrn name)////ce4(operating concern name)

sd-orders---user


controling------many applications

controling---------------------planed data////actual data


operating concern--co consualatnts


sap r/3
1.create a data source-------keb0
2.chk the extarctor-------rsa3

sap bw sys
3.replicate ds
4.assign infosource---application specific
5.create info cube
6.update rules
7.info package





crsoss application data---Generic extractors////application---specific--genric---co/pa

application specific-----business content extractors---sap deliverd

logistics data extractors---logistics applications


logistics----16 business applications---

02--------purchasing
03---inventry 
05---qualty mgt
11-------sales orders
12---deliveries
13--biling

11---sales orders

logistics data-------------header data////item data///schedule line data


business content-----------------2lis_11_vahdr
   2lis_11_vaitm
   2lis_11_vascl
12--------------Deliveries-----2lis_12_vchdr///2lis_12_vcitm
13--------------billing------------------2lis_13_vdhdr///vditm

lo extractors------------16 applications


ss(ds)---ts--psa--tr---cs--ur--dt

logistics----sd--orders---sales orders-------------sap tables---vbak/vbuk/vbrk

ecs---enterprize communication structure
es----extract structure

std/document table(vbak/likp/vbrk)---------ecs-----(setup table)--(full/init)-------extract stru-(10+2)-----------Data source--------sap bw sys


set up table---extract stru------------------------se11----------extractstru_setup
vbak------mcvbak
likp-----------mclikp
vbrk------mcvbrk

table---str+data
stru----structure


vbak/likp(document table)---------ecs--setup tables-----es----ds---ts--psa--tr--cs--ur--dt---queries/reports



sales orders--header data extractions---2lis_11_vahdr////////2lis_11_vaitm////////

sap r/3
1.install the data source from business content----rsa5
2.Mainatin extarct structure(addtional columns added from ecs) and data source---------lbwe


sap bw sys
3.replicate data source---ts is copied to bi sys
4.assign a business content info source----cs///tr
5.install bc infocube//////genric info cube
6.create update rules

sap erp
7.fill the data to setup tables---sbiw---(oli*bw)--11--OLI7BW////12----OLI8BW///13---OLI9BW/////EXTRACTOR CHECKER---RSA3

8.create info package---init///deltas


se11-----------------roosource/rodeltam------------ds is compatible with info cube or ods
(notes:if ur not allowed tomaintain extract stru due to data in setuptable delte data from set up tables--lbwg)



LO DELTAS:3 TYPES OF DELTA MECHANISMS--LO DELTAS

1.QUEUED DELTA
2.DIRECT DELTA
3.UNSERIALZED V3 UPDATE

SERIAILIZED V3 UPDATE---DUE TO TIME STAMP ERRORS IT IS REMOVED



lo delta---Logistics delta extraction

there r 3 types of delta mechanisms--1.Qued delta///2.Direct delta////3.Unserialized v3 update

1.lbwq---extraction queue
2.rsa7---delta queue
3.sm13---update queue


1.Queued Delta------lrage volumes of data/serializtion

sd---user creating reord---std tables----------lbwq----------collect the data to rsa7(jobs@lbwe)---info package(delta---sap bi sys)


user std table--v2------lbwq----------jobs@lbwe-----rsa7--ip(delta)--sap bw sys

2.Direct delta:

user std table----v1----rsa7--------ip(delta)---sap bi sys

small volumes data///limited serialization

3.unserialized v3 update:large volumes///no serialization

user std table---------------------sm13-------jobs@lbwe-----rsa7---infopackage(delta)----bi sys


1.setup Delta mechanism---lbwe


note:in rsa7 sys mantains luw related to last delta and current delta------
Why last delta luw?

incase of last delta load fails we have to request a repeat delta--to do thid last delta luw mantained
1 record----1 luw

direct delta--1 record---1luw
qued delta--group of reords---1 luw
unserialized----data packet---


init---d1/d2/d3/d4//d5/d6/d7

if delta4 is failed------------------how to coorect this error---repair full request



sap erp Master data extraction from sap r/3 sys---for all the applications

fl----ap/ar/gl--------------------(fi---sl)
co---pcc/gcc------pa
hr

logistics---lo extractor
ca---genric extractors

business content extractors

sap erp
1.install ur business content data source----rsa5
2.Maintain ur data source---rsa6

sap bw
3.replicate ds
4.assign bc infosource---if the infosource is direct update is--create infopackage--init/deltas
 if it is flexible update---1.use insert char as data target
   2.create update rules
   3.schedule--init/deltas


erp
vendor------attr data


0vendor_attr 





Data source enhancements:If the deleiverd data sources need to be added with addtional columns use enhancements


0consumer_attr---------sales org
0consumer_attr----10+adding --sales org


sap r/3
1.adding the columns(appending stru)----rsa6
2.populate the data------user exit---rsAP0001---cmod

sap bw/bi sys
3.replicate ds----the new filed is transferd
4.assign infoosurce---new filed maaping
5.in the target see to that the new column is available----0consumer---sales org (attr)
6.create update rules
7.info package------init/deltas



DB eXTRACTIONS:

ORACLE-----------------DB CONNECTOR---------------------SAP BI SYS(DB CLIENT//DBSL---MUST BE INSTALLED BY BASYS TEAM ON BI SERVER)


DB(TABLE/VIEWS)------SAP BI SYS----6db_table/view


1.CREATE THE DATA SOURCE-----RSDBC IN BI SYS
2.ASSIGN INFOSOURCE
3.DATA TARGET
4.UPDATE RULES
5.SCHEDULE THE DATA

PERFORMANCE:

ss-----------extraction time--------------sap bi sys------query run time---------bex suite(queries----------analyzer//web application designer)


The Query run time--------1.Query init time///2.DB read time//////3.Olap Aggregation time///4.Mdata read time///5.ovearall query run time


1.query init time----time taken by olap processor to start up ur query------rows and columns

2.DB read time----relevant data from database-----time taken to read the data base

3.Olap aggreation time---as per ur query design it has to aggregate the data

ic
eid/calweek/month///sales
100/1/jan/1000
200/1/jan/1200
100/2/jan/1300

eid/sales

4.Mdata read time--ft--dt--sid--mdata---to read the data from mdata tables

5.overal query run time---total query run time----

1.compression
2.indexes
3.aggrgates///rollups
4.partioning
5.attr change run
6.line item dimension
7.process chains

SAP BW Modelling Sample Notes

options in chars:

1.general-data type/length

lower case letters--by defualt bw dosnot allow lower case
display---------key/text
calyear/month
01/98-------------jan98--text
key and text

authorization relevant---
sales org----roles
1000  x
2000  y
3000  z

x---1000
y---2000
z---3000

ss-----------sap bw---tdata/mdata---time depndt and indepndt

time depndt data----if the data over a period of time keeps on changing---eid/dsg---/
time indepndt------if it is constant---time indpndt--eid/enm

mdata-------attr/text/hier
 attr---Display attr/Navigational attr
sap/customer
sap---------/bi0/
customer----/bic/


P---/BIC/PZSN_EID--------TIME INDEPNDT ATTR DATA TABLE
Q---/BIC/QZSN_EID------------TIME DEPNDT ATTR DATA TABLE
X----/BIC/XZSN_EID----TIME INDEPNDT SID TABLE NAVIGATIONAL ATTR
Y----/BIC/YZSN_EID-----TIME DEPNDT SID TABLE FOR NAV ATTR
M---/BIC/MZSN_EID------VIEW OF ALL MDATA TABLES
S----/BIC/SZSN_EID-----SID TABLE OF CHAR
T----/BIC/TZSN_EID-----TEXT TABLE


HIERARCHY:
WITH HIER-------TO MAINTAIN HIER STRU

H/I/J/K-HIERACHIES
ATTRIBUTES:ADDTIONAL COLUMNS/INFORMATION
EID--ENM/ADD/DSG---ATTRIBUTES OF EID
PID//PNM/PGRP-----ATTR OF PID


TYPES OF ATTRIBUTES:

DISPLAY ATTR:
NAVIGATIONAL ATTR
TRANSITIVE ATTR
COMPOUNDING ATTR


DRILL DOWN//DRILL ACROSS/RESTRICTION
RESTRICTION:CONTROLING THE OUPUT OF THE QUERY
 COUNTRY------US/CA/GER/IND-----------US/IND
DRILL DOWN:-----MORE DETAILED DATA--ROW WISE DATA
 COUNTRY---REGION----ORG---EMPOLOYEE---




DRILL ACROSS------------COLUMN WISE COMPARSON
CALYERAMONTH-----------JAN98/FEB98/MAR98/APR98--------

ON DISPLAY ATTR---NOT POSIBLE---DISPLAY PURPOSE

NAVIGATIONAL ATTR----POSSIBEL--DRILL DOWN/ACROSS/RESTRCION


TO DESIGN DISPALY ATTR
EID------ENM/ADD/DSG
NAVIGATIONAL ATTR:
PID//PGRP---NAV ATTR


PID-----------
NAVIGATIO0NAL ATTR-------ATTR-TRANSITIVE ATTR
SREG-----SORG(NAV ATTR)----ATTR---SALES MGR(TRANSTIVE ATTR)

COMPOUNDING ATTR---SUPERIOR INFOBJCT

master data /tdata loading

Data loading:
ss-----sap bw-----tdata/mdata
tdata--the data keeps on changing
mdata----the data which is constant---char data---attr/text/hier


data loading---------2 differnt methods for data loading--
   1.Direct update----master data loading--attr/text/hier
   2.Flexible update---tdata loading///mdata---attr/text only


Data flow---direct update

ss(ds)---ts---psa---tr---cs--dt(char---attr--p/q/x/y///text---t///hier---h/i/j/k)

ss----source sys----file sys
ds---data source-----stru of the data in the ss
ts--transfer stru------ds is copied to bw sys(ss)
psa---persistence staging area------temporary storage---data cleansing
cs---commn stru---stru of bw sys--
tr----mapping of ts columns with cs columns



ext star schema--------ft--dt---sid--mdata

many dim--emp dim//prd dim/mat dim

dim---chars---emp dim--emp char(sid)-----emp master----emp master///prd master//mat master/vendor master

emp master---attr/text/hier

steps for data loading

1.create application component(ac)
 2.create infosource(is)
  3.assign data source(ds--ss)
   4.create info package(ipack)



application component----ss---loading the data---applications---sd/mm/pp/qm
  sd--tdata/mdata----all the data loads related to an applicationr manageble by using an application component

sd----sd_ac///mm------mm_ac/////pp-------pp_ac
  mm---tdata/mdata



infosource:-----direct update///flexible update

data source----type of ss----file/sap/db

infopackage----ss-24/7----bdata--ss----------hourly/daily/weekly/monthly-------

using info package we can go for data loads at regular intervals


ac/is/ds/ip
emp master data--attr/text/hier

EXCEL--CRATE AN EXCEL--DUMMY RECORDS---EXCEL STRU
DS===TS
TS---FILLED BY THE SYS--DIRECT UPDATE--COPY TS--CREATE EXCEL





CSV---/ASCII

Master data text loading


eid----attr data
eid---text data loading


ss(ds)--ts---psa---tr---cs---dt(mdata--text---t table)


ac/is/ds/ip

ac---use existing ac---sd---ac_sd
is----direct update---attr/text/hier
ds---file type----attr/text/hier ds


activate text data source

ip-----

text---language+description of char

eid
100/200/300/400-----------description+lu



EMPLOYEE-----HIERACHY DATA LOADING




    0)US_EMP_HIER(ROOTNODE)
   1)CENTRAL      8)WESTREN REGION
  2)A  5)B    9) D  12)E
  3)100   4)200    6)300 7)400  10)500 11)600 13)700 14)800





EID--------HIERARCHY-----------SREGION/SORGANIZATION--EXTERNAL CHARS OF HIER
1.MAINTAIN EXTERNAL CHARS OF HIER---
2.NODE IDS//PARENT NODE(UPPER LEVEL) AND CHILD NODE(LOWER LEVEL)
3.NODEIDS ---START FROM LEFT FINISH TO UR RIGHT

AC/IS/DS/IP---HIERARCHY DATA SOURCE:

TRANSACTION DATA LOADING:

SYS---------------TDATA---ODS---INFOCUBE(MDIM STR)


ODS--?
INFOCUBE--?

SS------NEW INSERTED---DW
 MODIFIED-----UPDATED DW
 CANCLED----EFFECT-- TO THE DW----DATA CONSOLIDATION---ODS

 INFOCUBE---MDIM REPORTING


INFO CUBE/ODS---?



INFO CUBE:?
EXT STAR SCHEMA----FACT TABLE---DIM TABLE---SID--MDATA

FACT TABLE--KEY FIG--MAX 233 KEY FIGURES
DIM TABLE--CHARS(SID)---248

MAX--16 DIMENSIONS--3 SYS---TIME/UNIT/DATA PACK
MIN--4 DIMENSIONS---3(SYS)+1(USER)



TYPES OF INFO CUBES:

BASIC CUBE-----BW SYS-----ACTUALS DATA(HISTORICAL DATA)---READ PERFORMANCE --MANY USERS CAN READ THE DATA PARALLY//BUT ONLY ONE USER CAN WRITE THE DATA PARALLY----DATA+STRU BOTH R IN BW SYS


TRANSACTIONAL///RELA TIME INFO CUBE----PLANG DATA--SALES PLANG/COST PLANG---READ AND WRITE OPTIMIZED---MANY READ AND WRITES PARALLAY


REMOTE CUBE://VIRUAL PROVIDER---ONLY STRU IS MANTAINED---BUT DATA IS THR IN SS ITSELF---REPORT ALWAYS WE DO GET DATA FROM SOURCE
ONLY STRU IN BW  SYS///DATA IS IN SOURCE SYS

Database table---related to info cube

fact table---/bic/f(ictechname)///e fact table---/bic/e(zsn_ic)

dim tables------/bic/d(ictechanme)1/2/3/4/5--9/a/b/c/d
system dim----/bic/d(ictechname)t/u/p


star schema----list schema


ods---operational data store:

ods----------2dim object--table---3 diffrent tables

ods---data consolidation

icube--mdim stru---
note:if directly data is loaded to info cube---thr is a chance of duplicate reocrds

ods---------duplicates r overwritten---data consolidation
ods-----data is divided interms-----key fields/data fileds


key fileds---------primary key in a tagble---uniquein nature---doc no/itm no/scl itm no/order no--max -16 key fileds///always ur key fild is char
Data fileds:key figures--data filds///char--not key fields can be a data fileds



3 diffrent table:
1.New data table(activation queue)
2.active data table
3.change log table......


1.New data table:

ss---------ods---inserted to new data table---all reocrds---new/modified records/duplicates
this data is not avialble for reporting


2.active data table:
after loading data to ods--activate ods data---data is consolidation
new--insetred to active data table
modified---updated to adt
duplicate---overwritten


ss

docno/eid//sales
1 100 1000(old reocrs---before image)
2 200 1500


ods---ndt--activate---new---inserted to adt/cahnge log table


docno eid sales
3 300 1400
1 100 1600(after image--modifed reord)


ods---ndt---2inserted--activate-----before image is replaced after image

active data table

docno eid sales
1 100 1600
2 200 1500
3 300 1400


duplicate --overwrite
bi replaced by after image



cahnge log table:in the cahnge log table sys mantains before image/after image---evry change is maintaine

all the reocrd r maintained in change log table---images----0recordmode

N-=-----NEW IMAGE
X--BEFORE IMAGE---OLD RECORD
" " --AFTER IMAGE
D---DELTED IAMGES
R---REVERSE IMAGE


3.X----2 TYPES OF ODS--STANDARD/TRANSACTIONAL
IN 7.0---3 TYPES OF DSO--STD////DIRECT UPDATE DSO///WRITE-OPTIMIZED DSO



CREATION OF ODS:-----WHILE ACTIVATING ODS THE DATA MART(8ODSTECHNAME) IS AUTOMATICALLY GENERATED

DATA FLOW IN CASE OF FLEXIBLE UPDATE

SS(DS)--TS--PSA--TR--CS--DT(CHAR--ATTR/TEXT/HIER)--DIRECT UPDATE


SS(DS)---TS--PSA--TR--CS--UR--DT(ODS/ICUBE)

UPDATE RULES:SIMILAR TO TR--USING UR WE CAN MAP CS OBJECTS WITH DATA TARGET

TYPES OPF UPDATE RULES

1.INFOOBJECT
2.CONSTANT
3.ROUTINE
4.FORMULA
5.INITL VALUE
6.READ MASTER DATA ATTR
7.TIME DISTRIBUTION


Data loading to ods:

IMAGES---0RECORD MODE---STAUS COLUMNS


APPLICATION COMPONENT---EXSITING ONE
 INFOSOURCE--FLEXIBLE
  DATA SOURCE----FILETYPE(CREATE UPDATE RULES--TARGET)
   INFO PACKAGE


LOADING ODS DATA TO INFO CUBE:

ODS-------------------INFOCUBE


3 KINDS OF UPDATES:
1.FULL UPDATE
2.INTILIZATION
3.DELTA UPDATE


FULL LOAD-----ALL THE DATA IS LOADED TO BW SYS--10000000

INITLIZATION---DS CAN IDENTIFY DELTA RECORDS----

 2 KINDS OF INITLIZATION
  INTILIZE WITHOUT DATA TRANSFER:ONLY INITLIZATION
  INITLIZE WITH DATA TRANSFER-------FULL+INIT

DELTA LOADS-----------NEW/MODIFED---CHANGE


ODS TO INFO CUBE---IF IT IS FULL OR INIT IC GETS DATA FROM ACTIVE DATA TABLE
   IF IT IS DELTAS IC GETS DATA FROM CHANGE LOG TABLE(BI+AI)



ODS-----UPDATE RULES-------ICUBE

1.CREATE UPDATE RULES
2.LOAD DATA TO IC FROM ODS





Business content:set of pre configured objects by sap----0

ss(ds)--ts--psa--tr--cs--ur--dt---queries/workbooks/web templates/roles

application requiremnets------logistics/accounting//hr
industry----------------pharma/consumer/oil and gas
country re--------


there r 3 diffrent versions---business content

Deliverd version---by sap
the deliverd object must be insatalled------active vesrion

modify ---modifed version

object types in business content


COLLECT---INSTALL THEM

0SD_C01-=-----------INFO AREA/INFO OBJECTS


GROUPING-----------GATHERING THE REQUIRED OBJECTS

1.Only neccessary objects:the mandatory objects---to install any bi object
 ex----0sd_c01----ia/info objetcs

2.indata flow before:here sys groups those object that provide data to instaling object
ss(ds)--ts--psa--tr--cs--ur--dt---queries/workbooks/web templates/roles


3.indataflow afterwards---here sys groups those objects that gets data from instaling object

4.indataflow before and after wards---the entire data flow is installed


install---------------------activation

1.install------------------the activation is in dailog mode
2.install in background---here the activation takes place as a background job---sm37
3.install and tarnsport:apart from activation of the objects if u want totransport use this option
dev/testing/production


collection mode:this is regarding depndent object collection----if u want to collect the depndt objects by the sys use automatic collection////manual collection

attr-----------chars

install------------------actiavted 

Match or copy--------------------

info objects--------0emp id////0prd id----
empid
prd id-------active and modified version


0sd_c01----------------------instaling--info area//info objects------------------0empid///0prd id


0emp id/0prd id----------match or copy----to keep ur active or modifed version objects use this match or copy



how to install an object from business content:

rsorbct

0sd
0pur
0pp
0mm

BW Reporting some SAMPLE Points

Reporting:bex suite(erqa)

ss----------sap bw-------bex suite---data analsys


bex suite---DEVOLOPER/END USER

DEVOLOPER:1.QUERY DESIGNER2.ANALYZER//3.WEB APPLICATION DESIGNER
END USER---BEX BROWSER

IN 7.0---REPORT DESIGNER/VISUAL COMPOSER//BEX BROADCASTER



QUERY DESIGNER--TO DESIGN THE QUERIES---GETS DATA FROM SAP BW


SS-------SAP BW---OLAP PROCESSOR--------QUERY DESIGNER(*QUERIES)---ANALYZER/WEB BROWSER(WAD)

BEX BROWSER----USER CAN BROWSE---WORKBOOKS/VIEWS/WEB TEMAPLATES///SAP ERP REPORTS


SS----------SAP BW-----MDATA---CHAR TABLES///MDATA TABLES////TDATA----ODS/INFO CUBE---INFO AREA

QUERY DESIGNER---ANLYZER/WAD////BEX BROWSER

1.QUERY DESIGNER----SIMPLE QUERY
2.Analyzer---rrmx---to design the workbooks/views also

 eid pid sales
 100 11 1000
  12 1400
  result 2400
 200 13 2500
  11 2000
  result 4500
 ovearall result 6900
3.web application designer-------------web templates---web browser---html/xhml
 simple web template


RESTRICTION:USING THIS WE CAN CONTROL THE OUPUT OF A CHAR

INCLUSION/EXCLUSION

INCLUSION:INCASE OF INCLUSION--THE INCLUDED VALUE DATA IS DISPLAYED

COMP CODES-----1000/2000/3000-----1000

COUNTRY----US/CA/GER-----US--INCLUSION
  
 
 
EXCLUSION---EXCEPT EXCLUDED VALUE REMAING VALUES DATA IS DISPLAYED--1000---REMAING VAUES


INCLUSION--IMPROVES UR QUERY PERFORMANCE---SELCTS INCLUDED VALUE

1000/2000//3000

INCL---1000

EXCLUS--1000

ss----------etl------sap bw---fetch(queries)--Bex suite---Genrate the report

Bex suite---query esigner///analsyer////web application designer/web analsyer/////report deisgner//////visual composer./////Bex broadcaster-----portal


1.Query designer:using this we can design the queries whic can fetch the data from dw
query elemnts----restrcition///free chars///filter///restrcited key figure///calluculated key figure///new formula/////new selctions///condtions///exceptions///variable


2.Analsyer----excel based tool--using this we can design the workbooks for which data is presented thru bex queries--into a single workbook we can insert many queries--open the workbook--refreshed it gets latest data from info provider



ss---etl---sap bw---queries(qd)----workbooks(analsyer)//web browser(wad)//formated reports(
report designer)///iviews(vc)


3.web application designer-----web based tool---using this we can design web templates---the web templates can be customized by using web items---2 types of web items---sap///customer-----xhtml

sap----table/graph/dropdown/checkbox///


4.web analsyer-----using this we can genarte adhoc reports----

5.Report designer-----replaced with a bo tool----Crystal reports--using this we can genarte formated reports----rows/columns/images/logos/header/fotter

6.visual composer:using htis we can genarte iviews--highly visual based reports----



ss----etl--sap bw----mdata---chars//dso/icube/infosets and multi providers----ia


1.Restriction--------using this we can control the output of the query, thr r 2 types of restrcition

a.Inclusion---only included values data is displayed
b.exclusion----except excluded value remaing values data is displayed

2.Free chars--------------in the intial query run free chars r not displayed in out put they r displayed in status bar--drill dwon--row///drill across----column

3.filter:it is neither displayed in staus bar nor can be drill down to output area but it controls the entire output of the query

country----c00








rows/column---restriction///freechars////filters


free chars---status bar---driildown/acros

filter--it acts as a global controler of the query-----


country-us/uk/aus--salesorg/emp/sales/rev/taxes

user---x---us

filetrs neither it is displayed in status bar nor can be drill down to ouput area---controled by filetr chars


CONDITION:FOR GETTING THE QUERY OUTPUT WE CAN TAKE SOME CONDTION

TOP10 EMP---SALES---TOP10

TOP3 COUNTRY---NET REVNUE--TOP3

BOOTOM10/5

=/<>

CONDTIONS----CONTRADICTIONS




EXCEPTIONS----ALERTING USER
INVENTRY LEVELS--------------------MAT---1000TO-ALERT---PURCHASE

OPEN ORDERS---CUSTOMER----VALUE----ALERT

RETURNS------HIGH----ALERT SALES MAGR

CUSTOMERS---CREDITS----CREDIT VOLUME----ALERT THE BUSERS

DESIGNG ALERT---SCHEDULING ALERT TO USER





0SD_C01----Q1/Q/2Q/3Q/4----

CAHNGE QUERY LOCAL:CHANGES R CONFINED TO THAT QUERY
CHANGE QUERY GLOBAL:CHANGES CAN BE REUSABLE


GLOBAL----RESTRICTED KEY FIG///CALLUCULATED KEY FIG
LOCAL-----NEW SELECTION/NEW FORMAULA

RKF--NEW SELCTION
CKF---NEW FORMULA


RESTRICTED KEY FIGURE:USING THIS WE CAN RESTRICT ONLY ONE KEY FIGURE WITH ONE OR MORE CHAR VALUES


SALES---Q1/Q2/Q3/Q4--TREND ANALSYS

REV---97/98/99/00





NEW SELCTION:SIILAR TO RKF -----BUT IT IS LOCAL--NO REUSABLE

Free chars/filter////restrictions/////


#####Conditions--------------using this we can execute the query conditionally----top3 emp---wrt revenue

top 10 regions---wrt rev

emp sales volume=x amt///not equal to x////emp sales > or <

conditon can be applied on single///combinations of the chars////all the chars

in a single query we can design many conditions


####Exceptions---alerts--using this we can alert the user regarding a thresh hold value

sales alert---100000
emp
x-----40000--bad-----------red
y-----70000--------avg---yellow
z-----99000-------gud-------green

invntry alert----level1----warning----100000/////level2-------error-----80000

alert overdrafts
alert deliveries

alerts openorders
aalerts---sales returns



######change query local and change query global----------

0pur_c01-----------q1/q2/q3/q4/---q1---globalview-----the changes can be reusable
 Any thing defined in the local view----cant be reusable


Global---------restricted key figure///calllculated key figure

Local--------new selction////new formula




#####Restricted key figure:using this we can restrict only one key figure with one or more char values---rkf---global---reusables


sales---------week1/week2///week3///week4---using this we can trend analsys

Revenue-----q1/q2/q3/q4

#######New selction---------####it is similar to rkf but it is local which cant be reusable

####ckf/new formula----------



calluculated key figure////new formula


ckf-----global---reusable

using existing key figures of info provider we can define a new virtual key figfor which data is calluculated at run time

formula opertor


operating revenue///tax-----Net Revenue=operatingrev-tax


tax
salry---tax%salry


dividend
no of sahre=====eps-------calluclations


NEW FORMULA:IT IS SIMILAR TO CALLUCULATED KEY FIGURE BUT IT IS LOCAL ONE---CANT BE REUSABLE

IF U WANT TO USE ANY KEY FIGURE IN THE NEW FORMULA IT MUST BE AVILABLE IN COLUMNS(KEYFIGURE STRCTURAL ELEMNTS)

FUNCTIONS OF FORMULA:

BASIC FUNCTION:----HIGH--------TO THE POWER VALUES---X**Y---2**10

PERECENTAGE FUNCTIONS:

%SHARE----TAX %A SALRY

TAX--100USD
SALRY---1000USD

KF%AKF2


PERECENTAGE VARIANCE

ACTUAL SALES----90
PLANED SALES---100


PERCENTAGE VARIANCE----------OP1%OP2




PERCENTAGE SHARE OF RESULT
PERCENTAGE SHARE OF OVERAL RESULT

EID PID SALES
100 11 1000
 12 2000
 RESULT 3000
200 11 1300
 12 1500
 RESULT 2800
OVEARLL RESULT 5800


DATA FUNCTIONS---------VALUE WITHOUT DIMENSION--KEY FIGURE R DISPLAYED WITH UNIT DIMENSION
NODIM(KEY FIGURE)


BULLIAN OPERATORS IF THE GIVEN CONDTION IS SATISFIED THE VALUE IS ONE//IF IT IS NOT SATISFIED VALUE IS 0



FREECHARS//FILTERS/RESTRCTION/E3XCEPTION/CONDITNS///RKF-NEW SEL//CKF--NEW FORMULA



VARIABLES:DYNAMIC INPUT PARAMETRES GIVEN BY THE USER AT QUERY RUN TIME

COUNTRY----US/CA/AUS/GERMANY

US
GER
AUS

AS PER HIS SELCTION THE DATA MUST BE POPULATED

VAR-----CAHRS---READY FOR INPUT-------VALUE---THE DATA IS POPULATED/////REFRESH----READY FOR INPUT--CHANGE THE VALUES---POPULATED


VARIABLE GLOBAL --CAN BE REUSABLE ACROSS ALL UR INFO PROVIDERS
IP1--COUNTRY--VAR1
IP2----COUNTRY---VAR1


TYPES OF VARIABLES:5 TYPES OF VARIABLES

1.CHAR VALUE VARIABLES:FOR ANY CAHR---MANY VALUES---OUT OF MANY VALUES TO CHOSE ANY VALUE DYNAMICALLY---CHAR VALUE VAR


2.TEXT VARIBALE:TEXT---DESCRIPTION----USING TXT VAR WE CAN POPULATE DESCRPTIONS OF CKF/NEW FORMULA/RESTRICTED KEY FIGURE/NEW SELCTION DYNAMICALLY

3.FORMULA VARIABLE:USING WE CAN DEFINE FORMULAS DYNAMICALLY
CONDTIONS---TOPN/BOTTOMN----TOP3---3//5/8--DYNAMIC

4.HIERARCHY VARIABLE:CHAR---MDATA--ATTR/TEXT/HIERA
COUNTRY--US_H1///AUS---H2//UK----H3
OUT OF MANY HIER TO CHOSE ANY HIER DYNAMICALLY USE IT


5.HIERACHY NODE VARIABLE:HIER---MANY NODES--NODE DYANMICALLY

PROCESSING TYPES:



Change query Global--the changes r reusable///Chnage Query local---cant be reusable

Global----Restrcited Key figure///Calluculated key figure
Local----New selection //new formula

########Calluculated Key figure:using this we can create a new virtual key figure for which data is callculated by olap processor at run time

Revenue///tax


operating margin----------Rev-Tax


Total delivery time/no of deliveries=avg delivery time


ckgf--global=reusable


####New formula---------similar to ckf but it is local which cant be reusable----in the new formula Only we can use key figure structural elemnt

Gr qty/gr amt

inv qty///Inv amt


Value per unit=Inamt/inv qty=1000usd/120to---due to referencing objects---to remove the referencing objects---formula function----Value with out dimension

Nodim(Inv amt)/No dim of Inv qty


#############VARIABLES#################3--DYNAMIC INPUT PARAMETERS GIVEN BY THE SUER AT QUERY RUN TIME

COUNTRY------US/CA/DE/---------US--------VARIABLE-------READY FOR INPUT///


VARIABLE R GLOBAL---THEY CAN BE USED ACROSS ALL INFO PROVIDERS

TYPES OF VARIABLE

1.cHAR VALUE VARAIBALE-----FOR ANY CHAR IF WE R HAVING MANY VALUES----TO SELCT ANY CHAR VALUE DYNAMICALLY--USE THIS VAR

2.TEXT VAR---------------USING THIS WE CAN POPULATE DESCRITPIONS DYNAMICALLY----CAN BE USED WITH CKF/RKF/NEW SELC/NEW FORMULA----DESCRITIONS

3.FORMULA VAR----USING THIS WE CAN CALLCULATE FORMUALS DYNAMICALLY---CONDTIONS/EXCEPTION///CKF/NE FORMULA

CONDITONS-------TOP3 COUNTRYS/SALES---TOP-3/5/10/20

4.HIERACHY VAR-------MDATA--ATTR/TEXT/HIER---CHAR-----------SALES ORG===-----US--H1/DE--H2///GB--H3---TO CHOSE ANY HIERCHY DYNAMICALLY--USE THIS VAR

5.HIERACHY NODE VAR-----IN A SINGEL HIERACHY-----MANY NODES----OUT OF MANY NODES TO CHOSE ANY NODE DYNAMICALLY--USE THIS VAR

:::::PROCESSING TYPES::USING PROCESSING TYPE WE CAN TELL THE SYS HOW A VRAIBALE MUST BE PROCESSED AT RUN TIME


1.USER ENTRY///DAVLUE--BY TAKING USER GIVEN OR WITH DEFULT VALUE----THE VAR DATA IS POPULATED
COUNTRY---US/CA/DE

2.REPLACEMNT PATH-----CAN BE USED WITH CHAR VALUE/TEXT/FORMULA VARIABLE
IF USED WITH CHAR VALUE----THE SENDOR QUERY RESULT IS REPLACED BY RECIVER QUERY
Q1-JUMPING TO Q2

SALES ORDER QUERY----------STOCK LEVELS QUERY

IF USED WITH TEXT AND FORMUAL VAR---

3.AUTHORIZATION----BASED ON USER GIVEN AUTHORIZATION IF U WANT TO POPULATE DATA USE THIS PROCESSING TYPE

4.SAP EXIT-----------VAR DELIVERD BY SAP IN BUSINESS CONTENT-----CURRENTWEEK/MONTH///QURTERS////YEAR-----LAST 3/6/12 MONTHS SALES--INCLUDING//EXCLUDING CMONTH

LAST 6MONTHS CUMUALTIVE VALUES

5.CUSTOMER EXIT----WRT ANY USER SPECIFC REQUIREMENTS USE THIS PROCESSING TYPE------RSR00001









######Variable offsets######

calyear/month---user entry/Dvalues----ready for input-----july98/june 98---previous month(-1)///next month(+1) data

####Text Variable with processing type--Replacemnet path#####


Text Var---descrptns dynamically----new selection////rkf/ckf/new formula

New selction--uisng this we can restrict only one key figure with one or more char Values

when replacement path is used with text var--the var values r replaced by char values

#####Jump queries###########33
using this we can jump from one query to another query-----sendor query to reciver query


sales order query---prd/sales orders---q1
stock----infoprovider---query-----q2--prd/stock


q1--topn conditions----country/sales orders---c00/c03/c05
q2----detailed data --country/sales region/sales org/prd///sales/cost/revenue

sendor and reciver assignments---rsbbs

#####sap exit variable######---deliverd by sap--wrt std requirements

current week///current month////currentquarter/year

last 3/6/12--including cmonth/excluding cmonth


#######Authoriuzation#######

based on user given authorization if i want to populate data use this processing type

country-----user
us---------x
ca----------y
de--------z


1.design a var--authorization on country
2.populating data to the var
 a.make the country auth relevant
 b.Genaret auth objects--rsecadmin
 c.Genaret roles
 d.assign the roles to busers





text Variable ----replacemnt path


text----description---
replacemnt path---char/text/formula
rp--text var--the var values r replaced by char values

text var---rest key fig///new selction//ckf/new formula

new selction-----key figure---char/one or more



VARIABLE OFFSETS:


CALYEAR/MONTH------VAR---USER ENTRY D/VALUE----JUN99


 PREVOUS MONTH(-1)  JUN 99 NEXT MONTH(+1)





JUMP QUERIES//////RRI---REPORT TO REPORT INTERFACE/////DRILL THROUGH-------RSBBS


Q1-----TOPN(3)----COMP CODES/SALES---2000/3000/7000--SENDOR QUERY

Q2-----------COMP CODE/SALES ORG/GRUP/SALES/COST/REV----RECIVER QUERY


Q1----EXECUTE QUERY 





SAP EXIT:VAR--DELIVERD BY SAP--D&D-----------CURRENT WEEK/MONTH/QUARTER/YEAR

   LAS 3/6/12/MONTHS--INCLUDING/EXCLUDING CMONTH


STD VARIABLES BY SAP---


AUTHORIZATIONS----------

COUNTRY----USERS
US  A
CA  B
GE--------------C
GB=------------------D






Q1----IC--COUNTRY--AUTHORIZATION





1.MAKE INFO OBJECT---AUTH RELEVANT
2.GENERATE AUTH OBJECTS------RSSM(RSECADMIN)
3.GENRATE ROLE AND PROFILES-----PFCG
4.ASSIGN ROLES TO USERS---SU01


COUNTRY--AUTH RELVANT

Country----user

us-------x
ca----------y
de---------z


1.Variable---Authorizations---country
2.populating data to that Var
 a.make the country as auth relevant-rsa1
 b.Genearte analsys Authorization objects---rsecadmin
 
 d.assign them to users-rsecadmin/rsu01

0tcaactvt
0tcaiprov
0tcavalid


CHAR vARIABLE----CUSTMOER EXIT
USER D/VALUE///////REPLACEMNT PATH///SAP EXIT/AUTH/CUSTOMER EXIT---RSROOOO1////BADI-------RSR_OLAP_BADI

QUARTER TILL DATE
PREVIOUS YEAR---QTD


customer exit----user specific requiremnets if u want to populate the data we have to go for user exit----cmod----rsr00001


country---var--auth--ready for input----authorized value
x--us--based on user loged in----us

var---user exits----cmod


VAR NAME---
TYPE OF THE VAR

RANGES
TABLES----WHERE-----------TECH TEAM





WEB APPLICATION DESIGNER:WEB BASED FRONTEND TOOL---WEB TEMPLATES----WEB BROWSER


WEB ITEMS----CUSTOMIZE WEB TEMPLATES

2 TYPES OF WEB ITEMS----SAP WEB ITEMS--TABLE/GRAPH///DROPDOWN//CHECK BOX/RADIO BUTTONS///FILTERS///NAVIGATION PANNEL/////ADHOC QUERY DESIGNER//EXCEPTIONS/CONDITIONS


CUSTOMER WEB ITEMS-----HTML///IN 7.0----XML HTML SCRITING



HOW TO DESIGN WEB TEMPLATES

web template---input is from bex queries

table----table

graph-------Graphical------igs server must be installed

Query designer---query elemnets

bi--bex-query designer---analsyer///webapplication designer//Report designer////Bex broadcaster//Visyual composer


ANALSYER---------IT IS AN EXCEL BASED TOOL---USING THIS WE CAN DEISGN THE WORKBOOKS---IN AS INGEL WORKBOOK WE CAN INSERT MANY QUERIES----
THR R 2 MODES IN THE WORKBOOK

1.DESIGN MODE---WE CAN DESIGN THE WORKBOOKS--DESIGN ITEMS----DROPDWON////CHECKBOX/RADIOBUTTON///CONDITIONS///EXCEPTIONS///TEXT ELEMNTS


2.ANALSYS MODE------END USER-----TO BROWSE ALL HIS WORKBOOKS
fact tab--dim table(prd)---sid--mdata tab(prd master)


Report designer///wad////

query deisgner//analsyer///wad////report designer/////Bex broadcaster


:::::Bex broadcaster::::--using this we can distribute reports/workbooks/web templates////queries-----printer/portal/mail---pdf/excle/word////html///url////////hourly///daily/weekly/monthly///only upon the data changes


:::::Visual composer::::::using this we can genrate iviews which r highly visual based reports---graphical reprsentation of the data---as part of caf--vc is deliverd in bi----sap bi sys////sap erp/crm sys


sap bi sys--for iviews---input is from bex queries
other sap sys---badis


iviews can be customized by using ui controls--similar to web items---drop down/checkbox/radio buttons


vc-----the bi sys must be configured in portal server--integration between0--vc and bi sys---basys team


web based tool--url--we can open

Transportaion

Transportaion:

Dev------------devoloping
testing---testings
prd----live sys

sandbox
mirror sys

1.$tmp---package cant be transported if u want to transport---assign it to a transportable package

requests transportaion---parent request///task----

2.object stru can be transported ///we cant transport data

3.inactive object cant be transported

4.object must be transported in their created seaquence

5.r/3-----dev/test/prd
bw-------dev/test/prd

replication of ds is mandatory----

1.assign the object to a transportable package and request---rsa1
2.export the req----se09/se10
3.import the requset in the target sys-------stms


to create the package--------se80

BW Statistics

bw statistics----
1.Maintain statistics settings------info providers--olap/whm------------collected std tables------rsddstat*

2.colect the stat data from std tables to stat info providers
 a.instal stat ds in bw sys---rsa5
 b.replicate ds--rsa1
 c.assign infosurce---bcontent
 d.instal stat data targets from bcontent
 e.create update rules
 f.create info package--init/deltas

3.stat data need to be  anlayzed--st03n/////run the std reports on sta info cubes

 query---query run times/whm////---reports on std reports on stat infocubes

Line Item Dimension

line item dimension:if the size of dim table is more than 30% of fact table---then make that dim as line item dimension////

dim tab--lot of data---longer read time

fact table---dim table----sid---mdata tables


u can selct it as line item dimension-----if i make any dim as line item dim--

if u want to make nay dim as line item dimensio----ther should be only one char in that dim

sales order dim---(sales doc no)--line item ---sales docno(sid)---directly sid is placed to fact table

fact table--sid---master data

Indexes SAP bw InfoCube

Indexes:pointer to the records-----olap processor can serache record easily---db read time reduced

there r 2 types of indexes---bitmap//btree indexes/////primary indexs--maintained  by sys///secondery indexes--user

btree indexes r created on cardinality high table///bit map indexs r created on cardinality low table

table----Records


emp dim table
100
200
100
300
200----------------more repated values----cardinality low---

sales oredr dim
order no---1/2/3/4/5/'6---cardinality high


Note:indexes on info cube improves query performance but it tampers ur loading performance

before data loading delet indexes and after data loading maintain indexs--

to verify the indexs----se14---fact table

InfoCube Compression

1.COMPRESSIONS :

if i compress the info cube it aggregated the key figre values with same char combinations

ic
r1----eid/pid////sales
        100/11/1000
      200/12/1200 

r2---eid/pid/sales
      300/11/1200
      100/11/1200


q1----emp sale---db read----4 records///olap aggreagtion---2 records

100/11/2200
200/12/1200
300/11/1200

q1--eid/sales----db reocrds---3///////olap---0--------Reducing db read time/////Olap aggregation time---query performance

before compression data is there in "F" fact table//////after compression data is moved to "E" fact table

ic1----------req1/2/3/4/5-----compress--req5----sys compresses older request also---forms a unique request---00--ther in e fact table


after compression we cant delet data request wise----
ods---to info cube---compression


ods---icube--compress

ods
docno/eid/sales
1/100/1000

--activate=------100/1000-------------------info cube----100/1000

1/100/1500

ods
adt--1500

clt
-1000
1500

ods to infocube
-1000+1500=500

100///1000
100//500----------compress-----------100/1500


reconstruction--reinsert the delted data from info cube-----

1.psa must hold the data
2.status of the trnsafer stru must not be changed
3.update rules of the infocube--must be active


Selctive deletion:req--1---all the data is delted=-------if i want to delete the records selctively we have to go for selective deltion

req1-----eid 100

req1/2/3------------------100

Variables and Process Types Limitations and Usage

Aggregates

Aggregates:-
-----------
* Smaller Cube built on a Info Cube to Improve the Query pderformance.
* If we dont rollup the request it will not be available for reporting.

* Activate / Deactivate
* Switch on / off
* Delete

Aggregates:it is a subset of an info cube---baby cube---in the aggregates the data is stored in aggergated formate

icube
eid/calmonth/calquarter/sales
100/01/98///1/1000
200/01/98///1//1200
100/02/98///1///3400
200/02/98///1///4000

q1----eid/quarter/sales

db---records---4////olap---4 recordrds----------eid/quarter/sales
    100/1/4400
    200/1/5200



aggregate---calyera qurter/sales
  01/9600


q1---quarters/sales




ic1---aggr1/aggr2/agr3-olap proces----db read time///olap agrgation time


icube---detailed

aggergated---summrized data-----duplication of data-------

rsrt-------query trace


types of aggrgates:

1.aggregate by all char values---aggergate the data wrt all char combinations

calyeraquarters///sales
01/98////1000
01/98///2000/
02/98--300
04/98---5000
03/98---1200
03/98---1800

aggregates all chars

01/98---3000
02/98////300
03/98////3000
04/98///5000


2.aggergate by fixed value--single char value


country/sales
us///3000
us///5000
ca//2000
ge//4000

aggr---us
us/8000


3.aggregate by hier level
 level-1/2/3/4/5---each level we can maintain

1.aggregates----Mantain aggregates
aggr--simial r to info cube str-----fact tab---dim table---3 fixed dim--13 user dim

aggregate---fact table---2 fixed dim(unit/data package)+char(dim)


NOte:while loading data to info cube switch off the aggregate///aftr data loading switch on the aggregate

aggr--us

r10---ss---us/ca/gb-----1000---us---100

loading data to infocube and aggregate parally tampers ur loading preformance--


loading data from icube to aggregate----rollup 

Database Design in OLAP

Database Design in OLAP :-
-------------------------
* MDM:- Multi dimensional model.
* We can analyze data from multiple angles/dimensions by slicing and dicing the Info Cube.

*Star Schema:-
-------------- 
* Fact Table/Transaction data table at the center surrounded by Dimension tables/Master data tables connected with Primary Key - Foreign Key and all these tables existing inside the cube.

* Fact Table?
-------------
* any data what is stored in this table cannot be changed.

* Transaction data Table ?
-------------------------
* We store Transaction data in this table.

* Master data Tables ?
----------------------
* These tables store Master data(Detailed information about an entity).

* Dimension Tables ?
---------------------
* Each Master data table is acting as a side of a cube.

* Transaction Data Table / Fact Table will have 2 types of Coloumns:-

 a) Characteristics : on what basis we  analyze a keyfigure.

 b) Keyfigures : What we are   Analyzing.

* Each Characteristics coloumn in the fact table/transaction data table will connect to one Dimension table/Master data Table.

Types of ODS

Types of ODS:-
--------------
1) Standard
2) Transactional

1) Standard:-
--------------
* Data Target and Info Provider

2) Transactional:-
--------------------
* Used only for Planning. 
* Not available for Reporting.
* Only Active Data Table.
* Loading Data into Sebsequent data targets is possible.