Real time reporting

[Former Member]

Hi Experts,

Our customer wants some real time reporting, for which we have two options:

1. BW reporting: we can build an infocube and then create some BW reports out of it. It will be in very user friendly but not real time which is the actual requirement.

2. ABAP reporting: We can direcly pick up the real time data from the R3 tables and hence generate the reports. However, we may have 30,000 records coming from different tables which is going to expand in furture. So obviously we will face the performance issues.

Which option shall we choose...?

Thanks in advance. Points for sure

Warm regards,

Raman.

[former_member194669]

Hi,

I will suggest for option 2. If you have proper key for selection then how many tables you are selecting and how many records you are selecting don't have problem related to performance. But if you are going for BW BEX reporting using infocube, that updation will usually scheduled in the night from R/3.

and also choosing option from R/3 or BW will depend upon on the user access to server.

a®

[Former Member]

Well, since the requirement is "real time", then your only option is the second one.

If you program carefully, performance should not be an issue. 30,000 records is not a lot.

Rob

[Former Member]

Hi Raman.

ABAP report is the best idea in this case. 30000 records not a big deal you should go thru ABAP report.

regards,

paras