Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Attribute key cannot be found !

Author  Topic 

stathis30_2000
Starting Member

23 Posts

Posted - 2007-06-03 : 06:08:59
Hello !

Can somebody help me with the following error while deploying my 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.
The calendar includes the following dates :
1/1/1753 - 31/12/2007 (Time binding)
Why this referential integrity error occurs ??

Please help me because it is urgent and I cannot find a solution..

Thanks

stathis30_2000
Starting Member

23 Posts

Posted - 2007-06-03 : 06:24:51
Changing the deployment settings and choosing to ignore the errors it seems that none of my fact table dates exist in the dimension.
Why is that happening ? Browsing the time dimension everything looks fine!
Go to Top of Page
   

- Advertisement -