If you need to access the Jedox OLAP Server component of Jedox Web from Excel Clients on different machines, you must update the
palo.ini and make the following changes to configuration files:
- Changes in the file
Change the entry http “127.0.0.1” 7777 to either http “” 7777 or http <SERVER-IP> 7777.
- If you enter a static IP other than 127.0.0.1, you also need to change other configuration files:
…\httpd\app\etc\config.php, the entry define(‘CFG_PALO_HOST’, ‘127.0.0.1’) needs to be changed to the Server IP used in palo.ini.
…\core\palo_config.xml, the entry <host>127.0.0.1</host> needs to be changed to the Server IP used in palo.ini.
- Changing the Jedox OLAP Server port:
Change the port entry http 127.0.0.1 7777 to the new port.
This change must also be made in
…\httpd\app\etc\config.phpfor the entry define(‘CFG_PALO_PORT’, ‘7777’);
…\core\palo_config.xmlfor the entry <port>7777</port>.
- The Jedox services need to be restarted after making these changes in order to apply these settings.
You can make these settings if you run Jedox on-premise, but they must not be changed in a Jedox Cloud environment. These changes are available for Jedox Web Connections Manager if the server IP is hardcoded in palo.ini as the only allowed IP from which other connections can connect to OLAP. If you use the Excel Add-in, make sure you set the connection to
http "" 7777 to make sure that all the users of the Excel Add-in can connect to OLAP.
Note: it is recommended to check the settings and ensure that the firewall is configured to let these ports communicate outside the server. This must be ensured when a connection from the outside is made to the server, either from Excel Add-in or another Jedox Server to OLAP. For more information on how to use the ports, see Jedox Web Connections.