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

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