No of Records Read from Infoproviders in a query

[Former Member]

Hi,

I have a BEx query which is defined on a multiprovider having more than 20 infocubes.

I would like to know how many records are read from which infocube.

Does anybody have any idea how to get that in RSRT or some other means.

The way I expect is

IC1 - 2000

IC2 - 15000

IC3- 2400

.....

Regards,

Tapan

[Former Member]

You could build a query for this.  Use the characteristic 0INFOPROV (Infoprovider) to identify the infoproviders in your multiprovider and add this to your row structure.  In your column structure, create formula = 1.  Add the same selection criteria to this query and you can look at the total row for the formula you just created.

[Former Member]

Hi Brendan,

Perfect...But is there any way in RSRT/DB02 or DB Stat where I can get the number of records directly..

[Former Member]

I'm not sure.  If you were only dealing with DSO, you could check the number of entries in the active (A) table.  You could try looking at the size of the fact tables (E tables) for your Infocubes.

[Former Member]

Hi,

Would you please let me know how to assign points...

Regards,

Tapan

[Former Member]

Please see the following link for how to close a discussion (assign points):

http://scn.sap.com/community/support/blog/2013/04/03/how-to-close-a-discussion-and-why

Make sure to check the F & E tables for your infocubes when checking record counts.