Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

Remove duplicate values in OBIEE

233
Views
4
Comments
Natalie Andrek-27262
Natalie Andrek-27262 Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

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

Tagged:

Comments

  • Prudence K
    Prudence K 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?

  • Rachel Martorelli-Oracle
    Rachel Martorelli-Oracle 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

  • Natalie Andrek-27262
    Natalie Andrek-27262 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

  • RichardChan
    RichardChan 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