OBIEE - Blob data type
About
When using Blob data type, “DISTINCT” clause are not allowed.
Let op: OBIEE includes “DISTINCT” clause in SQL queries as soon as the primary key of a table is not selected
Implementation
BICS
In the online modeler (BICS), primary keys are automatically defined based on joins. So the dimension including the blob column must be joined to a fact table, using the blob column as a join key.