View source | Discuss this page | Page history | Printable version   

Modules:Analytics Limitations

Limitations

Mondrian Exception 'pos 64 exceeds capacity 64'

When Saiku does not show any cubes and you see an error like shown below in the log then one of the cubes has too many dimensions, combined with closure tables. Closure tables are used automatically by OB when mapping tree-based entities for example organisation or business partner category.

The only work around is to remove several dimensions from the large cube, i.e. split the large cube in multiple smaller cubes.

See also these links

 
Caused by: java.lang.RuntimeException: java.lang.IllegalArgumentException: pos 64 exceeds capacity 64
	at org.openbravo.client.analytics.MondrianProvider.getOlapConnection(MondrianProvider.java:178)
	at org.openbravo.client.analytics.OBSaikuOlapConnection.connect(OBSaikuOlapConnection.java:42)
	at org.openbravo.client.analytics.OBSaikuConnectionManager.connect(OBSaikuConnectionManager.java:104)

Closure/parent-child not supported in snow-flake

Closure/parent-child relations are not supported correctly in case of snowflake schemas. Note in general snow-flake mappings should be avoided when possible as they result in less performant database queries (many joins).

See here for more information on snowflake schemas.

Also this issue is a blocker for some of the Mondrian snowflake mappings:

Retrieved from "http://wiki.openbravo.com/wiki/Modules:Analytics_Limitations"

This page has been accessed 2,681 times. This page was last modified on 23 April 2014, at 13:34. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.