找不到ssas尺寸处理键错误 [英] ssas dimension processing key not found error
问题描述
在这种奇怪的情况下,我尝试处理维,数据源为MSSQL
,当我尝试处理此维时,出现此错误
OLAP存储引擎中的错误:处理时找不到属性键:表: application,列: Full_Name,值: Mr Peter McDonald。该属性为申请人全名。
由于我认为我知道问题出在哪里,我已经为该列设置了区分大小写的属性,我再次尝试处理,结果也一样。
当我使用like查询该列时,我得到了两条记录
Peter McDonald
Peter Mcdonald
我通常认为设置大小写可解决问题,但是在这种情况下不起作用,所以我想知道是否有人知道如何解决这个问题。 p>
非常感谢您的提前帮助!
抱歉回来太晚了。
我已经很长时间没有登录stackoverflow了。
简短版本:
这基本上是由SQL Server引起的,不区分大小写默认情况下进行比较。
因此,如果要防止此问题,必须使表或数据库区分大小写-将排序规则设置为ASCS
稍长的版本:
即使MSSQL匹配不区分大小写的内容,它仍然以不同的方式存储值,这在SSAS尝试对特定列进行区分时会成为SSAS的问题。
已经有一段时间了,所以我记不清了,但是它会有1个索引的两个值,并且会像我发布的问题一样抱怨。
I have this strange case where I am trying to process a dimension, the data source is MSSQL and when I try to process this dimension I am getting this error
Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'application', Column: 'Full_Name', Value: 'Mr Peter McDonald'. The attribute is 'Applicant Full Name'.
Since I think I know what the problem is, I have set the case sensitive property for this column and I tried processing again and it's giving me the same result.
when I query for the column using like, I get two records
Peter McDonald
Peter Mcdonald
I would normally assume that setting the case sentivity would solve the problem, but it's not working in this case, so I was wondering if anyone knows how to resolve this.
Thanks a lot for the help in advance!
Sorry guys for getting back too late. I haven't logged into stackoverflow for a long time.
The short version : This is basically caused by SQL server is not case sensitive for comparison by default. So if you want to prevent this problem you have to make the table or the database case sensitive - set collation to ASCS
Slightly longer version : Even though MSSQL matches Case insensitive what it still stores values differently, and this becomes an issue for SSAS when it tries to do a distinct on a particular column. It's been a while so I can't remember exactly but it will have two values for 1 index and it will complain like the question I have posted.
这篇关于找不到ssas尺寸处理键错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!