October 25, 2010 at 1:18 am
I have a cube that I do a full process of the dimensions and of the cube, yet i keep getting this error.
[Analysis Services Execute DDL Task] Warning: Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Item Key of Dimension: Current Item from Database: Sales Analysis, Cube: Sales Analysis, Measure Group: Sales Analysis, Partition: Fact Order, Record: 2290553.
I find this strange because all the dims are processed before the cube, i changed it from dimenion update to full process and yet i still get this error, any ideas? Yes if i update it directly in SSAS i dont get this problem.
October 25, 2010 at 11:14 pm
Look like fact has some dimension key for which record is not present in dimension table. I am not sure why it is not giving error in SSAS.
Try below step:
1) Unprocess cube
2) Process full cube/database
it should throw the error.
Thanks,
Amit G
http://www.msbiconcepts.com
October 26, 2010 at 5:27 am
Do you have all the foreign key constraints in place? If not, something may have crept in.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply