Free OLAP Development

Not related to a specific OLAP tool. (Includes forum policies and rules).
Post Reply
alevisen
Posts: 1
Joined: Mon Jun 01, 2009 11:26 am
Version: 9.1 sp3
Excel Version: 2003

Free OLAP Development

Post by alevisen »

I'd like to know if there exists a free tool for cube development that can connect to an Oracle 11g database. Thanks.
User avatar
Michel Zijlema
Site Admin
Posts: 712
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands
Contact:

Re: Free OLAP Development

Post by Michel Zijlema »

alevisen wrote:I'd like to know if there exists a free tool for cube development that can connect to an Oracle 11g database. Thanks.
PALO is an open source OLAP tool from Jedox. You can use their ETL Server to connect (through ODBC) to Oracle 11g. You could also use the freeware IMP:PALO tool to connect (through ODBC) to Oracle and load into PALO.

Michel
Marcus Scherer
Community Contributor
Posts: 126
Joined: Sun Jun 29, 2008 9:33 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016
Location: Karlsruhe

Re: Free OLAP Development

Post by Marcus Scherer »

You could use Pentaho Mondrian,
it's a different concept. The data storage takes place in the relational database. Mondrian has no storage of its own. Thus the cube is a virtual one. It uses the RDBMS aggregator (GROUP BY) for aggregating and materialized views of the relational database. You can base it on an existing dimensional model. It is queried with MDX. But there is no writeback.

http://mondrian.pentaho.org/documentati ... ecture.php

Regards,

Marcus
Post Reply