Welcome to Knowage Q&A, where you can ask questions and receive answers from other members of the community.

Categories

Most popular tags

cockpit dataset error chart datasource installer datasets installation widget parameters business-model olap knowage knowage_7_1 integration login knowage_7_1-ce report-designer cross-navigation analyticaldriver

OLAP - An error ocurred when placing member on axis

0 votes
1 view

HI,

When I tryed to move the dimension "PROVINCIA" under the dimension "FECHA" I got the error "An error ocurred when placing member on axis".

 }

Log: 

Caused by: org.olap4j.OlapException: mondrian gave exception while parsing query at mondrian.olap4j.MondrianOlap4jConnection$Helper.createException(MondrianOlap4jConnection.java:858) at mondrian.olap4j.MondrianOlap4jStatement.parseQuery(MondrianOlap4jStatement.java:375) at mondrian.olap4j.MondrianOlap4jStatement.executeOlapQuery(MondrianOlap4jStatement.java:346) 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:Failed to parse query 'SELECT {[Measures].[TOTAL COBRADO]} ON COLUMNS, CrossJoin({[FECHA].[2018], [FECHA].[2018].[1], [FECHA].[2018].[2], [FECHA].[2018].[3], [FECHA].[2018].[4], [FECHA].[2018].[5], [FECHA].[2018].[6], [FECHA].[2018].[7], [FECHA].[2018].[8], [FECHA].[2018].[9], [FECHA].[2018].[10]}, {[PROVINCIA].[PROVINCIA]}) ON ROWS FROM [CUBO_COBROS]' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:977) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:101) at mondrian.olap4j.MondrianOlap4jStatement$1.execute(MondrianOlap4jStatement.java:362) at mondrian.olap4j.MondrianOlap4jStatement$1.execute(MondrianOlap4jStatement.java:360) at mondrian.server.Locus.execute(Locus.java:86) at mondrian.server.Locus.execute(Locus.java:71) at mondrian.olap4j.MondrianOlap4jStatement.parseQuery(MondrianOlap4jStatement.java:356) ... 48 more Caused by: mondrian.olap.MondrianException: Mondrian Error:No function matches signature '{<Level>}' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:974) at mondrian.olap.ValidatorImpl.getDef(ValidatorImpl.java:205) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:2027) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:2024) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:79) at mondrian.olap.QueryAxis.resolve(QueryAxis.java:214) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:140) at mondrian.olap.Query.resolve(Query.java:560) at mondrian.olap.Query.resolve(Query.java:447) at mondrian.olap.Query.<init>(Query.java:201) at mondrian.olap.Query.<init>(Query.java:162) at mondrian.olap.Parser$FactoryImpl.makeQuery(Parser.java:927) at mondrian.parser.MdxParserImpl.selectStatement(MdxParserImpl.java:1241) at mondrian.parser.MdxParserImpl.statement(MdxParserImpl.java:1074) at mondrian.parser.MdxParserImpl.statementEof(MdxParserImpl.java:188) at mondrian.parser.JavaccParserValidatorImpl.parseInternal(JavaccParserValidatorImpl.java:57) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:97) ... 53 more 

Could you please tell me what is wrong? What should I check? 

BR,

Environment Knowage 6.2-CE, Linux, Chrome
in OLAP and What-If by (390 points)

below you'll find the mondrian xml generated:

<?xml version="1.0" ?>

<SCHEMA name="intentos">

<Dimension name="FECHA" type="TimeDimension" visible="true" highCardinality="false">

<Hierarchy hasAll="false" allMemberName="FECHA" primaryKey="ID_FECHA" > 

<Table name="d_fecha"/>

<Level name="ANIO" column="ANIO" uniqueMembers="true" ordinalColumn="ANIO" datatype="Integer" levelType="TimeYears" visible="true"/>

<Level name="MES" column="MES" uniqueMembers="false" ordinalColumn="MES" datatype="Integer" levelType="TimeMonths"  visible="true"/>

<Level name="DIA" column="DIA" uniqueMembers="false" ordinalColumn="DIA" datatype="Integer" levelType="TimeDays" visible="true"/>

</Hierarchy>

</Dimension>

<Dimension name="PROVEEDOR">

<Hierarchy hasAll="true" allMemberName="PROVEEDOR" primaryKey="ID_PROVEEDOR" >

<Table name="d_proveedor"/>

<Level name="DESCRIPCION" column="DESCRIPCION" />

</Hierarchy>

</Dimension>

<Dimension name="SERVICIO">

<Hierarchy hasAll="true" allMemberName="SERVICIO" primaryKey="ID_SERVICIO" >

<Table name="d_servicio"/>

<Level name="ID_SERVICIO" column="ID_SERVICIO" />

</Hierarchy>

</Dimension>

<Dimension name="PRECIO">

<Hierarchy hasAll="true" allMemberName="PRECIO" primaryKey="PRECIO">

<Table name="d_precio"/>

<Level name="PRECIO" column="PRECIO" />

</Hierarchy>

</Dimension>

<Dimension name="FUNCION">

<Hierarchy hasAll="true" allMemberName="FUNCION" primaryKey="ID_FUNCION">

<Table name="d_funcion"/>

<Level name="FUNCION" column="FUNCION" />

</Hierarchy>

</Dimension>

<Dimension name="TASADOR">

<Hierarchy hasAll="true" allMemberName="TASADOR" primaryKey="ID_TASADOR">

<Table name="d_tasador"/>

<Level name="TASADOR" column="TASADOR" />

</Hierarchy>

</Dimension>

<Dimension name="ESTADO">

<Hierarchy hasAll="true" allMemberName="ESTADO" primaryKey="ID_ESTADO">

<Table name="d_estado"/>

<Level name="ESTADO" column="ESTADO" />

</Hierarchy>

</Dimension>

<Dimension name="PROVINCIA">

<Hierarchy hasAll="true" allMemberName="PROVINCIA" primaryKey="ID_PROVINCIA">

<Table name="d_provincia"/>

<Level name="PROVINCIA" column="PROVINCIA" />

</Hierarchy>

</Dimension>

<Cube name="CUBO_INTENTOS_COBRO">

<Table name="c_intentos_cobro"/>

<DimensionUsage name="FECHA" source="FECHA" foreignKey="ID_FECHA"/>

<DimensionUsage name="PROVEEDOR" source="PROVEEDOR" foreignKey="ID_PROVEEDOR"/>

<DimensionUsage name="SERVICIO" source="SERVICIO" foreignKey="ID_SERVICIO"/>

<DimensionUsage name="ESTADO" source="ESTADO" foreignKey="ID_ESTADO"/>

<DimensionUsage name="PROVINCIA" source="PROVINCIA" foreignKey="ID_PROVINCIA"/>

<Measure name="TOTAL COBRADO" column="TOTAL_COBRADO" aggregator="sum" datatype="Numeric" formatString="$#,###.00"/>

<Measure name="CANT COBROS" column="CANT_COBROS" aggregator="sum" datatype="Integer" formatString="#,###"/>

</Cube>

<Cube name="CUBO_COBROS">

<Table name="c_cobros"/>

<DimensionUsage name="FECHA" source="FECHA" foreignKey="ID_FECHA"/>

<DimensionUsage name="PROVEEDOR" source="PROVEEDOR" foreignKey="ID_PROVEEDOR"/>

<DimensionUsage name="SERVICIO" source="SERVICIO" foreignKey="ID_SERVICIO"/>

<DimensionUsage name="PROVINCIA" source="PROVINCIA" foreignKey="ID_PROVINCIA"/>

<Measure name="TOTAL COBRADO" column="TOTAL_COBRADO" aggregator="sum" datatype="Numeric" formatString="$#,###.00"/>

<Measure name="CANT COBROS" column="CANT_COBROS" aggregator="sum" datatype="Integer" formatString="#,###"/>

</Cube>

</SCHEMA>

by (390 points)
Hi Guido,

it seems like it's not finding the level PROVINCIA. Check carefully the names of the fields you are using to build that dimension: foreign key, table and column names.

do you have access to log file?

I ask you, does it happen only with PROVICIA dimension?

Regards,

Nunzia
by (3.1k points)

Please log in or register to answer this question.

Powered by Question2Answer
...