General OBIEE

Get Involved. Join the Conversation.

Topic

    A K
    Adding Filters to prompts
    Topic posted August 8, 2016 by A KRed Ribbon: 250+ Points, last edited October 13, 2016, tagged Analyses, OBI Answers, OBIEE Answers, Reports 
    65 Views, 4 Comments
    Title:
    Adding Filters to prompts
    Summary:
    For you gurus out there, please I need a help
    Content:

    I always need to add recruiter name as a prompt but unfortunately we have so many recruiter records that are marked as deleted showing in the prompt. How do I filter out these names from showing in prompts.

     

    Comment

     

    • Arun Raj

      Hi,

      I have attached a word document. Hopefully that helps.

      ~Arun

      • A K

        Thank you very much for your response Arun. I checked the docs I suspected earlier I may need to write an SQL statement but it seems we are using a different subject area. This is for Taleo Recruiting OBIEE. If I have to write an SQL Statement I am not sure of what fields to pull the Active recruiter names from.Thanks again, Ayo

        • Arun Raj

          Hi,

          SQL statement should be pretty straight forward. I don't have Taleo in my instance, so can't tell you the exact SQL. However this is how you can construct one:

          SELECT "folder.field name"

          FROM "subject area name"

          WHERE "condition"

          folder.field name (in your case the folder will be the folder in which you see recruiter name details)

          You can add conditions like

          • "folder.field name" IS NOT NULL (to fetch only non null records)
          • "folder.field name" like 'A%' (to fetch records where the field name starts with the character A

          ~Arun