Retail Predictive Application Server (MOSC)

MOSC Banner

Measure's value is not calculating in Item-Week Level

edited May 19, 2019 5:02AM in Retail Predictive Application Server (MOSC) 2 commentsAnswered

In workbook WB1, the base intersection is str,itpt,week.

There is a worksheet WS1 within this, having intersection day_itpt_str.

There are 3 measures M1,M2,M3. All are having intersection day_itpt_str. The rule calculation is like M3=((M1-M2)/M2)%.

Default Agg: M1 : total

Default Agg: M2 : total

Default Agg: M3 : recalc

Default Spread: M1 : prop_pop

Default Spread: M2 : prop_pop

Default Spread: M3 : none

When we are viewing in Item - Day level, the calculations are showing correct, but when it is view in Item - week level, the values are showing 0.00%. But also in SubRange - Week level, it is showing correct values.

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