8 Replies Latest reply: Jan 19, 2010 7:05 AM by Sameer Ganeshe RSS

How to find out Cube Size (Step by step process)

Vaibhav A
Currently Being Moderated

Hi all,

 

Can any body tell me How can i find out the Cube size ?

 

 

Thanks in advance.

Vaibhav A.

  • Re: How to find out Cube Size (Step by step process)
    Senthil Kumar k
    Currently Being Moderated

    Hi ,

     

    What do you mean by cube size , Number of records present in cube or ratio for each dimension .

  • Re: How to find out Cube Size (Step by step process)
    Vaibhav A
    Currently Being Moderated

    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.

  • Re: How to find out Cube Size (Step by step process)
    Currently Being Moderated

    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.

  • Re: How to find out Cube Size (Step by step process)
    Ashish Tewari
    Currently Being Moderated

    Hi,

     

    Try this program: SAP_INFOCUBE_DESIGNS

     

    I hope you can find many posts for this on SDN, here are few:

     

    To find the Cube Size

     

    cube size

     

    Hope it helps...

     

    Regards,

    Ashish

  • Re: How to find out Cube Size (Step by step process)
    Currently Being Moderated

    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.

  • Re: How to find out Cube Size (Step by step process)
    Sameer Ganeshe
    Currently Being Moderated

    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

Actions