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

Improve metadata query (TupleReader) support for aggregation tables to include dimensions defining more than one column

    Details

      Description

      Currently the tuple reader will only resolve aggregate tables only if the column attribute is the only one set. Setting other column attributes like the ordinal and name will cause it to go back to the fact table.

      Comment from code:
      // determine if any collapsed levels contain more than one column, if
      // so, the aggStar is not compatible.
      //
      // In the future, this feature could be improved by:
      // 1. changing the sql generation to join the collapsed level to its
      // dimension table(s) to select the additional columns.
      // 2. Create members that are missing these values and populate the
      // values at a later time.
      // 3. extend agg tables to support additional level columns

        Issue Links

          Activity

          Hide
          Will Gorman added a comment -
          This feature was committed in change #13241 for 3.1 and 13243 for trunk
          Show
          Will Gorman added a comment - This feature was committed in change #13241 for 3.1 and 13243 for trunk

            People

            • Assignee:
              Jake Cornelius
              Reporter:
              Jake Cornelius
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: