SAP BW .....all info @ one place
SAP BW relevant Information
Loading

BI Data Modeling:
Business Content in SAP NetWeaver Business Intelligence ships with hundreds of InfoCubes and other data structures. To satisfy the demands of very demanding business communities, many of these structures are quite complex. The guidelines documents in this section describe the practices and recommendations used by SAP's internal Business Content developers to build these structures. As you build your own, you'll benefit from following their lead.

  1. Multi-Dimensional Modeling with SAP NetWeaver BI
  2. Modeling the Data Warehouse Layer with BI
  3. BI Data Modeling: MultiProviders and InfoSets
  4. Modeling Data Transformations in SAP NetWeaver Business Intelligence
  5. How to Routines within Transformations
Frontend Design:
  1. Frontend Design Guidelines - SAP BI in SAP NetWeaver 2004s (PDF 673KB)
  2. Frontend Design Guidelines - SAP BI in SAP NetWeaver 2004 (PDF 139KB)
  3. How to Create and Maintain User Interface Patterns for BI Content (PDF 6MB)
  4. Business Content - User Interface Patterns Guidelines (PDF 79KB)
  5. Download Package - the BI Template Wizard
  6. How to Calculate Balance Sheet Key Figures Using the Cell Editor in the BEx Query Designer (PDF 467KB)
  7. How to Add BI Reports to a Portal Page (PDF 2MB)
  8. How to Do Exception Broadcasting (PDF 490KB)
Source : BI Data Modeling and Frontend Design

 

Transporting from BWP TO BWQ : Reverse Transports
1.Create request in Source System (Eg: BWP) say A.
· Collect required objects into request A.
2.Goto TCode : SE09/SE10 --> create a transport of Copies request B
· Goto Tcode : SE09/SE10. You can see following screen.
Check, check box for Transport of Copies and click Create. Following screen comes. · Choose Transports of Copies and continue. Now you can see following screen.
Enter required Target system(F4 help available) Eg: BWQ.
3.Unlock Objects(Tcode : SE03) from Request A and Move Objects to Request B(Tcode SE10).
4.Delete objects from Request A.
5.Relase the request B
6.Go to Target System(Eg: BWQ) import Queue and import request.
7.In BWQ queue go to menu Request -->Forward--> give BWD or
you can directly provide BWD as Target System in Step 2.
8.Go to BWD and import the request.

 

BW Useful Tables

Posted In: , , , , , , , , , , , , , , , , , , , . By Srinivas Neelam


Custome Infoobjects
Tabels:
/BIC/M --
View of Master data Tables
/BIC/P -- Master data Table, Time Independent attributes
/BIC/Q -- Master data Table, Time Dependent attributes
/BIC/X -- SID Table, Time Independent
/BIC/Y -- SID Tabel, Time Dependent
/BIC/T -- Text Table
/BIC/H -- Heirarchy Table
/BIC/K -- Heirarchy SID Table

Standard Infoobjects Tabels(Buss. Content):
Replace "C" with "0" in above tables.
Ex:
/BI0/M -- View of Master data Tables


Standard InfoCUBE Tables :
/BI0/F --
Fact Table(Before Compression)
/BI0/E -- Fact Table(After Compression)
/BI0/P -- Dimension Table - Data Package
/BI0/T -- Dimension Table - Time
/BI0/U -- Dimension Table - Unit
/BI0/1, 2, 3, .......A,B,C,D : -- Dimension Tables

BW Tables:
BTCEVTJOB -- To check List of jobs waiting for events
ROOSOURCE -- Control parameters for Datasource
ROOSFIELD -- Control parameters for Datasource
ROOSPRMSC -- Control parameters for Datasource
ROOSPRMSF -- Control parameters for Datasource
-- More info @
ROOSOURCE weblog
RSOLTPSOURCE -- Replicate Table for OLTP source in BW
RSDMDELTA -- Datamart Delta Management
RSSDLINITSEL, RSSDLINITDEL
--
Last valid Initialization to an OLTP Source
RSUPDINFO -- Infocube to Infosource correlation
RSUPDDAT -- Update rules key figures
RSUPDENQ -- Removal of locks in the update rules
RSUPDFORM -- BW: Update Rules - Formulas - Checking Table
RSUPDINFO -- Update info (status and program)
RSUPDKEY -- Update rule: Key per key figure
RSUPDROUT -- Update rules - ABAP routine - check table
RSUPDSIMULD -- Table for saving simulation data update
RSUPDSIMULH -- Table for saving simulation data header information
RSDCUBEIOBJ -- Infoobjects per Infocube
RSIS -- Infosouce Info
RSUPDINFO -- Update Rules Info
RSTS -- Transfer Rules Info
RSKSFIELD -- Communication Structure fields
RSALLOWEDCHAR -- Special Characters Table(T Code : RSKC, To maintain)
RSDLPSEL -- Selection Table for fields scheduler(Infpak's)
RSDLPIO -- Log data packet no
RSMONICTAB -- Monitor, Data Targets(Infocube/ODS) Table, request related info
RSTSODS -- Operational data store for Transfer structure
RSZELTDIR -- Query Elements
RSZGLOBV -- BEx Variables
RXSELTXREF, RSCOMPDIR -- Reports/query relavent tables
RSCUSTV -- Query settings
RSDIOBJ -- Infoobjects

RSLDPSEL -- Selection table for fields scheduler(Info pak list)
RSMONIPTAB -- InfoPackage for the monitor
RSRWORKBOOK -- Workbooks & related query genunid's
RSRREPDIR -- Contains Genuin id, Rep Name, author, etc...
RSRINDEXT -- Workbook ID & Name
RSREQDONE -- Monitor: Saving of the QM entries
RSSELDONE -- Monitor : Selection for exected requests
RSLDTDONE -- Texts on the requeasted infopacks & groups
RSUICDONE -- BIW: Selection table for user-selection update Infocubes's
RSSDBATCH -- Table for Batch run scheduler
RSLDPDEL -- Selection table for deleting with full update scheduler
RSADMINSV -- RS Administration

RSSDLINIT -- Last Valid Initializations to an OLTP Source
BTCEVTJOB --To check event status(scheduled or not)
VARI -- ABAP Variant related Table
VARIDESC -- Selection Variants: Description

SMQ1 -- QRFC Monitor(Out Bound)
SM13 -- Update Records status

T Code : LBWQ --> QRFC related Tables
TRFCQOUT,
QREFTID,
ARFCSDATA

More info @
Note 728687 - Delta queued: No data in RSA7






 


RSW
_RATE_GET_BASIC
-- To get exchange rate
-- To get exchange rate for combination of source and target currency for defined exchange rate type
WEEK_GET_FIRST_DAY -- First day of week
DATA_TO_PERIOD_CONVERT -- To derive period from Date
RSAPO_SWITCH_BATCH_TO_TRANS, RSAPO_SWITCH_TRANS_TO_BATCH
-- To change Transactional cube to basic cube & basic cube to tran cube
BAPI_USER_ACTGROUPS_ASSIGN -- To assign Roles to User
BAPI_USER_GET_DETAILS - To get User Details
SUPRN_INS_OR_DEL_PROFILE -- To insert or delete a Profile
RSBCTDPE_GET_ROLE_FOR_USER -- To see Roles per User
BP_EVENT_RAISE
-- To raise an EVENT
RSDTM_ICD_DATA_DOWNLOAD -- To Download data from Infocube
RSPC_API_CHAIN_START -- To Start process Chain
RSPC_PROCESS_FINISH -- To finish any process in Process Chain
-- how to use : RSPC_PROCESS_FINISH (To restart PChain)
RSU5_SAPI_BADI -- To enhance Master data(Note : 709816)
RSDMD_DEL_MASTER_DATA -- To delete Master Data
RSMDM_MD_ACTIVATE -- To activate Master Data
BAPI_IOBJ_CREATE -- To Create Infoobjects
BAPI_IOBJ_REORG -- To reorganise Infoobjects
BAPI_IPAK_START -- To start Infopackage
BAPI_IPAK_CHANGE -- To Change Infopackage
BAPI_IPAK_GET_DETAIL -- To get details of Infopackage
RSSM_GET_REQUEST_STATUS -- To get request Status
BAPI_ISREQUEST_GETSTATUS -- To get request status
FILE_GET_NAME -- To get file Name.

RSW_RATE_GET_BASIC -- To Currency Translation
RSAOS_METADATA_UPLOAD -- To Replicate datasources selectively
RSDRD_DELETE_FACTS
-- To delete data selectively
RSDU_CHECK_PKEY_FACTTAB_DB6 -- Checks the partitioning key for the fact table of an InfoCube.
RSDU_CHECK_PKEY_ODSTAB_DB6 -- Checks the partitioning key for an ODS table.
RSDU_CHECK_PKEY_PSATAB_DB6 -- Checks the partitioning key for a PSA table
RSDRI_INFOPROV_READ -- To read data from Infocubes

RSPC_API_CHAIN_SCHEDULE -- To raise an event from R/3 source system

 

BW Useful Programs

Posted In: , , , , , , , , , , , , . By Srinivas Neelam


RSIMPCURR
--
To Transfer Exchange Rates
RSIMPCUST -- To Transfer Global Settings from source system
RS_TRANSTRU_ACTIVATE_ALL -- To Activate Transfer Rules
-- Useful whenever we need to activate transfer rules in Quality or Production system after transports.

RSAU_UPDR_REACTIVATE_ALL -- To Activate Update Rules
SAP_CONVERT_TO_TRANSACTIONAL -- To change Basic Cube to Transactional Cube
RSAR_PSA_CLEANUP_DIRECTORY -- To Clean PSA and Change log
SAP_INFOCUBE_DESIGN --
To know statistics(Size) of Cubes
--
Useful to know the size of Fact Tables and Dimension Tables
RSSM_SET_REPAIR_FULL_FLAG --
To change request status from Full load to repair full
-- Useful to start delta loads, If full loads are already present in data target from same data source
RSDDS_AGGREGATES_MAINTAIN -- For Hierarchy/Attribute Change run
RSDDS_CHANGERUN_MONITOR -- To Check Change run Status

RSDG_ODSO_ACTIVATE -- To Activate ODS in background. very much useful when BEx reporting switched on.
RSDG_IOBJ_ACTIVATE -- To Activate Infoobjects(Mass Activation)
RSDG_MPRO_ACTIVATE -- To Activate MultiProviders
RSDG_CUBE_ACTIVATE -- Activation of InfoCubes
RS_COMSTRU_ACTIVATE_ALL -- Activate all inactive communication structures
RSCONN07 - SAP Connect Administration(System Status)
RSAOS_METADATA_UPLOAD_BATCH -- To replicate single datasource from Source(R/3)

RSDRD_DELETE_FACTS -- To delete data selectively from infoprovider(ODS or CUBE)
RSAR_LOGICAL_SYSTEMS_ACTIVATE -- Activate All SAP Source Systems (After BW Upgrade)
RSDS_DATASOURCE_ACTIVATE_ALL -- Activate All DataSources of a Log System
RSTCC_ACTIVATE_ADMIN_COCKPIT -- Perform all steps to activate the content for the BI Admin Cockpit
RSTCC_ACTIVATEADMINCOCKPIT_NEW -- Activate Content for the BI Admin Cockpit

 


Attribute and hierarchy change run :
If you change master data (navigation attributes) or hierarchies of a characteristic that is contained in aggregates, you must adjust these aggregates. This ensures that queries that access the InfoCube or assigned aggregates are consistent. Unlike in the aggregates, no data that refers to navigation attributes or hierarchies is stored in the InfoCube. The master data or the hierarchy tables are joined with the tables of the cube when the query is executed.Regardless of whether or not aggregates exist, the system does not automatically transfer master data record changes, rather you must activate this master data explicitly. If aggregates are involved, you must adjust them using the change run before you can 'release' the data record changes (the corresponding InfoObjects or hierarchies are registered for the next change run: Transaction RSA1 -> Tools -> Apply Hierarchy/Attribute Change -> InfoObject List or Hierarchy List).

Problem: In any SAP System only One attribute change run can run at one point of time. i. e If one attribute change run is running in system from any process chain or for any project and 2nd one fails, if start at same time due to locking problem. Due to this entire data load fails.

Solutions:
1. Shift Change runs from info package level to global level and/or process chain level in order of priority. Means instead of keeping ACR after each infopackage update we can accumulate all in one ACR at end of Process Chain or in a separate chain, if this data is not dependent for next loads(means no look ups).

2. Increase CR_MAXWAIT time. CR_MAXWAIT is to create a delay for second attribute change run while the first attribute change run is running in the system.
At any single point in time, there can only be one CR in the startphase. Every other CR will immediately fail when unsuccessfullytrying to acquires the startlock. No wait is done here.
Above option is helpfull When the running CR is in the workphase, only then will a second CR enter the start phase and wait as long as specified in CR_MAXWAIT.And when the second CR is in the startphase, all other CRs trying to start will again immediately fail.
For more info @ SAP Note : Note 825927 - The BW Changerun: CR_MAXWAIT .so this is not 100% solution.

3. Created an ABAP Program and included before each Attribute Change Run in Process Chains. This Program checks if any ACR running in the system or not. If any ACR is running it delays 10 Secs. Recursively it checks and delays 10 secs every time. Program execution finishes only when there is not ACR running in the system and allows next process(Attribute Change Run) to trigger in Process Chain. After implementation of this program no ACR failures in our system. Check the coding at end of this blog in appendix.

How to implement:

Step1: Create an ABAP program(eg: ZRSDDS_CHANGERUN_MONITOR), coding available at Appendix. create a variant aswell for no of sces neets to wait at max.

Step2. Include this ABAP program in Process Chains between infopackage and Attribute Change runs as shown in the screenshot.

step3: Goto Process Chain(TCode: RSPC) and choose perticular process chain, then goto processes and choose ABAP program provide technical name and description. Provide created ABAP program and Variant save and activate Process Chain.


Appendix:

How to Integrate an ABAP Program in a Process Chain

Note 903886 - Hierarchy and attribute change run

Note 825927 - The BW Changerun: CR_MAXWAIT

Code :

*REPORT ZRSDDS_CHANGERUN_MONITOR.
TYPE-POOLS: rsdds, rrhi, rsd.
SELECTION-SCREEN BEGIN OF BLOCK NO_TIMES WITH FRAME.
PARAMETERS : L_TIMES TYPE I. --> Create a variant provide value(ex: 100, then it will wait at max 100*10 secs).
SELECTION-SCREEN END OF BLOCK NO_TIMES.
DATA: l_cr_state TYPE rsdds_cr_state,
l_t_chanm TYPE rsd_t_iobjnm,
l_s_chanm TYPE rsd_s_iobjnm,
l_t_hieid TYPE rshi_t_hieid,
l_hieid TYPE rshi_hieid,
l_t_aggrstate TYPE rsdds_t_aggrstate,
l_s_aggrstate TYPE rsdds_s_aggrstate,
l_t_msg TYPE rs_t_msg,
l_s_msg TYPE rs_s_msg.
write: /1 'Date' color 7, 12 'Time' color 7,
22 'Attribute change run Status'
color 7 .
Write AT /1(52) SY-ULINE.
DO L_TIMES TIMES.
CALL FUNCTION 'RSDDS_CHANGERUN_MONITOR'
IMPORTING
e_cr_state = l_cr_state
e_t_chanm = l_t_chanm
e_t_hieid = l_t_hieid
e_t_aggrstate = l_t_aggrstate
e_t_msg = l_t_msg.
case l_cr_state.
when rsdds_c_cr_state-finished.
write: /1 sy-datum, 12 sy-timlo,
22 'No Attribute change run Running'
color col_positive . --> We can check this program is usefull or not... how many times it saved dataload failues due to ACR Collision
(SPOOl we can check at TCODE: SP01)
EXIT.
when rsdds_c_cr_state-start.
write: /1 sy-datum, 12 sy-timlo,
22 'Attribute change run Started'
color 3.
wait up to 10 SECONDS.
when rsdds_c_cr_state-running.
write: /1 sy-datum, 12 sy-timlo,
22 'Attribute change run Running'
color col_negative.
wait up to 10 SECONDS.
when rsdds_c_cr_state-canceld.
write: /1 sy-datum, 12 sy-timlo,
22 'Attribute change run Cancelled'
color 4.
EXIT.
endcase.
ENDDO.

 


Free ebooks download for free
-- You can download some ebooks for free from this website available for many technologies..
SAP BW : Step-By-Step (FU FU)
SAP BW Certification - by Catherine M Rose

SAP BW Interview Questions - download for free
-- Download ebook for free from this site.
Book is very good, covers all areas of BW(Extraction, Modeling, Reporting, infospokes, process chains, user exits, routines, sample codes, data load monitor: errors & fixing, all types of extraction.... etc...

All Articles on SAP NetWeaver Business Intelligence
-- Very Good One... contains Articles, eBooks etc.... on all areas of Business Intelligence..

Five Ways to Enhance SAP BI back end Functionality Using ABAP
-- It covers how to write field wise routines, start routines in Update Rules & Transfer Rules and infopackage routines.
-- It Covers how to enhance datasource, user exit variables, ABAP in Process Chains, etc....

BI Performance Tuning


-- Contains all information related to BI performance tuning.


Performance Tuning for SAP BW : pdf


Performance Tuning for Queries with Aggregates : pdf


BEx Front-End Performance: Performance Analyses of BEx Analyzer and Web Application in the Local and Wide Area Networks Environment : pdf


SAP BW Data Load Performance Analysis and Tuning : e learning


-- Need SDN User ID and Password to log-on.

 

SAP Tables

Posted In: , , , , , , , , , , , , , , . By Srinivas Neelam
 

SAP BW Useful Trasactions

Posted In: , , , , , . By Srinivas Neelam


T Code Description
DB02 -- Table and Indexes Monitor
DB04 -- DB Performance Monitor
DB12 -- Backup logs
DB13 -- DBA Oracle Planning Calendar
DB16 -- Overview of Database Check Messages
ST02 -- Tune Summary
ST03 -- Worload: Statistical Records
LISTSCHEMA -- List Schemas
RSDCUBE -- To edit Infocube
PFCG -- Authorisation
RSSM -- Authorisation Objects
RRMX -- Business Analyser Loader
RSZDELETE -- To Delete Query Elelements
RSCUSTV4 -- BEx Values(To View/Change Global BEx Settings)
SCC4 -- Client Overview
RS12 -- Overview of master data locks
RSA1 -- Administrator’s Workbench
RSA5 -- Transfer Business Content DataSources
RSD1 -- InfoObject Maitenance
RSH1 -- Heirarchy's
RSDS -- keyfigures
SQ02 -- Infosets
RSISET -- Infosets
RSDDV - Maintain Aggregates
RSRTRACE -- Configuration Tool(Trace)
RSRCACHE -- To monitor/define Query Cache
BW30, SP17 -- Access modes for Query's(new, stored, hybrid, static)
RSMO -- Admin Work Bench Monitor
RSOR -- Metadata Repositoty
RSORBCT -- Bussiness Content
RSBBS -- Query Jump Targets
RSO2 -- Generic Data Extraction Tools. Maintain /Create datasource
RSQ02 -- Maintain Infosets transactions
RSQ10 -- Roles for Infoset query
RSRV -- Analysis and repair of BW Objects
RSSM -- Reporting Authorisation Objects
RSRT -- Query read Mode and analysis
RSZC -- Copy Queries between cubes
RSZDELETE -- Delete queries and workbooks
RSZV -- Maintaining variables
RZ10 -- Maintain profile parameters
RZ20 -- CCMS monitoring
SALE -- IMG for ALE
SBIW -- Implementation Guide
SCC4 -- Display/Add Client
SCCL -- Copy Client
SGEN -- SAP Load Generator
SPAD -- Spool Administration
ST02 -- Database Tune Summary
ST03 -- Workload Monitor
ST04 -- DB Performance Monitor
STMS -- Transport Manager
SU01 -- Create new user
SU10 -- Mass User Maintenance
RSA5 -- To Install datasources from Bussinesscontent
RSA6 -- Subsequent Process Datasources
RSA9 -- To Transfer application component heirarchy
RSA3 -- Extractor checker(To check datasource)
LBWE -- LO Data Extraction: Customizating Cockpit
LBWF -- BW Log
LBWG -- To delete Setup Tables
OLI*BW -- To fill Setup Tables( * --> Application Component)
OLI1BW -- To fill Setup Tables - Material Moments
OLI2BW -- To fill Setup Tables - Material Moments
OLI3BW -- To fill Setup Tables - Purchase Orders
OLI7BW -- To fill Setup Tables - Sales Orders
OLI8BW -- To fill Setup Tables - Deliveries
OLI9BW -- To fill Setup Tables - Billing
NPRT -- To see setup log
SLG2 - To delete expired logs
RZ20 - To see log for Process Chains
SM62 -- To Create an Event
SE93 -- To view Transaction Codes
SNOTE -- To implement SAP Note
OB08 -- Currency Exchange Rates - Overview
SMQ1 - qRFC Monitor for the outbound queue. You can use this to monitor the status of the LUWs in the outbound queue.
SMQ2 - qRFC Monitor for the inbound queue. You can use this to monitor the status of the LUWs in the inbound queue.
SMQS – You can use the Outbound Queue Scheduler to register, deregister, and exclude destinations.
SMQR – You can use the Inbound Queue Scheduler to register and deregister queues.
http://help.sap.com/saphelp_470/helpdata/en/0c/275c3c60065627e10000000a114084/frameset.htm
http://help.sap.com/saphelp_nw2004s/helpdata/en/76/e12041c877f623e10000000a155106/frameset.htm

Need more check @ https://www.sdn.sap.com/irj/sdn/wiki?path=/display/BI/BI+FAQ+-+Important+Transaction+Codes+in+SAP+Business+Intelligence&

https://www.sdn.sap.com/irj/sdn/thread?threadID=19879

-- More info @ Implementing Correction




 

How to Papers, related to BW direct download

Google
 

Recent Posts

SAP Jobs