Data Import
Error saving and publishing the Cube: (QueryEngine encountered error: MBase::WideCharToUnicodeValue: Invalid UNICODE value U+D96B...
CAUSE:All characters imported through data imported into Strategy Web must be valid in Unicode. In this case, U+D96B is not a valid UNICODE value.
For more information on the codepages accepted by Strategy Data Import, refer to the documentation on
Best Practices for Importing Data into MicroStrategy Web
ACTION:
Remove the non-unicode character(s) from the Excel file being imported. Several methods could be utilized to find the offending character(s), depending on the size of the Excel dataset being imported:
- Use a Unicode lookup tool to determine what the character looks like, then manually find this character in the Excel dataset.
- To find the character(s) in a large dataset, perform a binary search on the Excel dataset:
Split the dataset into two halves, into separate Excel files. Import and publishing both Excel files using Strategy Data Import. If only one of these files cause the error to be shown, then continue this process of halving and testing until the offending column(s) and row(s) are found.
