Remove duplicate values in OBIEE

Natalie Andrek-27262

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

Prudence K

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

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

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

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