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
-
Can you filter the MAX of a data set that uses RCOUNT and FLOOR functionsHello Oracle Analytics Community, Was hoping someone can help me with this question. Is there a way to only show the Max number of a data set created using RCOUNT and FL…Marcelo G. Proaño 61 views 3 comments 0 points Most recent by Marcelo G. Proaño Oracle Analytics Forum -
Field Location Help (License/Cert - Item Code )Summary: I am trying to add the 'Item Code' for license/certifications. I have gone through all the fields under Workforce Profiles - Person Profile Real Time related to…Andrew Mc 142 views 7 comments 0 points Most recent by Mahesh Sharma Oracle Transactional Business Intelligence Forum -
Options to provide a Invoice link from OACHi, We have archived historical invoices from EBS 11i into an object storage on OCI. We have historical transactions from 11i in ADW which we report from OAC in same OCI… -
Robert G Wilkinson 11 views 1 comment 0 points Most recent by Robert G Wilkinson Oracle Transactional Business Intelligence Forum -
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.6K views 13 comments 2 points Most recent by Sergey6885 Oracle Transactional Business Intelligence Forum -
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 Forum -
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? -
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 22 views 0 comments 0 points Started by Mahmoud Elsayed 01 Oracle Fusion AI Data Platform Forum -
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)… -
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 21 views 2 comments 0 points Most recent by Mahmoud Elsayed 01 Oracle Fusion AI Data Platform Forum -
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 588 views 0 comments 6 points Started by Benjamin Arnulf-Oracle Oracle Analytics and AI 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 3 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 144 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 108 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 24 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?