Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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!


Former Member
Not what you were looking for? View more on this topic or Ask a question