[Mondrian] #null member

[Julian Hyde]

I wonder if we can solve a more general problem: allow people to specify
a SQL expression for the name of a member. Right now, a member can have
different columns as the key and the name. If mondrian allowed SQL
expressions for the name, then you could write NVL(key_column,
'Missing') as the name expression.
 
It's possible that this already works - give it a try.
 
Julian


  _____  

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
On Behalf Of Matt Campbell
Sent: Friday, June 22, 2007 12:37 PM
To: Mondrian developer mailing list
Subject: [Mondrian] #null member



We have dimension tables which will include a row with null for the
member value.  These members end up getting represented in Mondrian as
'#null'.  For various reasons we can't change how this member is
represented in the database table.  Ideally we would like to set how
this gets displayed to give a more user friendly value, like 'Missing'.


How would people feel about allowing a configurable representation of
#null?


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20070623/d7330569/attachment.html