[Mondrian] Hiding measure values at certian dimension levels

Ognjen Milic ognjen.milic at asw.eu
Fri Nov 23 10:47:07 EST 2007


Julian Hyde wrote:
>> 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
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>   
Yes if  calculation of format string is not considered in triviality of 
calculated member. (If trivial calculated member can have expression in 
format string)

Ognjen



More information about the Mondrian mailing list