BI Publisher
Discussion List
-
How to setup private key authentication with sFTPContent Hi all, I'm trying to setup a sFTP connection to a vendor using private key authentication. I'm being told that Oracle needs to have a password setup, but the ve…User_2025-02-05-20-24-10-848 38 views 1 comment 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM -
Printing the Entire Dashboard PageSummary Print the entire dashboard page on the My Team DashboardContent We have pushed out some dashboard reports for our end users. We have placed these reports on the …Shelly Feyerherm 64 views 4 comments 1 point Most recent by Shelly Feyerherm Reporting and Analytics for HCM -
BI Publisher for WORD creates last row of a table as merged cellsSummary BI Publisher for WORD creates last row of a table as merged cellsContent With BI publisher for WORD I created a template with a table to be able to run the repor…Dena Swanson 37 views 4 comments 0 points Most recent by RaviThejaDarbha Reporting and Analytics for HCM -
Dashboard runs a report that opens a new window when it shouldn'tSummary As the title says, we have a Dashboard that runs a BIP Report and the run process pops the information into a new window. We aren't looking for this functionalit… -
Report AuditSummary Report showing when a report was last ran and by whoContent Hi All, I thought I saw this on a webinar, but I don't really recall. Is there a report in OTBI that … -
Multiple IF ELSE Conditions in BIP Excel TemplateSummary Multiple IF ELSE Conditions in BIP Excel TemplateContent Hi Experts, How to use multiple IF else condition BIP Excel Template. Example: IF Legislation_Code IN ('…Bala Kasineedi 101 views 1 comment 1 point Most recent by Raghavendra M Reporting and Analytics for HCM
-
Backend table name for error transactionsSummary Backend table name for error transactions generated from transaction ConsoleContent Hello Everyone, I'm trying to create a report to show data from the Transacti…
-
How to convert a datetime columns from a timezone to another oneContent Hi, we are trying to extract the start and end date of a learning activity in the correct timezone. as you can see in the screenshot we have created an activity …Alberto Boccato 21 views 2 comments 0 points Most recent by Alberto Boccato Reporting and Analytics for HCM -
Transaction Administration Real Time Subject Area - ReportContent Hi all, I am using this subject area to create report to pull the data about the pending transactions, however, we don't see that it has a dimension to show who …SunnyJaiswal 57 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is there a diagnostic report or other tool that will show Reports & Analyses that haven't been run iSummary Is there a diagnostic report or other tool that will show Reports & Analyses that haven't been run in 6 monthsContent Good afternoon. We are auditing our HCM BIP… -
Adjust Auto numbering in RTF Template OutputContent We have multiple paragraphs in a report built using RTF template which are numbered and some of them have conditions so if the condition is met the paragraph is …User_2025-02-05-15-04-32-460 95 views 1 comment 0 points Most recent by Venkata Sumanam Reporting and Analytics for HCM
-
Report to fetch Tax calculation cards at set up levelSummary Report to fetch Tax calculation cards at set up levelContent Hello Team, Is there any OTBI/BIP report to fetch tax calculation cards at the set up level? I want …Harish Kumar Kovi 74 views 4 comments 0 points Most recent by Thomas Cottrell-Duncan Reporting and Analytics for HCM
-
BIP Report running for everSummary Existing BIP report is running for ever with recent upgradeContent Hello Everyone, We have report which was running fine without any issues for 5 hours now with …
-
Embedding Dashboard on context UIContent Dear All, I have embedded dashboard on Hiring page by creating another tab as shown in attached screenshot. I don't want to show all the catalog options with das…User_2025-02-06-14-37-05-233 67 views 8 comments 0 points Most recent by User_2025-01-30-00-32-10-452 Reporting and Analytics for HCM
-
20C-Format does not match with date when scheduling BIPSummary 20C-Format does not match with date when scheduling BIPContent We're getting the attached when users go to schedule any BIP that has a date prompt. They can clic…User_2025-02-04-16-58-40-850 44 views 6 comments 3 points Most recent by Prudence K Reporting and Analytics for HCM
-
Best practice to pass parameters to BIP reports in the URLContent Hi, we need to embed a button in the performance document page in order to print a custom version of the performance document. We did the following: we created a…Alberto Boccato 63 views 5 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
How to add parameter value when scheduling AnalysisSummary How to add parameter value when scheduling AnalysisContent Hi, When I try to schedule Analysis using Agent, I can't find parameters which are available when it i…
-
RFT with 82 column but word has limit of 63 columnsContent I need to develop a report with these 4 requirements: -column number 82 -Output format XLSX, -2 header rows -specific sheet name in the Excel with RFT template I…Nicola Petri 41 views 7 comments 0 points Most recent by Nicola Petri Reporting and Analytics for HCM
-
Filter Job Names in BI Publisher reportSummary I need to remove some Job Names from reportContent Hi, How do I go about removing the job name: CLEANER from the report attached? There will no doubt be others t…User_2025-02-05-22-44-35-842 20 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Subject Area to determine the Minority/Non Minority Status of a personContent Hi , I want to use a Subject Area which determines the Minority/Non Minority Status of a person. Can anyone please suggest. Thanks, - ManishaManisha Chakraborty 24 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Tuning SQL queriesSummary Does anyone have any hints or tips they can share on techniques to tune SQL queries in BI Data Models?Content I have a BI Report which contains a single data mod…Jon Taylor 72 views 2 comments 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
OTBI: Need to display ratio between 2 analysis in a dashboard page.Summary OTBI: Need to display ratio between 2 analysis in a dashboard page.Content Hi, We have analysis 1: All Employees Head Count Analysis 2: HR Employees Head Count W…User_MC37Q 75 views 2 comments 0 points Most recent by User_2025-03-07-20-55-01-859 Reporting and Analytics for HCM -
How to meet that requirement for a report?Summary Output format XLSX, 2 header rows and specific sheet nameContent Hi community, I need to develop a report with these 3 requirements: -Output format XLSX, -2 head…Nicola Petri 26 views 3 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
HCM - Actual working hour and hourly wageContent Hello, I'd need to create a query (data model) for part-time employees in our organization for their actual working hour and hourly wage for a particular period …
-
Standard Working Hours and Standard Working Hours Frequency of Legal Employer or Legal Entity thru OSummary How to get the Standard Working Hours and Standard Working Hours Frequency of Legal Employer or Legal Entity thru OBIEEMark kristan De los Reyes 31 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Current and Proposed Values in a pending BPM workflowSummary Getting the Current and Proposed Values in a BPM workflow notification in BI reportContent We have a requirement to build a report where the HR Specialist can vi…Akash Kiran Jana 63 views 5 comments 0 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM
-
BI Publisher Report - Prompt IssueSummary The drop down list for selecting criteria will not wipe cleanContent Hi, Everytime someone opens this report the Business Unit, Package Type, Legal Entity and Lo…User_2025-02-05-22-44-35-842 27 views 6 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
What Role or Privilege should a user get to be able to archive and OTBI reports?Content What Role or Privilege should a user get to be able to archive and OTBI reports? is archive button is not displayed for a user?Walid Hamdy 56 views 2 comments 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Add Date to Report OutputContent Hi all - I am really hoping you can help me solve this oddity with our BIP report export to Excel. A user reached out to me asking to turn back on the option of …Prudence K 22 views 7 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Subqueries in Logical SQLSummary I've probably failed at some simple syntax..Content Attempting to build some fairly complex queries using Logical SQL Analysis in OTBI. This query: SELECT "Worke…User_2025-01-28-21-32-42-630 51 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM