My cube has been processing fine without any error messages. I added a new dimesion table in the data ware house and added a foreign key in my Fact table. I then added the values in the data ware house and everything was fine.
I then added the dimension in the cube and processed the dimension. But when i try to process the cube it gives the following error message.
The attribute key not found. MyFactTableName: Column Name
and a warning sign below it saying that the attribute key is not found in my dimension table and gives the table name.
please note i am using SQL Server 2005 BI Studio.