search

mysticfall / pivot4j

Pivot4J provides a common API for OLAP servers which can be used to build an analytical service frontend with pivot style GUI.
Other
128 stars 101 forks source link

Drillthrough not working for ragged cubes #127

Closed mysticfall closed 10 years ago

mysticfall commented 10 years ago

Drillthrough does not work properly when the cube contains ragged hierarchies.

Caused by: mondrian.olap.MondrianException: Mondrian Error:MDX object '[Geography].[Israel].[Israel].[Haifa]' not found in cube 'Sales Ragged'
    at mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:989) ~[mondrian-3.6.2.jar:?]
    at mondrian.olap.Util.lookup(Util.java:1024) ~[mondrian-3.6.2.jar:3.6.2]
    at mondrian.olap.Id.accept(Id.java:110) ~[mondrian-3.6.2.jar:3.6.2]
    at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79) ~[mondrian-3.6.2.jar:3.6.2]
    at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:2020) ~[mondrian-3.6.2.jar:?]
    at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102) ~[mondrian-3.6.2.jar:?]
    at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79) ~[mondrian-3.6.2.jar:3.6.2]
    at mondrian.olap.QueryAxis.resolve(QueryAxis.java:213) ~[mondrian-3.6.2.jar:3.6.2]
    at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:140) ~[mondrian-3.6.2.jar:3.6.2]
    at mondrian.olap.Query.resolve(Query.java:559) ~[mondrian-3.6.2.jar:3.6.2]
    at mondrian.olap.Query.resolve(Query.java:446) ~[mondrian-3.6.2.jar:3.6.2]
    at mondrian.olap.Query.<init>(Query.java:200) ~[mondrian-3.6.2.jar:3.6.2]
    at mondrian.olap.Query.<init>(Query.java:161) ~[mondrian-3.6.2.jar:3.6.2]
    at mondrian.olap.Parser$FactoryImpl.makeQuery(Parser.java:927) ~[mondrian-3.6.2.jar:3.6.2]
    at mondrian.parser.MdxParserImpl.selectStatement(MdxParserImpl.java:1241) ~[mondrian-3.6.2.jar:?]
    at mondrian.parser.MdxParserImpl.drillthroughStatement(MdxParserImpl.java:1488) ~[mondrian-3.6.2.jar:?]
    at mondrian.parser.MdxParserImpl.statement(MdxParserImpl.java:1077) ~[mondrian-3.6.2.jar:?]
    at mondrian.parser.MdxParserImpl.statementEof(MdxParserImpl.java:188) ~[mondrian-3.6.2.jar:?]
    at mondrian.parser.JavaccParserValidatorImpl.parseInternal(JavaccParserValidatorImpl.java:57) ~[mondrian-3.6.2.jar:?]
    at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:96) ~[mondrian-3.6.2.jar:3.6.2]
    at mondrian.rolap.RolapConnection.parseStatement(RolapConnection.java:759) ~[mondrian-3.6.2.jar:?]
    at mondrian.olap4j.MondrianOlap4jStatement.executeQuery2(MondrianOlap4jStatement.java:81) ~[mondrian-3.6.2.jar:?]
    at mondrian.olap4j.MondrianOlap4jStatement.executeQuery(MondrianOlap4jStatement.java:65) ~[mondrian-3.6.2.jar:?]
    at org.pivot4j.transform.impl.DrillThroughImpl.performDrillThroughMdx(DrillThroughImpl.java:176) ~[pivot4j-core-0.9-SNAPSHOT.jar:0.9-SNAPSHOT]
    ... 48 more