Popular Tags
- OTBI 1,455
- Reporting 1,397
- FDI 1,144
- Analysis and Data Visualization 989
- BI Publisher 865
- Analysis 684
- Oracle Fusion Analytics 597
- Administration 557
- OAC 479
- OBIEE 434
- Analytics 409
- BI Publisher Data Models 359
- Security 297
- HCM 269
- BIP 265
- Answers 265
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Oracle Analytics Cloud 218
- ERP Analytics Content 215
- Data Connectivity 211
- BI Publisher Report Templates 205
- Fusion Data Intelligence 195
- 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
-
6Support for WITH (CTE) Clauses in Manual SQL Queries in Oracle Analytics DV (OAS/OAC)Current Limitation: Currently, Oracle Analytics DV does not support the use of WITH (Common Table Expressions) clauses in manual SQL queries. We are are unable to define…Dhaval Parikh Stantec 81 views 3 comments 6 points Most recent by Michal Zima Oracle Analytics Idea Lab -
FDI ArtifactsI came across this article https://blogs.oracle.com/analytics/post/reusable-workbooks-fdi-artifacts-for-fusion-data-intelligence. Blog has a link to Oracle public reposi…Anjula Mittal 51 views 5 comments 0 points Most recent by Anitha Ramarao-Oracle Oracle Fusion ERP Analytics -
How to confirm users Starting Page in OACHello All, I have completed the migration of the entire OBIEE 12c catalog to Oracle Analytics Cloud (OAC) and have already validated user roles in the new OAC environmen…
-
Convert Date Field to "YYYY-Qx" FormatSummary Need to convert a date field from MM/DD/YYYY to "YYYY-Qx" format. Content Hi, I’m trying to convert a date field from the standard MM/DD/YYYY format into a "YYYY…aayhindujaswiss 11 views 3 comments 0 points Most recent by Gianni Ceresa Oracle Business Intelligence Applications
-
Consume external REST API in Fusion BIPIs there a solution to consume external REST API in BIP Report and use the response as data source?VijayAD 111 views 4 comments 0 points Most recent by Dnys Ch Oracle Transactional Business Intelligence
-
1HCM Compensation: Pay Range MetricsRange Penetration, Count/Percent employees under range minimum, and Count/Percent employees over range maximumNathan Yeager 1 view 0 comments 1 point Started by Nathan Yeager Oracle Fusion Data Intelligence Idea Lab
-
FDI dashboards for Advance CollectionsDoes Oracle ERP FDI has any out of the box dashboards and KPIs for Advance Collections?Anjula Mittal 21 views 1 comment 0 points Most recent by Sumanth V -Oracle Oracle Fusion ERP Analytics
-
How to Apply Multiple Filters, Parameters, and Use Fast Formulas in HCM ExtractsHi all, I’ve been working with HCM Extracts in Oracle HCM Cloud and have a good grasp on the basics. Now, I’m trying to go a step further and explore more advanced confi…Nikhilesh Reddy P 11 views 0 comments 0 points Started by Nikhilesh Reddy P Oracle Fusion HCM Analytics -
22Ability to report on Roles &Permissions associated with BIP Catalog FoldersDescription Hi All Currently we are not able to report on the roles & permission associated with each of the BIP catalog folders. We need to manually check the permissio…Karthik_ks 1.1K views 51 comments 22 points Most recent by Bhaskar Konar Oracle Analytics Publisher Idea Lab
-
Is there a bulk way to change ownership to OAC Agents?Hello Team, I have a customer that migrated from OBIEE to OAC and they have a lot of agents. The owner of those jobs left the company and they need to change the owner. …
-
How can I schedule a report with dynamic parameters?Is there any option to schedule a report that must be extracted in recurrent basis (end of month) with dynamic parameters? e.g: Meaning the first day of July I would lik… -
Semantic Model Extension Join Issue With Party Dimension for CAA table.Dear All, I have a scenario where I need to join the Configurable Account Analysis Table DW_FA_GL_ACCOUNT_ANALYSIS_CF(CAA) with Party Dimension. after creating a Custom … -
6Oracle Analytics Cloud REST API - Get Catalog Items - to increase fetch limit from 10K items to 100KProblem Statement: In large enterprise environments, Shared folders in OAC may contain over 10,000 catalog objects (e.g., reports, analyses, dashboards, datasets). The c…Palanisamy Madhan - Oracle 31 views 1 comment 6 points Most recent by sud_shekhar-Oracle Oracle Analytics Idea Lab
-
Oracle Analytics Cloud REST API - Get Catalog Items - to increase fetch limit from 10K items to 100KProblem Statement: In large enterprise environments, Shared folders in OAC may contain over 10,000 catalog objects (e.g., reports, analyses, dashboards, datasets). The c…Palanisamy Madhan - Oracle 21 views 2 comments 0 points Most recent by Palanisamy Madhan - Oracle Oracle Analytics
-
Why a new role cannot run OTBI reports but can run BIP reports when permissions are the sameWe have created a new role in oracle HCM. The user will be using this role for reporting needs. They can use BIP reports with no issues. But OTBI is causing problems. Th…Max W 21 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence -
Oracle Fusion OTBI and Data/Role SyncHi Team, I am a Oracle Security Specialist and often have to play with data sync and validate in UI and in OBI layer reporting. When I do a HDL to Bulk terminate users I…Nicolas Trojack 45 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence
-
OTBI Report for Current Invoice ApproverI am trying to build an OTBI report that shows invoices that are pending approval along with the name of the current approver.BillW 251 views 4 comments 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence
-
Oracle is a Leader in the new 2025 Gartner Magic Quadrant for Analytics and BI PlatformsWe’re delighted to share the news that for the second year running: Oracle has been named a LEADER in the new 2025 Gartner® Magic Quadrant™ for Analytics and BI Platform…Isabelle Nuage -Oracle Analytics-Oracle 1.1K views 10 comments 15 points Most recent by Anna Pietrangelo Oracle Analytics News -
Decimal value issue while displaying OAC Dashboard fieldHi, I have migrated a set of dashboards from OBIE 12g to OAC. However, some numeric fields on OAC dashboards are not showing numeric fields with 2 decimal numbers, even …
-
24Central Texas Severe Weather OutlookThis data visualization pulls weather information from multiple API's that are transformed and caategorized into Severe Weather conditional formatting. Active Fires are …User_P36H1 413 views 8 comments 24 points Most recent by Benjamin Arnulf-Oracle Oracle Analytics Data Visualization Gallery