Mapping columns with BLOB format type in Microstrategy Columns in the data source that use BLOB format types can be mapped to attribute forms and facts in MicroStrategy as the LongVarBin data type. According to Microstrategy the data types such as Picture, BLOB, Text depending on data can be assigned as LongVarBin data type in the attribute definition. LongVarBin Picture, BLOB, Text depending on data This data type is treated as a long string of binary data. This representation in MicroStrategy has the following effects on including data from a BLOB format type on a MicroStrategy report or document: • Since the BLOB format type is represented as a LongVarBin, the data is displayed in either binary or hexadecimal representation . The data is not converted into any other format such as an image or PDF format. Therefore, columns in a data source that use BLOB format types to represent images, PDFs, or other non-binary or hexadecimal data should not be include...
Microstrategy Business Intelligence knowledge sharing platform