Hi all,
Can any body tell me How can i find out the Cube size ?
Thanks in advance.
Vaibhav A.
Hi ,
What do you mean by cube size , Number of records present in cube or ratio for each dimension .
I mean How to find out the memory size which is consumed by the Cube(in MB or GB).
Is there any process to find out this.
You can get this information from BASIS,
give them the Fact and Dimension table names.... they will give you the size of each....
Hi,
Please use the tcode DB02 or DB02OLD and then select the detailed analysis and enter the name of the InfoCubes to find the memory used by the InfoCubes/ODS.
Thanks.
Hi Vaibhav,
To count size in records for infocube/DSO you can follow bello steps:
1.Goto SE38.
2.use program SAP_INFOCUBE_DESIGNS,
3. it will displays the all contents of Cubes.
or
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.
Regards,
Suman.
Hi,
Try this program: SAP_INFOCUBE_DESIGNS
I hope you can find many posts for this on SDN, here are few:
Hope it helps...
Regards,
Ashish
Hi,
try Tcode DB02
and
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.
Dimension Tables
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.
Fact Tables
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.
Regards,
Marasa.
Hi Vaibhav,
I Guess your requrement is finding the Size of Cube in MBs, please follow the link i hope it Helps.
http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/d0427b8a-7fe5-2c10-f1be-a8be71fa2c06
Thanks
Sameer