OTBI
Discussion List
-
how to create a page in UI and add dashboard into it in release 20BSummary how to create a page in UI and add dashboard into it in release 20BContent Hi, how to create a page in UI and add dashboard into it in release 20B. 20B is very d…User_MC37Q 29 views 2 comments 0 points Most recent by Mansur Khalil Reporting and Analytics for HCM -
Hiding prompt while exporting data from dashboardSummary Hiding prompt while exporting data from dashboardContent Hi Team, Can you please let me know how to hide the dashboard prompt while exporting data to excel. Than… -
Dashboard with Prompts using LSQLSummary Write analyses for Dashboard with Prompts using LSQLContent Is there a way to write analysis using LSQL(more complex, which would have outer joins etc.) which ca…Jozef Kozak 60 views 6 comments 0 points Most recent by user10465876 Reporting and Analytics for HCM
-
Can we lock the column order in the report outputSummary Can we lock the column order in the report outputContent Hi Team, Can we lock the column order in the dashboard output so that customer will not change the order…
-
Learning - Reporting on RecommendationsSummary Would like to report on who recommended learning items and to whomContent I would like to create a report to show who recommended learning items and to whom. I h…User_2025-01-25-05-06-07-246 57 views 3 comments 0 points Most recent by User_2025-01-25-05-06-07-246 Reporting and Analytics for HCM -
How to update the link for an embedded reportSummary Links for Embedded reportsContent Hi All, I am attempting to update the link for an embedded report after a recent copy from our production to test environment. …User_2025-02-04-08-51-08-912 34 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Payroll Balance Duplicating with Multiple AssignmentsContent Hi, I am trying to write a report in OTBI to pull Gross Earnings in a specific time period, and I am running into a problem where the amount is duplicating in so…User_2025-02-08-04-27-03-855 99 views 1 comment 1 point Most recent by Anshul_Khandelwal Reporting and Analytics for HCM
-
Using LIKE with FILTER() in an AnalysisContent I am trying to build a simple tile that gives the total number of employees with a job name that contains 'Director'. Example - 'Director of Compliance' I run in…User_2025-02-10-08-27-16-805 32 views 3 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
OTBI Learning - Department, job, grade... at enrollmentSummary OTBI Learning - Trying to get department, job, grade... at enrollment date (Offering Start Date) instead of actual oneContent Hello guys, As per title, I am tryi…User_2025-02-05-11-42-08-011 60 views 3 comments 0 points Most recent by User_2025-02-05-11-42-08-011 Reporting and Analytics for HCM
-
New Line of data for each variableSummary Just checking options available to prevent multiple lines if data in reportsContent Hi, I think I know the answer to this already but apart from using BI Publish…User_2025-02-05-22-44-35-842 24 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Ability to add hierarchy fields as Dashboard promptsSummary Unable to add hierarchy fields as Dashboard promptsContent I am trying to add "Hierarchy"."Level 1 Department" from Worker Assignment real time subject area as D…User_2025-02-10-08-27-16-805 29 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Hide options in cogwheel on embedded DashboardSummary As the title implies, we have a dashboard that we would like to hide some options on.Content Hi all, In the attached picture, we have two dashboards -- the botto…CIT Shane 22 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Reporting on employment contractsSummary New hires are still showing as pending workers in Employment Contracts Real Time subject area.Content I'm trying to write a report that will show all employees w…user9020833 42 views 12 comments 0 points Most recent by user9020833 Reporting and Analytics for HCM
-
Using analysis as a sub query - many values for the IN predicate errorSummary Using analysis as a sub query - many values for the IN predicate errorContent Hi, Using OTBI analysis as a sub query for a field for the another analysis . While…Phani S-Oracle 71 views 4 comments 0 points Most recent by Phani S-Oracle Reporting and Analytics for HCM
-
Briefing BookSummary Customization in content of Briefing BookContent Hello, We have created a Briefing book with combination of different analysis and schedule it. Struggling with b…User_2025-02-05-07-43-29-505 66 views 4 comments 1 point Most recent by Nithin Channa Reporting and Analytics for HCM
-
General BIP Report AssistanceSummary I have a series of questions about a BIP report I am trying to developContent Hi all, I just have a series of questions about BIP reports/Dashboards when embeddi…CIT Shane 56 views 9 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Logical SQL not recognizing Custom Fields in OTBIContent Morning all, I'm amending the Logical SQL for a report, but every time I try to reference our custom fields, the report errors out (see picture). It recognizes O…User_2025-01-28-05-39-23-766 30 views 4 comments 1 point Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM
-
Recover Deleted Report or FolderSummary How can I recover a deleted report or folder in any environment after deletion?Content Hi all, I would like to know if there is a recover option when a report or…User_2025-02-05-05-51-12-049 79 views 2 comments 0 points Most recent by Karina Ogata Reporting and Analytics for HCM
-
Emergency Contact Details Report - Required Duty/Data RoleContent Hi All, We have created Emergency Contact Details Report from Person Subject Area to support our Business Continouity agenda (attached). We have two custom roles… -
Workforce Management - Position Real Time - Missing Assignment CategorySummary Unable to find Assignment Category field in Position Real Time subject AreaContent When creating a position, we are using 3 fields on the setup - Assignment Cate… -
Need past 8 years historical data based on a effective date-OTBI analysisSummary Need past 8 years historical data(Counts based on their color) based on a effective date-OTBI analysis, We need to show data in a Graphical format attached.Conte…Nithin Channa 50 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Absence Report showing Annual Accrual, Carryover and remaining balanceSummary Require a report that will show the employee absence information for reporting purposesContent Hi All, I need some help in trying to figure out where my numbers …User_2025-02-04-08-51-08-912 485 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Current Performance Document TaskSummary Looking for a report showing only the current document taskContent We are looking for a report, one line per employee, that would list the current step that thei…
-
Is there any way to connect Oracle Fusion OBI from SQL ServerContent H Is there a way to connect to Oracle Fusion OBI server to our local SQL Server? We would like to report on Data in conjunction to our local HRIS system. Thanks,…Nizar Kassam 50 views 8 comments 2 points Most recent by Nizar Kassam Reporting and Analytics for HCM -
How to get the Latest Hire Date of Employee and compare the same with DFF attribute in OTBI AnalysisSummary How to get the Latest Hire Date of Employee and compare the same with DFF attribute in OTBI AnalysisContent Hi All, We have a DFF attribute called Beneficial ser…
-
Combining Pay Dates in a ReportSummary Need to combine all Results by Date Paid into one Number by MonthContent Greetings, I have a detailed pivot table that displays the run results by pay period by …Thomas Drzaic 25 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need to display Hire details from last six months in OTBI reportContent Hi All, We have a requirement to display HIRE Employees from last six months in OTBI report. In OTBI analysis we selected "Workforce Management - Worker Assignme…
-
SUBSTRING & DESCRIPTOR_IDOF Conditions in OTBISummary SUBSTRING & DESCRIPTOR_IDOF Conditions in OTBIContent Hi All, Can some one explain to me that how does the below conditions work and what's the in detail meaning…
-
Caution -> Inappropriate Content through re-direct links in Sample OTBI Dashboard (change link for cContent Hello, The seeded 'Sample OTBI Dashboard' (Profiles / Assignment Details and Drill to Person Gallery') has a link which goes to 'inappropriate content'. I guess …SantoshKumarBhairi 83 views 2 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
OTBI Custom Reports - User Interface Language Issues (English vs French)Content Hello, Can anyone please help me with these two questions? 1) created a custom report (based on seeded SubjectAreas) and renamed the columns in English. When Use…SantoshKumarBhairi 58 views 9 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM