Popular Tags
- OTBI 1,463
- Reporting 1,403
- FDI 1,166
- Fusion AI Data Platform 1,025
- Analysis and Data Visualization 995
- BI Publisher 869
- Analysis 685
- Oracle Fusion Analytics 602
- Administration 556
- OAC 496
- OBIEE 435
- Fusion HCM Analytics 419
- Analytics 414
- Fusion ERP Analytics 398
- BI Publisher Data Models 360
- Security 301
- HCM 270
- Answers 265
- BIP 265
- Analyses 255
- Developers 246
- Data Modelling and Datasets 230
- Oracle Analytics Cloud 224
- ERP Analytics Content 216
- Data Connectivity 212
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Analytics and AI Community
Oracle Analytics and AI Community, designed for Data Engineers, Data Analysts, Data Scientists, and AI leaders to share knowledge, discuss best practices, collaborate and drive innovation using Oracle Analytics and Oracle AI Data Platform.
Discussion List
-
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…Nishat2402 11 views 1 comment 0 points Most recent by MandeepGupta Oracle Fusion AI Data Platform Forum -
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 135 views 3 comments 10 points Most recent by MandeepGupta Oracle Fusion AI Data Platform 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 148 views 9 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Forum -
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…User_47ELX 21 views 2 comments 0 points Most recent by MandeepGupta Oracle Fusion AI Data Platform Forum
-
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 484 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 Forum -
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…venkata_k 21 views 1 comment 0 points Most recent by JohnW-Oracle Oracle Fusion AI Data Platform Forum
-
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 140 views 1 comment 0 points Most recent by Riyaz Ali-Oracle Oracle Analytics Publisher Forum
-
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 Forum
-
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 and AI 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 Forum
-
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 Forum
-
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 Forum
-
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 AI Data Platform 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…