Uploaded image for project: '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


    • 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.


      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



              • Assignee:
                jtcornelius Jake Cornelius
                jtcornelius Jake Cornelius
              • Votes:
                0 Vote for this issue
                2 Start watching this issue


                • Created: