How to Report on Hourly Basis from BW in HH-MM(not on 0calday)

[Former Member]

Hi Pals,

I need suggestions as my current user wants to report on every 2 hours(and staged into BW ODS) based on Time(HH-MM). Though we can bring details in BW on every 2 hrs but the issue is how to bring the Time characteristics in HH,MM. Requirement is to keep track of orders and deliveries with a precision on Time(i.e 12:10 PM). And when ever there is a chnage in OLTP box then based on scheduled extract it must reflect the time in hours and minutes.

Robert and party do you suggest to make chnages to existing Extractors and cast a new InfoObject in extracts to bring such kind of details. If yes then we need to create this as NUMC(0CALDAY is lowest Time characteristics).

Please suggest and let me know if this is possible then what are the pros and cons for this approach. I clearly agree that this kind of details can be best brought from OLTP box.

Sanjeev

[S0004647611]

Hi,

Since you are going to load very frequently, please consider note 620361 in terms of problems to expect. BW is not (yet) build for such high frequency loads. (too many admin overhead.) In BI 7.0 a new ODS type for direct update is available. This has no activation queue and less admin. Purpose to directly update from 2LIS** or your kind of scenario. Isn't it possible to build or use a remote cube scenario ? For the time registration as stated use 0TIME.

Kind regards, Patrick Rieken.

[Former Member]

Sanjeev,

You can use 0TIME to report HH:MM:SS data.

Hope it works ...

Ravi