Skip to main content
O
Oscar
February 18, 2022

Aggregation Business Rule

  • February 18, 2022
  • 4 replies
  • 0 views

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:

 

FIX ("2025","Jan":"Dec","Actual")


Calc DIM ("Account","Source","Product","ResponsibilityCenter","Interco","Entity","Location");


ENDFIX;

4 replies

E
EricOsmanski
February 18, 2022

Depending on what version you are on, Entity Aggregation is now in the platform and does not require any BR's.. You can read more n the Reference Guide :  

EricOsmanski_0-1645197411581.png

 

C
ckattookaran
February 18, 2022

There are multiple ways. One is as Eric suggested.

If you are on the latest version, you can use Aggregated Cons member to trigger an aggregation.

C
ChristianW
February 18, 2022

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

K
Koemets
February 22, 2022

Oscar,

The most obvious way for the older versions of the OS is to run a databuffer for your E#ParentEntity.Base and do your simple math inside the loop. I know it's kind of simplistic solution, but hey, keep it simple 🙂

Terms & ConditionsAccessibility statement