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
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/…Read more
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
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…Read more
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. …Read more
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
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
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
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
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
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
The Default Cube Advisor Tool for Microsoft Dynamics AX 2009 generates a list of Cube and Role Center elements that are not valid for the specific license and configuration keys you are using. This tool complements the whitepaper Microsoft Dynamics AX 2009 White Paper: Configure the Default OLAP Cubes See also: Microsoft Dynamics AX 2009…Read more