Real Time Reporting

[#1]

Hi Gurus ,

I have a quick question ! In BI 7.0 we can access the R/3 data for real time Reporting , which resides on R/3 side .

Can anybody suggest on this ? What SAP has to suggest for such a usage ? any downsides ?

Thanks in advance !

Thanks & Regards

Zeenath Syeda

Hewlett Packard

[Former Member]

Hey,

Realtime reporting could be done in two main approaches:

1. Realtime data acquisition - this is a new feature of BI7 - you could have data transferred in almost realtime to the application into a DSO. Once the data is posted into the application it's being pushed into the PSA with a daemon which then transfer the data into the DSO. You can than know that the data is valid to the last minutes. The problem - this DSO is used only for operational reporting and the data cannot be staged further (to infocubes for example) onwards using this realtime approach (only scheduled).

2. The second scenario is having a virtual infocube - this way the data is being pulled from the R3 as soon as the query is being ran. You might have performance problem if you have a lot of data. But the data is current.

if there is a lot of data, you can have some tricks being done - you may refer to an article on BW expert - which uses a multiprovider on top of two infocubes: on is virtual and the other is standard. the standard is being loaded with delta loads. since the new data is stored in the R3 delta load, you can use the virtual cube to load the data from it a query runtime. the multiprovider is used to unify the data.

here's the link to the howto -

<a href="http://www.bwexpertonline.com/archive/Volume_04_(2006)/Issue_09_(October)/V4I9A2.cfm?session=">how to</a>

Tomer.