Introduction

Requirements

DataWarehouse Explorer has been built on top of the .Net Framework 2.0. As the application has been virtualized, all required system components are present within the executable itself. However, to cut down on the size of the executable, two versions are available: one that includes the .Net framework in the virtual application, and one that doesn't.

Supported platforms

The application will run on any platform supported by the .Net Framework 2.0; in practice this means it will run on Windows 2000 and above (i.e. XP, Vista), both 32 and 64 bit editions.

Optional components

As the application has been virtualized, almost all required components are already included in the application itself. However, there are some features that access legacy or seldom used systems that require the installation of components on the user's computer.

Optional components must be installed when accessing the following sources:

Analysis Services 2000

There are two methods to access Analysis Services 2000 cubes:
 

1.Using the XML for Analysis Provider for SQL Server 2000 (preferred method).
The XML for Analysis provider is a web service that provides access to a Analysis Services 2000 server.
Using this technology you do not need to install anything on the client machine to connect to AS 2000, you only need to install the provider on the server machine.
When connecting to a cube using this method, you must specify the url of the web service you created during installation of the provider, for example http://myserver/xmla/msxisapi.dll.
 
2.Using the Analysis Services 2000 PivotTable Services client.
The PivotTable Services client can be downloaded from the Microsoft site.
To use this method, you must also install the Core XML Services 6 and the ADOMD.NET client. The downloads for these components can be found on the same page as the PivotTable Services client.
When connecting to a cube using this method, you can directly type the name of the analysis server you want to connect to.
 

Local cubes

To work with local cubes, the Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider must be installed on the user's machine. This can be downloaded from the Microsoft site.

More information

For more information on how DataWarehouse Explorer can be deployed, please review the Administrators Guide that is available for download from our website.