Microsoft KB Archive/942557

= How to connect to a SQL Server 2000 Analysis Services cube in PerformancePoint Dashboard Designer =

Article ID: 942557

Article Last Modified on 10/9/2007

-

APPLIES TO


 * Microsoft Office PerformancePoint Server 2007, 32 Bit Edition
 * Microsoft Office PerformancePoint Server 2007, 64 Bit Edition

-



Introduction
This article describes how to connect to a Microsoft SQL Server 2000 Analysis Services cube in the PerformancePoint Dashboard Designer component of Microsoft Office PerformancePoint Server 2007.



MORE INFORMATION
If you use the standard connection setting when you connect to a SQL Server Analysis Services cube, Dashboard Designer uses the XML for Analysis (XMLA) protocol to connect to the Analysis Services cube. Only Microsoft SQL Server 2005 Analysis Services supports the XMLA protocol. Microsoft SQL Server 2000 Analysis Services does not support the XMLA protocol. Therefore, if you try to connect to a SQL Server 2000 Analysis Services cube in Dashboard Designer, you experience problems.

To connect to a Microsoft SQL Server 2000 Analysis Services cube, you must use a connection string. To do this, follow these steps:  Start Dashboard Designer. In the Dashboard Designer window, click the Create tab. In the Objects group, click Data Source. In the Select a Data Source Template dialog box, expand All under Category, and then click Multidimensional. Under Template, click Analysis Services, and then click OK. In the Create a Data Source Wizard, on the Name the Data Source page, type a name for the data source in the Name box, and then click Finish. Click the Editor tab, and then click Use the following connection.</li> In the Connection String text box, type the following text:

provider=MSOLAP.2;data source= ;initial catalog= ;ConnectTo=8.0

Note In this step,  represents the name of the SQL Server 2000 Analysis Services server. represents the name of the Analysis Services database.

The following string is a sample connections string:

provider=MSOLAP.2;data source=MyServer;initial catalog=Foodmart 2000;ConnectTo=8.0

</li> In the Cube list, select the Analysis Services cube that you want to use.</li></ol>

Keywords: kbhowto kbinfo kbexpertiseadvanced KB942557

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.