real solutions for real problems
Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Analysis Services   (RSS)

Query execution failed for data set 'Company'

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

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

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

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

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

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

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

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'

Default Cube Advisor Tool for Microsoft Dynamics AX 2009 has been released

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

Unable to deploy ODC files to Enterprise Portal even after installing Hotfix KB960158

I was recently running into the situation that with Dynamics AX 2009 Service Pack 1 I was not possible to deply ODC files to Enterprise Portal when Microsoft SQL Server 2008 Analysis Services was used as backend database. The error message that showed

AX OLAP Cube Setup - Transaction Date not Saved

Today I saw an issue with the AX Cube definition manager not saving a new value for "Transaction date" on the measures tab. A user makes a change but when they go back to check it's not saved. This only occurs when the user follows a specific sequence
 
Page view tracker