Uploaded image for project: 'Pentaho Reporting and Pentaho Report Designer'
  1. Pentaho Reporting and Pentaho Report Designer
  2. PRD-2434

PRD will show only the one column if the same column is being queried in multiples of different aggregates.

    XMLWordPrintable

    Details

    • 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.
    • Operating System/s:
      Windows XP

      Description

      The following mql used in PRD 3.5 will only show one unaggregated date column for the max and min of "BC_DT_DATE_USAGE_DT_DATE"

      <?xml version="1.0" encoding="UTF-8"?>
      <mql><domain_id>Thinkronize</domain_id><model_id>Abc</model_id><options><disable_distinct>false</disable_distinct></options><selections><selection><view>Organization</view><column>BC_OR_ORGANIZATION_OR_NAME</column><aggregation>NONE</aggregation></selection><selection><view>User</view><column>BC_US_USER_US_USER_USERNAME</column><aggregation>NONE</aggregation></selection><selection><view>Usage</view><column>BC_UGF_USAGE_FACT_UGF_ID</column><aggregation>COUNT</aggregation></selection><selection><view>CT_USAGE_DATE_TIME</view><column>BC_DT_DATE_USAGE_DT_DATE</column><aggregation>MINIMUM</aggregation></selection><selection><view>CT_USAGE_DATE_TIME</view><column>BC_DT_DATE_USAGE_DT_DATE</column><aggregation>MAXIMUM</aggregation></selection></selections><constraints>
      <-CDATA[constraints.......... ]]->
      </constraints>
      <orders>
      <-CDATA[order.......... ]]->
      </orders></mql>

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              kcruzada Kurtis Cruzada (Inactive)
              Reporter:
              thinkronize-bi Chris
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: