Working with Xchange on the Server

Working with Xchange on the Server

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 Xchange. In all likelihood, though, you will need to configure Xchange for use with proCube Server, the subject of this topic and represented in the following figure.

workingwithxchangeserver.png

Figure 1.    Xchange Creates and Updates Cubes

The topic assumes that you have installed the Server. The first part of this topic concerns Creating a Cube from the 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 Configuring the Server for Xchange. Finally, we will discuss how to create relational tables from the proCube Server.

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 proCube Server, in preparation for working in a production environment. The procedure for this is discussed in Migrating OLP Databases with Cubes Built from Xchange from Local to Server.

Note that the following is an example of working with a Windows 2000 / SQL Server 2000 system.

Creating a cube on the server

To create a cube for placement on the server:

  1. Start proCube Management Studio.

  2. From the Server View, select a server. (If the server is stopped, right-click on it and select Manage Server - from there you can start or stop the server).

serverviewserverdatabasecommands.png

Figure 2.    Server View - Server and Database Menu

  1. To create a new database, right-click on a server and select New Database to open the New Database Dialog.

newdatabasedialogservernorthwind.png

Figure 3.    New Database Dialog - ServerNorthwind

  1. In the File Name: field, enter the location and name of the *.olp database. Make sure that you select Allow Reserved Characters.

  2. Click OK to create the database.

  3. From the Server View, right-click and select Load Database to open the Load Database dialog.

  4. Select the database file and click OK to return to Server View.

  5. Right-click and select Connect Database to activate the database.

  6. From  the Data ribbon's Xchange Group, click Create Cube to open the Create Cube from Relational Source dialog. You now can proceed to build a cube using the procedure as described in Defining an ODBC Data Source Between proCube and an SQL Server Database.

Working with Xchange as client in a server scenario

We will now consider how to proceed with Xchange features discussed previously (Modify Relational Dimension; Rebuild Cube; Update Cube) and whether these may be performed from a Client in a Client/Server scenario. The following is a useful table indicating what can be done from the Client in a Server scenario, provided you have appropriate database privileges (i.e., Design privileges on Metadata for the Cube.

 

proCube Client

Server

Create Cube

 

ü

Modify Relational Dimension

 

ü

Rebuild Cube

ü

ü

Update Cube

ü

ü

As indicated above, when working with a server-based database, you can not create a cube from a client using Xchange. You can, however, create a cube using Xchange on a local machine, then place it on the server.

 


Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk