BI Publisher
Discussion List
-
Pay Period Start & End Date IN BI ReportSummary Pay Period Start & End Date IN BI ReportContent Hi ALL, Can someone help me, I'm looking for Pay Period Start and END Date. Which table do i need to refer to get…User_2025-02-07-19-03-14-525 38 views 4 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM -
Masking functionality in ReportsContent Masking functionality in Reports Do we have any functions in OTBI/OBIEE or in BI Publisher/Templates/XSL functions to perform a masking functionality for some cu…Shivakumar Ayyanagowdar-Oracle 59 views 7 comments 1 point Most recent by Karina Ogata Reporting & Analytics for Sales -
Dashboard BI Publisher Report SecuritySummary Dashboard not retaining user securityContent I have created a dashboard report from a BI Publisher report using a data model. During testing, I have noticed the …Shelly Feyerherm 108 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
How to: Translate BI Publisher Report ParametersSummary I wish to know if it is possible to translate BI Reports parameters based on user environment language.Version Oracle BI 11.1.1.9Nalinee Uppiah 128 views 7 comments 0 points Most recent by Nalinee Uppiah Reporting and Analytics for HCM -
Can we query the list of custom BI reports and OTBI analysis in our instanceSummary The requirement is to pull the report name,report path, parameters and other corresponding attributes of a reportContent Hi, The requirement is to pull the repor…User_2025-02-07-18-15-37-534 61 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Salaries in WordsSummary I Need to put in Word Template the Salaries in wordContent I need to put in template WORD (bi publisher) , the salary in full (Words) can someone help me?Jorge Donaire-229567 54 views 8 comments 1 point Most recent by Sahil_Makhiza Reporting and Analytics for HCM -
Employee, Manager, Department Head ( Director & up ) and Division Head ( VP & up) in a report.Summary Employee, Manager, Department Head ( Director & up ) and Division Head ( VP & up) in a report.Content HI, I'm planning to build a BI Report having Employee, Mana…User_2025-02-07-19-03-14-525 51 views 9 comments 0 points Most recent by Mishra Ankit Reporting and Analytics for HCM -
Dashboard Prompt from BI ReportSummary Dashboard Prompt from BI Report does not workContent I have created a dashboard from a BI Report. I have attempted to set up a prompt but it isn't working. Can s…Shelly Feyerherm 95 views 1 comment 0 points Most recent by Sahil_Makhiza Reporting and Analytics for HCM -
Onboarding ReportSummary BI Publisher Onboarding ReportContent Hello. We have surveys under Onboarding and we need to report on the results. I have written this in BI Publisher but I am …User_F1ZIP 96 views 5 comments 0 points Most recent by Aries Gacias-84224 Reporting and Analytics for HCM -
Need Sample Query on Head Count BIP ReportSummary Need Sample Query on Head Count BIP ReportContent Hi All, I am trying to build a Headcount Summary Report in BIP to achieve the below results, Head Count Summary… -
Need Sample Query on Head Count BIP ReportSummary Need Sample Query on Head Count BIP ReportContent Hi All, I am trying to build a Headcount Summary Report in BIP to achieve the below results, Head Count Summary… -
Manager name for the CEOSummary After promoting an associate to CEO, the former CEO is still seen as his managerContent When our previous CEO retired, he was replaced by an associate within the…User_2025-02-05-12-06-38-063 49 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
sql to use to find out if someone is a line a manager ?Summary sql to use to find out if someone is a line a manager ?Content What sql to use to find out if someone is a line a manager ? We dont use the manager flag at assig…Ruzwan Akram 52 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Adding Case Statement to Existing Data ModelSummary Need assistance with case statementContent I am in need of assistance with the following: (1) case statement syntax and (2) adding a case statement to an existin…Shelly Feyerherm 47 views 9 comments 1 point Most recent by Shelly Feyerherm Reporting and Analytics for HCM -
Schedule a BI Report based on custom logic (makes use of Payroll Flow Pattern and Custom Fast FormulSummary Schedule a BI Report based on custom logic (makes use of Payroll Flow Pattern and Custom Fast Formula)Content Many a times we may have a requirement that we woul…AshishERPCloud 101 views 2 comments 7 points Most recent by Sahil_Makhiza Reporting and Analytics for HCM -
Original Hire Date and Grade ReportContent Hi, I am looking to report on original hire date, grade and time in a grade. Could anybody please help on this? Thank you!MohammadAfghanul Khair 46 views 5 comments 2 points Most recent by Jessie Jones Reporting and Analytics for HCM -
Set default parameter for date to SYSDATE in BIP Data ModelContent Hello I have a date parameter in my BI Publisher Data Model, and I would like to set it by defaut to today's date. I tried using CURRENT_DATE and SYSDATE but it … -
Get legal entities addresses in a BI Publisher Data ModelContent Hello, I am creating letters templates based on a BI Publisher Data Model. Inside these letters I need to put the address of the employee's legal entity. Is it p… -
user unable to see reports in a folderSummary user unable to see reports in a folderContent User is not able to see reports in any folder. Even in My Folders. It is just blank. Could see only folder structur…Anuradha T 240 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Row limits in OTBI ReportSummary Row limits in OTBI ReportContent Hi ALL, I have created OTBI Report based on Logical SQL. When I run it for one of the employee I see his data being populated wh…User_2025-02-07-19-03-14-525 113 views 9 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM -
Approval Rules: learning Assignment by ManagerSummary When a Manager creates an assignment for his team, is it possible to set up an approval transaction?Content Hi,I need your help!When a Manager creates an assignm… -
List of Succession Plan for a personContent Hi all, I am trying to get a list of all succession plan where an employee is active. Thank you!MohammadAfghanul Khair 28 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Unable to Unarchive .xdrz filesContent Hello, We have some .xdrz files that we've found on customer connect, but receive the attached error when unarchiving them. Is it still possible to unarchive the…User_2025-01-31-00-25-12-234 53 views 5 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Identifying tables behind PageSummary Looking if there's a table which I can query to determine the table/s behind the pages in Learning cloud.Content I'm new to cloud and was wondering if there's a … -
Server Message Block(SMB) protocol in BI ServerSummary SMB protocol to connect to Active Directory serverContent Hi All, We would like to send a CVS report from our HCM BI Server to AD server. Our AD team has asked u…Alvaro Couto 18 views 1 comment 0 points Most recent by Gabriel Grigorie-Oracle Reporting and Analytics for HCM