OBIEE - Blob data type

Bi Server Architecture With Client

OBIEE - Blob data type


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



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.

Documentation / Reference

Share this page:
Follow us:
Task Runner