mondrian - Virtual cube

[disorder]

Hi, has somebody exprerience with VirtualCubes? I have 3 cubes each has different fact table, and i need combine measures and dimensions from these cubes. When I select only one measure from this Virtual cube everythings works fine, but when I'll select more measures, each from other cube I get exception:

Code:

Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[Profitabilita2], [Measures].[Profitabilita1]} ON COLUMNS,
  Hierarchize(Union({[Account officers].[All Account officers]}, [Account officers].[All Account officers].Children)) ON ROWS
from [ZustatkyAll]
]
	at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1035)
	at mondrian.olap.Util.newInternal(Util.java:914)
	at mondrian.olap.Util.newError(Util.java:930)
	at mondrian.rolap.RolapConnection.execute(RolapConnection.java:353)
	at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:186)
	... 81 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: assert failed
	at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1032)
	at mondrian.olap.Util.newInternal(Util.java:907)
	at mondrian.olap.Util.assertTrue(Util.java:888)
	at mondrian.rolap.agg.SegmentArrayQuerySpec.addMeasure(SegmentArrayQuerySpec.java:105)
	at mondrian.rolap.agg.AbstractQuerySpec.nonDistinctGenerateSQL(AbstractQuerySpec.java:90)
	at mondrian.rolap.agg.SegmentArrayQuerySpec.generateSqlQuery(SegmentArrayQuerySpec.java:84)
	at mondrian.rolap.agg.AggregationManager.generateSql(AggregationManager.java:198)
	at mondrian.rolap.agg.Segment.load(Segment.java:251)
	at mondrian.rolap.agg.Aggregation.load(Aggregation.java:130)
	at mondrian.rolap.agg.AggregationManager.loadAggregation(AggregationManager.java:71)
	at mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:292)
	at mondrian.rolap.FastBatchingCellReader.loadAggregations(FastBatchingCellReader.java:157)
	at mondrian.rolap.RolapResult.executeBody(RolapResult.java:239)
	at mondrian.rolap.RolapResult.<init>(RolapResult.java:157)
	at mondrian.rolap.RolapConnection.execute(RolapConnection.java:330)
	... 82 more

 

Must be fulfilled some rule between Cubes for creating Virtual cube from them?What asserts mondrian in virtual cube?

I didn't find anything in the documentation about this :-

 

thx

 

dis.

Post edited by: disorder, at: 2006/11/23 10:17