Real Time Reporting

[Former Member]

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]

RDA

One disadvantage is since its PUSH mechanism involves resources for background processing ,as there is a need for contineous BGD process availability from BW to R/3 .

<b>Motivation for real-time</b>

Upload frequency for regular staging not sufficient

Number of requests can not be handled by BI system

Reporting requirements of data with sub 1 hours actuality

Operational reporting

The clear distinction between tools for analytical applications and tools for operational applications is more and more difficult.

See transactional data in reporting as it is created in source system („post & see“)

Availability of data in source system not known

Use „Push“mechanism (e.g. SAP NW XI)

Polling or

Trigger data load process via event from source system

Remote access of data not feasible due to resource consumption in source system (and cross application reporting requirements)

Splitting of staging processes (EDW) –General business rulesare processed during the day whereas scenario specific rules(definedby application, region, time zone, etc.) are processed at customer defined times

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/3db14666-0901-0010-99bd-c14a9349...

Hope it Helps

Chetan

@CP..

[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.