Reporting Series Part 1 – Building a Microsoft Dynamics® AX Reporting Toolkit

Reporting Series Part 1 – Building a Microsoft Dynamics® AX Reporting Toolkit

As any partner or client who has implemented Microsoft Dynamics AX can tell you, Dynamics AX out-of-the-box reporting is most likely not good enough to meet your business’ operational and financial reporting needs. While Microsoft® has done a good job of filling the financial reporting gap with the Management Reporter tool, a whole ecosystem of Dynamics AX add-ons has sprung up to support the operating reporting and business intelligence gap. When looking at the business case for Dynamics AX implementations, we often find that clients expect to use Dynamics AX to make more-informed decisions based on good data, but then the reporting aspect of the implementation is pushed back to a later phase. This frustrates users and often leads to onerous and longstanding workarounds. In this blog, we are going to start to clear up questions about what different tools are for, and how to narrow down the field to create an intelligent reporting toolkit that can be implemented from day one. This is the first blog post in a Reporting Series, so stay tuned for additional posts that help lay out a go-forward reporting strategy.

Financial Reporting

Every company has financial reporting needs, but while Dynamics AX has built-in financial reports most clients find that they are insufficient in meeting these needs. Most of our clients are using Microsoft’s Management Reporter (MR) tool to fill this gap. Access to MR comes with your Dynamics AX license though there are maintenance costs with this tool. This tool looks at ledger data for building reports – GL accounts and Financial Dimensions. It is a great tool for creating consolidated financial statements, distributing department-level P&Ls, and exporting data out to Excel. It is something a financial or business analyst can easily learn to write reports and support your business. This is something we recommend, and train our clients to use. In another blog post we will talk about a new feature in Dynamics AX that allows you to do complex international consolidations and eliminations directly in MR, along with the pros and cons of dropping the Dynamics AX consolidation process.

Operational Reporting

Where possible we advise clients to use standard Dynamics AX inquiry forms to do operational reporting. Inquiries can be customized by Users to a limited extent and developers can also extend Users’ ability to customize these forms, where there is a need. Where this does not meet your needs, there are other commonly-used tools to fill this gap. One such tool is Atlas. Atlas is a flexible tool that launches as an add-in directly in Excel and empowers Users to both extract data from AX and import data into AX in real-time. This tool has a bigger learning curve than MR; the User or whoever is writing an Atlas report must have a working knowledge of Dynamics AX table structure, which became much more complicated with Dynamics AX 2012 RTM. This tool also has some limitations on the complexity of reports. If you have especially large, complex reports sometimes the best route to success is to have an AX developer write an SSRS report. Many other tools exist in this space for this purpose as well.

Business Intelligence (BI)

BI is a space where there are many tools available. When thinking about BI, consider that output from BI can take two forms: (1) high-level management dashboards that look at trends and KPIs, and (2) detailed data that can be used by analysts for customized reporting. This can be an extremely powerful tool to provide information for decision-making in all aspects of the business, if leveraged correctly. BI data is generally refreshed periodically, such as nightly, so BI data is not real-time. BI cubes also require considerable maintenance and support. To create a custom cube of data is a significant task and thus BI generally has a material setup cost. Dynamics AX does ship with many standard cubes that you can deploy rapidly with minimal setup cost that can then be queried by Excel. We recommend that you deploy and use these cubes in absence of a more thorough BI solution for use in data analysis. These standard cubes can also be customized but it is, again, a non-trivial task.

Data Modeling

Dynamics AX ships with some data modeling tools that are brand new in Dynamics AX R3. In addition to that, Microsoft recently launched the Azure Machine Learning tool. We at Avantiico have not had a chance to dive into this tool yet, but once we do we will write up our findings in a blog post to share with the community.

These are some of the tools available to build a reporting toolkit, adding value to your Dynamics AX implementation. Better data leads to better analysis, and better decision making for your business; these tools are value-add for your business. Unleash all the data you have been collecting in AX with a proper reporting strategy. In the next Reporting Series blog, we will be covering how to use Management Reporter to building consolidating financial reports without having to go through the consolidation and elimination process in Dynamics AX.

Read the next part: Reporting Series Part 2 – Consolidation with Dynamics AX Management Reporter

About Dan McAllister

Dan McAllister has created 10 entries.

Post A Comment

YOUR CAPTCHA HERE

Contact Us

All fields required

First name

Last name

Company

Your Email

Subject

Your Message

×

Meet Us

All fields required

First name

Last name

Company

Your Email

Available Date & Time
AMPM

Your Message

×

Subscribe to our mailing list

* indicates required
 

×
Learn More

Contact Us

All fields required

First name

Last name

Company

Your Email

Subject

Your Message

×

CRM Test Form

×

Influence

All fields required

First name

Last name

Company

Your Email

Proposed Webinar Date & Time
AMPM

Your Message

×

Contact Us

All fields required
×

Contact Us Here! 

* indicates required

×

We want to hear your feedback

∗ indicates required

×

Let us keep you updated!

 ∗ indicates required

×

Meet Us

All fields required

First name

Last name

Company

Your Email

Available Date & Time
AMPM

Your Message

×

Contact Us Here! 

* indicates required

×

Contact Us Here! 

* indicates required

×

Schedule your meeting with us!

* indicates required

×

Schedule your meeting with us!

* indicates required

×

Book Your Time

×

                        RAMPUP SUBSCRIPTION PLANS

                    Choose a plan below, and one of our

              Support Consultants will contact you shortly.

×

                           PACKAGES START AT $4,999

                  Choose a package below, and one of our 

               Support Consultants will contact you shortly.

×

 Performance Review Details

 

Diagnostic Review of DyanmicsAX Server (AOS) & SQL performance and stability.

 

Written summary of findings and recommendations.

 

Up to 15 hours of issue resolution time to target your most immediate performance issues.

 

Review completed by our 100% onshore support team averaging more than 10+ years of DynamicsAX experience.

 

Get the help you need now, with no long-term commitment.

×

Functional/Department Help Pick 3

 

Help with up to 3 functional or department issues such as: invoicing, costing, closing the books, AR, AP, inventory, warehousing, etc.

 

Talk with our 100% onshore functional experts with over 250+ years of combined AX experience to define your issues and find recommended solutions.

 

Up to 20 additional hours of issue resolution time included.

 

Presentation of solutions and next steps from our expert team.

 

Get the help you need now, with no long-term commitment.

 

×

Reporting / BI Help

 

Choose up to 3 standard or custom reports for assistance.

 

Solve typical issues like: Report too slow, does not show what we need, need an additional field/column, etc.

 

Talk with our 100% onshore functional experts with over 250+ years of combined AX experience to troubleshoot report issues and recommend solutions.

 

Up to 20 additional hours of configuration or development time included.

 

Presentation of solutions and next steps from our expert team.

 

Get the help you need now, with no long-term commitment.

×

Please fill in the form to RSVP

 

×