calculation logic to convert data from one hierarchy to another
Hi,
We have a requirement to convert data from week hierarchy (wk dimesion) to calendar hierarchy (week dimension). is it possible to achieve?
Input: (history from first sales)
item chn w001 84
item chn w002 42
item chn w003 18
Output:(between forecast dates)
w20151228 item chn 84
w20160104 item chn 42
w20160111 item chn 18
Thanks