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 | 1 year 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 | 1 year 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 | 1 year 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. 0

    JAXB Unmarshal List of Interfaces

    Stack Overflow | 11 months ago | billdoor
    java.lang.UnsupportedOperationException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JNDI DataSource on Tomcat 4.1.27

    Oracle Community | 1 decade ago | 843854
    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