Uploaded image for project: 'Pentaho Analysis - Mondrian'
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-355

adding hours/mins as levelType for level of type Dimension

    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.
    • Closer:
      nobody

      Description

      Could be useful to add levelType for hours and minutes
      to the Dimension of type TimeDimension, and to control a way to aggregate minutes level into a quarter of an hour (15 min) or whatelse minutes aggregation, depending on project requirements.
      Here is an example of what could be a partial schema declaration for the time Dimension :

      <Dimension name="Time" foreignKey="TIME_ID" type="TimeDimension">
      <Hierarchy hasAll="true" allMemberName="All Years" primaryKey="TIME_ID">
      <Table name="TIME"/>
      <Level name="Years" column="YEAR_ID" uniqueMembers="true" levelType="TimeYears"/>
      <Level name="Quarters" column="QTR_NAME" uniqueMembers="false" ordinalColumn="QTR_ID" levelType="TimeQuarters"/>
      <Level name="Months" column="MONTH_NAME" uniqueMembers="false" ordinalColumn="MONTH_ID" levelType="TimeMonths"/>
      <Level name="Days" column="DAY_ID" uniqueMembers="false" levelType="TimeDays"/>
      <Level name="Hours" column="HOUR_ID" uniqueMembers="false" levelType="TimeHours"/>
      <Level name="Mins" column="MIN_ID" uniqueMembers="false" levelType="TimeMins"/>
      </Hierarchy>
      </Dimension>

      Could be usefull to think a way to express an aggregation of minutes in 10/15 minutes.
      Regards

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              andreacolpo Andrea Colpo
            • Votes:
              2 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: