Skip to main content
halbrooks100
Nov 13, 2023 8:51 PM UTC
Solved

Eliminations not working in an Alternate hierarchy

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

 

halbrooks100Answer
Nov 15, 2023 4:38 PM UTC

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. 

View in thread

5 replies

NicolasArgente
Veteran
Nov 14, 2023 11:18 AM UTC

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
    Nov 14, 2023 1:41 PM UTC

    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.

     

      halbrooks100Author
      Nov 14, 2023 2:04 PM UTC

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

      halbrooks100AuthorAnswer
      Nov 15, 2023 4:38 PM UTC

      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