Modules:Analytics XMLA
Languages: |
English | Français | Translate this article... |
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).