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

• MONDRIAN-1047
• Mondrian Posting 2013 November
• MONDRIAN-1810

 
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:

• http://jira.pentaho.com/browse/MONDRIAN-661