[Mondrian] Mondrian System Limitations

Julian Hyde jhyde at pentaho.com
Tue Nov 27 21:09:34 EST 2012

There are no hard limits to the number of cubes, dimensions, hierarchies, members etc., other than available memory and maybe the size of a Java list or array (2 ^ 31). Obviously nothing is for free, so all else being equal, a large schema will be slower than a small one. But Mondrian is designed to degrade gracefully.


On Nov 27, 2012, at 10:42 AM, Taylor Curro <patriotsfan1236 at gmail.com<mailto:patriotsfan1236 at gmail.com>> wrote:

Good Afternoon Julian-

I was wondering if you could answer a quick thought I have been trying to figure out.  I saw online a comparison of OLAP servers and some of the servers list out their system limits (number of cubes, measures, dimensions, hierarchies in dimension, levels in hierarchy, and dimension members) and could not seem to find any information regarding the Mondrian OLAP server.

I have been focusing primarily on the system limits for the number of measures and dimensions (though I am trying to figure out all areas listed above), since cubes could be scaled-out since they do not interact with each other (correct me if I'm wrong).  I am trying to see how complex the data can be when it comes to dimensions and cardinality to prevent scale problems.  I was wondering if you could provide any guidance/insight into this topic?  I would greatly appreciate it.

Thank you,

patriotsfan1236 at gmail.com<mailto:patriotsfan1236 at gmail.com>
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/20121127/9b4f4fae/attachment.html 

More information about the Mondrian mailing list