Excel VBA Add-in


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:

[url removed, login to view]

Skills: Excel, Visual Basic

See more: excel vba add, web api vba, jedox excel serial, palo vba api, excel vba java web, vba add excel, jedox excel add, vba excel add, www excel, vba work, vba with, olap multidimensional, olap database, multidimensional olap, java api table, java and excel, index bit, database multidimensional, bit index, script excel, vba for, in vba, excel vba with, excel vba or, excel vba help

Project ID: #1580988

3 freelancers are bidding on average $21/hour for this job


Hello. We are a Team of professionals in developing MS Access\Excel +VBA applications. Assume high quality work both in terms of technical background and time frame issues. Please check your inbox for examples.

$30 AUD / hour
(28 Reviews)

Hi We have very good experience in Ms-Office and Its Macro. We hope we can help you on this project Thanks, Kavitha

$15 AUD / hour
(0 Reviews)

plus +8 years working with VBA for excel.

$19 AUD / hour
(0 Reviews)