Spreading values from chain level measure to Store level Measure
I have the following measures:
Measure1 is at week-item-store. Has spread_type as prop
Measure 2 is at week-item-chn
Measure 1 has following values
Store1, Item1, Week1, 13
Store2, Item1, Week1, 17
Measure 2 has following values
Chn1, Item1, Week1, 30
Now I set the Measure 2 value as follows
Chn1, Item1, Week1, 30000
Then i execute the following rule
mace -d . -run -expression "Measure1.level([loc].[chn])=Measure2"
I expect the result to be as follows for Store level measure
Store1, Item1, Week1,13000
Store2, Item2, Week1, 17000
But I don't see the values changing. What should be the expression for the chain level value to spread across 2 stores proportionately?