Record count in a InfoCube.

[Former Member]

Hi All,

I want to see total number of records in an InfoCube for given Fiscal Year or Selected year.

I have 4 yrs of data. I want to see records in an infocube for selected year...

[Former Member]

YOu can probably go the t-code LISTCUBE and enter the cube name and also on the selection, just give the fiscal year and remove the output lenth. should display all the records.

BK

[Former Member]

Hi,

What is I wanted to find only the crecord count by Fiscal Year ? What would be the quickest way to get that - if I had a ton of cubes and ODS to query?

Regards,

[Former Member]

you'll have to do it separately for each InfoProvider... for InfoCubes I would check the fact table, for ODS objects the active table