December 30, 2011

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.




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.

December 29, 2011

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.

December 24, 2011

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

December 19, 2011

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

December 18, 2011

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

December 17, 2011

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

December 16, 2011

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

December 14, 2011

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 1st 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 1st 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.