Dummy or Black Column in OBIEE11g

Hi All,

I have seen, so many times due to some business requirement we need to create to dummy or black Column.

Steps –

Drag any Column from subject area

Go to Edit formula – add below syntax

Column with numeric values:  CAST(null as DOUBLE)

Or

Text column: Null

Or

Date column CAST(null as DATE)

Check below screen shots for Column with numeric values

Thanks and Regards 

Rp - rakeshpatil002@gmail.com