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:
<results xmlns=”http://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults“>
<root xmlns=”urn:schemas-microsoft-com:xml-analysis:empty”>
<Exception xmlns=”urn:schemas-microsoft-com:xml-analysis:exception” />
<Messages xmlns=”urn:schemas-microsoft-com:xml-analysis:exception”>
<Error ErrorCode=”3239313662″ Description=”Errors in the metadata manager. The attribute with ID of ””Description””, Name ”””” of referenced by the ”””” cube dimension, does not exist.” Source=”Microsoft SQL Server 2008 Analysis Services” HelpFile=”” />
</Messages>
</root>
<root xmlns=”urn:schemas-microsoft-com:xml-analysis:empty”>
<Exception xmlns=”urn:schemas-microsoft-com:xml-analysis:exception” />
<Messages xmlns=”urn:schemas-microsoft-com:xml-analysis:exception”>
<Error ErrorCode=”3239313412″ Description=”Errors in the metadata manager. Either the database with the ID of ””Dynamics AX”” does not exist in the server with the ID of ””ANUP209””, or the user does not have permissions to access the object.” Source=”Microsoft SQL Server 2008 Analysis Services” HelpFile=”” />
</Messages>
</root>
</results>
</return>
We got this issue on a SQL Server Analysis Server (SSAS) 2008 where the default collation was set to Turkish_CI_AS. The same will apply if you were running SQL Server 2005 and also with Turkish_CS_AS collation. This is by design as the Analysis extensions (OLAP framework tools and Default Cubes) have been tested only in the following AX language/collation combinations:
Language SSAS Collation
English US Latin1_General_CI_AS
Danish Danish default collation
German German default collation
Chinese Chinese default collation
Arabic Arabic default collation
You maybe able to workaround the issue as follows:
– In SQL Server Management Studio, connnect to SSAS and right click on the server name to change the properties of collation .
– Set your collation to Latin1_General for instance and restart SSAS
– Run the AX setup to add the “Analysis extensions”.
– When the DynamicsAX database and its cubes have been created, you could either change back SSAS collation to Turkish_Cx_Ax, or first backup the database, then change SSAS collation to Turkish_Cx_Ax and restore the backup.