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