[Mondrian] Hiding measure values at certian dimension levels

Julian Hyde jhyde at pentaho.org
Mon Nov 19 19:37:36 EST 2007

The requirement seems to make sense, but I have some questions about the
implementation. The devil is in the details, they always say.

First, can you explain whether the measures would be hidden within
calculations (i.e. null or throw an exception if accessed) or merely appear
blank when rendered in the UI.

Second, your example shows one level being hidden; how would you deal with
multiple levels being hidden (comma-separated level names might be tricky to
parse) or more generally still, wanting to hide at some members of a level
but not others. 

Third, could this be achieved using an existing mechanism like calculated
members, access control or format strings? Or perhaps handled by the UI


> -----Original Message-----
> From: mondrian-bounces at pentaho.org 
> [mailto:mondrian-bounces at pentaho.org] On Behalf Of Ognjen Milic
> Sent: Monday, November 19, 2007 7:40 AM
> To: Mondrian developer mailing list
> Subject: [Mondrian] Hiding measure values at certian dimension levels
> I wrote about this on the Mondrian forum, but I want to 
> mention this on 
> mailing list because I consider it important.
> Some measure values should be hidden at certain levels of dimension.
> If we have dimension Product  (as in foodmart) it has no sense to sum 
> Unit Sales or Store sales in All Products level or in Product 
> Department 
> etc because different product have different measure units.
> It has no sense to show sum of kilograms, liters and pieces. 
> It is OK to 
> calculate it through SQL queries, but not to show it.
> So it would be very useful when we would have some 
> CalculatedMemberProperty that could make dimesion value visible (or 
> hidden) on certain levels.
> This could be somethin like
> <CalculatedMemberProperty name="HIDE_VALUE_ON" value="[Product].[All 
> Products]"/>
> Ognjen Milic
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian

More information about the Mondrian mailing list