Today let’s talk about a common error in MicroStrategy while mapping a new Attribute:
The column %1’s datatype %2 with precision %3 scale %4 is not supported…
Sometimes MicroStrategy can’t get the exact data type from Database while creating a new form attribute.
It’s always a good idea to take a look at “Column Alias” while editing or creating a new attribute, because an unknown data type could appears there, just like the image below:
That is the reason that makes this error happens. So, lets solve this problem!
1. Edit your attribute -> Click on Modify -> click on Column Alias tab -> click “Modify” -> Click on “New” button” -> Give a name and the correct data type.
After that, update your schema and you will be fine again!
Hope it helps!
God bless you!