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
-
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 2 views 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 478 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 27 views 1 comment 1 point Most recent by JohnW-Oracle Oracle Fusion Data Intelligence -
How to cancel schedule of OTBI Agent of users who scheduled under their personal folders?Few OTBI reports have been scheduled by users under their folders and now they are no longer a part of the organization but the reports still seem to be running with the…Sheetal VBCS 66 views 7 comments 0 points Most recent by Hassan El Bouihi-Oracle Oracle Transactional Business Intelligence -
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… -
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 52 views 1 comment 0 points Most recent by Riyaz Ali-Oracle Oracle Analytics Publisher -
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 32 views 3 comments 0 points Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence -
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,…Joanne McCann 64 views 4 comments 0 points Most recent by SteveF-Oracle Oracle Analytics Cloud and Server -
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 145 views 0 comments 5 points Started by Aimee Williams-Oracle Oracle Analytics Trainings -
Are there alternative ways to format display when there are "no results"?I'm wanting to see if there is an elegant way to display elements where there are no results in the context of other data. For example, I've got a Projects dashboard I b…RyanPE 31 views 3 comments 0 points Most recent by Rich Merkel Oracle Transactional Business Intelligence -
access denied ("oracle.security.jps.JpsPermission" "AppSecurityContext.setApplicationID."Having this error when trying to access report i have tried adding roles to BI publisher but still persistsJin Yus 88 views 2 comments 0 points Most recent by sultank Oracle Transactional Business Intelligence -
Counting number of rows up to a specified value by an idHello, I have a dataset with id, test date, test_type, test result. ID Test_Date Test_Type Test_Result 1 2024-03-21 A Fail 1 2024-04-21 A Fail 1 2024-04-30 A Pass 1 2025…Max503 8 views 1 comment 0 points Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence -
3Roadmap Databricks Support for OACHi Team, As per below oracle document Databricks is not supported for OAC w.r.t BIP, Semantic Model and Administration Tool. Is there any plan consider to support and ce…User_OQKFG 43 views 2 comments 3 points Most recent by User_OQKFG Oracle Analytics Cloud and Server Idea Lab -
4Enhancement Request: Full Historical Data Extraction for Payroll Balance/Costing PipelineThe current implementation of the Payroll Balance Pipeline's full data load functionality limits data extraction to the three most recent years, regardless of an earlier…Anurag Umathe 56 views 0 comments 4 points Started by Anurag Umathe Oracle Fusion Data Intelligence Idea Lab -
1BIVOs do not have AP_INVOICE_AGING_GT and AP_PAYMENT_TEMPLATESI have checked FSCM lineage sheet in https://community.oracle.com/customerconnect/discussion/47652/r13-x-fscm-bi-cloud-adapter-bi-view-object-to-database-lineage-mapping…Gayathri Ajith 3 views 0 comments 1 point Started by Gayathri Ajith Oracle Transactional Business Intelligence Idea Lab -
1BIVOs do not have CE_BAT_TRANSFERSI have checked FSCM lineage sheet in https://community.oracle.com/customerconnect/discussion/47652/r13-x-fscm-bi-cloud-adapter-bi-view-object-to-database-lineage-mapping…Gayathri Ajith 8 views 0 comments 1 point Started by Gayathri Ajith Oracle Transactional Business Intelligence Idea Lab -
OAS 2024 - data flow column expression for OVER PARTITION BYIt seems like this might be possible in other (later?) versions of Oracle Analytics, but I'm working in OAS 2024, trying to build a data flow where I need to add a colum…User_TW8LE 31 views 1 comment 0 points Most recent by Chere-Oracle Oracle Analytics Cloud and Server -
1FscmTopModelAM.GRCTOPBIAM.AssessmentPVO - Enable all columns for reportingAn SR was raised because the BIVO fails when all columns are enabled, returning the following error: Caused by: java.sql.SQLException: java.io.IOException: execute query…Gayathri Ajith 3 views 0 comments 1 point Started by Gayathri Ajith Oracle Transactional Business Intelligence Idea Lab -
1AdvancedAccessControlDetailsRefPVO and AdvancedTransactionControlDetailsRefPVO - Enable all columnsAn SR was raised because the BIVO fails when all columns are enabled, returning the following error: Error: Query Failed: [nQSError: 17001] Oracle Error code: 904, messa…Gayathri Ajith 3 views 0 comments 1 point Started by Gayathri Ajith Oracle Transactional Business Intelligence Idea Lab -
1FscmTopModelAM.GRCTOPBIAM.DataSourcePVO - All fields should be enabled for reportingAn SR was raised because the BIVO report fails when all columns are enabled, returning the following error: Error: Query Failed: [nQSError: 17001] Oracle Error code: 904…Gayathri Ajith 4 views 0 comments 1 point Started by Gayathri Ajith Oracle Transactional Business Intelligence Idea Lab