Report Portal

Leaves() : Works for regular hierarchies but not for parent child hierarchies

My objective was to create a measure 'BudAmount' which is equal to 'Amount' at the leaf level and then it needs to be aggregated like 'Amount' measure across any hierarchy in AdventureWorks' "Financial Reporting" measuregroup .

I read a post in MSDN forum which was similar to my need. In the post, it was needed to define a calculated measure at leaf level and then aggregate the calculated measure like any normal measure.

Read more...

Tags: mdx, parent-child

 

2007-2015 VidasSoft Systems Inc.