Popular Tags
- OTBI 1,451
- Reporting 1,395
- FDI 1,131
- Analysis and Data Visualization 988
- BI Publisher 860
- Analysis 683
- Oracle Fusion Analytics 595
- Administration 555
- OAC 470
- OBIEE 433
- Analytics 404
- BI Publisher Data Models 358
- Security 296
- HCM 270
- BIP 265
- Answers 264
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Data Connectivity 211
- ERP Analytics Content 210
- Oracle Analytics Cloud 208
- BI Publisher Report Templates 205
- Fusion Data Intelligence 193
- 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
-
How to query fusion tables in SQL developerSummary: We have a data model to select the email_address_id from fusion.PER_EMAIL_ADDRESSES but we want to be able to query this table or data from this table (or IRC_C…maria.stanciu 2.5K views 13 comments 2 points Most recent by Sergey6885 Oracle Transactional Business Intelligence -
What is the recommended way to add PO Description column to CAA?A frequent analysis that is done by our users is a journal and account analysis for the payables module. As payables is a journal source, it is easy to merge journal and…
-
View Reports and AnalysisThere used to be a link under the Oracle Cloud Help Center where you could download an MS Excel spreadsheet which contained a listing of all the standard delivered repor…AVorster-Oracle 101 views 7 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence -
DV Calc using Power inplace of RootI am trying create a calculation to get the nth Root of a value I found this for using POWER in place or ROOT But I get a value of 1 back Any Suggestions?Wayne Van Sluys 49 views 3 comments 0 points Most recent by Jerry Casey Oracle Analytics Cloud and Server -
Custom Subject Area isn't available after deployment of semantic bundle from test to productionI imported and deployed the semantic bundle at target instance and all steps completed successfully. The semantic bundle contains custom Subject Area, but it is visible …Mahmoud Elsayed 01 21 views 0 comments 0 points Started by Mahmoud Elsayed 01 Oracle Fusion Data Intelligence
-
OBIEE 12c, session variable error "[nqsError: 23006] The session variable, NQ_SESSION."variable namHi All, Here is the scenario. I created a non-system session variable in the RPD and a request variable in answers dashboard prompt (both with same name, including case)…User_INLWQ 1.1K views 11 comments 0 points Most recent by Karthi_obiee Oracle Analytics Cloud and Server
-
Does importing a Semantic Model publish the Semantic Model into the target environment?Does importing a Semantic Model publish the Semantic Model into the target environment or do I need to republish the SME after importing?Kevin Riedy 28 views 2 comments 0 points Most recent by Mahmoud Elsayed 01 Oracle Fusion Data Intelligence
-
Oracle CloudWorld is now Oracle AI World - Register NowOracle CloudWorld is now Oracle AI World! It will be hosted in Las Vegas on October 13 to 16th, 2025. General attendee conference passes include access to: The welcome r…Benjamin Arnulf-Oracle 512 views 0 comments 6 points Started by Benjamin Arnulf-Oracle Oracle Analytics News -
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 9 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 132 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…
-
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 105 views 8 comments 0 points Most recent by GPOtimization Oracle Transactional Business Intelligence
-
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 20 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…
-
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 130 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 138 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…