0

SSAS Tabular Parent-Child Hierarchies

I suspect we're going to get a requirement to model parent/child and ragged hierarchies in SSAS at some point.  A current method for doing this work is outlined here: 

https://www.mssqltips.com/sqlservertip/5256/how-to-handle-a-parentchild-relationship-in-analysis-services-tabular/

As you can see, it heavily relies on the developer working on the model in Visual Studio - it would be extremely challenging to do this work in Discovery Hub as things stand now.  

This kind of hierarchy is extremely important when modeling charts of accounts or organizational structure - is support for this functionality on the map anywhere? 

1 comment

Please sign in to leave a comment.