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.

Documentation / Reference


Powered by ComboStrap