Examples: Fixed Asset Overview Report (Re-imagined)

Microsoft Dynamics AX 2012


The following report was created to demonstrate a new way of staying up-to-date on company assets using a graphical solution with built-in analysis.  Feel free to use this example to continue the effort of re-imagining existing processes with Business Intelligence.


Source code available here for AX 2012 R2.

Note: This is sample code and has NOT been fully vetted for production environments. Additional customizations are highly recommended.



Fixed Asset Overview 

Comments (2)

  1. I understand that this report was built for demonstration purposes, though I have a few comments regarding the way the data were presented in the report:

    Top 5 Assets – typically the top values are sorted by value descending or ascending upon case. Also I find it useless and unaesthetic to show the total in so big fonts and with a dark colored background.

    The Pie-Chart is kind of irrelevant and typically not recommended to display data. The most important argument is that the human eye can’t interpret correctly values based on multiple dimensions like in this case. Sure, to some degree can be identified which is the category with the biggest percentage, though how about the other values? Labels with the values for each category would have made the pie-chart more meaningful. Also the choice of colors can be argued…

    Are the Pie-Chart and Asset Distribution representing the same data? If yes, the information displayed are redundant. On the other side redundant information can be acceptable in a report as long the two modes of displaying the data facilitates the overall understanding of the data.

    I was wondering whether the values from Assets Distribution would be better shown if the chart was using the whole width of the report. Some labels for the values of the bars would have increased the meaning of the data. Also using it would have been nice if the colors for each category could have been synchronized between the charts.

    Asset Details – the Name seems to be irrelevant in the report, unless the same report is used for drilldowns or similar analysis and the column displays more meaningful data. It would have been easier to have Total Value instead of Value. Again, the sorting of data by value could increase the understanding of the table.

    I’m trying to give some meaning to the last chart, though I’m not sure if I can. I can see that the value model, whatever it means, is almost one fourth from the total, though that’s kind of all. Same remark as above related to the interpretation of multidimensional values applies here as well. The bar charts might be a better solution to represent the same data. I understand that developers worry that by displaying the data using the same tools could make the report boring for the users, though then we'd better question whether the data are meaningful for the users.

  2. Pete Matson says:

    I understand reports can look like this.   Why aren't many more of the out-of-the-box reports styled better?  Or at least be able to add a easy Report style template to all reports.

    Why can't you add images to a report style template?   Having a company/site seal in a report style template would be nice.   Then all your autoreports or autodesigns can use the Custom template very easily with a custom graphic.  

Skip to main content