OLAP Datamart Development MySQL Pentho Mondrian

Avg Bid (AUD)
Project Budget (AUD)
$15 - $25 / hr

Project Description:
Our core application has a C# business layer and a MySQL data layer. We have some reporting requirements that take literally hours to run as they require lots and lots of aggregation. We also foresee a use for pre-analyised data for dashboard type reporting. Thus we think it's time we introduce a datamart which pre-calculates the answers to our questions in real time such that we can simply return them as needed rather than calculate them as needed.

The assignment is therefore to build a set of cubes in a datamart using opensource software (perhaps Mondrian but open to other ideas). The sample report we provide (which is already built on top of MySQL but takes ages to run) should run near instantly.

This is sort of open-ended work so we are willing to pay by the hour. If the solution you develop works effectively, is well documented, well structured and highly maintainable then we will likely have a great deal of ongoing work available for you.

The source code is however our entire IP so you will not be able to download it to your own environment. You will instead be given Remote Desktop access to a server which contains the source code you'll work with and the development tools you'll need. You will only have keyboard and mouse access to the machine, you will not have any clipboard or mapped drive access in order to protect our IP. This matter is non-negotiable so please be aware of it upfront.

Additional Project Description:
01/09/2013 at 23:19 PET
Attaching a copy of the sample report. As you can see the report is very much just aggregated data which could easily be pre-calculated.

Hours of work: Unspecified Project Duration: 1 - 3 meses Skills required:
C# Programming, Java, MySQL, Pentaho
Additional Files: 9c25e848-9771-4e80-b421-38a2da07518e_10Jan2013151127.pdf
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.