Uploaded image for project: 'Pentaho Analysis - Mondrian'
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-941

Error for boolean member names

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Cannot Reproduce
    • Affects Version/s: 3.2.0 GA (3.6.0 GA Suite Release), 3.2.1 GA (3.7.0 GA Suite Release), 3.2.2 GA (3.8.0 GA Suite Release), 3.3.0 GA (4.1.0 GA Suite Release)
    • Fix Version/s: Backlog
    • Component/s: None
    • Labels:
      None
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      this happens in olap4j when i try to do cube.lookupMember(...)

      Caused by: org.olap4j.OlapException: Unable to find a member with name [[Has coffee bar], [1]]

      The above is an example from foodmart + MondrianOlap4j
      I'm using the lookup method to find specific members: Member lookupMember(List<IdentifierSegment> nameParts) throws OlapException;
      For some reason this doesn't work for that member and I think thats related to the name being 1 / 0
      Not sure why this is happening... The member is definitely there!

      In another query where the members of that dimension are included i also get the following exception (HSQLD + foodmart) thats why i think its related!?:

      java.lang.NumberFormatException: Illegal BOOLEAN literal: 0
      at mondrian.spi.impl.JdbcDialectImpl.quoteBooleanLiteral(JdbcDialectImpl.java:371)
      at mondrian.spi.Dialect$Datatype$4.quoteValue(Dialect.java:810)
      at mondrian.spi.impl.JdbcDialectImpl.quote(JdbcDialectImpl.java:665)
      at mondrian.rolap.agg.ValueColumnPredicate.toSql(ValueColumnPredicate.java:165)
      at mondrian.rolap.RolapStar$Column.createInExpr(RolapStar.java:1340)
      at mondrian.rolap.agg.AbstractQuerySpec.nonDistinctGenerateSql(AbstractQuerySpec.java:102)
      at mondrian.rolap.agg.DrillThroughQuerySpec.generateSqlQuery(DrillThroughQuerySpec.java:132)
      at mondrian.rolap.agg.AggregationManager.getDrillThroughSql(AggregationManager.java:132)
      at mondrian.rolap.RolapCell.getDrillThroughSQL(RolapCell.java:101)
      at mondrian.rolap.RolapCell.drillThroughInternal(RolapCell.java:289)
      at mondrian.olap4j.MondrianOlap4jCell.drillThroughInternal(MondrianOlap4jCell.java:156)
      at mondrian.olap4j.MondrianOlap4jStatement.executeQuery2(MondrianOlap4jStatement.java:89)

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            pstoellberger Paul Stoellberger
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: