467,136 Members | 1,272 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,136 developers. It's quick & easy.

OLAP - Calculating Minimum Measure if NULL is present

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.
Jul 20 '05 #1
  • viewed: 1918
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Philip Stoev | last post: by
5 posts views Thread by Framework fan | last post: by
3 posts views Thread by Miller | last post: by
3 posts views Thread by George Sakkis | last post: by
38 posts views Thread by jdcrief | last post: by
reply views Thread by YellowFin Announcements | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.