PDA

View Full Version : [Mondrian] Dynamic default members



Franco Graziosi
05-29-2007, 06:02 PM
_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian

Julian Hyde
05-31-2007, 05:00 AM
Sorry, Mondrian doesn't support dynamic default members. Please log it
as an enhancement request at sf.net; I can't say when we'll get to
implement it.

Note that a while ago, we added a similar feature: which allowed the
default measure to be any measure, including a calculated measure
defined in the cube.

Julian


_____

From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org]
On Behalf Of Franco Graziosi
Sent: Tuesday, May 29, 2007 3:00 PM
To: Mondrian developer mailing list
Subject: [Mondrian] Dynamic default members


Hi,

Is it possible to define a "dynamic" default member for hierarchies, for
example, in a time hierarchy I would like the default member to be
last available month. I tried the following definition:

<Dimension name="Time" type="TimeDimension" foreignKey="time_id">
<Hierarchy hasAll="false"
defaultMember="Tail([Time].[Month].Members)"/>
...

but seems that Mondrian expects as 'defaultMember' a constant value like
[Time].[2006].[12].


If not through configuration, is there any API call to perform this
task?


Thank you very much!

Franco Graziosi





_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian