We are aiming to extend the functionality of Jedox/Palo a multidimensional (OLAP) database with an Excel and a web interface with additional features. Highest priority is the Excel VBA side of things. The web aspect involving php/java script is "nice to have".
Details about the Jedox platoform:
Jedox OLAP offers a variety of ways to extend applications via API and standard serial interfaces. Serial interfaces in VBA, PHP, C++, Java and .NET allow Jedox OLAP to be extended. In this way partners and customers are able to provide further functionalities for Jedox OLAP.
Details of work:
For the Excel and the web interface we are looking for 4 functionalities. Some of them have already been developed but need to be improved and integrated in one install package. The development platform for the Excel add in will be VBA for the web front end PHP or Groovy.
The 4 for functionalities are:
1. Chart Drill down
2. Chart Drill Across
3. Relational drill down (potentially also from Chart)
4. Zero suppression of empty rows in table
Features 3. and 4. "relational drill down (potentially also from Chart)" and 4. "Zero suppression of empty rows in table" are already developed they just need to be integrated in the total package (add in).
To help you we have uploaded manuals for jedox palo. The Jedox for excel advanced manual describes a little bit the API integration in chapter 8.3 and 12.3. Further information about the API is also available in the Palo forum:
Additional Project Description:
04/23/2012 at 9:22 CLST
Please find more detailed specs in attachment. The managility addin.xlsx only works with the installed jedox software. Please download the software and manuals of jedox for further details here: http://www.jedox.com/en/jedox-downloads/
(software can be downloaded FOX with login).