[Mondrian] Using global dimension, but applying local level names
Julian Hyde
jhyde at pentaho.com
Thu Nov 3 13:25:02 EDT 2011
No way to do that currently.
A few thoughts.
1. The following Mondrian feature would solve the problem. 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.
If you think this would help, please log a jira case.
2. It also doesn't seem appropriate for Analyzer to assume that level names are unique within a cube. Maybe it should qualify them if the levels being displayed are not unique. Benny, what do you think?
3. A cube that has 28 uses of the same global dimension has some issues. Is this a hacky workaround to some other problem or missing feature? What's the underlying problem.
Julian
On Nov 3, 2011, at 6:47 AM, Diethard Steiner wrote:
> Hi,
> 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?
> Thanks,
> Diethard
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
More information about the Mondrian
mailing list