How to determine # of records that satisify a criteria?

[Former Member]

Hi,

I need to determine the # of records in an InfoCube that satisfy a certain criteria (e.g. 0MATERIAL = 11111, Country = US, 0CALMONTH=200602).

Can you suggest transactions that can help? I think transaction listcube can help but it also returns the data w/c might take awhile to retrieve.

Please advise.

Thank you.

[Former Member · Accepted solution]

LISTCUBE returns pretty fast. Make sure you check Use DB aggregation. to get summarized output.