How to install Analysis Cubes for Microsoft Dynamics GP


INTRODUCTION


This article describes how to install Analysis Cubes for Microsoft Dynamics GP and for Microsoft Business Solutions - Great Plains. Additionally, this article describes some common practices that you can follow when you install Analysis Cubes.

Note We recommend that you consider this article to be a supplement to the documentation that is included with each installer.

More Information


To install Analysis Cubes, follow these steps:

1. If you use Microsoft Dynamics GP 10.0, obtain the installer for Analysis Cubes with Microsoft SQL Server 2005 and with Microsoft SQL Server 2000 on the Microsoft Dynamics 10.0 CD2. 

If you use Microsoft Dynamics GP 9.0, obtain the installer for Analysis Cubes with SQL Server 2005 by visiting the appropriate Microsoft Website, depending on whether you are a partner or a customer.


Partner

https://mbs.microsoft.com/partnersource/downloads/releases/analysiscubes90sql2005.htm?printpage=false

Customer

https://mbs.microsoft.com/customersource/support/downloads/servicepacks/analysiscubes90sql2005.htm?printpage=false


Note The installer for Analysis Cubes with SQL Server 2000 is available only on the Microsoft Dynamics 9.0 CD2.

If you use Microsoft Business Solutions - Great Plains 8.0, obtain the installer for Analysis Cubes on the Microsoft Business Solutions - Great Plains 8.0 CD.

Note This version of Analysis Cubes is compatible only with SQL Server 2000.


2. Review the prerequisites for Analysis Cubes. To do this, see the documentation that is included with the installer.

Note If you use SQL Server 2005 and if you want to use the drillthrough functionality, you must use Microsoft Office Excel 2007.


3. Install Analysis Cubes.

Note The documentation that is included with the installer contains steps that you can follow to install Analysis Cubes.

Note The installation process in versions earlier than Dynamics GP 2010 are only supported from a 32-bit operating system.  Analysis Cubes for Dynamics GP 2010 is supported to be run from a 64-bit operating system. For more information, see KB article 929156


4. Create an SQL job to automatically run the master package. Additionally, create a job to process the cubes. This step only has to be done if you are using Dynamic GP 9.0.  Dynamics GP 10.0 and newer create the SQL job as part of the Analysis Cubes installation. 

Notes


  • For more information about how to create a scheduled job in SQL Server 2005, click the following article number to view the article in the Microsoft Knowledge Base: 930309How to set up the Master DTS and OLAP packages to run as a scheduled job in Microsoft SQL Server 2005
  • To create a scheduled job with SQL Server 2000, see the documentation that is included with the installer.

Microsoft Dynamics 9.0 and SQL Server 2005

For information about how to create Excel PivotTables from SQL Server 2005, click the following article number to view the article in the Microsoft Knowledge Base:

924017Components that are required to create Excel PivotTables from a server that is running Microsoft SQL Server 2005 Analysis Services



Excel add-in

If you want to create dashboard reports in Microsoft Office Excel 2003, you must download the Excel add-in for Analysis Services. To do this, visit the following Microsoft Website:

http://www.microsoft.com/downloads/details.aspx?FamilyId=DAE82128-9F21-475D-88A4-4B6E6C069FF0&displaylang=en/


Note TheExcel add-in is no longer available or supported. We recommend that you have Excel 2007 or newer if you want to create reports directly through Excel instead of through the Analysis Cubes client within Dynamics GP.