To count size in records for infocube/DSO you can follow bello steps:
2.use program SAP_INFOCUBE_DESIGNS,
3. it will displays the all contents of Cubes.
a). Goto se16
b).Give the fact tables : /bic/F(cube name) and /bic/E(cube name)or.
the same for ODS, active table is /bic/A(DSOname)00 or /bi0/(DSOname).
You can find the size of data through above two ways.
try Tcode DB02
A simplified estimation of disk space for the BW can be obtained by using the following formula:
For each cube:
Size in bytes =
(n + 3) x 10 bytes + (m x 17 bytes) *
http:// rows of initial load + rows of periodic load * no. of periods
n = number of dimensions
m = number of key figures
For more details please read the following:
Estimating an InfoCube
When estimating the size of an InfoCube, tables like fact and dimension tables are considered.
However, the size of the fact table is the most important, since in most cases it will be 80-90% of the
total storage requirement for the InfoCube.
When estimating the fact table size consider the effect of compression depending on how many
records with identical dimension keys will be loaded.
The amount of data stored in the PSA and ODS has a significant impact on the disk space required.
If data is stored in the PSA beyond a simply temporary basis, it could be possible that more than 50%
of total disk space will be allocated for this purpose.
u2022 Identify all dimension tables for this InfoCube.
u2022 The size and number of records need to be estimated for a dimension table record. The size of
one record can be calculated by summing the number of characteristics in the dimension table at
10 bytes each. Also, add 10 bytes for the key of the dimension table.
u2022 Estimate the number of records in the dimension table.
u2022 Adjust the expected number of records in the dimension table by expected growth.
u2022 Multiply the adjusted record count by the expected size of the dimension table record to obtain
the estimated size of the dimension table.
u2022 Count the number of key figures the table will contain, assuming a key figure requires 17 bytes.
u2022 Every dimension table requires a foreign key in the fact table, so add 6 bytes for each key. Donu2018t
forget the three standard dimensions.
u2022 Estimate the number of records in the fact table.
u2022 Adjust the expected number of records in the fact table by expected growth.
u2022 Multiply the adjusted record count by the expected size of the fact table record to obtain the
estimated size of the fact table.
I Guess your requrement is finding the Size of Cube in MBs, please follow the link i hope it Helps.