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

Loading Reporting data: "time frame" "frequency" "update times"

In a requirements package from which I am to design and build BW reporting, information has been provided on "time frame" "frequency" "update times"

Can you share your thoughts on these and how to consider them during the design/build? Examples will be very helpful. Also, how does “time basis” fit in here?

For example what is the implication when on a particular requested report, the frequency= "on demand".

If time frame = quarterly what effect will that be on “update time”?

Which of these speak to when data needs to be loaded into the BW? Which refers to when reports need to be generated? And is there a link between the two?

How is the determination on the frequency and specific time to load data for reporting purposes made?

In general, what influences the decisions on "time frame" "frequency" "update times" during the reuirements gathering phase?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2005 at 11:08 AM

    There is not really a set answer for that, basically you have to listen to what your users need, and what you can offer them based on your installed base.

    "Time basis" I'm not sure about, could refer to the type of timefield you are using. Transaction date, ...

    Let me give you an example

    Eg. Users here want there reports on wednesday morning, this is the only time that they will look at the reports.

    Frequency: You can get away with loading once a week

    Time frame: Because all my users will be in the system as of 5 am, I need to make sure data is ready by then. But I can't load before 1am because that is when FICO data is loading already...

    Update times: we could do some updates of new plan version during the rest of the week, since they are relatively small. (although I'm not really sure what they mean with update time, sounds the same like loading frequency)

    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.