Migration of Datasources

In SAP source system (ECC), the datasource is the relevant object that makes source data available in a flat structure for data transfer into BW.

In the source system, the datasource can have the SAP Delivery Version or Active Version.

There are two types of datasources in BI:

R/3 TR RSDS or 3.x DS R/3 TR ISFS

Since the datasource cannot exist in both of these versions simultaneously, you have to choose the form while replicating them to BW.

Replicated 3.x datasources can be used as Emulated datasources in BW for migration purposes.

SAP recommends migration of 3.x datasources if you are using RDA DTPs or Direct Data Access DTPs as emulated datasources does not support these two types of DTPs. Continue reading “Migration of Datasources”

Repartitioning (Infocube)

Partition of InfoCubes is done to divide the huge data in the fact table into several smaller, independent units. This improves the query performance.

InfoCube can only be partitioned using one of the two below criteria-

  • Based on month (0CALMONTH info object must be present in the cube)
  • Based on Fiscal period (0FISCPER info object must be present in the cube)

Partitioning and re-partitioning can be done even though the cube contains data. This concept was first introduced in SAP Netweaver BW 7.0 as a replacement of partitioning in 3.x

Please note that you do not partition the cube when you create it. Usually it is done at a later point in time when the cube has more than a million records. Continue reading “Repartitioning (Infocube)”

Process Chain Monitoring – Useful Programs and tables

Useful for monitoring purposes for the support team-

Tcodes: RSPCM, RSPC1, RSPCM, BWCCMS

Programs: Go to tcode SE38, enter the program name as RSPC* and press F4.

Observe the list of programs that appear:

  • RSPC_CCMS – Start of BW CCMS monitor
  • RSPC_CHAIN_RESTART – Restart process chain run (Caution!)
  • RSPC_DISPLAY_JOBS – Display of Jobs with display of program parameters
  • RSPC_LOG_DELETE – Deletion of process chain logs and assigned process logs
  • RSPC_LOG_SHOW – Display of log for a process
  • RSPC_MAINTAIN – Process Chain maintenance
  • RSPC_MAINTAIN_SINGLE – Process chain maintenance (one chain)
  • RSPC_MAINTAIN_SINGLE_NOLOG – Process chain maintenance using a type  and  variant
  • RSPC_DEMO_CREATE_CHAIN_BY_PROGRAM – Demo: Creating a process chain per program without user interaction
  • RSPC_PROCESS_FINISH – Report end of a process

Tables: Go to tcode SE11 and in the database table, type RSPC*. Press F4. Continue reading “Process Chain Monitoring – Useful Programs and tables”

Direct Update DSO and APD

Direct update DSOs are generally used in conjunction with the APDs (Analysis Process Designer).

APDs are very helpful in analyzing the hidden patterns in the data coming from various sources.

E.g. APO system creates plan data using complex algorithms for certain actual sales data in BW. Both of these can be fed to the APD to analyze the differences in Actual and plan values and find out the useful metrics like Forecast Bias, Forecast Accuracy etc. Continue reading “Direct Update DSO and APD”

Direct Data Access DTP – SAP Remote Cube or Virtual InfoCube

This post is just for demonstrating the use of virtual infocubes and direct access DTPs as these are not used so frequently while modeling.

There is no data acquisition and the BI system connects remotely to the source when the query is called by the user. This is particularly useful where very less data need to be retrieved and it changes frequently.

There is also a concept of using Open ODS views if your BW system is based in HANA, where there is a similar access to source tables directly and queries are based on the source fields. Continue reading “Direct Data Access DTP – SAP Remote Cube or Virtual InfoCube”

Steps to enhance LO Datasource in SAP ECC

Enhance LO standard business content data source with a field not present in the data source extract structure

Scenario 1:

The field to be added in the LO Data source is not present in the extract structure but it is available in the communication structure.

Steps:

If the field to be added is available in the communication structure, no need to enhance the data source in such cases. You simply have to add that field from the communication structure into the extract structure. Continue reading “Steps to enhance LO Datasource in SAP ECC”

Steps to enhance Datasource in SAP ECC

Below is a sample scenario to enhance the extract structure of a standard Data source. The procedure is same for custom data source. However, the procedure is slightly different for enhancing the LO extractors.

Enhancing a data source structure signifies that you want to add an extra field to the data source which is not present in the extract structure. For this you need to add this field in the extract structure and then write a logic to populate this field in tcode CMOD. The extractor then can be checked in tcode RSA3. Continue reading “Steps to enhance Datasource in SAP ECC”

Generic Datasource extraction in BW from Master Data table in ECC

Generic Datasources / Extractors  – Cross Application (RSO2, SBIW)

Master data / Attributes extraction/ acquisition from SAP R/3 ECC (OLTP) to SAP BI (OLAP) using generic data sources – cross application

Eg. 1. Using a Database table

T-codes: SBIW, RSO2, SE11, SE16, RSA3, RSA7, RSA11, RSA13, RSA14, RSD1, RSDS, RSMO, RSMON, LISTCUBE, RSPC, RSPC1, RSPCM

Part 1: Data Modeling

Step 1: Logon to SAP R/3 system

Step 2: Check the data in the table

Enter tcode SE11 Continue reading “Generic Datasource extraction in BW from Master Data table in ECC”

How to create tables in SAP system-II

Creation of Transaction data table with variable currencies and units of measure

Method: Top down approach

Structure:

Continue reading “How to create tables in SAP system-II”

How to create tables in SAP System-I

There are three ways to create a table in SAP-

  1. Using Built in type or pre-defined type
  2. Using top-down approach (Table, Table properties, fields, data elements, domains, check fields, currency fields, technical settings,…)
  3. Using bottom-up approach (data, domains, data elements, table, table properties, fields with data element assignments, technical settings)

Creation of table:

Master data table creation using built-in type/pre-defined type-

Structure of the table

Continue reading “How to create tables in SAP System-I”