472,145 Members | 1,431 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

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,
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

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?

Jul 20 '05 #1
0 2127

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
reply views Thread by Saiars | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.