Hi there,
I am trying to make an OLAP cube on a table having two columns (datetime,
Number_of_times_an_event_occured).
My dimension is time and I want to measure the Min and Max times an event
occured over time.
I have no problem in calculating Maximum occurance of events over time.
However, I have some NULL values in my Number_of_times_an_event_occured
column, due to which I don't see any result when I try to calculate
Minimums.
If I do a "select MIN(Number_of_times_an_event_occured) from Table1", I see
correct results. I read that Analysis Service treats NULL as 0 if there is
any other numeric (non-NULL) field present. However, for calculating my
Minimum Value, I need to ignore these NULL values and have my Min-Max
calculation on the rest of the data.
Could someone explain me this anamoly and how I can see the correct Minimum?
TIA.
