January 23, 2012 at 1:02 pm
Hello, I hope someone with more experience can help me. I am working my way through the 70-448 MS Press study guide and I am adding a dimension to a cube, it does the first bit of deploying ok, but when I click Run on the Process Dimension -Product dialogue box, it fails with the following error...
Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_DimProduct', Column: 'EnglishProductName', Value: 'Sport-100 Helmet, Red'. The attribute is 'English Product Name'.
I have looked on the web, but to be honest its early days and not sure what to do. If anyone happens to need the book to know what part I am referring to, it is on page 192, step number 7 of Exercise 1: Use the dimension wizard to create a dimension.
Any help would be most appreciated, I'm not sure I can fix this myself at this stage, and worried I might ruin the lot.
Regards,
D.
January 24, 2012 at 10:20 am
Duran (1/23/2012)
Hello, I hope someone with more experience can help me. I am working my way through the 70-448 MS Press study guide and I am adding a dimension to a cube, it does the first bit of deploying ok, but when I click Run on the Process Dimension -Product dialogue box, it fails with the following error...Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_DimProduct', Column: 'EnglishProductName', Value: 'Sport-100 Helmet, Red'. The attribute is 'English Product Name'.
I have looked on the web, but to be honest its early days and not sure what to do. If anyone happens to need the book to know what part I am referring to, it is on page 192, step number 7 of Exercise 1: Use the dimension wizard to create a dimension.
Any help would be most appreciated, I'm not sure I can fix this myself at this stage, and worried I might ruin the lot.
Regards,
D.
No clue of test or book.
It appears the problem is a duplicte key in dimProduct, EnglishProductName column.
Check the data to see that there is a dupe key and remove it. Be forewarned, if there is one dupe key, it's likely there are more.
January 24, 2012 at 10:39 am
Hello,
Thanks for getting back, I understand that there is a duplicate key and it needs removing, the problem is I am not sure how to do that, or where to find the duplicate key. I understand that the dimension is based on the underlying AdventureworksDW2008 database, however the layout is not the same as a normal database, so I am having trouble working out how to do it.
Regards,
D.
January 24, 2012 at 10:51 am
Duran (1/24/2012)
Hello,Thanks for getting back, I understand that there is a duplicate key and it needs removing, the problem is I am not sure how to do that, or where to find the duplicate key. I understand that the dimension is based on the underlying AdventureworksDW2008 database, however the layout is not the same as a normal database, so I am having trouble working out how to do it.
Regards,
D.
Ah, ok, I see.
well, yes, DW tables are denormalized. But I think the error message gave you the table name? It also gave you the value in a specific column, so you could start with a simple select query to try to locate that record, and hopefully find more than one.
Aside from tables being crafted differently, SQL tables are SQL tables, no change to how you would normally query or open a table. You can launch SQL and locate the dimension table and pop it open or query it.
Please let me know if you're still lost. I'm not sure if you're new to MS SQL or just the DW part of things.
April 11, 2012 at 5:52 am
I had the same problem but when I reviewed the exercise again I realised that I was changing the wrong column.
If you re-read "Working With SSAS Dimensions Exercise 1 / Step 3" on page 191.
On the 'Specify Source Information' page you need to change the 'Name Column:' field to 'English-ProductName' and not select it in the 'Key columns:' field.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply