Getting Size of Data Target(Using Transaction Code Procedure)

Introduction

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.

Approaches to find size

There are two basic approaches to find the size of the data target.

1.Transaction Code

2.Functional Module

1.Transaction Code Procedure 

For getting a size via transaction code you must have authorization for TCODE DB02

1: Go to DB02

2. Drill down Segment and click on Detailed Analysis.

3.Now put fact table name of the data target. If you don't know name of the fact table append /BIC/F(DATATAGET) to you data target name. E.g. suppose my data target name is test_cube so fact table name will be /BIC/FTEST_CUBE.

4.Click Tick 

5. Now you will get detailed analysis list of the cube. 

6. By clicking on each row you can see detailed analysis in above window. 

7. Now you will get table size in MB. There could be some partitions of memory size allocated to yourdata target so total size will be addition of all partition.Total Size of the fact tables = Sum of table partitions.So in these example Total Size = 0,063+0,063 = 0,126 MB.

8. Now find size for /bic/E(data target) . Sum up all table size and you will get actual size of the cube. 9. If you want to check size of DSO, check for active table /BIC/A (DSO NAME).