Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Severe Severe
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • 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

      The following MDX raises an Error:
      with member [Measures].[USales] as '[Measures].[Unit
      Sales]',
      format_string =
      iif([Measures].[Sales Count] > 100, "#.00 good","#.00
      bad")
      select

      {[Measures].[USales] , [Measures].[Store Cost], [Measures].[Store Sales]} ON columns,
      Crossjoin({[Promotion Media].[All Media].[Radio], [Promotion Media].[All Media].[TV], [Promotion Media]. [All Media].[Sunday Paper], [Promotion Media].[All Media].[Street Handout]}, [Product].[All Products].
      [Drink].Children) ON rows
      from [Sales]
      where ([Time].[1997])

      Java:
      "with member [Measures].[USales] as '[Measures].[Unit
      Sales]',"
      +"format_string ="
      +"iif([Measures].[Sales Count] > 100, \"#.00 good\",
      \"#.00 bad\") "
      +"select {[Measures].[USales] , [Measures].[Store Cost], [Measures].[Store Sales]}

      ON columns,"
      +" Crossjoin(

      {[Promotion Media].[All Media].[Radio], [Promotion Media].[All Media].[TV], [Promotion Media]. [All Media].[Sunday Paper], [Promotion Media].[All Media].[Street Handout]}

      , [Product].[All Products].
      [Drink].Children) ON rows"
      +" from [Sales]"
      +" where ([Time].[1997])"

      the problem is triggered by the fact, that ([Measures].
      [Sales Count] is used only within the "iif".
      If it is added to the axis, the query works fine.

      the call stack is:
      mondrian.resource.ChainableRuntimeException: Internal
      error: not found
      at
      mondrian.olap.MondrianResource.newInternal
      (MondrianResource.java:42)
      at
      mondrian.rolap.agg.AggregationManager.getCellFromCac
      he(AggregationManager.java:157)
      at
      mondrian.rolap.RolapAggregationManager.getCellFromC
      ache(RolapAggregationManager.java:130)
      at
      mondrian.rolap.RolapResult$AggregatingCellReader.get
      (RolapResult.java:295)
      at
      mondrian.rolap.RolapEvaluator.evaluateCurrent
      (RolapEvaluator.java:166)
      at
      mondrian.rolap.RolapMember.evaluateScalar
      (RolapMember.java:105)
      at
      mondrian.olap.fun.BuiltinFunTable$42.evaluate
      (BuiltinFunTable.java:1492)
      at mondrian.rolap.RolapEvaluator.xx
      (RolapEvaluator.java:116)
      at mondrian.olap.FunCall.evaluate
      (FunCall.java:244)
      at mondrian.olap.ExpBase.evaluateScalar
      (ExpBase.java:158)
      at mondrian.olap.fun.FunUtil.getDoubleArg
      (FunUtil.java:126)
      at
      mondrian.olap.fun.BuiltinFunTable$108.evaluate
      (BuiltinFunTable.java:3461)
      at mondrian.rolap.RolapEvaluator.xx
      (RolapEvaluator.java:116)
      at mondrian.olap.FunCall.evaluate
      (FunCall.java:244)
      at mondrian.olap.fun.FunUtil.getArg
      (FunUtil.java:53)
      at mondrian.olap.fun.FunUtil.getArg
      (FunUtil.java:44)
      at mondrian.olap.fun.FunUtil.getBooleanArg
      (FunUtil.java:94)
      at
      mondrian.olap.fun.BuiltinFunTable$75.evaluate
      (BuiltinFunTable.java:2766)
      at mondrian.rolap.RolapEvaluator.xx
      (RolapEvaluator.java:116)
      at mondrian.olap.FunCall.evaluate
      (FunCall.java:244)
      at
      mondrian.rolap.RolapEvaluator.getFormatString
      (RolapEvaluator.java:227)
      at mondrian.rolap.RolapEvaluator.getFormat
      (RolapEvaluator.java:232)
      at mondrian.rolap.RolapEvaluator.format
      (RolapEvaluator.java:251)
      at
      mondrian.rolap.RolapCell.computeFormattedValue
      (RolapResult.java:393)
      at mondrian.rolap.RolapCell.<init>
      (RolapResult.java:389)
      at mondrian.rolap.RolapResult.getCell
      (RolapResult.java:139)
      at
      com.tonbeller.jpivot.mondrian.MondrianResult.initData
      (MondrianResult.java:106)
      at
      com.tonbeller.jpivot.mondrian.MondrianResult.executeQu
      ery(MondrianResult.java:49)
      at
      com.tonbeller.jpivot.mondrian.MondrianModel.getResult
      (MondrianModel.java:122)
      at com.tonbeller.jpivot.mondrian.HHTest.main
      (HHTest.java:167)

        Activity

        Hide
        Mondrian Importer User added a comment -
        {jhyde}, 02/14/2003: status_id, 1 | {jhyde}

        , 02/14/2003: resolution_id, 100 |

        {jhyde}, 02/14/2003: assigned_to, 100 | {jhyde}

        , 02/14/2003: close_date, 0

        Show
        Mondrian Importer User added a comment - {jhyde}, 02/14/2003: status_id, 1 | {jhyde} , 02/14/2003: resolution_id, 100 | {jhyde}, 02/14/2003: assigned_to, 100 | {jhyde} , 02/14/2003: close_date, 0
        Hide
        Mondrian Importer User added a comment -
        {jhyde}

        , 02/14/2003: Logged In: YES
        user_id=312935

        Fixed in change 300.

        Show
        Mondrian Importer User added a comment - {jhyde} , 02/14/2003: Logged In: YES user_id=312935 Fixed in change 300.

          People

          • Assignee:
            Julian Hyde
            Reporter:
            hhaas
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: