Retail Predictive Application Server (MOSC)

MOSC Banner

RPAS rules: Filter Sales from first sales to certain weeks.

edited Jun 19, 2015 10:02AM in Retail Predictive Application Server (MOSC) 2 commentsAnswered

Hi all,

I am trying to select subset of sales data from the first sales to certain number of weeks(lets says 13 weeks).

I have tried the begin and end keyword and this what rules look like and it runs very slow. Is there any other function I can use to filter data as per need.

filterSales= if(sales>0 , dateDiff(begin, end,"WEEK" ) <=13, sales,0)

Any suggestions.



Thanks

Nick

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