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.
| Author |
Topic |
|
Duran
Starting Member
9 Posts |
 Posted - 2012-01-24 : 09:24:57
|
| Hello,I hope someone with more experience can help me, should be quite easy for people that post on here if the other posts are anything to go by. 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. I cant browse the dimension, as its deployed but not processed I feel like I am in no mans land and dont know where to turn.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. |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2012-01-25 : 07:06:33
|
| This is caused by a key in a dimension haveing instances where there are different description values for the same key value. eg: EnglishProductName Key value: 1 Name Value: 'Sport-100 Helmet, Red' and another member EnglishProductName Key value: 1 Name Value: 'Sport-100 Helmet, Blue'.You need to set up the attributes key values to identify the attributes uniqueness. Unfortunately I dont have the press study guide that you are using, so I am hoping that my answer is clear enough for you to understand.Duane. |
 |
|
|
|
|
|
|
|
70-448 Study Issue