Retail Predictive Application Server (MOSC)

MOSC Banner

How to set current week as unelapsed

edited Aug 23, 2020 5:06AM in Retail Predictive Application Server (MOSC) 1 commentAnswered

Hi Experts,

In MFP-CS v18.x, I want to set a boolean measure as 'unelapsed' only for current week and want to populate 'late on-order' measure in the current week from past elapsed weeks. I am using below rules and executing through daily batch, but the below Rule 1 (tried both options) is failing and MPWPFUnElapB isn't updated. All the below LHS & RHS measures base intx are 'week_scls_chan'

Rule 1: MPWPFUnElapB = if(current == today, TRUE, FALSE)

OR

Rule 1: MPWPFUnElapB = current == elapsed + 1

Rule 2: MPWPOOLR = if(MPWPFUnElapB, tssum(MPWPOOR, first, elapsed), 0)

Any quick help will be highly appreciated.

Thanks

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