Oracle Transactional Business Intelligence
Remove duplicate values in OBIEE
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 - 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!
White on White sounds the easiest , I was going to suggest a UNION with the body and total as separate analysis