Upgrading Reports for AX 2012 - Resources

I wanted to take the time today, to point to two resources on Microsoft TechNet. This is related to upgrading reports from AX 2009, to AX 2012. The very first thing that must be clear, is that No Reports will be upgraded to the new SSRS Reporting Model for AX 2012.

With that said, MorphX reports as well as ReportLibraries can still live within AX 2012. There is actually a process in which you have to execute that will take the metadata for the AX 2009 ReportLibraries and update them, so they can live and execute within an AX 2012 instance. That resource can be found here.: Report Project Upgrade [AX 2012]

Further, there is a guide: Guidance when Upgrading Reports [AX 2012].
"Reports are not upgraded automatically during the upgrade process. Microsoft Dynamics AX provides hundreds of default, out-of-the-box reports that you can deploy and customize. To upgrade MorphX reports, we recommend that you customize a default report. The default reports run on SQL Server Reporting Services. Reporting Services is a server-based reporting platform that provides comprehensive reporting functionality for a variety of data sources.

When upgrading to Microsoft Dynamics AX 2012, existing Reporting Services reports and reports based on the MorphX reporting framework are copied to the Microsoft Dynamics AX 2012system. However, they will not be upgraded."

The reporting model, metadata, as well as data structure changes, all within AX 2012 make it impossible really, and not a lot of value, for trying to upgrade, say an MorphX report, or even a ReportingLibrary to the new report model. This is an area of an Upgrade that will need attention for sure. Doing this, also means that you can take advantage of a lot of great new reporting tools, around Microsoft Excel PowerPivot as well as the new Microsoft Dynamics AX 2012 - Excel Add-in.

I will be covering this topic, in the class I'm leading next Tues at AXUG summit. I'm doing my final preps for sessions now, and looking forward to seeing everyone out there. You can follow me, as I will also be covering the event live from my twitter account: twitter.com/DynamicsERP.

That's all for now. Look for some updates while at AXUG, as well as my tweets. Also regular postings will pick back up after AXUG Summit next week.

Till Next Time! Cool Beans? ;-)

"Visit the Dynamics AX Community Page today!"

Dynamics AX 2009 - SSRS Report Deployment Issue

If you have deployed the SSRS Report Lib.'s from Dynamics AX 2009 before, you might have ran into some timeout issues.

Even with deploying the reports one ReportLib at a time. And if you have not seen this yet, most likely you will.

An error message, sometimes with great detail will show up during the Reports Deployment process, and that will reference something similar to the following.

[ThreadAbortException: Thread was being aborted.]

The ThreadAbortException is the key for this error. Basically the thread trying to do the deploy is timing out writing to the Report Server.

Most likely you cause is related to the amount of langauge files / cultures that are trying to be deployed for the given ReportLib.

A simple change can be done to help fix this issue.



The following is the steps to do, that relate to the above table inside Dynamics AX.:
1) Open the AOT
2) Expand Data Dictionary > Tables > LanguageTable > Fields
3) Right click on the 'LabelFile' field and choose properties
4) Change the Visible property to 'Yes'
5) Save the change
6) Right click on the LanguageTable and choose Open
7) In the table, uncheck the Label file field for any languages that are not needed
8) Deploy the ReportLibs again that were having issues

This may not be the fix all the time, but most likely it will be. Also this can be used to help clean up the Report Manager. The initial deploy can deploy a lot of reports in languages you just don't care about. So you can remove those, or clear the entire Report Manager and then deploy with only the language files / Cultures that matter to you.

Well that's call for now, check back soon, as I have more post coming! See you then!




"Visit the Dynamics AX Community Page today!"