Report Portal

Displaying totals at the bottom

For someone like me without a financial background, the default behaviour of AS when displaying a hierarchy seems natural: when you ask for a set like MyHierarchy.Members, you'd get all the parent members appearing in the list before their child members. But for financial reports you want the opposite, you want to see all child members displayed before the parent members. The other day I was asked how to do this in turn and asked Andrew Wiles (who has a lot more financial OLAP experience than me), and he pointed me to the simple answer - the HIERARCHIZE function.

Here's an example from Adventure Works:

Read more...

Tags: mdx

 

2007-2015 VidasSoft Systems Inc.