Hi,

I have about 30 source measures in my "Measures" Dimension. There are some
empty cells for some of the measures across different dimensions.

I am trying to replace empty cells with 0.00 in my sample query below. It
comes out with an error.

Query:

select CoalesceEmpty({Measures.Members},0.00) on columns,
[Business Line].members on rows
from
Sales

Error:


unable to open cellset
Formula error - syntax error - token ias not valid:
"CoalesceEmoty({Measures.Members}~,~0)

Please help how to achieve this. I know i can write "With" member logic for
each source measure to replace empty cells with zero's. But, i have 30
measures.

Thanks,

Sam.

Can a Calculated Cell work, like in this example,:

For '([Measures].Members)' As
'CoalesceEmpty(CalculationPassValue(
[Measures].CurrentMember, -1, RELATIVE), 0)',
FORMAT_STRING = '##.00;(##.00);0.00;#.00'

Select {[Measures].Members} on columns,
[Time].[Month].Members on rows
from Sales

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***