Dynamics AX Business Intelligence blog

I run into this blog some time ago. It is lead by Saveen Reddy who is Product Manager for Dynamics AX Business Intelligence. On his blog you will find the bunch of screen cast which will help you to develop reports: http://blogs.msdn.com/b/dynamicsaxbi/archive/2010/12/01/ax-ssrs-reporting-screencast-list.aspx as well some sneak previews regarding Dynamics AX 2012 and BI. Blog: http://blogs.msdn.com/b/dynamicsaxbi/…


Dynamics AX OLAP cubes shows data only till 2008 year

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….


Error when accessing form “BI generation options”

You get error when opening form Administration > Setup > Business analysis > OLAP > BI generation options Cannot execute the required database operation. The SQL database has issued an error and in Application event viewer on AOS server you can find following entry The database reported (session 3 (Admin)): [Microsoft][SQL Native Client][SQL Server]Invalid column…


OLAP Time dimension does not contain dates for year 2011

I ran into this problem when running TS_DeliveryPerformance report which was simply empty. After investigation I saw that all packing slip transactions made in January 2011 were shown in Sales Cube under Unknown year. Going forward when I browse Time dimension I could see that dates are only generated till the end of 2010 year. …


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

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…


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

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…


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

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…


An error has occurred during report processing. (rsProcessingAborted)

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…


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

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…