Rows in cube

[Former Member]

Hi,

Can anyone suggest me the method or tcode

1.to find the number rows in a cube and

2.to get the row size of the cube.

Regards,

Deepika.

[Vitaliy-R]

You posted this question in BIA forum, so I suppose it is somehow related to the topic of the forum.

1) If your goal of having number of records in the cube is related to estimation of time of initial indexing - you can use transaction RSRV, where one of check is doing this estimation.

2) In general: when cube is to be indexed into BIA, the system does not check precise number of rows, but just use estimated number from DB statistics. You'll see this number in RSDDV in Information before indexing cube with Wizard.

3) Once the cube is indexed, then in RSDDV you'll see exact number for table rows.

Hope this somehow helpful. Pls assign point if yes.

Cheers,

-Vitaliy

[Former Member]

1. In SE11 give ur cube name /BIC/FXXXXX and click on table contents and then click number of entries.

2. For the size of IC and row size

Regards,

Malar

[former_member188325]

Se16>your fact table name>execute-->Number of entries to get number of rows.

[Former Member]

Hi,

Run SAP_INFOCUBE_DESIGNS in SE38 you will rows n size.

Regards

Sankar