March 26, 2018 at 5:45 am
Hello, I am trying to process a dimension in SSAS OLAP cube and it is getting failed due to duplicate key found error.
After debugging, I found that the description column contains Tab and other special character. I set InvalidXmlCharacters property to remove. It worked for other special characters but not for Tab.
How can we fix this without changing the ETL or query in DSV?
Regards,
Akash
March 29, 2018 at 8:20 am
akash_singh - Monday, March 26, 2018 5:45 AMHello, I am trying to process a dimension in SSAS OLAP cube and it is getting failed due to duplicate key found error.After debugging, I found that the description column contains Tab and other special character. I set InvalidXmlCharacters property to remove. It worked for other special characters but not for Tab.
How can we fix this without changing the ETL or query in DSV?
Regards,
Akash
Until you either remove the duplicated values from the tables involved, or change your ETL process to do the removal, nothing is likely to change. Duplicate values isn't something you can go around.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply