Pentaho Analysis - Mondrian
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-458

error deducing type of Ytd/Qtd/Mtd functions within Generate

    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

      Ran into parser errors when using these functions:


      select generate({[Time].[1997].[Q4].[11]}, {Ytd( [Time].currentMember)}) on rows from [Sales];
      select generate({[Time].[1997].[Q4].[11]}, {Qtd( [Time].currentMember)}) on rows from [Sales];
      select generate({[Time].[1997].[Q4].[11]}, {Mtd( [Time].currentMember)}) on rows from [Sales];

      however, the equivalent PeriodsToDate function works:

      select generate({[Time].[1997].[Q4].[11]}, {PeriodsToDate([Time].[Year], [Time].currentMember)}) on rows from [Sales];
      select generate({[Time].[1997].[Q4].[11]}, {PeriodsToDate([Time].[Quarter], [Time].currentMember)}) on rows from [Sales];
      select generate({[Time].[1997].[Q4].[11]}, {PeriodsToDate([Time].[Month], [Time].currentMember)}) on rows from [Sales];

        Activity

        Hide
        Mondrian Importer User added a comment -
        {ruchen}, 10/07/2008: IP, Artifact Created: 71.6.42.5 |
        {jhyde}, 10/07/2008: IP, Comment Added: 66.92.12.96 |
        {jhyde}, 10/07/2008: status_id, 1 |
        {jhyde}, 10/07/2008: resolution_id, 100 |
        {jhyde}, 10/07/2008: assigned_to, 100 |
        {jhyde}, 10/07/2008: summary, parser error when using Ytd/Qtd/Mtd functions |
        {jhyde}, 10/07/2008: close_date, 0
        Show
        Mondrian Importer User added a comment - {ruchen}, 10/07/2008: IP, Artifact Created: 71.6.42.5 | {jhyde}, 10/07/2008: IP, Comment Added: 66.92.12.96 | {jhyde}, 10/07/2008: status_id, 1 | {jhyde}, 10/07/2008: resolution_id, 100 | {jhyde}, 10/07/2008: assigned_to, 100 | {jhyde}, 10/07/2008: summary, parser error when using Ytd/Qtd/Mtd functions | {jhyde}, 10/07/2008: close_date, 0
        Hide
        Mondrian Importer User added a comment -
        {jhyde}, 10/07/2008: Generate was assuming that the type returned by Ytd had a hierarchy, whereas in this case it validly only had a dimension.

        Changed summary, was "parser error when using Ytd/Qtd/Mtd functions".

        Fixed in change 11679, will be in mondrian-3.1.
        Show
        Mondrian Importer User added a comment - {jhyde}, 10/07/2008: Generate was assuming that the type returned by Ytd had a hierarchy, whereas in this case it validly only had a dimension. Changed summary, was "parser error when using Ytd/Qtd/Mtd functions". Fixed in change 11679, will be in mondrian-3.1.

          People

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

            Dates

            • Created:
              Updated:
              Resolved: