topic Re: Real time reporting in Application Development and Automation Discussions

Real time reporting

Former Member — Fri, 26 Oct 2007 17:52:30 GMT

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.

Re: Real time reporting

former_member194669 — Fri, 26 Oct 2007 17:59:41 GMT

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®

Re: Real time reporting

Former Member — Fri, 26 Oct 2007 18:01:26 GMT

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

Re: Real time reporting

Former Member — Sat, 27 Oct 2007 04:31:25 GMT

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