Professional Software Architecture : Dynamics AX 2009 Cube deployments to SSAS 2008 on a clustered SQL 2008 on Windows Clustering / Failover Server 2008

Welcome to David Sandor Sign in | Join | Help

Dynamics AX 2009 Cube deployments to SSAS 2008 on a clustered SQL 2008 on Windows Clustering / Failover Server 2008

In short: You must manually deploy the SSAS cubes to your SSAS 2008 server.

On your Dynamics AX 2009 installation media locate the following folder:

[MEDIA ROOT]:\support\Analysis Services\Scripts

Locate the DynamicsAX.xmla SSAS deployment script. This file contains all the information to create the SSAS database, all the dimensions, and all the cubes.

To install this script you must open SQL Server Management Studio 2008 and connect to the Analysis Services server.

Next, right click on the SSAS server root node and choose New Query | XMLA.

This will open a new XMLA query window. Drag the DynamicsAX.xmla script into this window and execute it. This will create the SSAS database for Dynamics AX.

Published Tuesday, May 05, 2009 7:31 PM by david

Filed under: Server 2008, Dynamics AX 2009, Axapta, Dynamics, SQL Server 2008, SSAS

Comments

	Tips and Tricks Professional Software Architecture...blogged. said: There is a document that links to a spreadsheet which lists all the licensing modules which relate to May 5, 2009 11:32 AM
	Professional Software Architecture said: The following is a journal of my installation of the AX2009 product. Some basic environmental information: May 5, 2009 11:44 AM
	David Sandor said: Microsoft Dynamics Axapta 2009 Installation Notes and Error Messages July 16, 2009 2:56 PM

Anonymous comments are disabled

This Blog

Home
Links