Retail Predictive Application Server (MOSC)

MOSC Banner

Measure value not showing properly- MFP

edited Feb 1, 2023 10:08AM in Retail Predictive Application Server (MOSC) 5 commentsAnswered

RPAS Version - 16.0.2

MFP Version- 16.0.2


Rules:-

SlsBR = prefer(SlsTR/Laslstr) 

Laslstr = if(current == first, TslsTR, lag(SlsTR))

TslsTR <- timeshift(SlsTR.master,-1)


For SlsBR measure the week level data looks fine. It is calculating as per the rules when it is present as first period or as any Nth period in the workbook.

At aggregated levels (like, month, qtr,ssn), the data is not getting calculated correctly when it is present as first period.

SlsBR's aggregation method is recalc and it should take the sales value at aggregated level and recalculate.

But it has taken the average of the week value and is putting it in the month and similarly for qtr and season. 

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