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

Using global dimension, but applying local level names

    XMLWordPrintable

    Details

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

      Description

      It's extremely convenient to use global dimensions. In my case, I have one global date dimension and reuse it about 28 times.
      The problem though is, that while I can assign a local dimension name, the levels will still have the same name as the global level name.

      In example:
      global:
      Date/Monthly Calendar/Year/Month/Day in Month
      local:
      Registration Date/Monthly Calendar/Year/Month/Day in Month

      What I'd like to see in a GUI like Analyzer is:
      Registration Date/Registration Date - Monthly Calendar/Registration Date - Year/Registration Date- Month/Registration Date - Day in Month

      Otherwise if somebody does a search for month, they will get returned 28 "months" ... so there is not way to differentiate them ("Registration Date - Month", "Cancellation Date - Month" would be more meaningful).

      Is there a way to achieve this by making some modifications to the schema?

      Julian suggested:

      Allow details of a dimension to be changed when it is used. For example,

      <DimensionUsage source='Time' name='Registration Date'>
      <Hierarchy name='Monthly Calendar'>
      <Level source='Year' caption='Registration Date - Year'/>
      <Level source='Month' caption='Registration Date - Month'/>
      <Level source='Day in Month' caption='Registration Date - Day in Month'/>
      </Hierarchy>
      </DimensionUsage>

      Note that this doesn't fully re-specify the dimension, just allows you to override particular metadata attributes.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              diddy Diethard Steiner
            • Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated: