We are having a problem when using NUMBER data type in the Data Warehouse that is being used by Microstrategy.
When in the warehouse we use NUMBER data type, in Microstrategy Desktop Warehouse Catalog, the columns using this data type show "Unknown" in the Data Type Description.
This is making a lot of the reports that use attributes mapped to this columns to fail.
We tried both with Microstrategy 9.2.1 and Microstrategy 9.3 but the "Unknown" data type keeps appearing.
Is there anyone who is using this BI tool with TD 14? Has anyone deal with this issue before?
Any help will be appreciated.
Thanks for your time.
Check the compatibility matr¡ix. I'm not sure that MS 9.2.1 & 9.3 is certified to work with TD 14 yet.
The NUMBER datatype is supported with MSTR9.3.0. Suggest you upgrade to the latest 9.3.0 Hotfix. I have done some simple tests; and seem to have no problem mapping the NUMBER datatype into MSTR facts with 9.3.0/HF2 & TD14.
Please try latest 9.3.0/HF2. If you still have any issues, I recommend you open a Tech Support Case with MicroStrategy.