Search results matching tags 'denali' and 'PowerPivot'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=denali,PowerPivot&orTags=0Search results matching tags 'denali' and 'PowerPivot'en-USCommunityServer 2.1 SP2 (Build: 61129.1)Parent-child special calculations in #BISM #Tabular #Denalihttp://sqlblog.com/blogs/marco_russo/archive/2011/07/22/parent-child-special-calculations-in-bism-tabular-denali.aspxFri, 22 Jul 2011 07:55:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:37157sqlbi<p>Alberto Ferrari published an <a href="http://sqlblog.com/blogs/alberto_ferrari/archive/2011/07/20/tabular-parent-child-dimensions-sumofleaves-and-the-calculate-wall.aspx">interesting blog post</a> regarding how to write particular calculations over a parent-child hierarchy in PowerPivot Denali (and in BISM Tabular, of course). One case is the Sum of Leaves (summing only the leaves of a parent-child hierarchy) and the other is the Sum of Children (computes all the nodes that are descendants of the current node, excluding the value of the current node).</p> <p>It is always more interesting the fact that DAX can perform calculation over hierarchies, without having specific commands to navigate in a hierarchical structure. The results is not so easy to write, but it works and is probably pretty efficient.</p>