Well, hello. It has been more than three years since my last blog, since then I have been really busy at work and have a baby in the meantime.
That being said, I wonder how much joy you guys have with playing with MR.
I have been using Dynamics AX and MR for more than 3 years now and I am still able to learn new things. One of them is that MR is able to use the organizational hierarchies of Dynamics AX as the reporting tree.
For those who are clueless, in your organisation, you can define the organisational hierarchies of not just the standard organisation but for all your financial dimensions. The idea is that when you select an organisational hierarchy as the reporting tree, you do not need to create it from scratch. Furthermore, when the hierarchy changes in AX (I dropped the word “organizational” as it just makes typing too long), MR is able to reflect that based on the period selected for the report. I thought that was pretty cool.
What happens when you want to use the hierarchy as a filter in the column definition?
Terry: why in blazers would anyone want to do that?
Well, it so happened that I had a customer who needed to do just that.
Imagine the need to have different columns represent the amounts not at leaf level, but at a middle hierarchy level. Sure, you can filter on dimensions and manually create it, but there is no need to re-invent the wheel.