[Mondrian] Hiding measure values at certian dimension levels

Julian Hyde jhyde at pentaho.org
Fri Nov 23 06:34:36 EST 2007


> Julian Hyde wrote:
> > Third, could this be achieved using an existing mechanism 
> like calculated
> > members, access control or format strings? Or perhaps 
> handled by the UI
> > entirely?
> >
> Ognjen Milic wrote:
> I achieved this through format string expressions, but then I loose 
> ability of drilling through in JPivot, because there is no drilling 
> through for calculated members and
> no format string expressions for measures.

Suppose we could make trivial calculated members drillable. Would that solve
your problem?

I know people often create trivial calculated members just to change format
strings, e.g.

with member [Measures].[Foo] as ' [Measures].[Unit Sales], FORMAT_STRING
='$#,###.000' '
select {[Measures].[Foo]} 
...

Julian




More information about the Mondrian mailing list