OTBI
Discussion List
-
What does DATA_DS G_1 mean in BIP?Summary What does DATA_DS G_1 mean in BIP?Content Hello All, I am running a SQL in BIP and it is returning DATA_DS G_1 (see attached SQL and screenshot of DATA_DS G_1). …User_2025-03-07-21-07-25-805 428 views 6 comments 1 point Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for HCM -
Donuts instead of PiesSummary Is it possible to output Donut charts instead of pie charts?Content Most modern dashboards contain at least one donut / doughnut chart. Few contain pie charts an…User_2025-01-23-23-50-04-709 102 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Top N querySummary Filter top 5 leaving reasonContent Hi, I want to create a report that shows the top 5 reasons of leaving (e.g. 'found another job", "Low salary" etc.). I know wh…
-
Department tree versions issueContent Hi , Department tree having 2 versions , both are active , old version is end dated 31/12/2016 and new version is starts from 1/1/17. In new version existing dep…
-
Manager Types in reports - HELP NEEDEDContent Hi All, I want to create a report that will show the manager type + manager name for each employee. i.e. Person Name Manager Type Manager Name Dudi Levi Line Man…Dudi Levi 98 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Locate setup/configuration tables in reporting/analytics toolSummary Locate setup/configuration tables in reporting/analytics toolContent We are discussing where set up tables can be located in the Reporting tool. For example, we … -
SQL Expression for a specific month and day with a year of current year - 1Content Hi - I need to add a filter to an OTBI report that is hire date greater than 10/1 of the prior year. I would like to make the year dynamic based on the year of t…Julia SRI International 144 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Phones and emails make duplication rowsSummary I'm trying to add columns for emails and phones but instead of one line it's duplicating itContent Hi, I created an analysis in OTBI that shows employees phones …
-
Does Drill down feature work for Logical SQL based Analytics?Summary Want to know if the drill down feature works with analytics developed using Logical SQLContent For one of the requirement it was not possible to use the fields d…Sricharan Monigari 89 views 6 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Can we expose analytics or dashboards to users on fusion pages without traversing to BI CatalogSummary Can we expose analytics or dashboards to users on fusion pages without traversing to BI CatalogContent We have developed some analytics and dashboards and the cl…Sricharan Monigari 109 views 11 comments 0 points Most recent by Lynda Huebsch-Oracle Reporting and Analytics for HCM
-
Cross Subject Area Dashboard OptionSummary Need to join multiple subject area for dashboard purposesContent Hi, I apologize in advance if this is already discussed in some previous thread- if that is the …User_2025-01-30-19-26-42-218 47 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Payroll Activity ReportSummary Page breaks in Payroll Activity ReportContent Hello, It would be really nice if the payroll activity report could page break between person. I think it would mak…Susan Anderson 159 views 3 comments 1 point Most recent by Richard Marko-47911 Reporting and Analytics for HCM -
Publishing a custom dashboard to one user from OTBI in HCM FusionSummary Need assistance in publishing a custom dashboard in OTBI out to a single userContent I have a custom dashboard that I only want one user to have access to. I kno…User_2025-01-25-04-17-41-399 144 views 8 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
Lost 'Add subject area' functionality in OTBISummary Lost 'Add subject area' functionality in OTBIContent Hello, Since this morning, we lost icon that lets you to add additional subject-area during report creation.…SantoshKumarBhairi 59 views 12 comments 2 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
Search a date un value of columns that containts multiple date (DD/MM/YYYY ~DD/MM/YYYY ~DD/MM/YYYY )Summary How to search for date of birth in the actual year from value which contains many datesContent Hello, I want to find persons which their date of birth is in the …User_I6AXL 30 views 3 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
Absence leave duration issueContent Hi, I am unable to get the correct leave duration in the analysis , employee has applied for 0.5 days leave , but in the analysis it is showing as 1 day , I have…
-
CONCAT Area Code and Phone NumberSummary I want to combine an employees work, home, and cellular phone number so area code isn't a seperate columnContent Using this forum topic https://cloudcustomerconn…User_2025-01-28-08-47-04-905 131 views 5 comments 0 points Most recent by User_2025-01-28-08-47-04-905 Reporting and Analytics for HCM
-
Creating a Filter Based on Staff with Multiple Rows of Data in AnalysisSummary Creating a filter that will only produce records when an employee has more than one row on the reportContent Hi- I'm working on building a report to focus specif…Bernadette L 56 views 2 comments 0 points Most recent by Bernadette L Reporting and Analytics for HCM -
Error on InfoletsSummary I've created two simple infolets for employees to see HC and FTEContent I've created two simple infolets for employees to see HC and FTE - but when then go to th…User_2025-01-29-19-59-40-005 68 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Traversing Department Tree in Reports with a ParameterSummary The ability to use one parameter in an otbi report for the department hierarchy as opposed to the multiple levels of departments being handled individuallyConten…User_2025-01-25-00-51-33-059 148 views 7 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Best Practice for text formattingSummary Building and exporting reports with text fieldsContent In building out a report around goals we're encountering issues with exporting the data. If we export the …User_2025-01-28-08-47-04-905 49 views 4 comments 1 point Most recent by User_2025-01-28-08-47-04-905 Reporting and Analytics for HCM
-
Grouping monthly figures to create YTDSummary Grouping monthly figures to create YTDContent Hello, I am trying to create an OTBI report within the Subject Area called 'Payroll - Payroll Run Results Real Time…User_2025-01-30-03-54-32-528 67 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Static Data ColumnsSummary Is there a way to 'repurpose' a column from an OTBI subject area with a static data value, conditionally?Content Hello Customer Connect Community! Is there a way…User_2025-01-22-19-43-38-766 41 views 3 comments 0 points Most recent by User_2025-01-30-03-53-16-644 Reporting and Analytics for HCM
-
"Private" goal measure in Goals reportsSummary TRying to identify the right measure to use in an analysis to show private goalsContent Hi there, in OTBI I'm trying to create a Goals reports by creating an ana…User_2025-01-23-23-26-05-357 42 views 3 comments 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM
-
Show those with No Goals in a Goal ReportSummary Creating a report which shows those with no goals in a particular goal planContent I'm looking to create a report that shows a count of goals for users along wit…User_2025-01-22-19-54-00-543 90 views 4 comments 0 points Most recent by User_2025-01-22-19-54-00-543 Reporting and Analytics for HCM
-
OTBI Analysis- Column PropertiesContent I have created an OTBI analysis based on Workforce Performance - Performance Rating Real Time subject area. Requirement is to review employee goal and competenci…User_2025-01-28-21-18-43-496 85 views 2 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
What job role gives access to Human Capital Management – Approval Notification Archival Real Time suSummary What job role gives access to Human Capital Management – Approval Notification Archival Real Time subject area ?Content What job role gives access to Human Capit…Ruzwan Akram 81 views 2 comments 2 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Fusion Field - OTBI Subject / Folder MatrixContent Afternoon all, Is there a master matrix anywhere that lists fields in Fusion and cross-references them to their location subject area / folder / sub folder in OT…User_2025-01-28-05-39-23-766 119 views 2 comments 1 point Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM
-
Valid Job Grade reportingSummary We are trying to determine if we have muliple Valid Grades for Job CodesContent We found some Job Codes with multiple Valid Grades and I am having difficulty wri…User_2025-01-23-21-24-21-434 147 views 5 comments 2 points Most recent by Nitin.Goswami Reporting and Analytics for HCM
-
Workforce Management - Timecard Application RoleContent Hi All, We are currently struggling to obtain data from: "Workforce Management - Processed Time Cards Real Time" "Workforce Management - Reported Time Cards Real…Aaron Leggett 31 views 2 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM