SQL
Discussion List
-
Table name to capture reverse termination date & its details for reverse terminated employeesSummary Table name to capture reverse termination date & its details for reverse terminated employeesContent Hi All, In which table I can find the reverse terminated dat…Nirmal Kumar L 22 views 0 comments 1 point Started by Nirmal Kumar L General Transactional Reporting (OTBI) -
Different report in same Excel file with differents sheetSummary Different report in same Excel file with differents sheetContent Hi Experts, I created 3 new reports as per our customer requirements. But they need all the repo…Nirmal Kumar L 35 views 3 comments 0 points Most recent by Nirmal Kumar L General Transactional Reporting (OTBI)
-
How to get roles assigned to BI ReportsSummary How to get the roles assigned to BI ReportsContent HiI need to a quick way (SQL or BI report) to get the roles assigned to reports (we have about 200 of them). I…
-
Fetching last manager name and number for the terminated employees in sqlSummary Fetching last manager name and number for the terminated employees in sqlContent Hi, Anyone know how to fetch the manager name for the terminated employees? For …Nirmal Kumar L 44 views 1 comment 0 points Most recent by Nirmal Kumar L General Transactional Reporting (OTBI)
-
Time in role reportSummary I need to create a time in role reportContent I need to create a time in role report. In our old system we had a calc which said minimum Effective Date for Emplo…Peter Kirwan 21 views 2 comments 0 points Most recent by Clyde Ramcharan-61521 General Transactional Reporting (OTBI)
-
Report Employee Photo in Custom DashboardSummary Is there a way to display an employee photo in a custom dashboard?Content We have a custom Talent Profile dashboard and I am wondering if there is a way to pull …Brenda Jacks-49721 48 views 5 comments 0 points Most recent by Sandor Banfi-52443 General Transactional Reporting (OTBI)
-
How to calculate subtotal of sectionSummary trying to get subtotal of section but it includes all dataContent Any suggestions on how to get the subtotals added to this report? Example below, want totals fo…Michelle Slobig Rotsolk 31 views 1 comment 0 points Most recent by Manoj Madhavan General Transactional Reporting (OTBI) -
Error occurs in query when we add one line in where conditionSummary Error occurs in query when we add one line in where conditionContent Hi, While adding this line in the existing query the below error occurs. Line used in where …Nirmal Kumar L 25 views 0 comments 0 points Started by Nirmal Kumar L General Transactional Reporting (OTBI)
-
Syntax to converting 24 hour time format to 12 hour format in sqlSummary Syntax to converting 24 hour time format to 12 hour format in sqlContent Hi, Anyone know the SQL syntax to convert 24 hour time format(eg. 18:00 for 6:00 PM) to …Nirmal Kumar L 25 views 1 comment 1 point Most recent by Manoj.Gupta General Transactional Reporting (OTBI)
-
Extracting Project Team Member Start DatesContent Hello How can I extract the the Person, Project Role and Start Date from OTBI or BI Publisher? I have found several subject areas where some of the information i…Aaron Leggett 17 views 0 comments 1 point Started by Aaron Leggett General Transactional Reporting (OTBI) -
Embedded Reporting/BI PublisherSummary audit report using offer fieldsContent Hello, I am trying to build a report for recruiters to use to audit the offers they have created. The intention is for the…Alice Kim, SPHR-SCP 49 views 5 comments 1 point Most recent by Alice Kim, SPHR-SCP General Transactional Reporting (OTBI) -
Calculate Yesterday date based on CURRENT_DATE variableSummary Calculate Yesterday date based on CURRENT_DATE variableContent Hello, how do I could calcolate obtain yesterday date based on current_date field in an OTBI analy…Giuseppe 1234 73 views 2 comments 1 point Most recent by RichardChan General Transactional Reporting (OTBI)
-
OTBI Data Security is not working for Documents of Record Real Time Subject AreaSummary OTBI Data Security is not working for Documents of Record Real Time Subject Areakrishiveth 19 views 1 comment 1 point Most recent by krishiveth General Transactional Reporting (OTBI) -
How to do MAX Date Logic less than Prompted AsOfDate in AnalysisSummary Trying to get the maximum Salary Change Date in OTBI AnalysisContent I am trying to convert a filter to SQL to get the maximum Salary Change Date that is less th…Brenda Jacks-49721 79 views 1 comment 1 point Most recent by rashid ramzan-45341 General Transactional Reporting (OTBI)
-
Audit Report for Bank DetailsSummary Audit Report for Bank Details - Pulls all updates on employees bank detailsContent how do I create a audit report for employees bank details. This needs to show …Peter Kirwan 74 views 1 comment 0 points Most recent by User_6T5YF General Transactional Reporting (OTBI)
-
Extracting Configuration Options via OBIEEContent Hi All I've been asked to try and export the configuration options of expenses (Setup and Maintenance > Manage Policies By Expense Category). Now, I can export t…Aaron Leggett 25 views 1 comment 0 points Most recent by Satish Kumar-21650 General Transactional Reporting (OTBI)
-
report on user account details - Role NamesSummary SQL for reporting on employees rolesContent Can someone see how to stop the multiple rows from returning in below SQL? select "PER_USERS"."USERNAME" as "USERNAME…Peter Kirwan 57 views 4 comments 1 point Most recent by Ramesh Nakka General Transactional Reporting (OTBI)
-
Return Candidate Name only for Specific CSW Selection steps/statusesSummary How to modify my SQL statement to remove redundanciesContent Hi! I've created a report to return all Open Requisitions as well as Filled Requisitions for the pas…Kim Welker 32 views 11 comments 2 points Most recent by Rahul Thomas General Transactional Reporting (OTBI) -
Help with my SQL CodeSummary Help with my SQL CodeContent I am trying to create a BIP Report to show Document Payslips pdf uploaded for each employee (with HDL) which covers the Tables like …User_6T5YF 57 views 1 comment 1 point Most recent by User_6T5YF General Transactional Reporting (OTBI)
-
SQL IS NULL errorContent Hi We're trying to create multiple reports where we want to bring back a column with no data in (e.g. Missing Bank Details where the employee does not have a ban…Aaron Leggett 33 views 3 comments 0 points Most recent by Neil Peacock General Transactional Reporting (OTBI)
-
Format prompt selectionsSummary Add specific formatting to prompted selectionsContent Is there a way to format the selections that show for prompts? For instance i need to have a prompt that fo…User_EQ8R5 28 views 4 comments 0 points Most recent by User_EQ8R5 General Transactional Reporting (OTBI)
-
StatsSummary Stat ReportContent is it possible to report where you have a count of the number of employees in a age range - the age ranges would be columns and then rows woul…Peter Kirwan 24 views 1 comment 0 points Most recent by Chris Dabel General Transactional Reporting (OTBI)
-
Pivot Table/Table Horizontal LayoutSummary Adjusting the layout of a pivot table or table from vertical to horizontalContent I need to change the layout of a sectioned Table from vertical to horizontal. I…Andy French 71 views 1 comment 0 points Most recent by JF Carpentier-23261 General Transactional Reporting (OTBI) -
Days between Step/StatusSummary OBI Days between Step/StatusContent I am trying to create a custom calculations to show the number of days a submission remains in a particular step and status. …Alexis Rivers 49 views 1 comment 0 points Most recent by Kellyzuckerman General Transactional Reporting (OTBI)
-
Days on Hold CalculationSummary Need a days on hold formula for Legacy environmentContent Hello - does anyone happen to have a days on hold formula for OBI in the legacy recruiting environment?Will Murphy 20 views 2 comments 0 points Most recent by Will Murphy General Transactional Reporting (OTBI)
-
Building a BO subquery in SQLContent Below mentioned are BO subqueries, need to use them in OBIEE. Can anyone list out anyway to do it..Anish Goswami 38 views 8 comments 0 points Most recent by Kiran Shenvi General Transactional Reporting (OTBI)