Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Empty Cells

Author  Topic 

QAZAFI
Yak Posting Veteran

50 Posts

Posted - 2009-04-05 : 17:23:25
Hi All

How can I replace my empty value in my Measure with Zero

For Example

I have a measure Actual Sales

I have a dimension products and time

Products July August Sep OCT

Bikes Empty $750 empty $800

Cars $300 $690 $450 $540

I would like to replace these empty values becoz there is no sale being made for bikes for the month of july and Sep and I would like to replce it with 0 value

I will really appreciate your help

Thanks

Qazafi


   

- Advertisement -