Microsoft Dynamics 365 Blog

Blog posts for Analysis Services

Some reports from Reporting extensions can raise error when running on SQL 2008 R2 

1 min read

Thanks to our colleague in Japan we found problem when running some Dynamics AX reporting extensions report on SQL 2008 R2. When we open some standard SSRS reports with SQL2008R2 (ie. TSInvoicedPurchaseAmount.TS_InvoicedPurchaseAmountDetail.Report ), we receive following error. An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset ‘InvoiceAmountDetailedReport’. (rsErrorExecutingCommand) Query (58, 19)…Read more

0 Comments

Measure ‘Total purchases’ in Accounts payable cubes for dimension ‘Vendor Master’ shows values Uknown 

2 min read

Some time ago I run into problem that measure ‘Total purchases’ for dimensions ‘Vendor Master’ did not work. There was only values for attribute Uknown. So I was not able to see what was sum of vendor purchases for each vendor although I had bunch of Purchase Orders which were posted and invoiced. First step…Read more

0 Comments

Dynamics AX OLAP cubes shows data only till 2008 year 

2 min read

Some time ago we run into following problem. When we browsed Accounts Receivable Cube for Total Sales dimension we could see data only till 2008 year, the data for years: 2009, 2010 and 2011 where just simple not displayed. The first idea was to try solution from following post: http://blogs.msdn.com/b/emeadaxsupport/archive/2011/01/07/olap-time-dimension-does-not-contain-dates-for-year-2011.aspx but it did not help….Read more

0 Comments

Query execution failed for data set ‘Company’ 

1 min read

Recently we were having problems to get the Role Center up and running. Report Server is setup and working in a correct way. Most reports can be generated, but a few does not answer correct. For those report the following error is generated: “Query execution failed for data set ‘Company’” Reports in Role Center can…Read more

0 Comments

Unable to install Dynamics AX 2009 Analysis extensions when the default SQL Server Analysis Server collation is set to Turkish_CI_AS or Turkish_CS_AS 

2 min read

We came across an issue where by after installing the Dynamics AX 2009 Analysis Extensions sucessfully, no database is created! Even if you manually try to create the Dynamics AX Analysis database from the analysis script file DynamicsAX.xmla (found under the installation media in “\support\Analysis Services\Scripts\” folder), you get the following error message: <BR><return xmlns=”urn:schemas-microsoft-com:xml-analysis”>   <results xmlns=”http://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults“>     <root…Read more

0 Comments

Kerberos authentication issues in a multi server environment affecting only the KPI web part 

3 min read

When you are setting up Dynamics AX 2009 Role Center and Enterprise Portal in a multi server environment where each component is running on Windows Server 2008 you may get confronted with an authentication issue. The base requirement for a multi server scenario to work is to use Kerberos authentication and configuring Service Principle Names…Read more

0 Comments

SQL Execution Error. The multi-part identifier … could not be bound. 

2 min read

We were running lately into an issue with Dynamics AX 2009 and Microsoft SQL Server 2008 Analysis Services after switching the data source provider from SQLNCLI.1 (Microsoft SQL Server 2005 Native Client) to SQLNCLI10.1 (Microsoft SQL Server 2008 Native Client). The switch was necessary as the provider SQLNCLI.1 (Microsoft SQL Server 2005 Native Client) was…Read more

0 Comments

An error has occurred during report processing. (rsProcessingAborted) 

1 min read

In Dynamics AX 2009 a very common scenario with Enterprise Portal and Role Center is that only users that are local Administrators on the machine where Microsoft SQL Server 2005 is installed can correctly see Microsoft SQL Server 2005 Reporting Services reports (based on Microsoft SQL Server 2005 Analysis Services). All the non-admin users see…Read more

0 Comments

Connecting from Dynamics AX 4.0 Client to Microsoft SQL Server 2008 Analysis Services fails 

1 min read

Recently when I was trying to access an OLAP cube on Microsoft SQL Server 2008 Analysis Services from within the Dynamics AX 4.0 Client I was running into the error message: One or more required client components that support OLAP analysis are not installed on this computer. For details on the required components, in Administrator…Read more

0 Comments

Installing Microsoft Dynamics AX 2009 Analysis Extensions on a Microsoft SQL Server 2005 Analysis Services Failover Cluster 

2 min read

When you are trying to install the Microsoft Dynamics AX 2009 Analysis Extensions on a Microsoft SQL Server 2005 Analysis Services Failover Cluster you will run into the following error: Connecting to SQL Server 2005 Analysis Services on server ‘SQLAS’ and instance ‘MSOLAP$SQLASCLUSTER’. A connection cannot be made. Ensure that the server is running. No…Read more

0 Comments