Up to this point we have proceeded as though we were operating from a standalone machine—this approach is useful for showing the workings of OLAP Exchange®. In all likelihood, though, you will need to configure OLAP Exchange® for use with PowerOLAP®– MDB Server, the subject of this section and represented in the following figure:
.png)
This section assumes that you have installed the MDB Server. [You may see PowerOLAP MDB Server section for further information.]
The first part of this section concerns Creating a Cube from the MDB Server Service Control Program, with the assumption that the Server has been configured to connect to a relational database and that the DSN has been set up. If that is not the case, you will need to begin with the subsequent topic, Configuring the MDB Server for OLAP Exchange. Finally, we will discuss how to create relational tables from the MBD Server.
Tip
It may be advantageous to first create Cubes you want on a local machine
for testing purposes, following all the procedures you have learned so
far. You could then put these Cubes on the PowerOLAP® MDB Server,
in preparation for working in a production environment. The procedure
for this is discussed in the Section on Administrator Topics, Migrating
OLP databases with Cubes Built from OLAP Exchange, for Local to Server.
Note that the following is an example of working with a Windows XP, Windows 2003 server and SQL Server 2008 R2 system.
Please see the following topics: