Modules:Analytics XMLA

XMLA - xmla4js - Excel Integration

Openbravo Analytics supports the XMLA webservice api.

The standard xmla context path/url to the xmla webservice has a form like this:

http://localhost:8080/openbravo/xmla?l=Openbravo&p=openbravo

Note:

• replace the host/port/context with the settings relevant for your installation.
• The parameters l and p are for the username and password. Note that when sending password information it is best to use a secure connection (https) and application setup.

Openbravo embeds the xmla4js application web ui, the xmlajs application can be accessed through a url like this:

http://localhost:8080/openbravo/web/org.openbravo.client.analytics/xmla4js/

Note: the xmla4js samples have the xmla url pre-filled with http://localhost:8080/openbravo/xmla?l=Openbravo&p=openbravo, make sure to replace this url with a url relevant for your installation.

To access Openbravo Analytics through xmla4js visit the xmla4js sample page:

http://localhost:8080/openbravo/web/org.openbravo.client.analytics/xmla4js/samples/index.html

You can read/access Openbravo Analytics also from excel through the XMLA webservices. This is for example supported through a excel plugin as provided by Simba (non-open-source).