Oracle Transactional Business Intelligence

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

Remove duplicate values in OBIEE

231
Views
4
Comments

Content

Hi All,

Is it possible to remove duplicate values in OBIEE?

In my report, columns A and B have unique values per line for an employee, however, column G is all the same value and it repeats itself to match the same number of lines of column A & B. The screenshot can probably demonstrate this a lot clearer than I'm describing it :).

Is it possible to remove all but the bottom value in column G?

Thank you in advance for your help!

Natalie Flanagan

Remove Duplicate Values in OBIEE.png

Welcome!

It looks like you're new here. Sign in or register to get started.

Comments

  • Rank 5 - Community Champion

    Natalie - how do you want it to look?  This may help in providing an answer.  Because really, you could just remove the column or have it display blanks.  But I don't think that's what you are looking for right?

  • Rank 4 - Community Specialist

    It may be as simple as like changing the text color to white on white, it shouldn't affect the total column

  • Rank 1 - Community Starter

    Thank you both for answering.

    Prudence - you bring up a great point. I thought the data was redundant/unnecessary but I'm really not sure how I want it to look. I guess accurate data won't ever hurt anything so it's no issue to just leave it in there.

    Rachel - Thanks for that tip. I'll give it a try!

    Natalie

  • Rank 6 - Analytics Lead

    White on White sounds the easiest , I was going to suggest a UNION with the body and total as separate analysis

Welcome!

It looks like you're new here. Sign in or register to get started.