Hi,

In the fact table I have to dates: START_DATE and END_DATE. I must build a
cube, which gives me information how many facts is in the certain day.
How to create Time dimension and Measure(s) for such a cube?

For example - how many offers was valid in 2005.11.08? Each offer in fact
table has start_date and end_date - and of course other information lke
customer, prodcuct, etc.

Could anyone help me in making my first cube, please?

BR
D.

If you have both START_DATE and END_DATE then your facts must have duration
rather than representing a singular point in time. For your example, I
suppose that an offer would be valid on a given date if a fact row exists
where that date is >=START_DATE and <=END_DATE. Assuming that each fact
table row is an offer, there's no measure involved here. All you need is to
do is count fact rows that match that date criterion. If a single fact row
many represent multiple offers, then sum that values in the field that holds
the number of offers, again applying the date criterion.

Seth


D wrote:

--
Seth Grimes Alta Plana Corp, analytical computing & data management
Intelligent Enterprise magazine (CMP), Contributing Editor
grimes (AT) altaplana (DOT) com http://altaplana.com 301-270-0795