time distribution / time conversion in transformation BI 7.0
Í 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!