Skip to main content
H
halbrooks100
November 13, 2023
Solved

Eliminations not working in an Alternate hierarchy

  • November 13, 2023
  • 2 replies
  • 0 views

We have our main hierarchy that has intercompany eliminations working as they should. 

We also have 2 alternate hierarchies where one is eliminating as it should, and the other is not eliminating. 

 

Consol -   Primary Hierarchy - Percent Consolidation 100

Consol - Alternate hierarchy - Percent Consolidation 0  - Elimins not working at first common parent,

Second Alt Hierarchy - Percent consol 100 - Eliminations working as they should.

 

halbrooks100_0-1699908517794.png

 

Best answer by halbrooks100

Thank you for your feedback, it appears our issue is related to the account extensibility, the base level accounts are not valid for the parent rollups and therefore do not eliminate.  Meeting further with OneStream to confirm. 

2 replies

N
NicolasArgente
Veteran
November 14, 2023

Hi halbrooks100 
You are correct, there should  be an elim on Consol. Please review your elimination script probably under Finance BR rules. Is Consol rolling up to a parent? Remember Elim will happen after the local, translate....
Thanks,

    MikeG
    MikeG
    Contributor
    November 14, 2023

    And halbrooks100 both hierarchies will need to be Consolidated separately at the respective Entity Parent.  Make sure your V#CalculationStatus is OK on both hierarchies.

     

      H
      halbrooks100Author
      November 14, 2023

      Thanks Mike, sounds like I need to pull the alternate out into its own consolidation.   and thanks v# calc status is OK in both. 

      H
      halbrooks100AuthorAnswer
      November 15, 2023

      Thank you for your feedback, it appears our issue is related to the account extensibility, the base level accounts are not valid for the parent rollups and therefore do not eliminate.  Meeting further with OneStream to confirm. 

      Terms & ConditionsAccessibility statement