on 04-18-2006 7:46 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Balaji,
You can find the overall size of a fact table in DB02. Are you asking for specific cube?
Cheers!
Bhuvana.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.