[Mondrian] Querying non-SQL multidimensional store

Julian Hyde jhyde at pentaho.com
Tue Nov 13 12:55:46 EST 2012

I suggest that you populate a single table in an embedded or embeddable database like hsqldb or MonetDB. Mondrian will talk to it via SQL but because it is embedded you don't need to worry about it. Pentaho Instaview works in this way (using MonetDB).


On Nov 11, 2012, at 1:09 PM, Radek Maciaszek <radek.maciaszek at gmail.com<mailto:radek.maciaszek at gmail.com>> wrote:


I am trying to figure out how I can make my object database work with Mondrian. Is there any way to make Mondrian work with a non-SQL storage? I have a data store with multidimensional arrays, which I would like to expose to Mondrian. My arrays are rather small so I can load them into memory - perhaps it would be possible to somehow popular the Mondrian cache with them within my Dialect implementation? This way Mondrian would never have to issue any SQL queries as all data would be loaded into the cache. Any ideas are appreciated.

Mondrian mailing list
Mondrian at pentaho.org<mailto:Mondrian at pentaho.org>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20121113/08fafb30/attachment.html 

More information about the Mondrian mailing list