With a client/server installation, only the user who is logged in during the installation will be registered with the OLAP Server. Other users first must register once they connect to the Jedox OLAP Server. The server will remain in the Jedox server list until unregistered again.
To create a new connection or to modify an existing connection, click on “Jedox Wizard” in the Jedox Ribbon.
The Jedox Connection Wizard appears:
With selection of connection type “Jedox Olap” you can
- create a new connection
- edit or unregister an existing connection
Connecting Excel Client with local OLAP Server
To register a new Jedox OLAP connection called “localhost” (supposing that it doesn’t exist), first select <new connection> and then click “Next”.
In the next dialog, fill in the fields as shown in the image below. These are the default values for the connection “localhost”. The password is “admin”.
When you have entered all the values, click “Test connection”. If the test is successful, you will receive a corresponding message. Confirm the message with OK, and then click “Finish”.You will receive a confirmation that the connection to Jedox OLAP was successfully registered.
Click OK to close the Jedox Connection Wizard.
Connecting Excel Client with a Jedox OLAP Server via a Proxy Server
In this case, enter the following addition in the server field of the connection wizard:
For example: @192.168.2.110:8080
Connecting Excel Client with a Jedox OLAP Server in the network
Suppose the computer on which the Jedox OLAP Server is installed has the network IP address 192.168.2.100 and associated name Jedoxsv0001.
To make communication with the Jedox OLAP Server possible for other computers, open the palo.ini file of the server with an editor. Then perform the following modification:
Below the line http “127.0.0.1” 7777 insert the following new line: http “192.168.2.100” 7778
Save the file and then restart the service “JedoxSuiteMolapService” of the Jedox server.
Now we can establish a connection with the Jedox Wizard of the Jedox client using the following entries:
The name in the field “Connection name” is not required to be the network name of the server (Jedoxsv0001). Of course, the user “john” and his password must exist on the Jedox Server.
Since the original entry – http “127.0.0.1” 7777 – has not been replaced, the server machine still has access through the localhost connection.
Note: the connection will be established faster if you use the IP address of the server (192.168.2.100) instead of the name (Jedoxsv0001) in both the palo.ini file and in the Jedox Wizard.
For each server entry created with the Jedox Wizard, there will be an entry in the registry.