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

IBP S&OP Time Streams

Dear all,

In regards to the creation of time streams for IBP S&OP planning areas does anybody have good tips or tricks to create and update these in a smarter way than via a text file with the structure defined? It works but it does not seem to be a very robust and flexible way of maintaining a system a state of the art system?

Br., Peter

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Oct 27, 2015 at 09:11 AM

    Hi Peter you have to use a file. But you can make it quite simple: - The time profile itself is just for display, plus it frames the maximum time horizon you can load the file, so you can have the horizon in the top with a very long end date, e.g. 31.12.2035. This has no impact on sizing and performance, it will just make sure you don't need to change it every year - just don't ever touch again - In the planning area itself, time horizon settings with + / - x years and month etc. frames what can maximum be loaded into the key figures, not into the time profile. - Create one big master file, that has all the horizon for the next many years, e.g. until 2035 as well, and make sure that file is within the horizon of the time profile. Now you can load it, even if the planning area itself has a smaller horizon. - With that, you still cannot maintain key figure data out of the horizon given in the planning area, it just makes sure you load the time profile once and for all. Works pretty easy if you have only month, quarter and year More effort if you have weeks as it is just some work to prepare in the file. Yours Irmi

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Peter,

      I could not agree more with you about Time Profile maintenance using flat file upload especially comparing with SAP APO where it is automation (based on storage bucket profile setup).

      Having said that we need to consider the pain and effort needed to setup Fiscal Year Variant which is essentially similar to Time Profile in IBP, main difference being flat file upload.

      To automate the Time Profile at Day, Week level is really significant effort (month, quarter, year is just 17 entries per year so manageable) but some Excel VB programming has done the trick of creating the repetitive Day and Week data. The bigger challenge is NOT the day, week, month, year period start and end definition but adding Period Description that may very well differ from client to client.

      Some more Excel VB magic applied for period formatting will do the needful.



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.