Migrating OLP Databases with Cubes Built from OLAP Exchange^® - from Local to Server

It may be advantageous to first create the Cubes you want on a local machine, for testing purposes, then put these Cubes on the PowerOLAP MDB Server, in preparation for working in a production environment.

1.   First, copy your database, containing the Cubes in question, to the Server (In this example the Northwind.olp is used).

2.   If you then go to the PowerOLAP ribbon and click on the Data tab and select Cube Properties command from the OLAP Exchange control group, you will receive the following message, indicating that the PowerOLAP database cannot find the (previously specified) driver used on the local machine.

3.   Click OK, and the OLAP Exchange Cube Properties dialog box appears, with all information filled in, but the Driver.

4.   You can next click Configure and proceed through the same sequence of Data Source Name screens, etc., to name a DSN using the same driver that was used in creating the Cube on the local machine.