Consolidation and Intercompany Elimination with parallel hierarchies

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

In my last post I described and approach on how to calculate consolidated values (adjusted by intercompany eliminations) using PowerPivot and DAX. In this post I will extend this technique so it can also be used with parallel hierarchies as this is also very common in financial applications.

Switching from a single hierarchy to multiple parallel hierarchies has several drawbacks for tabular models:

Read more...

 

Tags: dax, design, hierarchy

 

2007-2015 VidasSoft Systems Inc.