OTBI
Discussion List
-
Percentage of columnSummary Need to calculate a percentage off Median salary by various attributesContent Attached sample. I can get the first 4 columns. However, I can't come up with the r…Mike Borghoff 59 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there any easiest way to find the Fact/Measure columns in OTBISummary Is there any easiest way to find the Fact/Measure columns in OTBIContent Hi Team, I am looking for the easiest way to find the Fact/Measure columns in OTBI inste…User_2025-02-04-07-00-18-658 238 views 6 comments 0 points Most recent by User_2025-02-04-07-00-18-658 Reporting and Analytics for HCM -
Calculations - level downContent I need to build three charts that hinge off one another: 1. Average or Median salary by Gender/BU/Management level. 2. From the chart above, I need to just get a…Mike Borghoff 41 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM
-
BI Publisher, Bursting Template ConditionsSummary Only show second page of template if condition is metContent Hello I am bursting a letter to colleagues telling them the outcome of a pay review. The template ha…User_2025-01-31-17-49-32-187 53 views 5 comments 1 point Most recent by User_2025-01-30-21-52-52-008 Reporting and Analytics for HCM
-
Is SFTP possible in OTBI AgentsSummary Is SFTP possible in OTBI AgentsContent Hi Team, Is there a possibility of sending output file to third party by using SFTP in OTBI agents. Regards, Chaitanya.User_2025-02-04-07-00-18-658 61 views 4 comments 0 points Most recent by User_2025-02-04-07-00-18-658 Reporting and Analytics for HCM
-
Monthly Headcount by Assignment Status for each MonthSummary Monthly Headcount by Assignment Status for each MonthContent The business is looking for Headcount by Month by Assignment Status. I tried using the Workforce Tre…Preston Schultz 53 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Auditing Hierarchy Loops in Department TreesContent Hi Guys, Does anyone happen to have a report that is able to show hierarchy loops within a department tree? We do currently have a report that shows which manage…Ivy__Valverde 35 views 3 comments 3 points Most recent by Ivy__Valverde Reporting and Analytics for HCM -
Autopopulated Prompt with Current_Date (SYSDATE)Content Hello everyone, We have a OTBI dashboard that contains analysis that is running As-Of date parameter. As-Of reporting was set up by adding SET VARIABLE PARAM_EFF…User_KOLMZ 260 views 7 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Backend Table column value for Ethnicity "Not_disclosed"Summary Ethinicity "Not_disclosed" backed table column valueContent Hello, Im trying to find Backend Table column value for Ethnicity "Not_disclosed". Attached is the sc…
-
Need a report to get all the fast formulas in the system along with formulaSummary Need a report to get all the fast formulas in the system along with formulaContent Need a report to get all the fast formulas in the system along with formulaVer…Koteswararao Yenikepalli 46 views 8 comments 1 point Most recent by Koteswararao Yenikepalli Reporting and Analytics for HCM -
OTBI Report MigrationSummary How to migrate OTBI Reports from one company's environment to anotherContent Currently company "ABC" is using OTBI tool for analytics purpose over HCM cloud data…User_2025-02-04-22-00-05-391 56 views 3 comments 0 points Most recent by User_2025-02-01-08-03-07-149 Reporting and Analytics for HCM
-
Check for duplicate Position Codes using COUNTSummary Show count of position code to identify duplicatesContent Hi, I am using the Position Real Time subject area and I'm trying to determine which position codes are…
-
Headcount vs. Head Count DefintionsSummary There are at least 14 different headcount presentation columns in OTBI - when do you use whichContent I am new to OTBI and trying to understand when one would us…User_2025-02-04-10-47-55-876 134 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI - Manager person number as the main keySummary Is it possible to refer the manager person number as the primary key in OTBIContent Hi, Can I make a report in OTBI so all the fields (assignment status, job, de…Yaniv 66 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Custom Subject Area Content in Analysis / DashboardsSummary Receives errors when sharing an analysisContent So I built some analysis by using some custom subject content areas, i.e. Regions built from multiple locations. …Deb Luisi 56 views 3 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Payroll balance values through OTBIContent Hi All, We created custom balances in the application. We have a requirement to display custom balances and standard balances like (Gross Pay..etc) values throug…User_6I33I 183 views 2 comments 0 points Most recent by User_2025-02-04-07-00-18-658 Reporting and Analytics for HCM
-
OTBI Report for employeeSummary Unable to see employee's location in OTBI reportContent Hi We have created an OTBI analysis report containing empoyee's legal employer & work location (XML Attac…Mohit Gupta-45440 76 views 2 comments 0 points Most recent by VijayaBaskar Ranganathan Reporting and Analytics for HCM -
OTBI custom datesSummary Custom Dates in OTBI reportingContent Hi All, I want to display custom date ranges in OTBI and the corresponding headcounts for the dates. As of now, I am able t…SuryaMuralidharan 58 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Oracle Report Jam at Collaborate 2019: Here to Build Your Reporting ConfidenceSummary April 8-10 2019, San Antonio TXContent Come and meet reporting experts from across Oracle HCM product development who can build a report with you, answer your re…Gail Langendorf-Oracle 30 views 1 comment 0 points Most recent by User_V2LE8 Reporting and Analytics for HCM -
Print Amount in Arabic in OTBI ReportSummary Print Amount in Arabic in OTBI ReportContent Hi, We have developed a report where every month we sent a balance confirmation letter to customer. This balance cou…Sanin Antony T 26 views 3 comments 0 points Most recent by Sanin Antony T Reporting and Analytics for ERP -
Adding a new Essbase dimension to the OTBI subject area 'General Ledger - Balances Real Time'Summary Adding a new Essbase dimension to the OTBI subject area 'General Ledger - Balances Real Time'Content p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helveti…User_2025-02-04-20-58-40-814 45 views 1 comment 0 points Most recent by User_2025-01-28-06-00-33-387 Reporting and Analytics for ERP
-
Line Manager : Unable to see Termed Managers : Role FilterSummary Line Manager is unable to see termed workersContent Hi Team, We are trying to use the seeded Line Manager Dashboards. Unfortunately our line managers are unable …G Suman 42 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Access to reports and analysis with restriction on few TablesSummary Access to reports and analysis with restriction on few TablesContent Hi All, we have a requirement, for a learning specialist, we want to give access to reports …
-
BI Notification not generating any results because of session variableSummary Bi Notification is not generating any results because of the session variableContent Hi All, I am reusing the BI notification from the learnign community and for… -
Fusion - Goals reportingSummary Goals Approval StatusContent Hello I have found an issue where within the goals section of fusion the approval status is showing as pending approval, but when I …Andrew Braid 182 views 9 comments 0 points Most recent by User_2025-01-30-21-43-17-989 Reporting and Analytics for HCM -
How to hide Oracle HCM Seeded Report FoldersSummary Hide Oracle HCM Seeded Report FoldersContent Hello Everyone, Does anyone know how to hide Oracle HCM Seeded Report Folders? Attached is the screen-print for refe…
-
Oracle Gateway Error in OTBISummary Oracle Gateway Error in OTBIContent Hi Team, In our OTBI reports, we are getting the below gateway error Error View Display Error Odbc driver returned an error (…Harish Kumar Kovi 46 views 4 comments 0 points Most recent by Harish Kumar Kovi Reporting and Analytics for HCM