You may use the below variable: "date variable" > TIMESTAMPADD(SQL_TSI_DAY, -7, CURRENT_DATE) Thanks to Manoj who had posted the above formula in another post. Here is the link to the original post: Thanks, Arun

You can create a BI Publisher report using RTF Template / Excel Template. You will have more control over the size of columns, text-wrapping etc. Thanks, Arun

Hi Ashish, Try the below steps: Create a dashboard prompt with the same name as the prompt / parameter that you have created in the Data Model. Add the dashboard prompt and the BI report to the Dashboard. Thanks, Arun

Thanks Neil. That's an interesting point. The excel Template for BI reports has a similar limitation. Regards, Arun

Hi Neil, Thanks for the tip. I believe in newer versions of Excel (2013, 2016 etc), we can view more than 65000 records. Thanks, Arun

Hi, Are you using a OTBI report? We had to create a BI report to by pass the issue. ~Arun

how about using UPPER key word to force any selection to be in upper case?

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…

Hi, I have attached a word document. Hopefully that helps. ~Arun

That is strange. We had such an issue, however we were thinking that someone accidentally moved the folder to another folder. I wonder if there is an audit trail on these actions. Thanks, Arun

Hi, You can use FND_TREE_NODE and fnd_tree_version_vl tables to get the hierarchy data in BI report. Thanks, Arun

If you go to Edit Formula, you will be able to see the "||" symbol. you can use the same to concatenate the columns. Something like below: "Candidate Location of Residence"."Candidate Country Of Residence"||', '|| "Candidate Personal Information"."Candidate Address Line 1"||', '|| "Candidate Personal…

May be look at the below? * Worker : Termination Date * Location : Effective End Date * Job : Effective End Date There could be more. I am sorry I cant give you a straight forward answer without seeing the analysis being created. Hope this helps.

Happy to help. Since it is HR / Employee data, you might want to look at any date columns to make sure you are only picking the most recent / active record. If it is a SQL we mostly look the Effective Date columns. Please check if you can utilize any Effective Date columns in your filter. For example, an employee can have…

Can let me know the subject area you are using?

Ok. So you are creating a OTBI report. I was checking if you were creating a BI publisher report. Try adding some filters in your analysis.

Are you using custom data model? If yes, then you will have to check the data model to make sure the SQL query is correct. Thanks, Arun