Popular Tags
- OTBI 1,470
- Reporting 1,405
- FDI 1,183
- Fusion AI Data Platform 1,031
- Analysis and Data Visualization 1,004
- BI Publisher 871
- Analysis 686
- Oracle Fusion Analytics 608
- Administration 556
- OAC 516
- OBIEE 436
- Fusion HCM Analytics 422
- Analytics 418
- Fusion ERP Analytics 403
- BI Publisher Data Models 361
- Security 301
- HCM 277
- BIP 267
- Answers 265
- Analyses 255
- Developers 246
- Oracle Analytics Cloud 241
- Data Modelling and Datasets 230
- 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: news, forums, labs, events, sharing center, training, and groups. Connect with analytics and AI peers and get answers.
Discussion List
-
2Retaining OTBI Parameters in OTBI OutputDescription (Required): Parameters in OTBI are lost once we run the OTBI Report. We enter the values in parameters in OTBI Report and click on Submit. After submit, we s…Kunal Kalra-Oracle 2 views 1 comment 2 points Most recent by Adnan Saleem Oracle Transactional Business Intelligence Idea Lab -
Journal Line DFFs Inconsistent on Fusion Analytics ReportsWhile transitioning reports from GL Account Analysis to Configurable Account Analysis, I found an issue where not all journal line dff values show in a report. After not…
-
16OTBI Export to Excel or CSV limitationOrganization Name Capgemini Description Hi Team, The OTBI Report export to excel or csv limited to 25k and 75k rows.This Limit is very small for business requirements.It…Sateesh Kumar 141 views 10 comments 16 points Most recent by Benjamin Arnulf-Oracle Oracle Transactional Business Intelligence Idea Lab
-
Help - OTBI Redwood links for work ordersEdit: Note I dont need the old deeplinks, I need the Redwood links that need to replace my old deeplinks. Thanks for the team's previous help on the links to go directly…Hylton 31 views 3 comments 0 points Most recent by Bhaskar Konar Oracle Fusion AI Data Platform Forum
-
Delay in syncing data for OTBI real time usage subject area?I Have developed an OTBI report (Analysis) to get the Audit data like usage of OTBI reports in last 6 months using OTBI Real time usage subject Area. but to test that I …Asritha 103 views 8 comments 0 points Most recent by GPOtimization Oracle Transactional Business Intelligence Forum
-
1Need to query PVO data in BI Publisher Data ModelWe need to query PVO data in BI Publisher Data Model, here's the PVO name: FscmTopModelAM.ScmExtractAM.ScmRcsBiccExtractAM.ItemUOMConversionPVOVarnika Pathak 21 views 1 comment 1 point Most recent by MandeepGupta Oracle Analytics Publisher Idea Lab
-
first day of previous month and last day previous month Schedule Report Job in oracle fusionI want to schedule a BI Report job - first day of previous month and last day previous month Schedule Report Job in oracle fusion using : {$FIRST_DAY_OF_MONTH()$} {$LAST…
-
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…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 131 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 141 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 497 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 162 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