To access a list of data types supported by Oracle BI EE, use the Oracle BI Server nqcmd utility to run the NQSGetSQLDataTypes procedure.
For example: call NQSGetSQLDataTypes(0);
When you run this procedure, the results contain a list of supported data types and information specific to each data type such as case sensitivity and the ability to search.