When trying to create a generic document OLAP, by loading a mondrian cube.
The error is shown create
"org.pivot4j.PiviotException:
org.olap4j.OlapException: mondrian gave exception while executing query"
possible error is in cube in query MDX that displays the log:
it.eng.spagobi.utilities.engines.SpagoBIEngineRuntimeException:
Error while executing MDX statement: Nome de objeto 'dbo.FatoSolitacaoQuantidade' inválido.
Caused by: org.pivot4j.PivotException: org.olap4j.OlapException: mondrian gave exception while executing query
at org.pivot4j.impl.PivotModelImpl.getCellSet(PivotModelImpl.java:598)
at it.eng.spagobi.engines.whatif.model.SpagoBIPivotModel.getCellSet(SpagoBIPivotModel.java:145)
at it.eng.spagobi.engines.whatif.WhatIfEngineInstance.updateWhatIfEngineInstance(WhatIfEngineInstance.java:228)
... 43 more
Caused by: org.olap4j.OlapException: mondrian gave exception while executing query
at mondrian.olap4j.MondrianOlap4jConnection$Helper.createException(MondrianOlap4jConnection.java:858)
at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQueryInternal(MondrianOlap4jStatement.java:423)
at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQuery(MondrianOlap4jStatement.java:347)
at org.pivot4j.impl.PivotModelImpl.executeMdx(PivotModelImpl.java:646)
at org.pivot4j.impl.PivotModelImpl.getCellSet(PivotModelImpl.java:596)
... 45 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while executing query [select {[Measures].[Quantidade]} ON COLUMNS,
{[TipoSolicitacao]} ON ROWS
from [UniSolicitacao]
]
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select sum("FatoSolitacaoQuantidade"."Quantidade") as "m0" from "dbo"."FatoSolitacaoQuantidade" as "FatoSolitacaoQuantidade"]
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:977)
at mondrian.olap.Util.newInternal(Util.java:2404)
at mondrian.olap.Util.newError(Util.java:2420)
at mondrian.rolap.SqlStatement.handle(SqlStatement.java:361)
at mondrian.rolap.SqlStatement.execute(SqlStatement.java:252)
at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:350)
at mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:625)
... 8 more"
Help me please
