mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'WITH SET [Markets] as '{[Markets].[All Markets]}' MEMBER [Measures].[Invalid] as '(0/0)' select {[Measures].[Invalid]} ON COLUMNS, {[Markets]} ON ROWS from [SteelWheelsSales]'

Pentaho BI Platform Tracking | Pedro Vale | 2 years ago
  1. 0

    Using Mondrian 3.10-SNAPSHOT, the following query works: WITH SET [Markets] as '{[Markets].[All Markets]}' MEMBER [Measures].[Invalid] as '(0/0)' select {[Measures].[Invalid]} ON COLUMNS, {[Markets]} ON ROWS from [SteelWheelsSales] Using Mondrian 3.11-SNAPSHOT, it does not. It throws the following: mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'WITH SET [Markets] as '{[Markets].[All Markets]}' MEMBER [Measures].[Invalid] as '(0/0)' select {[Measures].[Invalid]} ON COLUMNS, {[Markets]} ON ROWS from [SteelWheelsSales]' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:977) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:101) at mondrian.rolap.RolapConnection.parseStatement(RolapConnection.java:760) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:56) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:444) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:145) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.BandedMDXDataFactory.queryData(BandedMDXDataFactory.java:54) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:135) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:85) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:434) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryData(CachingDataFactory.java:326) at pt.webdetails.cda.dataaccess.PREDataAccess.performRawQuery(PREDataAccess.java:127) Caused by: java.lang.UnsupportedOperationException at mondrian.mdx.UnresolvedFunCall.getType(UnresolvedFunCall.java:82) at mondrian.olap.SetBase.getType(SetBase.java:140) at mondrian.mdx.NamedSetExpr.getType(NamedSetExpr.java:123) at mondrian.olap.ValidatorImpl.canConvert(ValidatorImpl.java:253) at mondrian.olap.fun.SetFunDef$ResolverImpl.resolve(SetFunDef.java:428) at mondrian.olap.ValidatorImpl.getDef(ValidatorImpl.java:190) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:2027) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:83)

    Pentaho BI Platform Tracking | 2 years ago | Pedro Vale
    mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'WITH SET [Markets] as '{[Markets].[All Markets]}' MEMBER [Measures].[Invalid] as '(0/0)' select {[Measures].[Invalid]} ON COLUMNS, {[Markets]} ON ROWS from [SteelWheelsSales]'
  2. 0

    Using Mondrian 3.10-SNAPSHOT, the following query works: WITH SET [Markets] as '{[Markets].[All Markets]}' MEMBER [Measures].[Invalid] as '(0/0)' select {[Measures].[Invalid]} ON COLUMNS, {[Markets]} ON ROWS from [SteelWheelsSales] Using Mondrian 3.11-SNAPSHOT, it does not. It throws the following: mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'WITH SET [Markets] as '{[Markets].[All Markets]}' MEMBER [Measures].[Invalid] as '(0/0)' select {[Measures].[Invalid]} ON COLUMNS, {[Markets]} ON ROWS from [SteelWheelsSales]' at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:977) at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:101) at mondrian.rolap.RolapConnection.parseStatement(RolapConnection.java:760) at mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:56) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractMDXDataFactory.performQuery(AbstractMDXDataFactory.java:444) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.AbstractNamedMDXDataFactory.performQuery(AbstractNamedMDXDataFactory.java:145) at org.pentaho.reporting.engine.classic.extensions.datasources.mondrian.BandedMDXDataFactory.queryData(BandedMDXDataFactory.java:54) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:135) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:85) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:434) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryData(CachingDataFactory.java:326) at pt.webdetails.cda.dataaccess.PREDataAccess.performRawQuery(PREDataAccess.java:127) Caused by: java.lang.UnsupportedOperationException at mondrian.mdx.UnresolvedFunCall.getType(UnresolvedFunCall.java:82) at mondrian.olap.SetBase.getType(SetBase.java:140) at mondrian.mdx.NamedSetExpr.getType(NamedSetExpr.java:123) at mondrian.olap.ValidatorImpl.canConvert(ValidatorImpl.java:253) at mondrian.olap.fun.SetFunDef$ResolverImpl.resolve(SetFunDef.java:428) at mondrian.olap.ValidatorImpl.getDef(ValidatorImpl.java:190) at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:2027) at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102) at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:83)

    Pentaho BI Platform Tracking | 2 years ago | Pedro Vale
    mondrian.olap.MondrianException: Mondrian Error:Failed to parse query 'WITH SET [Markets] as '{[Markets].[All Markets]}' MEMBER [Measures].[Invalid] as '(0/0)' select {[Measures].[Invalid]} ON COLUMNS, {[Markets]} ON ROWS from [SteelWheelsSales]'
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    GitHub comment 3827#150987504

    GitHub | 1 year ago | Cidan
    java.lang.UnsupportedOperationException
  5. 0

    PCA throws exception no matter what

    GitHub | 1 year ago | TShockman
    java.lang.UnsupportedOperationException

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.lang.UnsupportedOperationException

      No message provided

      at mondrian.mdx.UnresolvedFunCall.getType()
    2. mondrian.mdx
      UnresolvedFunCall.getType
      1. mondrian.mdx.UnresolvedFunCall.getType(UnresolvedFunCall.java:82)
      1 frame
    3. mondrian.olap
      SetBase.getType
      1. mondrian.olap.SetBase.getType(SetBase.java:140)
      1 frame
    4. mondrian.mdx
      NamedSetExpr.getType
      1. mondrian.mdx.NamedSetExpr.getType(NamedSetExpr.java:123)
      1 frame
    5. mondrian.olap
      ValidatorImpl.canConvert
      1. mondrian.olap.ValidatorImpl.canConvert(ValidatorImpl.java:253)
      1 frame
    6. mondrian.olap.fun
      SetFunDef$ResolverImpl.resolve
      1. mondrian.olap.fun.SetFunDef$ResolverImpl.resolve(SetFunDef.java:428)
      1 frame
    7. mondrian.olap
      ValidatorImpl.getDef
      1. mondrian.olap.ValidatorImpl.getDef(ValidatorImpl.java:190)
      1 frame
    8. mondrian.olap.fun
      FunUtil.resolveFunArgs
      1. mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:2027)
      1 frame
    9. mondrian.mdx
      UnresolvedFunCall.accept
      1. mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:102)
      1 frame
    10. mondrian.olap
      ValidatorImpl.validate
      1. mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:83)
      1 frame