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. (I use SQL Server 2005)

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

BR
D.

You have several options in creating the time dimension. SSAS 2005 can
build it for you on the server side, or you can derive a time dimension
from your fact table dates using the time dimension builder in SSAS
2005. Third option is to take the traditional approach of building a
time dimension table which joins to your fact. Join it on both your
data fields and create a count or distinct count measure. Using
role-playing dimensions, you can also have a time dim for start dates
and a time dim for end dates.
There should be plenty of Google help on cube-building.

On Nov 7, 12:08 am, "D" <t... (AT) onet (DOT) pl> wrote: