I want to do time distribution from month to week and from week to month in one transformation with different condition.
e.g. for type A data, I want to do month to week, for type B data, I want to do week to month distribution.
it seems I can do so in update rule, the old BW 3.5 way. however it only allows one type of time distribution, not both in the same update rule.
when I try bi7.0 transformation from DSO to cube, it can only do time distribution from week to day, or from month to day. not from month to week and week to month.
OK, then I can do week to day, then accumulate day to month later on. however it seems I can't do a conditional time distribution in bi7.0.
in summary, I need to do
1. time distribution month to week, week to month, conditionally. can I?
2. can I do both in one transformation or update rule?
gchen