Complete information about Semantic Partitioned Objects (SPO) in BW 7.3

This document explains everything about SPO's in BW 7.3. This documents covers the following things.

1) Components of SPO and naming convention

2) Modelling of SPO

3) Tables related to SPO

4) Enhancements in modelling

5) DTP creation for SPO's

6) Other functionalities.

ALL YOU NEED TO KNOW ABOUT SEMANTICALLY PARTITIONED OBJECT IN BW 7.30

Design Considerations for BW 7.3 Info Providers

The below are the list of info providers which are newly added in BW 7.3.

1) Semantic Partitioned Object(SPO)

2) Hybrid Provider

3) Composite Provider

4) Transient Provider.

The below documents gives the information about each info provider, design, when to use which one, advantages and dis advantages.

DESIGN CONSIDERATION FOR 7.30 INFOPROVIDERS - WEBINAR PRESENTATION

Dataflow copy tool in SAP BW 7.3

In BW 7.3 we have new functionality called data flow. Using this tool development work will be reduced, in this document step by step procedure is explained with detailed step.


SAP BW 7.3 -- Dataflow copy tool

Brief overview of new features in SAP BW 7.3

The below are the some of the new features added in SAP BW 7.3

1. Hybrid providers
2. Graphical Data flow modeler
3. Accelerated data loads
4. Semantic partitioning
5. Integrated planning front end
6. Analytical indexes

In this document we have detailed view about the above features.

SAP BW 7.3 - New features

SAP BW Errors and Fixes for Transports

This document will explain about the issues we face when we are dealing with transports in SAP BI system and how to solve them.

SAP BW Errors and Fixes for Transports

Transports in SAP BW: Issues and Resolution

Validity Table in SAP BW/BI

Validity table stores the characteristic values for which non cumilative keyfigures are valid. Non cumilative key figures are objects that are always in relation to a point in time and are not simply summarized.

This comes in picture when you are creating info cubes for inventory management.

The below documnets explians the step by step procedure to maintain validity table for non cumilative key figures.

Validity Table in SAP BW/BI

SAP Transport Procedures and Best Practices

This documents explains about the land scape of SAP, how to create transport request in ECC and BI as well. It explains about the naming conventions, objects collecting procedures and releasing of the transports.

for detailed and step by step information check out the below document.

SAP Transport Procedures and Best Practices

how to find Size of Data Target [Cube/DSO]

Many times we need to know exact size of the data target. It could be cube or DSO. When we create data target on the server, server automatically creates some space on the server. This space or size varies time by time. Basically Size is based on volume of the data in data target.

We can achieve this using two methods.

1) By using trasaction code
2) using functional module

check the below document for step by step procedure.

Getting Size of Data Target [Cube/DSO]

Changing ECC Source Systems without Affecting Data Modeling Objects in SAP BW

This document discusses about switching ECC source systems in SAP BW Environment without affecting the data modeling objects in the BW environment. By data modeling objects, we mean transformations, update rules and transfer rules getting inactive or getting deleted. Once the source system is switched, data reload needs to happen to have the initializations and deltas to come from the new source system. Also we have to ensure that the data from old source system( both transactional and master ) needs to be deleted in the BW system before reloading from the data from new source system to ensure consistency in the data from new system.

The below documents will explain the step by step procedure.

Step by Step on Changing ECC Source Systems without Affecting Data Modeling Objects in SAP BW

creation of multiple characteristics and key figures in one click

Do you know that we can create multiple characteristics and key figures in one click?


All you need to do for this is create an ABAP program using SE38 and create custom t-code for this program in SE93.


Now prepare your excel file with list objects you want to create and select the infor area to which you want to assign this objects.


For step by step procedure refer the below document and you have code as well.


Wrapper Tool for Creating Multiple Info Objects in one go

Reverse Transport mechanism in SAP BI

In some rare cases, we will find us in a situation where we have to do reverse transportation from Production or Quality system to Development system.

Lets take a senario where you have devoped some big queries or objects and transported till Production system. After sometime unfortunately you have losed those changes in Development system. In this case you can get those changes by performing reverse transportation in SAP BI.

In all the times, reverse transportation is not advisable as it includes risk and require hyper care. If you don't have any other option, then you can go for this.

Attached document will give you the step by step procedure about reverse transportation in SAP BI.

Reverse Transport Mechanism in SAP BI

Different jobs in SM37 when process chain runs

The below table gives the information about the jobs run in SM37 when we run process chains.

Job Name	Description	Program	Variant ( TYPE)
BI_PROCESS_ABAP	Job for ABAP Program	RSPROCESS	ABAP
BI_PROCESS_ATTRIBCHAN	Attribute Change Run Job	RSPROCESS	ATTRIBCHAN
BI_PROCESS_DROPCUBE	Delete the contents of the cube Job	RSPROCESS	DROPCUBE
BI_PROCESS_DROPINDEX	Delete Database indexes Job	RSPROCESS	DROPINDEX
BI_PROCESS_DTP_LOAD	Load data using a DTP	RSPROCESS	DTP_LOAD
BI_PROCESS_INDEX	Create Database Indexes	RSPROCESS	INDEX
BI_PROCESS_LOADING	Load data using Info Package	RSPROCESS	LOADING
BI_PROCESS_ODSACTIVAT	ODS Activation	RSPROCESS	ODSACTIVAT
BI_PROCESS_ROLLUP	Rollup to BWA/Aggregates	RSPROCESS	ROLLUP
BI_PROCESS_TRIGGER	Start of Process Chain	RSPROCESS	TRIGGER
BI_PROCESS_PSADELETE	Delete the contents of PSA	RSPROCESS	PSADELETE

SD LO Data sources and Source tables

Most of the time we will find difficult to find the source tables for LO data sources.

Here i have given information SD LO Data sources.

VBRK(Billing Doc Header), 

VBRP(Billing Doc Item), 

VBAK(Sale Doc Header), 

VBAP(Sale Doc Item), 

VBUK(Sale Doc Header status) 

VBUP(Sale Doc Item Status), 

LIKS (Delivery header Data) 

LIPS(Delivery item Data) ,

2LIS_11_VAHDR --> VBAK,VBUK

 

2LIS_13_VDITM --> VBRK,VBRP,VBUK,VBUP 

2LIS_13_VDHDR --> VBRK,VBUK 

2LIS_11_VAITM --> VBAK,VBAP,VBUK,VBUP 

2LIS_12_VCHDR --> LIKP,VBUK 

2LIS_12_VCITM --> LIKP,LIPS,VBUK,VBUP

Record Mode Concept in Delta Management

This document explains about the 0recordmode and delta management in SAP Bi system.

Record Mode Concept in Delta Management

Time Distribution and Automatic Time Conversion in Update Rules

This document explain the procesdure about Time Distribution and Automatic Time Conversion in Update Rules.

Time Distribution and Automatic Time Conversion in Update Rules

Deleting the Requests from the PSA and Change Log Tables in Business Intelligence

This document will explain about the deleting change log and PSA tables in BI using process chains.

Deleting the Requests from the PSA and Change Log Tables in Business Intelligence

Automatic Deletion of Similar/Identical Requests from InfoCube after Update

This document explains the concept of automatically deleting the overlapping requests from InfoCube with a step by step solution.

Automatic Deletion of Similar/Identical Requests from InfoCube after Update

Efficient Monitoring Techniques – Do You Want Something Better than RSPCM?

This document explains about the different ways to minotor the process chains in SAP BI.

Efficient Monitoring Techniques – Do You Want Something Better than RSPCM?

Number Range Buffering for DIM IDs and SIDs

During the Master Data Loading, each record will go to database table and pick the new SID number.
Similarly, during the Info Cube data loading also each record will go to database table and gets the new
DIM-ID. Since we have huge amount of data, the performance of the loading will be decrease. Because all
the records will go to database table and gets new either the SID (or) DIM ID numbers.

This document will explain how to do number range buffering.

Number Range Buffering for DIM IDs and SIDs

Triggering the Process Chains at Last Day of Every Month using Events

This article describes how to execute/trigger the Process Chain on Last Day of Every Month using Events. Here I took Exchange Rates and Global settings. i.e. these two things need to change on Last Day of every Month. Based on your requirement, you can change the process chain events, i.e. you can use this logic for Data Loads or for some other purpose also.

Triggering the Process Chains at Last Day of Every Month using Events

Triggering the Process Chains at Particular Date using Events

This article describes how to run the Process Chain at particular Dates using Events. The requirement is every month we need to load the data (or Trigger the Process chain) on 8th and 11th day.

•This logic is useful in different scenarios also; here I’m taking Process Chain Scenarios.
•Using this logic, you can also automate some Programs/Function Modules etc...

Triggering the Process Chains at Particular Date using Events

Exception Aggregation in Business Explorer

This article will give yuo information about the Exception aggregation in SAP BEx query designer with examples.


Exception Aggregation in Business Explorer

LO Extraction datas sources and setup tables list

The below list will give you the information about the LO data sources and it's setup table names.

Application		Data Source	Setup Table	Description
2	Purchasing	2LIS_02_ACC	MC02M_0ACCSETUP	Folder: BW Setup for MC02M_0ACC
	Purchasing	2LIS_02_CGR	MC02M_0CGRSETUP	BW-Rebuild for MC02M_0CGR Storage
	Purchasing	2LIS_02_HDR	MC02M_0HDRSETUP	Storage BW Setup for MC02M_OHDR
	Purchasing	2LIS_02_ITM	MC02M_0ITMSETUP	Storage BW Setup for MC02M_OITM
	Purchasing	2LIS_02_SCL	MC02M_0SCLSETUP	Storage BW Setup for MC02M_OSCL
	Purchasing	2LIS_02_SCN	MC02M_0SCNSETUP	BW-Rebuild for MC02M_0SCN Storage
	Purchasing	2LIS_02_SGR	MC02M_0SGRSETUP	BW-Rebuild for MC02M_0SGR Storage
3	Inventory Controlling	2LIS_03_BF	MC03BF0SETUP	Save BW Reorganization for MC03BF0
	Inventory Controlling	2LIS_03_BX	MC03BX0SETUP	BW Stock Initialization Storage for MC03BF
	Inventory Controlling	2LIS_03_UM	MC03UM0SETUP	Save BW Reorganization for MC03UM0
4	Production / Shop Floor Control	2LIS_04_P_ARBPL	MC04P_0ARBSETUP	BW Reorganization Store for MC04P_0ARB
	Production / Shop Floor Control	2LIS_04_P_COMP	MC04P_0COMSETUP	BW Reorganization Store for MC04P_0COM
	Production / Shop Floor Control	2LIS_04_P_MATNR	MC04P_0MATSETUP	BW Reorganization Store for MC04P_0MAT
	Production / Shop Floor Control	2LIS_04_PEARBPL	MC04PE0ARBSETUP	BW Reorganization Store for MC04PE0ARB
	Production / Shop Floor Control	2LIS_04_PECOMP	MC04PE0COMSETUP	BW Reorganization Store for MC04PE0COM
	Production / Shop Floor Control	2LIS_04_PEMATNR	MC04PE0MATSETUP	BW Reorganization Store for MC04PE0MAT
5	Quality Management	2LIS_05_Q0ACTY	MC05Q00ACTSETUP	BW Reorganization Store for MC05Q00TSK (Notif. Activity)
	Quality Management	2LIS_05_Q0CAUSE	MC05Q00CSESETUP	BW Reorganization Store for MC05Q00CSE (Notification Cause)
	Quality Management	2LIS_05_Q0ITEM	MC05Q00ITMSETUP	BW Reorganization Store for MC05Q00ITM (Notification Item)
	Quality Management	2LIS_05_Q0NOTIF	MC05Q00NTFSETUP	BW Reorganization Store for MC05Q00NTF (Notification)
	Quality Management	2LIS_05_Q0TASK	MC05Q00TSKSETUP	BW Reorganization Store for MC05Q00TSK (Notification Task)
	Quality Management	2LIS_05_QE1	MC05Q1_INSPSETUP	BW Reorganization Store for MC05Q1_0INSP (Check Results)
	Quality Management	2LIS_05_QE2	MC05Q2_INSPSETUP	BW Reorganization for MC05Q2_0INSP (Inspection Results)
	Quality Management	2LIS_05_QVUDN	MC05QV0UDNSETUP	Store BW Reconstruction for MC05QV0UDN (Usage Decision)
6	Invoice Verification	2LIS_06_INV	MC06M_0ITMSETUP	Folder: BW Setup for MC06M_0ITM
8	Transport/ Shipment/Shpmt Costs	2LIS_08TRFKP	MC08TR0FKPSETUP	Storage BW Reorganization for MC08TR0FKP
	Transport/ Shipment/Shpmt Costs	2LIS_08TRFKZ	MC08TR0FKZSETUP	BW Reorganization Store for MC08TR0FKZ
	Transport/ Shipment/Shpmt Costs	2LIS_08TRTK	MC08TR0TKSETUP	BW Reorganization Store for MC08TR0TK
	Transport/ Shipment/Shpmt Costs	2LIS_08TRTLP	MC08TR0TLPSETUP	BW Reorganization Store for MC08TR0TLP
	Transport/ Shipment/Shpmt Costs	2LIS_08TRTS	MC08TR0TSSETUP	BW Reorganization Store for MC08TR0TS
11	SD Sales Orders	2LIS_11_V_ITM	MC11V_0ITMSETUP	BW Reorganization Store for MC11V_0ITM
	SD Sales Orders	2LIS_11_V_SCL	MC11V_0SCLSETUP	BW Reorganization Store for MC11V_0SCL
	SD Sales Orders	2LIS_11_V_SSL	MC11V_0SSLSETUP	BW Reorganization Store for MC11V_0SCL
	SD Sales Orders	2LIS_11_VAHDR	MC11VA0HDRSETUP	BW Reorganization Store for MC11VA0HDR
	SD Sales Orders	2LIS_11_VAITM	MC11VA0ITMSETUP	BW Reorganization Store for MC11VA0ITM
	SD Sales Orders	2LIS_11_VAKON	MC11VA0KONSETUP	Storage BW Reconstruction for MC11VA0KON
	SD Sales Orders	2LIS_11_VASCL	MC11VA0SCLSETUP	BW Reorganization Store for MC11VA0SCL
	SD Sales Orders	2LIS_11_VASTH	MC11VA0STHSETUP	BW New Structure Store for MC11VA0STH
	SD Sales Orders	2LIS_11_VASTI	MC11VA0STISETUP	BW New Structure Store for MC11VA0ST
12	LE Deliveries / Shipping	2LIS_12_VCHDR	MC12VC0HDRSETUP	BW Reorganization Store for MC12VC0HDR
	LE Deliveries / Shipping	2LIS_12_VCITM	MC12VC0ITMSETUP	BW Reorganization Store for MC12VC0ITM
	LE Deliveries / Shipping	2LIS_12_VCSCL	MC12VC0SCLSETUP	BW Reorganization Store for MC12VC0SCL
13	SD Billing Documents	2LIS_13_VDHDR	MC13VD0HDRSETUP	BW Reorganization Store for MC13VD0HDR
	SD Billing Documents	2LIS_13_VDITM	MC13VD0ITMSETUP	BW Reorganization Store for MC13VD0ITM
	SD Billing Documents	2LIS_13_VDKON	MC13VD0KONSETUP	Storage BW Reconstruction for MC13VD0KON
17	Plant Maintenance	2LIS_17_I0ACTY	MC17I00ACTSETUP	BW Reorganization Store for MC17I00ACT (Notif. Activity)
	Plant Maintenance	2LIS_17_I0CAUSE	MC17I00CSESETUP	BW Reorganization Store for MC17I00CSE(Notification Cause)
	Plant Maintenance	2LIS_17_I0ITEM	MC17I00ITMSETUP	BW Reorganization Store for MC17I00ITM (Notification Item)
	Plant Maintenance	2LIS_17_I0NOTIF	MC17I00NTFSETUP	BW Reorganization Store for MC17I00NTF (Notification)
	Plant Maintenance	2LIS_17_I0TASK	MC17I00TSKSETUP	BW Reorganization Store for MC17I00TSK (Notification Task)
	Plant Maintenance	2LIS_17_I3HDR	MC17I30HDRSETUP	Store BW reconstruction for MC17I30HDR (Order)
	Plant Maintenance	2LIS_17_I3OPER	MC17I30OPRSETUP	Store BW Reconstruction for MC17I30OPR (Process)
18	Customer Service	2LIS_18_I0ACTY	MC18I00ACTSETUP	BW Reorganization Store for MC18I00TSK (Notif. Activity)
	Customer Service	2LIS_18_I0CAUSE	MC18I00CSESETUP	BW Reorganization Store for MC18I00CSE(Notification Cause)
	Customer Service	2LIS_18_I0ITEM	MC18I00ITMSETUP	BW Reorganization Store for MC18I00ITM (Notification Item)
	Customer Service	2LIS_18_I0NOTIF	MC18I00NTFSETUP	BW Reorganization Store for MC18I00NTF (Notification)
	Customer Service	2LIS_18_I0TASK	MC18I00TSKSETUP	BW Reorganization Store for MC18I00TSK (Notification Task)
	Customer Service	2LIS_18_I3HDR	MC18I30HDRSETUP	Store BW Reconstruction for MC18I30HDR (Order)
	Customer Service	2LIS_18_I3OPER	MC18I30OPRSETUP	Store BW Reconstruction for MC18I30OPR (Process)
40	Retail / Retailing	2LIS_40_REVAL	MC40RP0REVSETUP	BW Reorganization Store for MC04PE0ARB
45	Agency Business	2LIS_45_CDLST	MC45CD0LSTSETUP	Folder: BW Setup for MC45CDLST
	Agency Business	2LIS_45_PDLST	MC45PD0LSTSETUP	Folder: BW Setup for MC45PD0LST (Posting List)
	Agency Business	2LIS_45_VDLST	MC45VD0LSTSETUP	Folder: BW Setup for MC45VD0LST (Settlement Vendor)
	Agency Business	2LIS_45_HDR	MC45W_0HDRSETUP	Folder: BW setup for MC45W_0HDR
	Agency Business	2LIS_45_ITM	MC45W_0ITMSETUP	Folder: BW Setup for MC45W_0ITM
	Agency Business	2LIS_45_LST	MC45W_0LSTSETUP	Folder: BW Setup for MC45W_0LST

LO Extraction : Tcode and program for filling setup tables

One of the most important activity while performing LO extraction is Setup tables filling. We often find difficulty while finding out the t-code and program which runs in SM37 when you fill setup tables for LO Extractors.

Below list will give you the clear information.

Datasource                              Tcode                        Program

2LIS_02*                              OLI3BW                 RMCENEUA

2LIS_03_BX                         MCNB                    RMCBINIT_BW
   
2LIS_03_BF                         OLI1BW                  RMCBNEUA
   
2LIS_03_UM                        OLIZBW                 RMCBNERP

2LIS_04* orders                   OLI4BW                  RMCFNEUA
   
2LIS_04* manufacturing       OLIFBW                  RMCFNEUD
   
2LIS_05*                             OLIQBW                  RMCQNEBW
   
2LIS_08*                             VTBW                     VTRBWVTBWNEW
   
2LIS_08* (COSTS)              VIFBW                    VTRBWVIFBW
   
2LIS_11_V_ITM                 OLI7BW                   RMCVNEUA
   
2LIS_11_VAITM                OLI7BW                   RMCVNEUA
   
2LIS_11_VAHDR               OLI7BW                   RMCVNEUA
   
2LIS_12_VCHDR               OLI8BW                   RMCVNEUL
   
2LIS_12_VCITM                OLI8BW                   RMCVNEUL
   
2LIS_12_VCSCL                OLI8BW                   RMCVNEUL
   
2LIS_13_VDHDR              OLI9BW                    RMCVNEUF
   
2LIS_13_VDITM               OLI9BW                    RMCVNEUF
   
2LIS_17*                           OLIIBW                    RMCINEBW
   
2LIS_18*                           OLISBW                   RMCSNEBW
   
2LIS_45*                           OLIABW                   RMCENEUB

Scheduling options in Process chains.

Different types of Scheduling option in Process Chain:

While Scheduling a Process Chain, there are two options:

The start process is set to Direct scheduling:

• BI_PROCESS_TRIGGER is released with configured start options.
• Subsequent application processes are scheduled and released as event triggered jobs.

The start process is set to Start Using Meta Chain or API:

• No BI_PROCESS_TRIGGER is scheduled or released. You have to start the process chain via another process chain or API (Function module: RSPC_API_CHAIN_START). This provides flexibility to schedule process chains with the help of a driver ABAP program.

• Subsequent application processes are scheduled and released as event triggered jobs.

• In this case Change Selection option will not be there.

 Scheduling scenario for Direct scheduling:

 Scheduling a Process Chain on a particular day of every Month

1)  Suppose we want to schedule a Process chain on 1^st of every month:

Open the Chain in Planning mode (RSPC or RSPC1) >> Right click on the Start Process >> Display variant >> Change Selections >> Click on Date/Time tab >> there click on Periodic Values Tab

Click on Periodic Values Tab >> There click on Monthly.

Check and Save.

In the Schedule Start date field enter 1^st date of the present month.

Then the chain will run on first of every month.

 Schedule a process chain at different times during the day

Suppose we need to run a Process Chain twice a day daily at two different timings X and Y.

Open the Chain in Planning mode (RSPC or RSPC1) >> Right click on the Start Process >> Display variant >> Change Selections >> Click on Date/Time tab.

There in the Scheduled start field give the date when the Chain is going to run for the first time and enter the time in the Time field as X.

Then click on the Periodic value tab and Click on Daily.

Then Check and Save, again Check and save.

Activate and Schedule the Chain.

Now right Click on the Start Process >> Display Scheduled Jobs >> there you will find one Release Job (BI_PROCESS_TRIGGER) >> Select the Job >> In the top JOB tab >> Click on it and select Repeat Scheduling.

There Click on Date/Time tab, maintain the date and enter time as Y. Select Periodic Job Check Box >> Check and save. Then come out and you  will find that the Start Process is in red color. It means that the Process chain is scheduled for multiple times i.e. it has more than one Release Job.

Suppose you want to run the chain 5 or 6 times a day,you can do it in this way or you can do it in another way.

Create an Event in SM62.

Then go to SM36 Give a Job name >> Then click on Steps >> Click on ABAP Program >>Give the Program name BTC_EVENT_RAISE >> In the Variant Field Enter the Event created in SM62 >> Check and Save.

Then click on the Start Condition >> Click on Date/Time tab >> Give the date and give the first time.

In this way create 5 different Jobs by giving 5 different timings.

Maintain this Event in the Start condition of the Process chain.

Note: BTC_EVENT_RAISE is available in BI 7.0, for BW 3.X create a Program using function module "BP_EVENT_RAISE" and pass the event name as parameter. Save this as variant.

Check SAP Note : 919458 for Documentation.

Schedule a Process Chain to run only for X number of days of a month

Suppose we need to run a Process chain every first 15 days and Last two days of every month.

In this case, create a Factory Calendar using T-code SCAL. There declare first 15 days and Last two days as Working days and rest all as Holidays.

Right click on the Start Process >> Display variant >> Change Selections >> Click on Date/Time tab >> Click on the Restriction tab (F6) >> there maintain the Calendar id and Select Do not Execute on Sundays or Holidays>> Then Check and Transfer >>Then in the Scheduled start field give the date when the Chain is going to run for the first time.

Then the Process chain will only run as per the above requirement.....

Trigger Event at R/3 to BW side:

Suppose we want to Schedule a Process chain as event based. This event will be trigger from R/3 to BW:

In BW System:

1. Create New Z-Program with Parameters Event Id, Event Parameter and In the Code Use BP_EVENT_RAISE Function raise Event with Parameter. Create Transaction ZEVENT for this Program.
2. Create Process Chain to Load Data from R/3 to BW.
3. Schedule this process chain after the Event and parameter. Activate and Schedule this process Chain.
4. Now Run SHDB to Create BDC code for this Transaction 'ZEVENT' with Parameters of Event and Event parameters.
Now BW is ready to Load after

In R/3 System:

1. Call Function RFC_CALL_TRANSACTION with 'ZEVENT' Transaction and BDC Table with Correct Event and Parameter. Use Destination as your BW System.
2. Check SM59 for BW Connection.
This Function Execute the Transaction in BW system. That will raise the Trigger required and that will Start the Process Chain and Load the Data.