Popular Tags
- OTBI 1,444
- Reporting 1,390
- FDI 1,106
- Analysis and Data Visualization 983
- BI Publisher 851
- Analysis 679
- Oracle Fusion Analytics 583
- Administration 555
- OAC 446
- OBIEE 433
- Analytics 399
- BI Publisher Data Models 353
- Security 292
- Answers 264
- HCM 262
- BIP 261
- Analyses 255
- Developers 244
- Data Modelling and Datasets 228
- Data Connectivity 210
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 192
- Report Output 184
- Fusion Data Intelligence 173
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
-
How to restrict data access in OTBI reports: buyer can only retrieve their own POHi Experts, (Please advise the category of posting this inquiry, I am choosing OTBI as a start, if it is more suitable to Purchasing category then please help to migrate…Liwen Chiu 1 view 3 comments 0 points Most recent by Liwen Chiu Oracle Transactional Business Intelligence -
Sign In Sign Out Audit report in Oracle FusionSummary: Hello, We have requirement to extract User Sign In, Sign Out and IP Address details through Oracle BIP/OTBI reports. Is there any Seeded report available in Ora…Sushmitha G 2 views 2 comments 0 points Most recent by Kishore Padala-Support-Oracle Oracle Transactional Business Intelligence -
How to get the Take-Home Pay (Net Pay) of EMP in Oracle HCMI am working on generating reports related to Take-Home Pay (Net Pay) in Oracle HCM, which is the net amount of income a worker receives after deductions (such as taxes,…Trupti Khodke 2 views 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence -
conditional formatting in RTF for duplicateSummary: Is it possible to format rows so that a value is filled with yellow when the value is present in the data more than once? Content (please ensure you mask any co…Alex Glose 1 view 4 comments 0 points Most recent by Alex Glose Oracle Transactional Business Intelligence -
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 14 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 2 views 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 1 view 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 2 views 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 2 views 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 45 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 1 view 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 1 view 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 1 view 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