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
-
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 3 views 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 3 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 5 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 4 views 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 2 views 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
-
Can an Agent to Generate OTBI Report and Email increment to the next GL period?I have an OTBI that produces all the the voided AP payments in a given period. Can I create a process where by the OTBI report and report agent increment to the next per…Elena Brennan 11 views 2 comments 1 point Most recent by Shankar-Oracle Oracle Transactional Business Intelligence
-
Fixed Assets - Asset Balances Real Time: Ending BalanceThe Fixed Assets - Asset Balances Real Time: Ending Balance is showing a sum of Cost and Depreciation. How can I make it show the NBV?Srinivasan1 1 view 1 comment 0 points Most recent by Shankar-Oracle Oracle Transactional Business Intelligence
-
BIP report working fine for admin login but exceeding time limit for user loginSummary: We have a BIP report that delivers report within 2 minutes for admin login but when HR specialist (user) logs in to run the same report, it exceeds time limit C…Abishek R 3 views 1 comment 0 points Most recent by Shankar-Oracle Oracle Transactional Business Intelligence
-
Supplier Bank Account info: how to filter "Assignment Inactive On"Hi Experts, Would like to reach out to you regarding the proper way of filtering Supplier Bank Account's "Assignment Inactive On" field. Please refer to the screenshot t…Liwen Chiu 2 views 1 comment 0 points Most recent by Liwen Chiu Oracle Transactional Business Intelligence
-
Action link not working for Logical SQL AnalysisHi Experts, We have created two analysis which will be a master drill down report, both of these analyses are created through logical SQL, the two analyses are summary a…Aman Mishra 2 views 4 comments 0 points Most recent by Aman Mishra Oracle Transactional Business Intelligence
-
From to period is not working in OTBI reportWhen i am trying to add a parameter, for budget period name , i am using between in the prompts but it's not giving the from to period. Sometimes it's giving error and s…Omran Zeaiter 2 views 1 comment 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
What is the latest limit on OTBI export for CSV & Excel.I was able to export 75k in excel & 500k records in csv with OTBI. However, I keep on reading that excel has a limit of 25k & csv has 75k as a limit. Do we have a way to…Saumishra 4 views 3 comments 0 points Most recent by mkucuk_tr Oracle Transactional Business Intelligence
-
Language ReportLooking to create a language report for all employees to access when needed. I am using Workforce Profiles - Person Profile Real Time but when I test employee's access, …Ratha Sun 1 view 1 comment 0 points Most recent by Mark Stoker Oracle Transactional Business Intelligence
-
Custom Dashboard throwing out errorWhenever i try to access custom dashboard it throws out this error Permissions are in place for dashboard/folder also our role has the subject area needed but then too i…Manav Pundhir 2 views 5 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Report with Workforce Compensation Real Time Subject area returns duplicate resultsI have a report that I've created using the Workforce Compensation Real Time Subject area, in the report I have the fields: Person Number Assignment Number Assignment St…Adam_Cantwell 1 view 1 comment 0 points Most recent by Adam_Cantwell Oracle Transactional Business Intelligence