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.

Do you know you can make a copy of the hierarchy at a point in time? Select a particular hierarchy, then save it. VOILA – it becomes a reporting tree.

Then open it and have a look – do you see the problem of using this tree?

That’s right, levels higher than the leaf level have dimensions assigned to them! This will not work for roll ups.

What you need to do is to remove the dimensions of the upper levels leaving the dimensions just for the leaf level. Now the tree will roll up correctly.

What happens when the hierarchy changes? Just save the latest hierarchy as a tree and delete the dimensions of the upper levels again. This should take you all of 5 – 10 minutes.

Have fun! :p

Leave a Reply

Your email address will not be published.