Popular Tags
- OTBI 1,427
- Reporting 1,383
- FDI 1,061
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 672
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 405
- Analytics 382
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 255
- Analyses 253
- BIP 247
- Developers 243
- Data Modelling and Datasets 223
- Data Connectivity 208
- ERP Analytics Content 205
- BI Publisher Report Templates 201
- Report Output 183
- Oracle Analytics Cloud 168
- Customizing Reports 156
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
-
3BICC extract PVO for FscmTopModelAM.AnalyticsServiceAM.LookupValuesPVOOrganization Name Ricoh Europe PLC Description We are using data store "FscmTopModelAM.AnalyticsServiceAM.LookupValuesPVO" in BICC for the extraction and we have found d…Archana P-Oracle 383 views 2 comments 3 points Most recent by Praneetha G Oracle Transactional Business Intelligence Idea Lab -
Sickness Absence End Date not updated in ANC_PER_ABS_TYPE_ENTRIES tableWe initially have had an existing approved Sickness Absence for an employee with duration - Start Date - 01/06/2025 End Date - 28/06/2025 Then we have modified the End D…Raktim_Pal-IBM 11 views 2 comments 0 points Most recent by Raktim_Pal-IBM Oracle Analytics Publisher -
5Support 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 55 views 3 comments 5 points Most recent by Michal Zima Oracle Analytics Cloud and Server Idea Lab -
Issue while installing BI Publisher plugin for wordIt looks like this after installation.Shilpa Varghese 33 views 2 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Oracle Analytics Publisher
-
FDI ArtifactsI came across this article . Blog has a link to Oracle public repository (Click here ) but when I click on the link, it doesn't work for me. Does anyone know how to get …Anjula Mittal 34 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…Alvaro_Soares 31 views 5 comments 0 points Most recent by SteveF-Oracle Oracle Analytics Cloud and Server
-
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 12 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 26 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 3 views 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 18 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 -
21Ability 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 836 views 51 comments 21 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. …Chari-Oracle 43 views 3 comments 0 points Most recent by Bhaskar Konar Oracle Analytics Cloud and Server
-
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…OLGA JIMENEZ JUAN 25 views 3 comments 0 points Most recent by Gianni Ceresa Oracle Analytics Cloud and Server -
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 … -
5Oracle 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 1 comment 5 points Most recent by sud_shekhar-Oracle Oracle Analytics Cloud and Server 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 11 views 2 comments 0 points Most recent by Palanisamy Madhan - Oracle Oracle Analytics Cloud and Server
-
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 11 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 20 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 218 views 4 comments 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence