Jump to content
Changes to the Jaspersoft community edition download ×

mondrian - Virtual cube


Recommended Posts

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:


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 :-





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

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...