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

time distribution / time conversion in transformation BI 7.0

Hi experts,

Í have volumes saved in a key figure on month level (e. g. 200905) and want to distribute this volumes to week level.

So e. g., eek 200918 would get 3/31 of month 200905, week 200919 would get 7/31 of this month and so on.

Just to avoid any comments I read in other threads: this IS possible!

During tests I created a data source with several month characteristics filled as 200905, 05.2009, 052009 and experimented with internal/external format, conversion exit PERI6 andsoforth.

The source field for month was created with 0CALMONTH as model has the same data type (NUMC), length etc.

However - while creating the tranformation and creating the rule between the month of the data source and the 0calmonth I always get the error message "Automatic time conversion is not possible..."

By the way - this happens also for the rule from month (data source) to 0CALMONTH (cube).

Any help would be highly appreciated!

Julian

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on May 04, 2009 at 02:55 PM

    > Hi experts,

    >

    > Í have volumes saved in a key figure on month level (e. g. 200905) and want to distribute this volumes to week level.

    > So e. g., eek 200918 would get 3/31 of month 200905, week 200919 would get 7/31 of this month and so on.

    >

    > Julian

    In the target you should have 0CALWEEK and in source you need to put 0CALMONTH.

    Choose Time characteristic as rule type in transformation.On doing this you would see description as "Time distribution" beside it.

    Transfer value.Save and activate.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Dennis Scoville

      Hi Dennis,

      as already written in my very first post please have a look into [http://help.sap.com/saphelp_nw70/helpdata/en/e5/f913426908ca7ee10000000a1550b0/frameset.htm] , Section Time Update.

      There is exactly described that it is possible:

      "You can update time characteristics with time distribution. All the key figures that can be added are split into correspondingly smaller units of time. If the source contains a time characteristic (such as 0CALMONTH) that is not as precise as a time characteristic of the target (such as 0CALWEEK), you can combine these characteristics with one another in the rule. The system then performs time distribution in the transformation."

      So I consider opening an OSS message...

      Regards,

      Julian

  • author's profile photo Former Member
    Former Member
    Posted on Jul 14, 2011 at 11:47 AM

    HI julien ,

    did you found any solution for the same . if yes would you please share this with me

    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.