nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Home
Oracle Analytics and AI
Oracle Analytics and AI Forums
Oracle Analytics Forums
Oracle Analytics Forum

Need assistance for the logic to create one column in OBIEE

User_E9OMM

Hi All,

I have a report. It looks like this :

I have to add one more new flag column in the report.

Logic is - If for a given year (2016) - employee has two different Manager Flags (Both Y and NO) then the value of the new flag should Y for that year.

Find more posts tagged with

Comments

Joel Acha

Just do something along these lines:

CASE WHEN COUNT(DISTINCT "Manager Flag" BY "Employer Number", "Year") =2 THEN 'Y' ELSE 'N' END

Substitute Names that I've put with double quotes with the actual Presentation column names