Retail Predictive Application Server (MOSC)

MOSC Banner

Spreading values from chain level measure to Store level Measure

edited May 31, 2016 5:07AM in Retail Predictive Application Server (MOSC) 1 commentAnswered

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center