Hierarchy Tables: store as parent-child or flattend

A parent-child table works great on a cube, but sometimes you need it as a flattend table.

Could we have an option on hierarchy tables to either store it in the traditional parent-child manner, or as a dynamically generated flat table? (So, if your hierarchy is 6 levels deep, you get 6 columns in your table; filling the blanks with parent values in case of ragged hierarchies)


this might be related to this post: https://support.timextender.com/hc/en-us/community/posts/205682823-Option-to-flatten-hierachy-table?input_string=Hierarchy%20Tables 


Please sign in to leave a comment.