Category: | Bug report |
Priority: | Normal |
Status: | New |
Project: | Severity: | Minor |
Resolution: | Open |
|
Component: | Reproducibility: | Always |
Assigned to: |
I am also Facing one Problem
The demo.xml is
<?xml version="1.0"?>
<Schema name="SudeepSchema">
<Cube name="DivyaCubeReal">
<Table name="StateWiseZone"/>
<Dimension name="State">
<Hierarchy hasAll="true" allMemberName="All State">
<Level name="State" column="state" uniqueMembers="true"/>
</Hierarchy>
</Dimension>
<Dimension name="Zone">
<Hierarchy hasAll="true" allMemberName="All Zone">
<Level name="Zone" column="zone" uniqueMembers="true"/>
</Hierarchy>
</Dimension>
<Dimension name="type">
<Hierarchy hasAll="true" allMemberName="All Type">
<Level name="Type" column="type" uniqueMembers="true"/>
</Hierarchy>
</Dimension>
<Measure name="Total Count" column="type" aggregator="count" formatString="Standard"/>
</Cube>
</Schema>
and the Query is SELECT {
([type])
} ON COLUMNS,
{
([Zone].[All Zone],[State].[All State])
} ON ROWS
FROM [DivyaCubeReal]
The Report gets generated ,but When I expand All State colum I am getting this error below :
Caused by: com.tonbeller.jpivot.olap.model.OlapException: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[type].[All Type]} ON COLUMNS,
Hierarchize(Union(Crossjoin({[Zone].[All Zone]}, {[State].[All State]}), Crossjoin({[Zone].[All Zone]}, [State].[All State].Children))) ON ROWS
from [DivyaCubeReal]
]
at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:305)
at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54)
at com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapModel.java:48)
at com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDecorator.java:54)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at javax.el.BeanELResolver.getValue(BeanELResolver.java:87)
... 110 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[type].[All Type]} ON COLUMNS,
Hierarchize(Union(Crossjoin({[Zone].[All Zone]}, {[State].[All State]}), Crossjoin({[Zone].[All Zone]}, [State].[All State].Children))) ON ROWS
from [DivyaCubeReal]
]
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785)
at mondrian.olap.Util.newInternal(Util.java:1340)
at mondrian.olap.Util.newError(Util.java:1356)
at mondrian.rolap.RolapConnection.execute(RolapConnection.java:471)
at com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java:279)
... 118 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: assert failed
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:782)
at mondrian.olap.Util.newInternal(Util.java:1333)
at mondrian.olap.Util.assertTrue(Util.java:1314)
at mondrian.olap.fun.FunUtil$HierarchizeArrayComparator.compare(FunUtil.java:2144)
at mondrian.olap.fun.FunUtil$HierarchizeArrayComparator.compare(FunUtil.java:2126)
at mondrian.olap.fun.FunUtil$LoggingTupleComparator.compare(FunUtil.java:2008)
at mondrian.olap.fun.FunUtil$LoggingTupleComparator.compare(FunUtil.java:1984)
at java.util.TimSort.countRunAndMakeAscending(Unknown Source)
at java.util.TimSort.sort(Unknown Source)
at java.util.TimSort.sort(Unknown Source)
at java.util.Arrays.sort(Unknown Source)
at java.util.Collections.sort(Unknown Source)
at mondrian.olap.fun.FunUtil.hierarchize(FunUtil.java:536)
at mondrian.olap.fun.HierarchizeFunDef$1.evaluateList(HierarchizeFunDef.java:49)
at mondrian.calc.impl.AbstractListCalc.evaluate(AbstractListCalc.java:67)
at mondrian.rolap.RolapResult.executeAxis(RolapResult.java:696)
at mondrian.rolap.RolapResult.evalLoad(RolapResult.java:559)
at mondrian.rolap.RolapResult.loadMembers(RolapResult.java:534)
at mondrian.rolap.RolapResult.<init>(RolapResult.java:256)
at mondrian.rolap.RolapConnection.execute(RolapConnection.java:443)
... 119 more
Any idea why this error is coming. I feel that the mdx query is not getting executed and I am missing some join or connection b/w 2 tables.
1 Comment:
I am new to this arena too... BI reports run smoothly when the data is denormalized. Create a view which is a resultset of 2 tables. Before executing MDX query, execute the MDX in OLAP work bench. You will get an abstract idea of your report... Alternate is change your olap setting, http://localhost:8080/jasperserver/olap/properties.html.