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

Aggregate with parent-child closure dimension

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed
    • Severity: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • 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:
      jhyde

      Description

      (I've posted this in the "Help" forum as well)
      I have a Mondrian cube with an Account dimension
      whose levels are defined in a parent-child "closure"
      table. This works great, especially with a jpivot
      view.

      There is a parent member called "Net Income" that has
      two children: "Revenue" and "Expenses". My client
      wants to see the Expenses as a positive number,
      but "Net Income" really should be "Revenue"
      MINUS "Expenses".

      I know that I can build an MDX formula to calculate
      the correct Net Income number, but that defeats the
      idea of having this data in a cube to begin with.

      The client's desire to show expenses as a positive
      number is not unusual.

      Is there a way to have this in an aggregate table,
      which would have a structure essentially identical to
      the cube's fact table (plus fact_count), but could
      also include summarized data for my upper account
      levels?

      I could then write a stored procedure to generate
      data for all account levels and do the Net Income
      calculation in my stored proc.

      Mondrian could do its dynamic aggregation, pivoting,
      etc. with the rest of the dimensions.

      Perhaps this is a new feature request?

      Any thoughts, ideas, suggestions, would be welcome.

        Attachments

          Activity

            People

            Assignee:
            jhyde Julian Hyde (Inactive)
            Reporter:
            msemsel msemsel
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: