Oracle Transactional Business Intelligence
Remove duplicate values in OBIEE
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
Comments
-
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?
-
It may be as simple as like changing the text color to white on white, it shouldn't affect the total column
-
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
-
White on White sounds the easiest , I was going to suggest a UNION with the body and total as separate analysis