Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = text

Hi Pentaho folks,

When I am teaching Pentaho to my students they always forget to put the primary key in the hierarchy and they error below will occur.

Like the example below:

Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while loading segment; sql=[select "dim_convenente"."convenente" as "c0", sum("fato_convenios_siconv"."m_valor_convenio") as "m0" from "dw"."dim_convenente" as "dim_convenente", "dw"."fato_convenios_siconv" as "fato_convenios_siconv" where "fato_convenios_siconv"."sk_convenente" = "dim_convenente"."convenente" group by "dim_convenente"."convenente"]
    at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:942)
    at mondrian.olap.Util.newInternal(Util.java:2261)
    at mondrian.olap.Util.newError(Util.java:2277)
    at mondrian.rolap.SqlStatement.handle(SqlStatement.java:336)
    at mondrian.rolap.SqlStatement.execute(SqlStatement.java:236)
    at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:318)
    at mondrian.rolap.agg.SegmentLoader.createExecuteSql(SegmentLoader.java:555)
    at mondrian.rolap.agg.SegmentLoader.loadImpl(SegmentLoader.java:187)
    at mondrian.rolap.agg.SegmentLoader.access$000(SegmentLoader.java:48)
    at mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:155)
    at mondrian.rolap.agg.SegmentLoader$SegmentLoadCommand.call(SegmentLoader.java:129)
    ... 5 more
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = text
  Dica: No operator matches the given name and argument type(s). You might need to add explicit type casts.
  Posição: 253
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2077)

How to solve it.

Put the primary key in the hierarchy.