OTBI
Discussion List
-
Bursting Query table from the reportsSummary: Bursting Query table from the reports Content (required): Hi Team, Greetings! Is there any table(s) which holds the queries included in the bursting query in th…Parag Hiremath 437 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Best practice for reporting on incomplete allocated checklists?Summary: Hi All, Does anyone have any "best practices" for reporting on incomplete allocated checklists? We have a business case to report on number of incomplete checkl…William_Johnson 61 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Report on Training Hours for each learnerSummary: Hi all, We are trying to report on each learner's hours during one year - has anybody been successful in building this in OTBI? Thank you in advance for your re…Cora_Stanciu 31 views 3 comments 0 points Most recent by Emily Robinson Reporting and Analytics for HCM
-
CAGR(Compound Annual Growth Rate) Calculation in OTBISummary: Creating an OTBI analysis to calculate CAGR of the joiners in my org in last 3 years. Content (required): I am trying to calculate CAGR of the joiners in my org…Dinky Dudeja 51 views 2 comments 0 points Most recent by Dinky Dudeja Reporting and Analytics for HCM
-
How to generate employee listing report in Oracle fusion?Summary: Content (required): Employee Listing report Version (include the version you are using, if applicable): Oracle Fusion Cloud Applications 23A (11.13.23.01.0) Cod…Radha, Rangu 664 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Unable to display recently created courses on reportSummary: Sorry, another question about the Learning Records subject area. Content (required): I need to create a report which includes all of our EDI training. Again, I'… -
OTBI->Cloud Benefits Sample for 401k, 403B, etc. Enrollments by Gender, Ethnicity, Participant CostsSummary: This is part of a series of sample reports created by Oracle BI and HCM Product Management. You can copy the setup for this report and add it to your Oracle HCM…Adam Gates-Oracle 41 views 0 comments 0 points Started by Adam Gates-Oracle Reporting and Analytics for HCM -
Can the parameter affect both the row and the column in the Matrix report prepared from the analysisI have a matrix report that I use on the Dashboard screen, and the column information consists of job name information. The row information is also from the locations. a…Cansel Karasoy 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Error Code U9KP7Q94Summary: Path not found - Check input path entered Error Codes: U9KP7Q94 Content (required): Hi All, Has anyone run into this problem before? We archived and unarchived …William_Johnson 283 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Best practices for Journeys reporting in Workforce Management - Checklist Real Time subject area?Summary: Subject Area: Workforce Management - Checklist Real Time Need: Leverage best reporting practices to drive adoption rates and system monitoring for allocated jou…William_Johnson 102 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Subject Area for Override LocationSummary: We have a requirement to query 4 different types of address for employees. HOME, US Resident Tax, Work Location and Override Location addresses. I am able to qu… -
Learning Records subject area - Assigned Learning Item InformationSummary: A couple more questions, about the Learning Records subject area: Content (required): 1) Assigned Learning Effective Date (Assigned Learning Item Information) O…
-
compare two project budget versionsSummary: Please confirm how to compare different versions of budget from UI or using OTBI? Content (required): Version (include the version you are using, if applicable)…
-
Security on OTBI reportSummary: Hi, We prepared an OTBI report on programs/projects. We are able to view all the data in the reports irrespective of Business unit/project unit/ project organiz…Santhi Sree 261 views 3 comments 0 points Most recent by Shivashish Dwivedi-Oracle Project Management
-
Analysis error - Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PSummary: Analysis of 3 Subject areas, if no prompts are selected, produce report, when selecting a prompt, analysis result in error Content (required): Analysis of 3 sub…
-
Reading SQL Error CodesSummary: Hi All, Does anyone have any documentation/point me in the direction of resources that would help us read standard SQL error codes when working in OTBI? Include…William_Johnson 44 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to run current effective structure (BOM) explosion reportSummary: I have item structure which has been redlined components and effective-date as future date. I try to run OTBI report to see current structure, not future revisi…
-
How do I show all completions for same Course Title in OTBI report?Summary: OTBI report to show completions only shows first completion if title is the same. Need to get OTBI report to show the same data as the View Transcript (which ca…Aaron Reynolds 82 views 6 comments 0 points Most recent by Aaron Reynolds Reporting and Analytics for HCM -
Reporting on count of incomplete/complete Journeys in OTBI?Summary: For OTBI analyses - our organization needs to be able to report on the following in the Workforce Management - Checklist Real Time subject area: 1) Total number…William_Johnson 491 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Impact Rating Model column filter breaks analysisSummary: Subject Area: Workforce Profiles - Person Profiles Real Time Column: Impact Rating Model Content (required): Hi All, We run into an error under the Workforce Pr…William_Johnson 21 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
OTBI Learning records report for a Line Manager including not only Direct but also IndirectSummary: Content (required): Hi there, i cannot find an answer to the above question. We have line managers who want to see the learning completions of the direct report…Bobby Jourdan 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM