Closed

Excel VBA Add-in

This project received 3 bids from talented freelancers with an average bid price of $21 AUD / hour.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
N/A
Total Bids
3
Project Description

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]

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online