Recalc measure manually edited — oracle-mosc

Retail Predictive Application Server (MOSC)

MOSC Banner

Recalc measure manually edited

edited Aug 1, 2015 10:01AM in Retail Predictive Application Server (MOSC) 4 commentsAnswered

Hi,

we are facing problems implementing these scenarios on RPAS 14.0.1:

Given these three real measures:

Sls, editable, base intx str_line_mnth, aggregated in total and spreaded as prop_pop, calculated as Sls = PySls * (1 + DeltaVsPyP)

PySls, base intx str_line_mnth, aggregated in total and spreaded as prop_pop, calculated as PySls = Sls of previous year

DeltaVsPyP, editable, base intx str_line_mnth, aggregated in recalc, calculated as DeltaVsPyP = (Sls - PySls) / PySls

Our customer wants that RPAS recalculate the value of DeltaVsPyP whenever DeltaVsPyP or Sls is manually edited.

Cosider this example:

201420152016
Sls 80100110
PySls80100
DeltaVsPyP10%10%

  • When changing Sls of year 2015 to 200, RPAS must calculate

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