Popular Tags
- OTBI 1,432
- Reporting 1,386
- FDI 1,086
- Analysis and Data Visualization 981
- BI Publisher 844
- Analysis 676
- Oracle Fusion Analytics 579
- Administration 555
- OBIEE 432
- OAC 426
- Analytics 395
- BI Publisher Data Models 350
- Security 291
- Answers 264
- HCM 257
- Analyses 254
- BIP 253
- Developers 244
- Data Modelling and Datasets 226
- Data Connectivity 210
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Report Output 184
- Oracle Analytics Cloud 177
- Customizing Reports 159
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
-
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 41 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
-
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 2 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 2 views 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
-
Data discrepancy between HCM Oracle UI and OTBIHello all, While developing a report we saw that the data that is stored in HCM Module UI is different from what is displayed in OTBI. We need to take a gap between this…Jaime Castillo 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Oracle Transactional Business Intelligence
-
unable to access OTBI reports from Product Management subject AreaUsers are unable to any OTBI analysis from product management subject area. This issue is with user who has custom item master view only responsibility Custom responsibi…Pavan Kumar B 1 view 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Need to create alert when PO Receipt date is in closed AP periodHi Team, Need to create alert when PO Receipt date is in closed AP period. When i goto OTBI, i dont see any option to create alert, any role i am missing? please help. P…Kalpesh Salunke-Oracle 1 view 3 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
User selecting accounting period for running an OTBI report without triggering ERP full licenseIn a License analysis we came to know that in Financial Analyst Role the Privilege "Manage Period Close Activities" is triggering "Oracle Fusion Enterprise Resource Plan…Protyush Ghoshal 2 views 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Custom OTBI - VETS - 4212 - Legislative Information Information is missing in Output FileWe have a custom VETS - 4212 OTBI Report. But all the attributes are giving values except Legislative Information attributes in the Output File. For example: Legislative…Badru 1 view 1 comment 0 points Most recent by Shankar-Oracle Oracle Transactional Business Intelligence
-
Problem in query that returns information from Oracle customers by siteSummary: My query should have only the records that were modified in sysdate SELECT /*********hz_parties******************/ hp.party_id, hp.party_name, hp.jgzz_fiscal_co…Cesar Tepetla Corte 1 view 1 comment 0 points Most recent by Shankar-Oracle Oracle Transactional Business Intelligence
-
Prefix SET VARIABLE PARAM_EFFECTIVE_DATE not workingWe are running some of our OTBI reports with a variable for a user-prompted date (data for a specific date). Currently, the report variable uses and displays the wrong d…rrr 2 views 3 comments 0 points Most recent by Mark Stoker Oracle Transactional Business Intelligence
-
How to remove duplicate lines of data in OTBI report.I've written a report in order to provide aggregate data for our performance documents and their rating score. My report produces the correct data, with the exception of…Tyler Buczynski 1 view 4 comments 0 points Most recent by Mark Stoker Oracle Transactional Business Intelligence
-
Error running OTBI report - The user request exceeded the maximum query governing execution time.There is an OTBI report which gives results when I run using my ID but the same report is giving error - "The user request exceeded the maximum query governing execution…Abinaya P 1 view 1 comment 0 points Most recent by Shankar-Oracle Oracle Transactional Business Intelligence
-
Large Data Set not returningHi Everyone! The organization I work for has ~10 manufacturing plants across the US. Folks on the HR compensation team analyze compensation data for those locations as a…CJALSPAC 1 view 1 comment 0 points Most recent by Shankar-Oracle Oracle Transactional Business Intelligence