NULL values in Cube for measures

[SP1709]

I am facing one problem for cubes. Eventhough I have NULL for certain measures in cube it gets populated as 0 in Cube. Has anyone faced this kind of problem. How can I solve this

eg In Database
D1 D2 Measure1 Measure2
A B NULL 10
C D 10 NULL

Expected in Cube
D1 D2 Measure1 Measure2
A B 10
C D 10


Currently getting
D1 D2 Measure1 Measure2

A B 0 10
C D 10 0


If anyone can provide some tips on this issue it would be of great help to me.

Any tip will be greatly appreciated

Thanks,

 

[HRoarke]

I'm facing the same situation - did you ever find resolution?

"I swear by my life and my love of it that I will never live for the sake of another man, nor ask another man to live for mine."
— John Galt
Atlas Shrugged

If you want to get the best response to a question, please check out FAQ222-2244 first

 

[SP1709]

hi John,

I solved this problem. For this you have to create a normal measure. And then a calculated measure from this normal measure.
e.g you want this for store sales
then make a measure named as dbstoresales=database.storesales

and then an calculated measure
store sales=if(dbstoresales=Null,Null,dbstoresales)

Regards,
SP