Skip to main content
A
AndreaF
May 8, 2024
Solved

Aggregate without consolidating

  • May 8, 2024
  • 3 replies
  • 1 view

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

Best answer by Krishna

AndreaF  - It can be configured in DM Job and you can attach the DM job to the Calculation Definition in WF Profile


Krishna_0-1715176980050.png

 

3 replies

K
KrishnaAnswer
May 8, 2024

AndreaF  - It can be configured in DM Job and you can attach the DM job to the Calculation Definition in WF Profile


Krishna_0-1715176980050.png

 

R
RachealCrowder
May 8, 2024

Hi Andrea,

Yes, you can configure the Calculation Definition on the workflow profile as follows: 

- Cons: Aggregated

- CalcType: Consolidate


RachealCrowder_0-1715177003104.png

I hope this helps.

A
AndreaFAuthor
May 8, 2024

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!

Terms & ConditionsAccessibility statement