Popular Tags
- OTBI 1,428
- Reporting 1,383
- FDI 1,062
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 673
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 407
- Analytics 382
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 256
- Analyses 253
- BIP 247
- Developers 243
- Data Modelling and Datasets 223
- Data Connectivity 208
- ERP Analytics Content 205
- BI Publisher Report Templates 201
- Report Output 183
- Oracle Analytics Cloud 168
- Customizing Reports 156
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Analytics Community
The Oracle Analytics Community helps connect with Data, Analytics, and AI experts, explore forums, events, user groups, idea labs & share data visualizations.
Discussion List
-
AOR analysis fails when I add representative or employee dataI'm trying to create an analysis using Workforce Management - Areas of Responsibility. I need to pull the AOR information as well as representative and employee informat…Sherie Ross 2 views 0 comments 0 points Started by Sherie Ross Oracle Transactional Business Intelligence -
all reports created in HCM with creation datewe have audit and security reconsilation requirement. to full fill this we need all reports crated in HCM with creation date or get the all the reports careated after ce…Sasanka Redy Thavva 3 views 0 comments 0 points Started by Sasanka Redy Thavva Oracle Transactional Business Intelligence
-
Table that stores working hours and daysHello! I need to find the table that stores the information on this screen. Does anyone know?LeonardoNogueira 1 view 0 comments 0 points Started by LeonardoNogueira Oracle Transactional Business Intelligence
-
Rehired Employees are Unable to retrieve employment letter using the current user name* ---- For example: Person Number: 187775 Current Username: A187775 (Results in an error) Old User Name: uakhokh (Fetches data correctly or could download the letter usi…Ashok Kumar Sharma 1 view 0 comments 0 points Started by Ashok Kumar Sharma Oracle Transactional Business Intelligence
-
Need to Group by the Column based on data from 2 different Subject areas in OTBIHi Team, I am creating a OTBI report, and it is basically a Payroll Reconcillation Dashboard, it is having lots of details, one potion is having the details about the sa…VaibhavChavan20 3 views 0 comments 0 points Started by VaibhavChavan20 Oracle Transactional Business Intelligence
-
How to show 2 result sets in one otbi analysis - Cloud HCM (Learning)Hi all Looking to get some insight from the wider community on HOW to combine 2 sets of filtered data into a consolidated analysis. The ask from Customer is to have for …Richard Davis 1 view 0 comments 0 points Started by Richard Davis Oracle Transactional Business Intelligence
-
Why is CASE function always returning ELSE statement?Within our Case function we are comparing a number of months with "Timestampdiff" function with a descriptive flexfield that has numbers. We added the "Timestampdiff" fu…Robin Vanhoegaerden 1 view 0 comments 0 points Started by Robin Vanhoegaerden Oracle Transactional Business Intelligence
-
Oracle HCM - inactive organisations in promptsHello, I have some organisations (ex : services or legal enity) that are inactive in the system (EX : OLD SERVICE). It doesn't affect any reports but it still appears in…Jacqueline GRANDIN 2 views 0 comments 0 points Started by Jacqueline GRANDIN Oracle Transactional Business Intelligence
-
Payroll balance analyses timing out for relatively small data setsI recently noticed that my Payroll Balance OTBI analyses have started to time out. I'm aware that the Payroll Balances tables have few indices and are subject to perform…Kevin Sheehan 1 view 0 comments 0 points Started by Kevin Sheehan Oracle Transactional Business Intelligence
-
How do i perform a lookup within a OTBI analysis reportSummary: I need to perform lookup through Grade Name field to map Grade names for Direct managers adjacent to Direct Manager field in the same report (where I have Perso…Abhishek Bagh 2 views 0 comments 0 points Started by Abhishek Bagh Oracle Transactional Business Intelligence
-
How to see if the employee has executed custom BI reports that are linked to springboardSummary: Hi! There is a requirement for me to enable checking (like an analysis) if employees have executed custom BI reports that are linked to springboard. What can I …Georgette Honora 1 view 0 comments 0 points Started by Georgette Honora Oracle Transactional Business Intelligence
-
Getting error while connecting with Oracle BI ConnectionSummary: Getting error while connecting with Oracle BI Connection Content (please ensure you mask any confidential information): I login with user created specifically f…Jyoti_Garg 1 view 0 comments 0 points Started by Jyoti_Garg Oracle Transactional Business Intelligence
-
Can we add Report and Analytics area same as payables under expenses moduleSummary: Is there a way to add the report and analytics option to access the report directly from the expenses area same as payables. Please find attached screenshot of …Kritika Gupta 1 view 0 comments 0 points Started by Kritika Gupta Oracle Transactional Business Intelligence
-
Budget date in budgetary control balances screen vary in "budget_date" column in XCC_TR_LINES tableSummary: We wanted to display the budget date column in custom report where we have found discrepancies in fusion screen and "BUDGET_DATE" column in XCC_TR_LINES table, …
-
How to Call ff_exec.run_formula in Oracle BI Publisher ReportSummary: Hello Oracle Experts, I am working on Oracle Fusion Cloud BI Publisher (BIP) report and need to call the ff_exec.run_formula function to retrieve Fast Formula r…Moamin Shadid 3 views 0 comments 0 points Started by Moamin Shadid Oracle Transactional Business Intelligence
-
Salary Basis JoinI am building a OTBI report that requires the 'Benefits - Enrollment Real Time' and the 'Compensation - Salary Details Real Time' subject areas. I need to include 'Salar…
-
How we de output Header on CSV even when there is no data with SOAP API?Hello, We have a report that we schedule through SOAP API payload, and the requirement is to have the header on the CSV output even when there is no data. Currently, on …Kristelle 2 views 0 comments 0 points Started by Kristelle Oracle Transactional Business Intelligence
-
OTBI - Analysis Dashboard - Payables Invoices security context by BUHello, we are creating a report using OTBI for payables we have a question related the security access. Our customer want to query invoices depends of user, if the user …Jose Angel RuizMen 1 view 0 comments 0 points Started by Jose Angel RuizMen Oracle Transactional Business Intelligence
-
what standard reports available which print Fixed Asset DFF AttributesWe would like to know what oracle standard reports available which display Fixed asset DFF attributes especially for Asset category and transaction DFF details. we have …
-
Database Resource Condition session variableSummary: Hi. We are trying to create new Database Resource Conditions to give visibility to users of specific data, right now we use the following variable: HRC_SESSION_…Vitor Nakamura 1 view 0 comments 0 points Started by Vitor Nakamura Oracle Transactional Business Intelligence