Using the My Oracle Support Portal (MOSC)

MOSC Banner

Lookup

edited May 16, 2017 5:02AM in Using the My Oracle Support Portal (MOSC) 2 commentsAnswered

BUWPRclsTfrTo measure is a drop-down (picklist).

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

BUWPRclsTfrOut is used to get the index.

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

BUWPRclsTfrOutR is editable. All measures BUWPRclsTfrOutR, BUWPRclsTfrInR,  BUWPRclsTfrTo,  and BUWPRclsTfrOut are at week country class stock-type intersection.

BUWPRclsTfrOut is my mapping measure. I did'nt put the picklist here directly as the mapping measure in the Lookup , as it was not working. Even assigning the picklist selection into a new measure and using it as the mapping measure did not help. So I tried this Lookup Procedure via Index itself.

It is functioning well at Class intersection in the environment where the product hierarchy has one class under respective class-group. So the measure BUWPRclsTfrInR  is getting populated for the selected class from the source class BUWPRclsTfrOutR measure's value. But its not working if the environment's product hierarchy is having multiple class under one class group. So the measure BUWPRclsTfrInR  remains empty.

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