Hi,
There is the general support article for this error, you could see the solution in it see if it helps: Error message when processing a dimension Check about the case sensitive case in the article.
regards,
Lukas
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello, I'm creating dimensions in SSAS and I was successful with the two other dimensions tables but only this one is giving me an error when processing it.
the error is
Server: The current operation was cancelled because another operation in the transaction failed.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Loan', Name of 'Dim Loan' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Credit Card Authorization' attribute of the 'Dim Loan' dimension from the 'RMG_CUBE_2020' database was being processed.
OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.
Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_Dim_Loan', Column: 'Purpose_of_Loan', Value: 'Investment'. The attribute is 'Purpose Of Loan'.
I checked my data and I don't have any duplicates in the primary key, while with the investment row was repeated intentionally in that column 'Purpose_of_Loan',
this column is not primary key or unique so I'm not sure why I'm getting this error
can you please tell me what I'm I doing wrong in here?
Hi,
There is the general support article for this error, you could see the solution in it see if it helps: Error message when processing a dimension Check about the case sensitive case in the article.
regards,
Lukas