Retail Predictive Application Server (MOSC)

MOSC Banner

Timeshift Procedure - What does it return when no mapping is found in lagmap

edited Jan 25, 2017 3:23PM in Retail Predictive Application Server (MOSC) 9 commentsAnswered

Hi,

I have this rule to calculate a value using timeshift based on lagmap measure:

Expression:

WkElapseNOLLY <- timeshift (WkElapseNOF, MapLLY)

Measure:

WkElapseNOLLY

Base Intx: Week

NA Value: 0

WkElapseNOF

Base Intx: Week

NA Value: 1

MAPLLY

Base Intx: Week

Type: String

*****************************************************************************************************************************************************

Calendar in RPAS starts from year 2014 and is loaded until year end 2019.

As is the case with any lagmap measure, there is no LLY mapping available for years 2014 and 2015, i.e. the cell contents of MALLY start from 201601, as listed below

*************************************************************************************************************************************

bnpsys@tstr600427:/u/data1/GEORGE_UK_MFP/data/maplly.db$ /u/bnp/rpas/rpas/bin/printArray -array .maplly%1 |head

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