Improving rules performaces
Hello all,
I am working with Oracle Cloud RDF v19.0.004; while writing custom rules for calculating preprocess indicators, given the size of the domain, I decided to add a mask that identifies days in the past:
c_T1PastDayB = current <= today - 1 (c_T1PastDayB at day level)
and use this boolean in rules with day level, in order to skip evaluation for days in the future.
Since the rules that would require the above mask are a lot and all calculate LHS measures at day_sku_store, I thought of creating another temp measure at day_sku_store calculated as