Re: NULL to 0 Conversion
- From: "Tim Dot NoSpam" <Tim.NoSpam@xxxxxxxxxx>
- Date: Mon, 22 May 2006 20:29:41 -0400
Why don't you make this a business rule in the ETL? The only reason I bring
this up is because I have a similar problem and it unfortunately increases
the overall complexity of the cube to have to "fake" values.
-Tim
"Scott" <Scott@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:80322673-4E8A-47B9-8E11-0DB0047F4A47@xxxxxxxxxxxxxxxx
Is there any way to convert a NULL to a 0 in either an MDX calculated
member
or otherwise without creating a value for members that would otherwise be
empty. I have several hundred employees, only a few of whom create
revenue.
I don't want the others to show. There are however several consultants
who
have NULL or 0 revenue. When I try to convert the NULL to a zero (using
IIF
expression) I return all of the other employees as well. I'm trying to
avoid
having to using Reporting Services expressions to convert NULL's to zeros
and
manage less code.
.
- Prev by Date: Re: NULL to 0 Conversion
- Next by Date: Re: Calculated member value v/s relational totals
- Previous by thread: Re: NULL to 0 Conversion
- Next by thread: Re: Calculated member value v/s relational totals
- Index(es):
Relevant Pages
|
