[Mondrian] #null member
Thiyagu Palanisamy
tpalanis at thoughtworks.com
Tue Jun 26 11:02:18 EDT 2007
Thanks Julian, It works.
We are able to change null value to 'Missing' using NameExpression with
COALESCE, eg: COALESCE("promotion"."promotion_name",'Missing').
- Thiyagu
"Julian Hyde" <julianhyde at speakeasy.net>
Sent by: mondrian-bounces at pentaho.org
24/06/2007 00:58
Please respond to
Mondrian developer mailing list <mondrian at pentaho.org>
To
"'Mondrian developer mailing list'" <mondrian at pentaho.org>
cc
Subject
RE: [Mondrian] #null member
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?_______________________________________________
Mondrian mailing list
Mondrian at pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20070626/813934be/attachment.html
More information about the Mondrian
mailing list