[Mondrian] #null member
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').
"Julian Hyde" <julianhyde at speakeasy.net>
Sent by: mondrian-bounces at pentaho.org
Please respond to
Mondrian developer mailing list <mondrian at pentaho.org>
"'Mondrian developer mailing list'" <mondrian at pentaho.org>
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.
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
Mondrian mailing list
Mondrian at pentaho.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Mondrian