OTBI
Discussion List
-
Report with null data between tablesContent Hello experts I've managed to make an interaction between 2 tables in OTBI DataModel. Then I need to create a report. The problem is the report does not show the…Pedro Teixeira 15 views 7 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Can we hide a Performance Tile based on a value of a column in the OTBI Analysis Criteria?Summary Can we hide a Performance Tile based on a value of a column in the OTBI Analysis Criteria?Content Hi, We have a requirement were we need to hide a Performance Ti… -
Query Absence Pending TransactionsContent Hello experts. I'm trying without success to create a report that gives me the history of transactions. Category - Status - to whom - initiated at - Approver (As…Pedro Teixeira 339 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Need Training Calendar Report FormatSummary Need Training Calendar Report FormatContent We have a requirement where we need to present a training calendar to employees for upcoming ILT offerings month wise… -
Reporting on reversed terminationsContent Hi all, I have searched on this topic but have not found a working example of this report or confirmation that it can be done. Can anyone advise whether it is po…
-
SCM – Using Manufacturing Cloud’s Library of REST Services, 13 January 2021, 8 a.m PT - Submit QuestContent Submit your questions for the SCM – Using Manufacturing Cloud’s Library of REST Services session to have them answered during the live event. Post your questions…
-
How to Create an initiative with a dummy destination objectSummary Need a dummy initiative with a linked analysis(in OTBI) so that we can use this initiative in migrating midstream assignments from legacyContent We are trying to… -
How to modify existing OTBI analysis built using Logical SQL?Summary I am new to Logical SQL OTBI reports and want to know how to make modifications to an analysis once I created it using logiical? I have to add a new column and p…User_2025-02-05-23-02-13-475 300 views 10 comments 2 points Most recent by User_BUU5W Reporting and Analytics for HCM -
Change the language of the text in RTF template.Content Hi Experts, I am looking for a function for RTF template using which I can change the Language of the text. for eg: Orignal Data- English: One Thousand Two Hundr…Jaswant Prajapati 388 views 3 comments 1 point Most recent by Misbahul Khair Reporting and Analytics for HCM
-
Who hasnt submitted a TimecardContent Hi all We have been live with HCM for a year and i have been tasked with providing a report that shows who has not submitted a time card. The seeded reports dont…Dawn Cawston - CPS 87 views 1 comment 0 points Most recent by SameerJain Reporting and Analytics for HCM -
Unable to access reports and analytics after userid changes in OTBISummary User no longer is able to access reports and analytics. Receives error 'Unable to reconnect (after 3 tries) to BI Presentation Server using the connection Id =BI…
-
Number of receipts made in a periodContent Hello I am trying to find out the number of receipts made between certain dates, but I am struggling to find the correct subject areas, or BI tables which contai…Helen Thomas 33 views 2 comments 3 points Most recent by Helen Thomas Reporting and Analytics for SCM
-
Unable to Combine 2 Subject Areas throws error.Summary I am trying to combine Compensation salary history and payroll element history Subject area it throws me error. If someone can help out or would appreciate if th…User_2025-02-07-09-10-02-492 54 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Converting what pulls through as text to a numberContent I have created a report in OTBI but the 'Displayed Input Value Meaning' is coming through as a text field rather than a number field and ideally I would like to …User_2025-02-06-11-18-47-896 939 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Invalid Payroll Transactions in the SubledgerContent We have been up for a year on Oracle and have had a very rocky go of it. We have about 50k (yep thats right) invalid transactions for 2020 in the subledger from …Rebecca McArthur 30 views 2 comments 0 points Most recent by Rebecca McArthur Reporting and Analytics for HCM
-
Field School Empty in Subject Area “Workforce Profiles – Person Profile Real Time”Content Hello All, We have created the following report “Report Degree” which uses the subject area “Workforce Profiles – Person Profile Real Time” and the following col…Bernard T 77 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Point in Time - Home Address for EmployeesSummary Point in Time - Home Address for EmployeesContent Does anyone know if it is possible to create a report that returns employee's home address as of a specific dat…Kathleen Nguyen 27 views 8 comments 1 point Most recent by Kathleen Nguyen Reporting and Analytics for HCM
-
Misalignment of DatesContent Hi all - I have an issue I've not experienced before. I have an LSQL for a changes report I am working on, and I am pulling in the Last Update Date for the assig… -
Subject Areas in Union analysisSummary Only the primary subject area is visible in a Union analysisContent Hi, We're busy building reports ahead of a not-too-distant implementation of Cloud for HCM & …User_2025-02-08-05-56-00-229 46 views 7 comments 0 points Most recent by User_2025-02-08-05-56-00-229 Reporting and Analytics for HCM
-
How to Add Worker Details to Job Details in a single report in OTBIContent Hello, I am trying to add the following under Workforce Management-Worker Assignment Real Time subject area: Job-> Job Name, Job Code and Level Worker-> Name Whe…User_2025-02-10-12-13-36-181 21 views 4 comments 0 points Most recent by User_2025-02-10-12-13-36-181 Reporting and Analytics for HCM
-
Set Column Filter Formula to 'Full Time' - Dashboard TileSummary I've created a headcount dashboard with tiles by employees, contingent worker, Full Time, Part Time, PRN. I've created a column filter formula for all of the til…Monique Moore 10 views 1 comment 1 point Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Action Link LayoutContent Hello experts. I'm trying to use action link. but I'm also unable to edit the layout. I'd like to make it like abutton, not a single stream of text as default. A…Pedro Teixeira 40 views 9 comments 2 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Question marks in attributes causing filtering troubleContent Hello Experts, We've encountered a situation where a course has been setup in our learning module with a question mark at the end. We've found that when we try t…Rob F 12 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Learning in OTBI - subject areas changing in 2021?Summary In a recent product forum or webinar it was highlighted that by 21B there will be a subject area called 'Learning Assignments' deprecatedContent In a recent prod…
-
Can we create the output as .txt file in analysisSummary Can we create the output as .txt file in analysisContent i have created a analysis to fetch the assignment number for all the employees.but we need the output as…User_2025-02-05-02-11-29-794 34 views 8 comments 0 points Most recent by Denise Izzi Reporting and Analytics for HCM