Aggregation Business Rule
Hello
How does one write an aggregation business rule? I know Accounts aggregate automatically, but a business rule is needed for Entities, correct? In Essbase we could have something like:
...
Forum Discussion
It doesn't work for entities, but I want to mention it anyway:
The api.data.calculate function has filter parameters, they can be used similar to the fix command:
api.Data.Calculate(formula, accountFilter, flowFilter, originFilter, icFilter, ud1Filter, ud2Filter, ud3Filter, ud4Filter, ud5Filter, ud6Filter, ud7Filter, ud8Filter, onEvalDataBuffer, userState, isDurableCalculatedData)
api.Data.Calculate("A#Profit=A#Sales-A#COGS",,,,,"UD1#Admin.base",,"UD3#Americas.base, UD3#UK",,,,"UD7#Top.base.remove(None)",,,,)I hope this helps