Creating a Logical Column using REGEXP_LIKE in BMM Layer in RPD

Rohit Trehan

Hello Folks,

I have a requirement with the following business rule (simplified for understanding), which I need to implement in OBIEE BMM (RPD)..Do I need to use 'EVALUATE' function ?  If yes, could you please modify the below expression including evaluate that I could plug into by BMM layer to create a logical column.

SUM(CASE
WHEN 1=1 and 'good' = 'good' and not(REGEXP_LIKE (TRIM (<table1>.<column1>), '[[:digit:]]{14}')) and <table1>.<column2> = '0111'
THEN <table1>.<value>
ELSE 0
)

Gratefully !

Thomas Dodds

What have you tried?