September 11, 2016 at 11:12 pm
I've been trying to process a cube (designed by someone else) and have been getting an error. I've been able to narrowed it down to one dimension which produces an error and the following warning:
"Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_Dim_time', Column: 'Mth_Name', Value: 'April'. The attribute is 'Mth Name'."
The message seems pretty obvious... The underlying 'dbo.Dim_time' table has duplicate 'April' values in the 'Mth_Name'. When I look at the table, it in fact does have duplicate 'April' values, however, from my reviews of that field, it SHOULD! The table is holding multiple years and is repeating the month's name for each year.
So not sure why it's causing a problem. It appears the problem may be because of the way he setup the attribute relationships.
Any ideas?
Please take a look at the attached screen shots.
Note:
There is a warning message in two of the attribute relationships. The message says:
"Design hierarchies for each incoming relationship path when attributes have multiple incoming relationships or, if any of the incoming relationships are unnecessary, you should delete them."
September 12, 2016 at 1:00 am
have a look at http://hownottoprogram.azurewebsites.net/?p=631 - maybe it applies
September 12, 2016 at 12:58 pm
Thanks for the suggestion. Just read through it and it seems that may be the problem. I'll try it and report back. Thanks!
September 13, 2016 at 2:55 am
This is a common problem. You need a composite key for the MonthName. Add the year as well, so that you get April 2016 instead of just April.
The reason for this is that if you just use the month, SSAS has no idea to which year it belongs.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply