Retail Predictive Application Server (MOSC)

MOSC Banner

Lookup not functioning as expected

edited May 9, 2017 11:25AM in Retail Predictive Application Server (MOSC) 4 commentsAnswered ✓

Hi experts,

We are trying to use the lookup function to map the stocks of one class to another class.

BUWPRclsTfrTo measure is a drop-down (picklist) which selects the destination class

In order to use the lookup, the index of the above is then fed into the lookup function as given below.

BUWPRclsTfrOut = index([prod].[clss],BUWPRclsTfrTo).

BUWPRclsTfrOut is used to get the index.

BUWPRclsTfrInR <- lookup(BUWPRclsTfrOutR,[prod].[clss],BUWPRclsTfrOut )

BUWPRclsTfrOutR is editable stock measure of the source class.

All measures BUWPRclsTfrOutR, BUWPRclsTfrInR,  BUWPRclsTfrTo,  and BUWPRclsTfrOut are at week (clnd)/country(locn)/class(product)/stock-type intersection.

BUWPRclsTfrOut is my mapping measure.

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