Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Adding Filters to prompts

51
Views
4
Comments

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.

 

Welcome!

It looks like you're new here. Sign in or register to get started.

Comments

  • Rank 5 - Community Champion

    Hi,

    I have attached a word document. Hopefully that helps.

    ~Arun

  • Rank 2 - Community Beginner

    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

  • Rank 5 - Community Champion

    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

  • Rank 2 - Community Beginner

    Thank you Arun

Welcome!

It looks like you're new here. Sign in or register to get started.