Retail Predictive Application Server (MOSC)

MOSC Banner

Holding Value for a Recalc Measure

edited Dec 14, 2014 11:45PM in Retail Predictive Application Server (MOSC) 2 commentsAnswered

Hi,

I have a question regarding holding values for a recalc measure  Gross Sales %.

The rule is like

Rule 1

Gross Sales U = Gross Demand U * Gross Sales %

Gross Sales % = Gross Sales U/ Gross Demand U

Here Gross Demand U gets fed from a file. And business enters Gross Sales %, in turn triggering the calculation of Gross Sales U. Or if Business changes the value for Gross Demand U, the Gross Sales % gets recalculated.

However now the business wants to enter Gross Sales % first, even before the plan for Gross Demand U. They want to hold the value of Gross Sales % (whatever they have entered), even if Gross Demand U is zero.

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