KB20514: How to map a boolean datatype as integer with PostgreSQL database with cast function in MicroStrategy 9.x and later

SYMPTOM:
When executing a report against PostgreSQL warehouse database the execution is failing with the following error.
 
The column %1's datatype %2 with precision %3 scale %4 is not supported
CAUSE:
The Boolean datatype is not supported with PostgreSQL database in Strategy 9.x
 
ACTION:
Strategy will continue to investigate and post updates as soon as they are available.
 
WORKAROUND:
It is possible to map the boolean datatype as integer in Strategy 9.x. This can be done by using a cast function.
 
STEP 1.
Update structure in the warehouse catalog of the table including the boolean column. Strategy 9.x doesn't have mapping between boolean type and Strategy internal datatype. The boolean datatype should be seen as "Unknown"; it is not natively supported by Strategy 9.x .
 

 
STEP 2.
Create a new attribute where the boolean datatype is used as an id form. The column with boolean datatype can be mapped as integer by using a cast function. Design the desc form for the attribute normally.
 
ApplySimple( "cast(#0 as INT)", )

 
STEP 3.
Create a report based on the boolean expression. As described below the boolean datatype is mapped as integer and the values '0' appears for false, and '1' appears for true. The respective desc forms are stored as 'No' and 'Yes'.
 

 
NOTES:
See the following Technical Notes for more information.
 

• 19263(KB4100-811-1940) - 'The column %1's datatype %2 with precision %3 scale %4 is not supported' error message appears when executing a report against PostgreSQL database with Strategy 8.1.1
• 9796 (KB5200-7XX-0418) - How to convert a CHAR to an INTEGER in Strategy for SQL Server

Third Party Software Installation:
WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.