How to calculate how many data records in cube and DSO

[Former Member]

How to calculate how many data records in cube and DSO? Is there any program that we can run to calculate? Thanks for your answer.

[Former Member]

Hi,

Think you can use RSREQDONE / Listcube with 'Out put numberof hits' option. (you can also use with selections).

For DSO records chk in the manage tab of the dso. see contents of Active table, change log table.

thanks.

[Former Member]

Hi......

Calculate size of Infocube .........

1) Total Records

a) SE16 >> Fact table name(/BIC/E or /BIC/F).................then click on "Number of Entries"

b) SE38 >> Prog : SAP_INFOCUBE_DESIGNS

2) Size in Bytes

Tcode DB02 >> Detail Analysis >> In Object name...........give the infocube name or the ODS name......

Calculate size of ODS .........

a) SE16 >> Give the ODS table name >> "Number of Entries"

b) In the Manage Screen>> Content >> Click on the desired table >> "Number of Entries"

Tcode DB02 >> Detail Analysis >> In Object name...........give the the ODS name......

Also Check........

http://help.sap.com/bp_biv235/BI_EN/documentation/sizing30_newasap.pdf

Hope this helps...

Regards,

Debjani.........

[Former Member]

Hi,

To check with the DSO...you can just go to the DSO in manage and check the option" number of records".

you can also check this in ST03 and in tablespaces option...give the DSO name and it wll give the number of records present in the table.

Here you have the parameter DATABASE which stores entry for the number of records in each DSo and there size but again you need to have statistics already set up for this.

For the cube you can run a selectiopn in the manage tab again below you have the checkbox "display number of output" or some thing like that.

Also if you want information about all the cubes then you can go to SAP_INFOCUBE_DESIGNS and run this report...the number of records in the fact table is the total number of records in the cube.

But for this you need to have the statistics created and updated for the cubes for which you want to count the number of records.

Thanks

Ajeet