Retail Predictive Application Server (MOSC)

MOSC Banner

rpas rules doubt

edited Jun 25, 2016 5:03AM in Retail Predictive Application Server (MOSC) 5 commentsAnswered

Hi All,

I need your help for the below calculation.

      subclass sku1sku2
calendarsales sales sales
1/1/201612       1 3
2/1/201613       2 5
3/1/201614       3 6
4/1/201615       4 8
5/1/201616       4 2
6/1/201617       6 1
7/1/201618       7 5
8/1/201619       4 2
9/1/201611       8 9

Now I need to find out calendar position where sales total is >=50 for subclass using tssum

Also then find out the respective tssum value for sku1 and sku2 using that calendar position

I have found below way to do so but not sure if it's correct.

subclass sales measure   subsales -->  (day_scls)

sku         sales measure   skusales --> (day_sku) ,total --> agg, repl --> spread

threashhold value measure threshld --> (day_scls) ,naval-50

date for start the sku         startdate --> (day_sku) type -->date

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