Popular Tags
- OTBI 1,445
- Reporting 1,390
- FDI 1,107
- 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 263
- 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 I access the oracle tables in Oracle BI EE PublisherWhat are the recommended steps to access Oracle database tables directly within Oracle BI EE for reporting and analysis? -
Which table holds audit data or historic LC Expiration date under supplier master business class...Which table holds audit data or historic LC Expiration date under supplier master business classification as 'POZ_BUS_CLASSIFICATIONS' holds only one row which is curren…
-
10Privilege Access to FA_FUSION_SOAINFRA.WFRuleDictionaryOrganization Name Staffordshire University Description Privilege Access to FA_FUSION_SOAINFRA.WFRuleDictionary so we can access these tables to produce our own sql repor…JHould 113 views 3 comments 10 points Most recent by MandeepGupta Oracle Fusion Data Intelligence Idea Lab
-
Latest data changes are not reflecting in the OTBI report immediatelyHello All, We have an AOR drill-down OTBI report, but the latest changes to data are not reflecting immediately. For example, when we assign an AOR to an employee, it so…Nusrat Shaheen 75 views 9 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence -
New to Oracle Fusion: reporting & ETL challenges when moving data to a warehouse?I’m fairly new to the Oracle Fusion ecosystem and eager to learn from those who have gone before me. If you’ve had to extract data from Oracle Fusion—using OTBI, BIP, or…
-
37BIP Reports built on Excel Template currently doesn't support Report Output Format Option as xlsxDetails: Currently BIP Reports built on Excel Template, supports Report Output Format Options as .xls and this can hold data of only 65K records per worksheet/tab in Exc…Malavika Sairaman 541 views 10 comments 37 points Most recent by MandeepGupta Oracle Analytics Publisher Idea Lab
-
I cannot find Oracle Analytics Day by Day Mobile app on App Store or Play StoreI am not able to find Oracle Analytics Day by Day Mobile app on App Store or Play Store. Is this mobile app deprecated? Anyone has any update on this? Thank You.Usha Athimakula 62 views 5 comments 0 points Most recent by Bhaskar Konar Oracle Analytics Cloud and Server -
1Allow the Create Analysis feature to also access data models and not just subject areas.Could you please extend the analysis functionality to also be able to use data models. We find when creating operational working dashboards the analysis works better for…Hylton 2 views 0 comments 1 point Started by Hylton Oracle Transactional Business Intelligence Idea Lab
-
18OTBI Link to Payables Invoice ImageOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Wincanton Description (Required): I a…DennisOliver 432 views 8 comments 18 points Most recent by srirams Oracle Transactional Business Intelligence Idea Lab
-
Tips for most efficiently adding concatenated columns to subject areas?We have a need for concatenated Code and Descriptions from our GL Segments such as "Department Code Department Name". Concatenating at the DV report level is not efficie…Caroline Blanchard 22 views 1 comment 1 point Most recent by JohnW-Oracle Oracle Fusion Data Intelligence -
How to cancel schedule of OTBI Agent of users who scheduled under their personal folders?Few OTBI reports have been scheduled by users under their folders and now they are no longer a part of the organization but the reports still seem to be running with the…Sheetal VBCS 37 views 7 comments 0 points Most recent by Hassan El Bouihi-Oracle Oracle Transactional Business Intelligence
-
We would like to Implement subject-area–level filter that applies to all users in FDIWe’d like to enforce a subject-area–level default filter for all users by fixing the Balancing Segment Tree to a single value (e.g., “Company CHS_PL”), so it’s automatic…
-
29Add system role for DV Scheduler feature. Make it available for FDIThis idea was closed as "delivered". The mod misunderstood. DV Scheduler Feature - Add system role — Oracle Analytics We are not asking for DV Scheduler We are asking fo…Victor H 143 views 1 comment 29 points Most recent by Andrew at MKL Oracle Analytics Cloud and Server Idea Lab -
How To Format Numbers As Text So That The Report Output Displays Leading Zeros Without Leading SpaceOn : 5.6.3 version, Designing Layout Templates Have custom reports that need to be generated in either PDF or EXCEL format. In the XML rtf template, in order to preserve…Anil Pandey-Oracle 25 views 1 comment 0 points Most recent by Riyaz Ali-Oracle Oracle Analytics Publisher
-
How to report on Historical Organization Hierarchies?We have 6 historical versions of our organization tree, but when trying to report on the previous versions in reporting, only the latest organization hierarchy is showin…Mark Stoker 21 views 3 comments 0 points Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence
-
OAS DV datasets resulting in extremely poor performance.We noticed in the past number of weeks that any of our DV's in OAS (V7) built off datasets are performing very poorly. When we rebuild the DV direct from a subject area,…Joanne McCann 42 views 4 comments 0 points Most recent by SteveF-Oracle Oracle Analytics Cloud and Server
-
Upcoming Live Webinars - Early SeptemberKickstart your journey with our exciting lineup of webinars designed to empower you in the world of data analytics! From learning the fundamentals of FDI and creating wo…Aimee Williams-Oracle 144 views 0 comments 5 points Started by Aimee Williams-Oracle Oracle Analytics Trainings -
Are there alternative ways to format display when there are "no results"?I'm wanting to see if there is an elegant way to display elements where there are no results in the context of other data. For example, I've got a Projects dashboard I b…RyanPE 11 views 3 comments 0 points Most recent by Rich Merkel Oracle Transactional Business Intelligence
-
access denied ("oracle.security.jps.JpsPermission" "AppSecurityContext.setApplicationID."Having this error when trying to access report i have tried adding roles to BI publisher but still persistsJin Yus 66 views 2 comments 0 points Most recent by sultank Oracle Transactional Business Intelligence
-
Counting number of rows up to a specified value by an idHello, I have a dataset with id, test date, test_type, test result. ID Test_Date Test_Type Test_Result 1 2024-03-21 A Fail 1 2024-04-21 A Fail 1 2024-04-30 A Pass 1 2025…Max503 1 view 1 comment 0 points Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence