to know IC having data r not

[Former Member]

Hi Experts,

how to know whether my infocube having data or not

without going to manage tab........... Is there any shot cut

Actually my requirement is to know which IC are not in use

Regard's

Venkat

[Former Member · Accepted solution]

hi,

You can check it by using st03.

Tables and index option.

Just check there Fact and E table size of the cube.

Regards,

Ashish

[Former Member · Accepted solution]

Hi Ashish,

thx's 4r immediate reply where can i find table opp.....

over there i need to enter all IC fact table name aaaa.......

thx's in advance

Regard's

venkat

[Former Member · Accepted solution]

Hi Shyam,

in that t-code there is no space management opp..

let me know in detail plz

regard's

venkat

[Former Member · Accepted solution]

Hi,

Just execute the pgm - SAP_INFOCUBE_DESIGNS and you will get the data distribution for all the infocubes.

Just do a find for the infocube you want.

The number against the rows will tell you if data is there or not.

[srikanthbwbw · Accepted solution]

Hi

GOTO list cube transaction code and type in your cube name and execute, It willl dispaly records if there exists any otherwise no data found

Thanks

Srikanth

[Former Member · Accepted solution]

Hi,

thx's 4r giving me such type of program.

is there any program 4r ODS list also

thx's in advance

Regards,

venkat

[Former Member · Accepted solution]

Hi,

there its having rows----

---

but i need size......... is that info is size r just a row's

and one more small thing i need number of record's in IC

can any one

[Former Member · Accepted solution]

Hi,

Yes rows are nothing but no of records.

Also if you would like to get the size, go to DB02 and check the space distribution against the cube.

[Former Member · Accepted solution]

Hi,

i need same like ODS also that mean number of ods which i contain data and size

plz help out

[Former Member · Accepted solution]

Hi,

You can use function module DB_GET_TABLE_SIZE to get the size of an infocube or DSO.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d0427b8a-7fe5-2c10-f1be-a8be71fa2...

[Former Member · Accepted solution]

Hi murali,

that function module is perfect but i don't want to enter one by one.

i need total information like which we can find for IC by excuting the program sap_design_IC.

i need same like ODS also i am in BW verstion.

regard's

venkat

[former_member182470]

Hi,

Check in LISTCUBE transaction.

Regards,

Suman

[Former Member]

Hi,

I am having an process to find out the IC&ODS size

that is goto SE11----enter STAT and press F4. then it will show the some table their by selecting one table name

we find the details............ but wht is the problem is which table i neesd to sel and in table name wht i nedd to enter.....

Regard's

venkat

[Former Member]

Hi guy's,

i can't complete my requirement can you any one help me i need IC&ODS which having data

need to delete remaining things

Regard's

venkat

[Former Member]

Hi,

In DB02 you find the table and index option and there is an option of table space. Give it as * FACT* (name space for E & F table) this will have all the E and F tables of your system.

Try it out.

Regards,

Shyam.

[Former Member]

Hi,

Is your system on DB2 ?

You can achieve it in DB02 t code. In the tab of space management . In it give the table space name as *FACT* .

This will give you the F table and E table space for all the cubes. Download it to excel and check for the ones having size as 0.

This might help.

Regards,

Shyam.