05-08-2024 08:26 AM
Hi all, how do you run an aggregation, i.e. calculate the "Aggregated" member of the consolidation dimension, without running a consolidation?
In particular, would it be possible to setup the Process step of a workflow profile so that it runs an aggregation (as opposed to a consolidation/force consolidation)?
Thank you
Solved! Go to Solution.
05-08-2024 10:04 AM
@AndreaF - It can be configured in DM Job and you can attach the DM job to the Calculation Definition in WF Profile
05-08-2024 10:05 AM
Hi Andrea,
Yes, you can configure the Calculation Definition on the workflow profile as follows:
- Cons: Aggregated
- CalcType: Consolidate
I hope this helps.
05-08-2024 10:04 AM
@AndreaF - It can be configured in DM Job and you can attach the DM job to the Calculation Definition in WF Profile
05-08-2024 10:05 AM
Hi Andrea,
Yes, you can configure the Calculation Definition on the workflow profile as follows:
- Cons: Aggregated
- CalcType: Consolidate
I hope this helps.
05-08-2024 10:36 AM
Ok, thank you both! I don't know why I expected a separate "Aggregate" command to be there alongside the consolidate/force consolidate, but in fact I have to consolidate on the Aggregated member!