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 |
|
HenryFulmer
Posting Yak Master
110 Posts |
 Posted - 2012-08-01 : 12:04:16
|
When I'm trying to process one of my cubes error due to a duplicate attribute key, but the column that's listed isn't a key nor does it have any constraints on it.Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_dimItems', Column: 'ItemDescription', Value: 'TIRE KLX/DRZ/LDZ800'. The attribute is 'ItemDescription'. Any ideas where to look for the real issue? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-01 : 12:21:18
|
| i think you've set this column up in relationships within cube.check the relationships tab in cube definition------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
HenryFulmer
Posting Yak Master
110 Posts |
Posted - 2012-08-01 : 15:09:47
|
| Yes, I have a relationship set up in the cube between the ItemNumber and the ItemDescription.Why does that cause a duplicate attribute key issue? I do have the same same description twice but the ItemNumber, which is my primary key, is different. Sorry, I'm still new to Analysis Services. How can I correct this? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-01 : 16:10:30
|
quote:
Originally posted by HenryFulmer
Yes, I have a relationship set up in the cube between the ItemNumber and the ItemDescription.Why does that cause a duplicate attribute key issue? I do have the same same description twice but the ItemNumber, which is my primary key, is different. Sorry, I'm still new to Analysis Services. How can I correct this?
how do you relate between itemnumber and description? you should be relating only between item number itself b/w tables. does your fact have itemnumber? or are you using surrogate key?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
HenryFulmer
Posting Yak Master
110 Posts |
Posted - 2012-08-03 : 17:16:39
|
| I have set up a Relationship Attribute between ItemNumber and ItemDescription : Source Attribute: ItemNumber; Related Attribut: ItemDescription; Relationship Type: Flexible.My Fact table contains the itemnumber as a value. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-03 : 17:48:42
|
| isnt it enough to create a single attribute with NameColumn as ItemDescription and KeyColumn as itemnumber ?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
|
|
false duplicate attribute key