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
-
Oracle Procurement Cloud BIP Report - Does trigger require parameters unique to the trigger SQL?Summary: Trigger SQL returned no data when sharing the same parameter with the report logic. Content (please ensure you mask any confidential information): We are using …C. Joseph 1 view 1 comment 0 points Most recent by C. Joseph Oracle Transactional Business Intelligence -
Banner on Reports & Analytics pageHi , We have noticed a new yellow banner at the top of the 'Home' page in all our environments on Reports & Analytics page since it got upgraded to 24D stating "The Mark…Neha Bhatt 15 views 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence -
OTBI Dashboard Dependent Prompt is not taking another prompt value in sql ?We are trying to create dependent prompt in OTBI. Dependent prompt is created using sql as we need to put some additional conditions. We are using following syntax but i…Ankur Jain--Oracle 1 view 2 comments 0 points Most recent by Ankur Jain--Oracle Oracle Transactional Business Intelligence
-
OTBI Query to Retrieve the Most Up To Date Record of a Learners Learning AssignmentI have been having issues with trying to pull the most up to date learning assignments for people for a report. I have been using WLF_ASSIGNMENT_RECORDS_F and it is all …marcfromhawaii 2 views 1 comment 0 points Most recent by marcfromhawaii Oracle Transactional Business Intelligence
-
Time Series Calculations - Using a Count Measure for YTDHello all, I'm attempting to create a measure using the time series calculation of TODATE to achieve YTD numbers. For example, if I need to achieve YTD invoice amounts t…Pete 17 1 view 2 comments 0 points Most recent by Pete 17 Oracle Transactional Business Intelligence
-
Setup IBAN for EMEA population in OracleSummary: We need to setup Banking Info within Oracle and unsure how to set this up for the EMEA population using “IBAN”. Can anyone guide me the process do the same? Con…Abinaya P 1 view 1 comment 0 points Most recent by Bianca Lei Villareal Oracle Transactional Business Intelligence
-
Simplest programmatic way of scheduling BI Publisher jobs in Fusion FinancialsSummary: Any light touch report scripted report submission tools that can be used with Fusion Financials for BI Publisher scheduled job submission Content (please ensure…Robert of STAU 1 view 1 comment 0 points Most recent by MiaM-Oracle Oracle Transactional Business Intelligence
-
Language ReportI had created a roster report for employees to run which will generate a list of employees and the language that they speak in case they need a translator. However, I am…Ratha Sun 1 view 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
I need to make a report in OTBI that only shows information for its AORI have a report that shows the salary history of the employees, which should work for a custom role that we have in the company, which works through the areas of respons…Sebastian Ramos Felix - HCM Specialist 1 view 2 comments 0 points Most recent by Sebastian Ramos Felix - HCM Specialist Oracle Transactional Business Intelligence
-
OTBI filter helpI want add the condition for the filter to pull last month whole data based on running month. Column name is "Assignment Absences Details"."Date Start" Please helpReddykrishna 1 view 2 comments 0 points Most recent by Reddykrishna Oracle Transactional Business Intelligence
-
What is the current row limit of OTBI in Oracle Fusion?Hello Experts, I’ve recently created an OTBI report to generate a customer list and managed to fetch around 500,000 rows. Can anyone confirm the maximum row limit or sug…Akhil Chawan 35 views 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
How to restrict user based on Cost Center to view OTBI ReportSummary: I have created Dashboard for Budget Vs actual. The user has Access to all the Cost Center data in dashboard. How to restrict user based on Cost Center (the user…Raoof Ahmed 5 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Is there any way to add daily rates in ""Costing- Receipt Accounting Real Time" Subject areaI am trying to add the daily rates in "Costing - Receipt Accounting Real Time" subject area to calculate the ledger amount(in USD) converted to the specific currency(EUR…Indrajeet 2 views 2 comments 0 points Most recent by Indrajeet Oracle Transactional Business Intelligence
-
OTBI Banner - 24DHi, We have recently received the 24D update in one of our development instances. In OTBI we have noticed a new yellow banner at the top of the 'Home' page in OTBI. Is t…Adam Greener 2 views 3 comments 0 points Most recent by TerriMarks Oracle Transactional Business Intelligence
-
My custom report not showing results after applying Accounts paybale payment supervisor role.Hi, I am using Payable Payment - Disbursement real time subject area to generate one report but when I pull the payment amount and payment date to layout I am not seeing…Pooja_123 1 view 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence -
unable to find the Negotiations Creation date in Sourcing Subject Areaunable to find the Negotiations Creation date in Sourcing Subject Area.. Below are the subject areas where we are trying to check the Negotiations Creation date. Below a…Raoof Ahmed 1 view 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
How to Restrict Business Units based on user access in OTBI parameter lovIs there any way to restrict the Business Unit based on the User access in OTBI parameter Example: If user A is assigned with US BU USD and US MFG BU USD Business unit i…Mazher Shaikh 7 views 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Scale a long numberI have a horizontal bar chart showing a long dollar figure (billions) and would like to scale it down it to $#.#B. I know this can be done for a tile but cannot determin…Tonya H 1 view 2 comments 0 points Most recent by Tonya H Oracle Transactional Business Intelligence
-
OTBI client role based reportingHi, Our customers require to have BU or role based reporting dashboards on OTBI. They do not want to have multiple reports, the requirement is single report but the data…Gökhan Karabulut 1 view 2 comments 0 points Most recent by Gökhan Karabulut Oracle Transactional Business Intelligence
-
Report job runs after the end dateSummary: One of our scheduled reporting job had run beyond the defined end date. Does anyone know why report job still appear "Active" and runs beyond provided end date?…Ridma Karunanathan 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Oracle Transactional Business Intelligence