Better together: Microsoft Dynamics AX 2012 R2 and SQL Server Power View

Microsoft Dynamics AX 2012 R2 utilizes the powerful capabilities of SQL Server in providing a comprehensive BI solution. A summary of Microsoft Dynamics AX 2012 R2 BI capabilities are provided below. We have categorized the capabilities along the lines adopted by BI industry literature.    Power View is an interactive, browser-based data exploration, visualization, and…

Known Issue: Dynamic Precision designs spacing issues in RTL languages

Microsoft Dynamics AX 2012   WHAT IS THE ISSUE?   Pattern – Precision designs containing columns in a tablix control which are hidden using dynamic expressions.  These expressions are commonly used to evaluate the report data set or parameters.  For example, if the type of purchase order affects the columns displayed in the report it…


Overview: Drill-Thru Support in Reports

Microsoft Dynamics AX 2012 WHAT IS A DRILL THROUGH? With regard to SSRS reports in Microsoft Dynamics AX 2012, a drill-though is a hyperlink embedded directly in the report content. These hyperlinks can be statically defined in the report definition or generated dynamically based on the reporting session context including user security rights, AX metadata, and configuration keys….


How To: Setup SSRS Report Archiving

Microsoft Dynamics AX 2012   Background Dynamics AX 2012 enables users to choose Archive as a print destination. When chosen, the report is saved to the archive. Archiving functionality makes use of the Microsoft Dynamics AX document management framework. This means that the system administrator has the ability to specify the location of the archive….


IsNotApplicable (N/A) attribute and count measures in AX (2012) SSAS cubes

With Dynamics AX 2012, a new attribute shows in the AX SSAS cubes’ dimensions: IsNotApplicable (N/A). The attribute has been added as part of the solution to prevent errors during the cubes processing that were due to missing relationship-keys, e.g., attribute keys, between the fact and dimension tables. Such errors and their logging had a…


Collections: Scale-Out Deployments

Dynamics AX 2012 SQL Server provides many opportunities to share resources and improve the availability of your report server. Use the following resources to plan and implement a scale-out deployment for use with Dynamics AX 2012. A SQL Server Reporting Services (SSRS) scale-out deployment includes two or more report server instances that share a single…


White Paper: Format & Alignment Transformations

Dynamics AX 2012 SUMMARY A segment of our target customer base requires numeric characters to be rendered in reports using the national format to be compliant with government standards for the Department of Zakat and Income Tax documentation.  Developers also require field level control over the reporting framework’s numeric transformations which affect column alignment and…


Collections: Report Developer Resources

Dynamics AX 2012   This article contains a list of helpful resources for Microsoft Dynamics AX 2012 report developers. SQL Server Reporting Services – Links to high level Reporting Services content and developing with Reporting Services.   Planning and Architecture – Describes the architecture of the reporting framework in Microsoft Dynamics AX.…


How To: Directing Reports to Email

Dynamics AX 2012 Sharing reports via Email has never been easier. The following exercise outlines the process for developing a reporting solution that includes automatic distribution using Email without prompting the user for additional parameter information. Step 1/2: Create a session management class To send reports via Email from code you can use the new…


How To: Sending Reports to file

Dynamics AX 2012 Automation is a common requirement for transactional reports such as Customer Invoices and Sales Receipts which are triggered by other user actions. This exercise will illustrate techniques for opening SSRS Reports using code without prompting the user for additional parameter information. Step 1/3: Open a report from code To open a report…