Possible to return 0 instead of blank?

#1

Is it possible to have an mdx query return 0 instead of blank? I have a lot
of measures that are numeric, so is it possible to add some statement to the
query og something to get a 0?

Kaisa M. Lindahl

#2

use IIF( isempty(<Measure name>),0,<Measure name>)
you may need to create a calculated member for each measure like this

Kaisa M. Lindahl wrote:

Quote:

Is it possible to have an mdx query return 0 instead of blank? I have
a lot
of measures that are numeric, so is it possible to add some statement
to the
query og something to get a 0?

Kaisa M. Lindahl

#3

Function CoalesceEmpty is the right way to do it, see BOL

"Kaisa M. Lindahl" <kaisaml (AT) hotmail (DOT) com> wrote

Quote:

Is it possible to have an mdx query return 0 instead of blank? I have a
lot
of measures that are numeric, so is it possible to add some statement to
the
query og something to get a 0?

Kaisa M. Lindahl

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Possible to return 0 instead of blank?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Possible to return 0 instead of blank? - 01-14-2005 , 02:28 AM

Re: Possible to return 0 instead of blank? - 01-14-2005 , 02:37 AM

Re: Possible to return 0 instead of blank? - 01-14-2005 , 04:18 AM