Time dimension

Hi all !

I am new to analysis services so I need some help concerning the time dimension.
I have created a cube using and existing data source and then I added a server time dimension.

The first question is: How the server time dimension is related to the datetime dimension which is in the fact table??

And the second one: I added a measure with aggregate function AverageOfChildren and the following error occurred 'Semi-additive measure requires time dimension'.

Please help, I have read all the tutorial related to different types of time dimensions but still haven't figured out what is causing the problem..

Thanks

I solved the problem but now the following error occurs when I deploy the cube :

The attribute key cannot be found : dbo_fact_table, Column: datetime Value 25/10/1901 4:18:00 pm...

The year 1901 is included in the time period of the time dimension. Does the time matter ?

Thanks

Please, can somebody help me with my problem ? It is urgent and I can not think of any solution... Does the date format matter?
My calendar covers the following dates :
1/1/1753 - 31/12/2007 (Time binding)
Why this referential integrity error occurs ??


Thanks

If the granualarity of the time dimension does not require Time then trim it from your fact table and only use dates.

Raulie