Oracle Analytics Forum

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

Categories

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

Need assistance for the logic to create one column in OBIEE

1
Views
1
Comments
User_E9OMM
User_E9OMM Rank 4 - Community Specialist
edited Aug 13, 2024 5:23PM in Oracle Analytics Forum

Hi All,

I have a report. It looks like this :

Test.png

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.

Comments

  • Joel Acha
    Joel Acha Rank 8 - Analytics & AI Strategist

    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