The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

AndreaF's avatar
AndreaF
Contributor III
2 years ago
Solved

Aggregate without consolidating

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

Workflow
  • Krishna's avatar
    Krishna
    2 years ago

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

     

  • RachealCrowder's avatar
    RachealCrowder
    2 years ago

    Hi Andrea,

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

    - Cons: Aggregated

    - CalcType: Consolidate

    I hope this helps.

3 Replies

  • Krishna's avatar
    Krishna
    Valued Contributor
    2 years ago

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

     

  • RachealCrowder's avatar
    RachealCrowder
    New Contributor III
    2 years ago

    Hi Andrea,

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

    - Cons: Aggregated

    - CalcType: Consolidate

    I hope this helps.

  • AndreaF's avatar
    AndreaF
    Contributor III
    2 years ago

    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!