Hi Folks!
After a long time I got a chance to work on SSAS cube.
One of my colleague asked for my help in resolution of the below error message.
Severity Code Description Project File Line Suppression State
Error MeasureGroupAttribute [CRC001_CALLCENTRE_CALLS].[Logs].[Calling Party].[Number] : The key column #0 has data type 'Double' different than the attribute's key column data type 'WChar'
I was so happy to find its resolution in minutes.
The resolution is to
Edit the dimension of the cube and go to properties of the offending attribute. KeyColumns --> DataType needs to be changed from WChar to Double.
Bingo!
The issue was resolved and cube was deployed !!
After a long time I got a chance to work on SSAS cube.
One of my colleague asked for my help in resolution of the below error message.
Severity Code Description Project File Line Suppression State
Error MeasureGroupAttribute [CRC001_CALLCENTRE_CALLS].[Logs].[Calling Party].[Number] : The key column #0 has data type 'Double' different than the attribute's key column data type 'WChar'
I was so happy to find its resolution in minutes.
The resolution is to
Edit the dimension of the cube and go to properties of the offending attribute. KeyColumns --> DataType needs to be changed from WChar to Double.
Bingo!
The issue was resolved and cube was deployed !!
No comments:
Post a Comment