BI Publisher
Discussion List
-
CASE statement THEN valueContent I would like to add a case statement logic where if a condition holds true, a column value is displayed. But in addition to the value being displayed from the sy…User_2025-02-10-08-27-16-805 25 views 2 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM -
Ethnicity bar graphSummary Bar graph does not match tabular view.Content I am trying to pull employee ethnicities from the system. I have come across multiple posts on how to bucket employ…User_2025-02-10-08-27-16-805 68 views 6 comments 1 point Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
Direct Report Headcount in OTBI?Summary Are there any fields in OTBI which can pull a manager's direct reports / headcount, or otherwise indicate that they are a manager?Content Are there any fields in…Monica Fundak 53 views 3 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM -
Sample Workforce Compensation BIPContent Hello experts, where could I find sample Workforce Compensation BIP? I need to build a BIP report allowing managers to see their direct/indirect reports for the …Valerio Curzi 52 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
BIP Report Jobs IssueContent Hi all, I asked a couple of weeks ago about changing the privacy of Report Jobs from Private to Public which was answered here: https://cloudcustomerconnect.orac…
-
Head Count as of given dateContent Hi Experts, We are looking for a report which has the below data point. The worker subject are giving information as of date and in the current requirement we ne…Kiran Kancherla 36 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Instance identifier in BIP reportSummary We need specific report to run only if it is on specific instance (say Test POD).Content We need specific report to run only if it is on specific instance (say T…Priyanka More-Oracle 174 views 5 comments 1 point Most recent by Priyanka More-Oracle Reporting and Analytics for HCM
-
Table for Attachments under position profileContent Hi, Can someone help me with the table contains the attachment information under position profile? Regards, NivyaNivya Mathire 92 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How to load sample report in Oracle HCMContent Hello experts, I need to load a custom template as example in Oracle HCM. I want to load an image showing a sample performance document. In addition, I have crea…Valerio Curzi 32 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Simple logical sql query fails to load in data modelSummary Simple logical sql query fails to load in data modelContent We were trying to create a data model with Simple query(Name = Any , Data Source = Oracle BI EE, Type…Sreedharan-Oracle 72 views 7 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Question on .catalog filesContent Hello Experts, I got two questions (probably a weird ask) on BI catalog objects. In /analytics (OBIEE), the archive will create a .catalog file instead of a.xdo/…Akash Kiran Jana 139 views 5 comments 2 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM
-
How to remove an unwanted character in rtf template (PDF Output)Summary How to remove an unwanted character in rtf template (PDF Output)Content Hi Experts, We are generating confirmation letter with PDF format for this we are using R…Bala Kasineedi 518 views 4 comments 0 points Most recent by Bala Kasineedi Reporting and Analytics for HCM
-
How to fetch the deleted goalsSummary How to fetch the deleted goalsContent Hi, We are in REL 13 20 D. Our customer want to fetch the Goals details of the employees which are deleted. Could you pleas…Radha Devi P 91 views 13 comments 1 point Most recent by Radha Devi P Reporting and Analytics for HCM
-
Absence Calendar Details Real Time - Incorrect Data in ReportContent Hi Experts, We have created a OTBI report in which we are getting the results as per leave type and for one specific leave type, we are getting very small (Incor…Kiran Kancherla 25 views 1 comment 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Extract Projected Accrual Absence Balance in HCM/BIP reportSummary Extract Projected Accrual Absence Balance in HCM/BIP reportContent Hi Experts,We have a requirement to fetched projected Absence balance of employee in extract t…Rajeev Nayan 671 views 6 comments 3 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
We need to fetch all active records from current Organization Tree for department structureSummary We need to fetch all active records from current Organization Tree for department structureContent Hi Experts, We need to fetch all active records from current O…Balaganapathi Kasineedi 67 views 6 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
How to export OTBI report including Personal Photo?Summary Need to crreate an OTBI with Personal Photo and Export successfullyContent Dear Experts: I have builld an Employee List report with Personal photo as a columon. …Mayi218-Oracle 73 views 1 comment 2 points Most recent by Seiichiro Yasui Reporting and Analytics for HCM
-
Organization Levels, Organization Manager Names, and their Effective DatesSummary Organization Levels, Organization Manager Names, and their Effective DatesContent Hi Experts, Good day! Can you please help and guide or redirect me to resources…Raymund Jerome 12 views 4 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM
-
Report to show all future approversContent Hi, Does anyone know of a report or way to query, all future approvers in an approval chain for notifications. For example, next approver is person x, then once …
-
Need Employee Leave Balance Report ?Summary Need any pointers/hints for building Employee Leave Balance ReportContent Expected Layout Parameters Effective Date : 06-Jul-2015 Employee Leave Balance Report P…AshishERPCloud 718 views 10 comments 5 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
How to get link between Plan, Plan option and Elements for individual compensation plans?Summary How to get link between Plan, Plan option and Elements for individual compensation plans?Content Hi Team, We have a requirement where to fetch all the elements a…Harish Kumar Kovi 128 views 6 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Promotion SpeedContent Hi All! Has anyone had luck working on promotion speed ratios out of OTBI? Diving into this in the next week or two and wanted to see if anyone else has worked o…Lauren Owen 28 views 3 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to replace DATA_CACHE with XML_DATA_CACHE syntax in Oracle BIP Data Models?Summary How to replace DATA_CACHE with XML_DATA_CACHE syntax in Oracle BIP Data Models?Content Hi Experts, We came to know that Oracle deprecated 'DATA_CACHE' column and…Harish Kumar Kovi 118 views 4 comments 0 points Most recent by Harish Kumar Kovi Reporting and Analytics for HCM
-
Combining Oracle HCM and data from external sourceSummary How to create a data model for BI report using combination of Oracle and external dataContent Hello All, I need to generate a CSV file, to be sent periodically t…User_K90ZS 54 views 6 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
BI excel template xsl when otherwise tags giving data in different format with extra spacesSummary BI excel template xsl when otherwise tags giving data in different format with extra spacesContent Hi All, In one of the custom BI report we are using excel temp…User_XT9HW 36 views 1 comment 0 points Most recent by Pradeep Sharma-14802 Reporting and Analytics for HCM
-
Table and Column for Override Average Weekly Earnings field on Maternity LeaveSummary Table and Column for Override Average Weekly Earnings field on Maternity LeaveContent Hi Experts, We have a requirement to fetch the Override Average Weekly Earn…Rajeev Nayan 70 views 2 comments 0 points Most recent by Rajeev Nayan Reporting and Analytics for HCM
-
BIP Report Scheduling IssueContent Hi all, I'm currently in the process of scheduling the reports we've built using BIP data models, but we've noticed that all schedules that I've created only sho…
-
Restrict to run reports for delivered Employee RoleSummary How to restrict with delivered Employee Role to run reports from BIContent Hi Experts, We have noticed that general Employees have access to run reports (like Pa…Rakesh Ankusham 53 views 6 comments 1 point Most recent by Aaron Leggett Reporting and Analytics for HCM
-
Behaviors tagged under each competency in Talent profileContent Hi, Can someone help me with the database table where we get the Behaviors tagged under each competency? Regards, NivyaNivya Mathire 6 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
HEX values for seeded pie chart colorsSummary HEX values for seeded pie chart colorsContent I have built a pie chart for Performance ratings for a Dashboard. The systems default to 3 colors - Yellow, Blue an…User_2025-02-10-08-27-16-805 22 views 2 comments 2 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM