You may run into this error running OLAP reports on a SQL Server 2016 Reporting Services instance on which the ENU\x86\SQL_AS_ADOMD.msi component from the Microsoft® SQL Server® 2012 SP1 Feature Pack was not installed. SYMPTOMS: When running the report in AX 2012 client you will see this error in the info log: “Client found response…Read more
Jolanta Malkowska
Posts
If you enabled Power BI integration in your Microsoft Dynamics 365 for Finance and Operations system as instructed in the article below, you may notice that parts of the reports do not display data while some do, even though there are transactions in the system and the Power BI reports were not modified by you….Read more
Data collection for the Named User License Counts report in Dynamics AX 2012 R3 Cumulative Update 9 and later
3 min read
Jolanta MalkowskaYou may be already familiar with the blog post of my colleague in which the background of the Named User License Counts report is explained. Using the Named User License Count report In this post, I would like to explain a change that was introduced in relation to this report in Cumulative Update 9 for…Read more
How to: Add a new relation for a new field to the same table to which a relation already exists [AX 2012]
3 min read
Jolanta MalkowskaIn Microsoft Dynamics AX 2012, the EDT relations were moved to tables and the creation of a new EDT relation is not possible anymore. This implies that only table relations can be added to the system. In special cases, additional relations need to be added to tables for new fields that reference the same table…Read more
Why does converting a report to pre-processing help to resolve timeout issues?
4 min read
Jolanta MalkowskaI assume you are familiar with the below post that contains detailed instructions for increasing relevant timeouts to enable long running reports to execute successfully. How To: Addressing SSRS Session Timeouts (Alternatively Tips to help prevent long-running reports from timing out [AX 2012]) The first recommendation in case of reports which use the Report Data…Read more
Dynamics AX 2012 Reporting: How to configure order positions to be kept on one page
2 min read
Jolanta MalkowskaWe often work on cases where an item position is not kept together on one page even though the “KeepTogether” property is set to “True” on the Details Group. The reason is that the Details Group is not treated by the SSRS as a regular group used for grouping data. Hence, a possible solution to…Read more