OTBI
Discussion List
-
Ethnicity values question in Recruiting Subject AreaSummary: Asking for assistance in understanding the difference between 2 Ethnicity fields Content (required): Hello. Can anyone advise on the difference between the 2 fi… -
OTBI - Calculate Tenure using Presentation VariableSummary: I need show Tenure calculation by subtracting the Work Relation Start Date of a person from the Date passed by the user against the presentation variable (Promp…Harpreet Shergill Oracle 102 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI analysis column content does not wrap when added to dashboardSummary: OTBI analysis column content does not wrap when added to dashboard. Content (required): Standalone OTBI wraps text but when added on dashboard text is not wrapp…Adil Muhammad 25 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Unable to scroll Subject Areas with UnionSummary: When trying to use the "Combine results based on union intersection and difference operations" I'm unable to scroll past the initial list of Subject Areas to th… -
Handling Invalid Dates in a CASE statement in OTBISummary: How do you replace 00--0 with an actual date in OTBI? Getting error with CASE statement below Content (required): My CASE statement is coming back with an error…
-
How to get Active Bank Account DetailsHi Experts I am trying to write a query to get Active Bank Account Details for a given employee. I am not sure in which table and column this flag is stored. I checked "…Dharmendra Shukla 507 views 4 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
Need inputs for 401k Contribution ReportSummary: Need inputs for 401k Contribution Report Content (required): Hi Team Greetings! This is about getting the details for 401k contributions report including deferr…Parag Hiremath 82 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
How do you include inactive requisitions in an analysis?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Ed Sevilleja 55 views 4 comments 0 points Most recent by Ed Sevilleja Reporting and Analytics for HCM
-
How to report on Date Paid in last 12 monthsSummary: I have a report using the Payroll Balances Real Time subject area. The requirement is that when the report runs on the first day of every month, the output is f…
-
Reporting on ICD/Manage Personal Contribution Requests that have been SavedSummary: Content (required): We use Individual Compensation Distributions for our employees to claim for irregular payments (overtime worked etc.) as we are not yet usin…Leanne W 50 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Annualized TurnoverSummary Want to incorporate an annualized turnover in my Turnover DashboardContent Is there currently anything with annualized turnover, or do I need to formulate someth… -
How to apply a 'Custom Theme' to OTBI reports/dashboards.Summary: How to apply a Custom Style Theme to dashboard and reports to align to Company standard. Content (required): is it possible within OTBI to generate and apply a … -
Timecard status reportSummary Trying to retrieve a report in Fsuion which gives timecard at its different status of its lifecycle.Content Does anyone know of a report that would give the time…Shelly-Ann Mahabir 90 views 4 comments 0 points Most recent by Shelly-Ann Mahabir Reporting and Analytics for HCM
-
The promt does not affect the analysis report on the Dashboard screen.I have an analysis report that I use on the dashboard screen and parameters that I expect to affect this report, and one of these parameters does not affect the report, …Cansel Karasoy 66 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Which table stores the "Assign as" information for initiativeSummary: Hello All, I am trying to build a report to fetch learning initiative details but i am not finding any information regarding the assign as column in the UI.Plea…minati_behera-Oracle 54 views 3 comments 0 points Most recent by minati_behera-Oracle Reporting and Analytics for HCM
-
How can i query the "Active" Organization Tree version description?Summary: How can i query the "Active" Organization Tree version description? Content (required): I'd like to be able to return the value / name of the Version ID tied to…Shant Karakashian 2.8K views 3 comments 0 points Most recent by Shant Karakashian Reporting and Analytics for HCM
-
Syntax for comparing numeric plain text value with number valueSummary: Requirement is to build analysis to identify employees whose payroll run result of a particular element does not match a corresponding value held in assignment …Alastair Wood 40 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Unable to find the Subject area/SQL query to get the Final close date value in the PayrollRelationUISummary: In the Payroll Relationship UI we have final close date value at the Element duration dates as well as Assignment level. I am unable to find any subject area/SQ…
-
Tile visual errors when The Table Visual is not added to ViewSummary: Hi, can anyone please help with the error message that appears when Table visual is removed from the view leaving the Tile visual in view. Content (required): T…
-
Job Incumbents 10th 25th 50th 75th 90th incumbent baseSummary: We are building an otbi dashboard that can be leveraged to report on incumbents jobcodes and paygrade ranges. We have the base report with jobcodes and number o…Akshay.Agarwal 43 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Sharing Recruit to Hire Dashboard -- download catalog fileSummary: I know I have seen a posting that shared the delivered Recruit to Hire Dashboard in a customizable download file. Can someone share the link to that posting? I …Ellen Manthei 66 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Pivot table help - Measures dont sumSummary: Measures in a pivot table do not sum, instead appear as a 1 regardless of total. Content (required): Im new to OTBI and dislike pivot table (OTBI, excel, anywhe…
-
Need A Dynamic way of setting Date Parameters to begin with the 01st AprilSummary: Hi, I need to schedule an OTBI report that looks at changes made to a salary from the 01st April to the last day of the previous month. For example the report s…
-
Manager Details (more than one)Summary Writing an OTBI Report which pulls all of an employee's managersContent Hello, We record two managers for each employee at our company. One is the line manager a…John Gerbracht 106 views 8 comments 0 points Most recent by Kris Cregger Reporting and Analytics for HCM
-
How can I add the manager information of the employees to the Analysis report?I want to add the managers of the employees such as 'head,c-suite,sr.head' to the report I prepared from the analysis report. When I get this information from the "Matri…Cansel Karasoy 47 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Termination report for multiple work relationshipsSummary: I need a true termination report for when someone leaves an organization with multiple legal employers, and they have multiple work relationships. I know there …Jessica D 64 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Using COUNT function in Excel Template in BI PublisherSummary Using COUNT function in Excel Template in BI PublisherContent Hi All, Can someone please provide an example of how to use the count function in BI Publisher Exce…Aloka Bhattacharya 330 views 2 comments 1 point Most recent by Valeriy Gorbunov Reporting and Analytics for HCM -
How can I use parameters that work independently from each other on a single dashboard screen?Hi, I have multiple reports that I use on the dashboard screen and my 2 reports have promts. And from these separate promts there are common ones. I want to use the sepa…Cansel Karasoy 37 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Need to customize a workflow notification but cannot see 'Customize' in the More dropdownSummary: Need to customize a workflow notification but cannot see 'Customize' in the More dropdown. I have a custom BI Admin role. Am I missing a permission to be able t…PrJohns-Oracle 36 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Need to fetching displayvalue of payroll time type from time entry layout component.Summary: Hi, We want to fetch the display value of the payroll time type from the time entry layout component. I am not able to find it in any OTL subject area. Has anyo…Piyush Pokharkar-Oracle 42 views 2 comments 0 points Most recent by Piyush Pokharkar-Oracle Reporting and Analytics for HCM