OTBI
Discussion List
-
Need inputs to display Town_or_city, Region_1, Region_2 and Region_3 values in BIP reportSummary: Need inputs to display Town_or_city, Region_1, Region_2 and Region_3 values in BIP report Content (please ensure you mask any confidential information): We have… -
Convert Date to Mon-YY Format in Edit FormulaGood Day, Is there a way to convert date column to Mon-YY format in edit formula instead of using Column Properties > Data Format? Thank you.
-
Project List Details OTBI report not showing any DataSummary: Project List Details OTBI report not showing any Data. Custom role is configured with all the below required duty roles Project Performance Reporting Transactio…Rohit Kumar Singh 63 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Replicate Project segment Code to Asset Number with different Event Type in Oracle OTBI AnalysisSummary: Hi, I'm building an OTBI Analysis report using "Fixed Assets - Asset Transactions Real Time" subject area where the requirement is to copy the PROJECT segment c…
-
Avg Time to Resolve (In Hrs)Summary: We are using the "CRM - CRM Service Request Summary" table to prepare service request data using reports. As part of that, there is a report that provides week-…Anusha716 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
OTM BI Publisher - Run Report using Rest API or any other mediumDear Community We have a requirement where 3rd party application would like to run a report using REST API or any other medium (e.g. Webservices). We would like to know …
-
How to create OTBI for chart of account value ?Summary: Can I create OTBI for all segments in the chart of account value sets, like the hierarchy structure? Content (please ensure you mask any confidential informatio…
-
Role required to Search for Report JobsSummary: User X (with BI Admin role) is unable to search and view BI report submitted by user Y. Content (please ensure you mask any confidential information): User leil…Shubhojit 53 views 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Can we display alpha numeric values in Pivot table?Summary: Can we display alpha numeric values in Pivot table? Content (please ensure you mask any confidential information): We have a requirement to fetch the UDT (User …
-
Count of All Performance Goals is not showing properlySummary: Hello, can you pls check my filters below. The Count of All Performance Goals is not showing properly so I added the Goal Status filter but still not showing up…
-
OTBI Dashboard and Reports for ExpensesSummary An OTBI dashboard with a series of drillable reports for ExpensesContent The attached catalog files can be imported into an ERP Cloud instance to create a dashbo… -
SQL query that brings the fields to HDL for CostCenter?Summary: Content (please ensure you mask any confidential information): Does anyone have a SQL query that brings the fields to HDL for CostCenter ? Simple with the minim… -
Possible to trigger Learning Alert from Learning Status?Summary: Hello, Are we able to configure Learning alerts that will be triggered when a Learning Assignment is changed to a particular status? For example, Exempted, Not … -
OTBI Managers and Direct Reports Additional FieldsSummary: I need to create a report that summarizes the span of control for job levels that have direct reports. Looking for the right fields to use. Content (please ensu…
-
Historical Location Data Workforce Learning - Learning Records Real TimeSummary: Content (please ensure you mask any confidential information): We have started to move our reports to the Workforce Learning - Learning Records Real Time as the…Jeremy CSC 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Absence Date Start in OTBII created a report using Workforce Management - Absence Real time that shows absences employees have along with the date created, and date start of the request. I notice…
-
losing headcounts while using some columns in parameter FDIHello I'm facing an issue while using a parameter in FDI for the subject area HCM - Workforce Core. below an example when I use this paramater, I get the right headcount…Ayoub AFRASS 11 views 2 comments 0 points Most recent by Ayoub AFRASS Reporting and Analytics for HCM -
Is Learning Access working dynamically when add access based on 'analysis report criteria'?Summary: Content (please ensure you mask any confidential information): Is using 'analysis report criteria' dynamic when add access to learning items? for example: analy…
-
Length of Service based on Rehire date calculationContent I am trying to calculate Length of Service based on employee's latest hire date. I used Workforce Event Real Time subject area to calculate the rehire date (usin…Riti Malhotra 138 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to bring HCM UDT Columns into Fusion OTBI subject areaSummary: Need to access the UDT columns (HCM) in OTBI standard subject area's instead of using the "Payroll - User Defined Tables Real Time" as a separate subject area. …
-
Setup connection/API from Fusion reports to Azure data warehouseSummary: Hi Team, Any suggestions on sending the data from Fusion reports (OTBI/BIP) to our internal Azure data warehouse without using a flat file method of SFTP. Any o… -
How to identify who made changes to the DFFs we used in our OTBI reports?Summary: There are few OTBI reports in Dev env which resulted in error because of missing DFFs. we got the DFFs back by running the schedule process. but we want to know…Hitachi ServiceDesk 21 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
How to filter a column?Summary: Hello, I need help on how could I filter to show only the last row. Thank you in advance! Content (please ensure you mask any confidential information): Version…