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

Weighting factors for parent/child hierarchies

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Open
    • Severity: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Not Planned
    • 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.
    • Closer:
      nobody

      Description

      Parent/child hierarchies are a very useful concept to model various requirements from the business world - not just employee hierarchies.

      To further extend the functionality it would make perfect sense to support a weighting factor during the aggregation. A weighting factor would have to be assigned to each relation between to nodes, 1 otherwise. The idea is to calculate the weighting factor for each path from the reporting node to its leaf level nodes that are eventually linked to the fact table.

      Example
      Parent Child Weight
      A B 0.5
      B C 0.5
      A D 0.5

      Aggregating from C to A would result in applying a total weighting factor of 0.25 whereas aggregating from B to A would use a factor of 0.5. Aggregating from A to A would use a default weight factor of 1.
      Aggregating B or D to A results in a factor of 0.5

      Obvioulsly, the closure table would have to be extended to to carry the following factors:

      Root Leaf Weight
      A A 1.0
      A B 0.5
      A C 0.25
      A D 0.5
      B B 1.0
      B C 0.5
      C C 0.5
      D D 1.0

      To create an additional aggregator would make sense because of performance considerations in case of not having weighting factors different than 1.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            Former Triage User Old Triage User (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated: