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 !
