OBIEE - Blob data type

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs)

1 - 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

2 - Implementation

2.1 - 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.

3 - Documentation / Reference