cancel
Showing results for 
Search instead for 
Did you mean: 

how to find Size of the fact table?

Former Member
0 Kudos

hello all

how do i find out the size of the fact table?

Is the size of the fact table is same as size of the cube.

pls let meknow

regards

balji

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hello Balaji,

To find out size of fact table

DB02 ->Detailed anaysis -> Fact table name

It will show you the details.

The size of cube is not exactly equal to the size of fact table, but usually as fact table is much more larger than dimension tables, fact table size will give you a fair idea about cube size.

Hope it helps.

Regards,

Praveen

0 Kudos

hi Balji,

you can use DB02->detail analysis,

type in table name infocube name,

you will get size of infocube in bytes.

to count size in records for infocube you can use

program(SE38) SAP_INFOCUBE_DESIGNS,

or se16 and count the fact tables : /bic/F[infocube name] and /bic/E[infocube name] or /bi0/F[infocube name] and /bi0/E[infocube name],

size of fact table NOT same as size of the cube since there are dimension tables also.

to list out tables of infocube, you can use LISTSCHEMA.

hope this helps.

Former Member
0 Kudos

Hi Balaji,

You can find the overall size of a fact table in DB02. Are you asking for specific cube?

Cheers!

Bhuvana.