Search code examples
stringnullssascubezero

SSAS - Always show zeros - NOT blanks

I have a cube that I access via Targit (BI Solution). When I browse / use that cube I want all quantity results to be a zero if null / blank NOT a blank, but no matter what I try I get blanks. I have changed the Null Processing property for the measure in question as well as attempted to change / remove the format string. I still get blanks instead of zero's.

Thoughts?

UPDATE: I figured out that I could create a calculated measure and use iif / isempty funcitons to force zeros. This works - just wondering if there is a cleaner way to accomplish this.

Thanks

Bill

Solution

  • Try using a formating expression such as FORMAT_STRING = "#.00;(#.00);#.00;-" This should give the desired results without the perf hit.

    More info: http://msdn.microsoft.com/en-us/library/ms146084.aspx