Removing certain row in OBIEE Analysis Answer based on existence of another row — Oracle Analytics

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

Removing certain row in OBIEE Analysis Answer based on existence of another row

Received Response
1
Views
1
Comments
user13074086
user13074086 Rank 1 - Community Starter
edited Aug 13, 2024 7:02PM in Oracle Analytics Cloud and Server

Hi,

We have a requirement where we wish to remove certain row from analysis answer based on existence of another row. Please see the following results of 'Original' analysis

Customer       Type        ID

A                   S             1       

A                   O             2

B                   S             3

C                   O            4

For all Customers where rows with both "Type" values (i.e. "S" and "O") exist, rows with "Type" "O" need to be removed from the Answer. Practically second row (A, O, 2) needs to be removed. 'Expected' result should be

Customer       Type       ID

A                   S            1        

B                   S            3

C                   O           4

Regards, Atul

Answers

  • choracy69
    choracy69 Rank 6 - Analytics Lead

    Hi,

    Try use formule like this: max(Type)

    If the Type column has a value of "S" and "O" they will always appear larger ones or "S"


    .