Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Creating a Logical Column using REGEXP_LIKE in BMM Layer in RPD

Received Response
11
Views
1
Comments
Rohit Trehan
Rohit Trehan Rank 3 - Community Apprentice
edited Aug 13, 2024 5:33PM in Oracle Analytics Cloud and Server

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 !

Answers