Enable CLOB Field in OBIEE

Today we are going to discuss how to enable CLOB field in OBIEE. Below are the steps which need to be followed.

Lets assume , ACTION_ITEM table has a column called ACTION_TAKEN which datatype is CLOB.

1. There is not CLOB datatype in OBIEE RPD. For CLOB please select LONGVARCHAR type in RPD physical layer.

 2.   Its mandatory to define a Keys for that Physical Table in RPD.

3.Open the same column in BMM layer. Select that particular column and click on Edit under “Column Source Type”.

4. Open that Column from Logical Table Source.

5. Need to use LOOKUP DENSE funcation.

Syntax : LOOKUP (DENSE  CLOB Column, PK Column)

6. Move it to Presentation layer and use the same in BI report.

Enjoy and Stay Well !! :)