dbTalk Databases Forums  

Ascii code 223 causes AS2k5 cube processing to fail with duplicate

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Ascii code 223 causes AS2k5 cube processing to fail with duplicate in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
BigJimSlade
 
Posts: n/a

Default Ascii code 223 causes AS2k5 cube processing to fail with duplicate - 09-15-2006 , 03:55 PM







When trying to process a table containing a field "Last_Name"

It looks like these two values are considered the same:
sass
saß *ASCII 223

The cube processing fails complaining about a duplicate key value.

Errors in the OLAP storage engine: The attribute key is a duplicate: Table:
dbo_PersonDimension, Column: Last_Name, Value: Saß.



is there a setting in analysis services that can treat these as two distinct
values (Sql Seems to handle this fine) or is this a bug in AS2k5?



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.