Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2005 at 08:29 PM

    Sanjeev,

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

    Hope it works ...

    Ravi

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 25, 2005 at 07:31 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.