General OBIEE

Get Involved. Join the Conversation.

Topic

    Natalie Andrek
    Remove duplicate values in OBIEE
    Topic posted March 24, 2017 by Natalie AndrekBlue Ribbon: 750+ Points, tagged Analyses, Customizing Layout, OBI Answers, OBIEE Answers, Report Layouts, Reports, Setup, SQL, Taleo Enterprise 
    699 Views, 4 Comments
    Title:
    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

    Image:

    Comment

     

    • Prudence Kruchten

      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

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

    • Natalie Andrek

      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

    • Richard Chan

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