The key column #0 has data type 'Double' different than the attribute's key column data type 'WChar'

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 !!

Let's Start with Other Learnings

Hi Friends,
Its been so long since I posted any new entries.

There are very few entries in this blog and I regret for not writing all my learning's in this blog. I am used to learning anything new daily for at least 10 to 20 minutes on what I am working on.

With my next role being an Azure Architect, it requires me to learn Azure , Agile, Project Management, CMMI and so many other topics.

Would like to start my entries on all the topics that I learn...

The name of this blog still remains PurelySQL as all the next entries is obvious next thing for any SQL Developer or Architect.

Blogging your Learning's is so much fun !!!! Yippee !!!!!