Popular Tags
- OTBI 1,456
- Reporting 1,398
- FDI 1,146
- Analysis and Data Visualization 991
- BI Publisher 865
- Analysis 684
- Oracle Fusion Analytics 597
- Administration 557
- OAC 481
- OBIEE 434
- Analytics 410
- BI Publisher Data Models 360
- Security 299
- HCM 269
- BIP 265
- Answers 265
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Oracle Analytics Cloud 219
- ERP Analytics Content 215
- Data Connectivity 212
- BI Publisher Report Templates 205
- Fusion Data Intelligence 196
- Report Output 184
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
-
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 131 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 141 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…
-
2Allow 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 1 view 0 comments 2 points Started by Hylton Oracle Transactional Business Intelligence Idea Lab
-
19OTBI 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 481 views 8 comments 19 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 21 views 1 comment 1 point Most recent by JohnW-Oracle Oracle Fusion AI Data Platform -
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 71 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…
-
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 102 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 31 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,…
-
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 141 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 31 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 101 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
-
3Roadmap Databricks Support for OACHi Team, As per below oracle document Databricks is not supported for OAC w.r.t BIP, Semantic Model and Administration Tool. Is there any plan consider to support and ce…
-
5Enhancement Request: Full Historical Data Extraction for Payroll Balance/Costing PipelineThe current implementation of the Payroll Balance Pipeline's full data load functionality limits data extraction to the three most recent years, regardless of an earlier…Anurag Umathe 61 views 0 comments 5 points Started by Anurag Umathe Oracle Fusion Data Intelligence Idea Lab -
1BIVOs do not have AP_INVOICE_AGING_GT and AP_PAYMENT_TEMPLATESI have checked FSCM lineage sheet in https://community.oracle.com/customerconnect/discussion/47652/r13-x-fscm-bi-cloud-adapter-bi-view-object-to-database-lineage-mapping…Gayathri Ajith 1 view 0 comments 1 point Started by Gayathri Ajith Oracle Transactional Business Intelligence Idea Lab
-
1BIVOs do not have CE_BAT_TRANSFERSI have checked FSCM lineage sheet in https://community.oracle.com/customerconnect/discussion/47652/r13-x-fscm-bi-cloud-adapter-bi-view-object-to-database-lineage-mapping…Gayathri Ajith 1 view 0 comments 1 point Started by Gayathri Ajith Oracle Transactional Business Intelligence Idea Lab
-
OAS 2024 - data flow column expression for OVER PARTITION BYIt seems like this might be possible in other (later?) versions of Oracle Analytics, but I'm working in OAS 2024, trying to build a data flow where I need to add a colum…