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
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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]'

    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