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
-
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 19 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 39 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 4 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 39 views 2 comments 3 points Most recent by User_OQKFG Oracle Analytics Cloud and Server Idea Lab
-
3Enhancement 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 26 views 0 comments 3 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 4 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 5 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 26 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 4 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 2 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
-
1FscmTopModelAM.GRCTOPBIAM.ControlTestPlanResultPVO - All fields should be enabledAn SR was raised because the BIVO report fails when all columns are enabled, returning the following error: [nQSError: 17001] Oracle Error code: 1445 ORA-01445: cannot s…Gayathri Ajith 2 views 0 comments 1 point Started by Gayathri Ajith Oracle Transactional Business Intelligence Idea Lab
-
NSAW - EPM ConnectorHow to correctly apply filters on EPM cube dimensions and metrics in NSAW ? When connecting from NSAW to EPM Cubes, we are able to establish the connection successfully,…Priya Chary 28 views 2 comments 0 points Most recent by Priya Chary Oracle Analytics Cloud and Server
-
1OTBI Change Order Subject Areas- Column to identity the ChangesDescription We have Change Order Subject areas in OTBI but there is no column to specify is the change related to Price,Quantity,Charge account etc.. and what value has …Karthikeyan Sukumar 3 views 1 comment 1 point Most recent by User_42SLD Oracle Transactional Business Intelligence Idea Lab
-
Setup new Connection in ODI for DatabricksWe utilize Oracle OAC dashboards for data visualization. Our source system is Databricks, and we are attempting to establish a connection from ODI to access the catalog …User_WA0HA 200 views 3 comments 0 points Most recent by User_JD0JE Oracle Analytics Cloud and Server
-
How to ensure the relevant BU Data Access for OTBI reports?Hello, I assigned the Employee role to a user in order to give access to the reports in Reports and Analytics tab. However, when the user runs the report, all data from …Sinem Ozmen -Oracle 1.3K views 12 comments 0 points Most recent by GPOtimization Oracle Transactional Business Intelligence
-
divide two row values using same column of OTBI analysisHi, Each of the two rows is derived from analysis of same subject area. The reason for this design is i cannot accommodate two different conditions in same analysis so I…mknmdp 60 views 7 comments 0 points Most recent by Jerry Casey Oracle Transactional Business Intelligence
-
OTBI Report based on AOR.Hi Team, There is a requirement to have the OTBI report output based on AOR. I have done the necessary setup and have verified from UI that the data is restricted based …Vikas V. Kamat 36 views 2 comments 0 points Most recent by GPOtimization Oracle Transactional Business Intelligence
-
Person Records Secured By AOR Does Not Restrict Data Reflected In OTBI ReportsSummary: Hello Everyone ! I am trying to secure the data returned by HR_ANALYST job role by using an AOR with a scope of Department. Although, it works fine in the HCM U…Maruvada Sanat Kumar-Oracle 760 views 10 comments 0 points Most recent by GPOtimization Oracle Transactional Business Intelligence
-
6We should have way to output unique rows from Dataflow.@GabriellePrichard-Oracle This is related to my community post. How to get unique rows from Dataflow out — Oracle Analytics Use case: I am joining multiple datasets whic…Rajakumar Burra 34 views 3 comments 6 points Most recent by Bhaskar Konar Oracle Analytics Cloud and Server Idea Lab