Popular Tags
- OTBI 1,387
- Reporting 1,362
- FDI 927
- Analysis and Data Visualization 923
- BI Publisher 807
- Analysis 658
- Administration 547
- Oracle Fusion Analytics 541
- OBIEE 418
- BI Publisher Data Models 331
- Analytics 324
- OAC 303
- Answers 260
- Security 258
- Analyses 252
- Developers 238
- HCM 231
- BIP 225
- Data Modelling and Datasets 212
- Data Connectivity 205
- ERP Analytics Content 193
- BI Publisher Report Templates 182
- Report Output 181
- Agents 151
- Customizing Reports 145
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Customizing Reports
Discussion List
-
How to get the Full Year based on Current Month in OAC DV?Hello All, We have a requirement in OAC DV to display the full year's amounts/values of data dynamically based on the currently selected period filter. Specifically, the… -
Dynamically Reference Values for the Previous Year based on User Filter SelectionHi everyone, I am currently trying to implement a dynamic filter for a KPI card in Oracle Fusion Data Intelligence. In the below image, I have laid out an example: We ha… -
7Customizing and saving filters on OOB/OAC reportsFor Pre-Built reporting, there should be a way we can save our customizations on the Shared Folders >Oracle >Fusion ERP without saving it to another directory. There sho…Juan Hurtado 331 views 6 comments 7 points Most recent by Jamie Anderson-Oracle Oracle Fusion Data Intelligence Idea Lab -
Performance Issue After Joining EGO_ITEM_EFF_B on the basis of CHANGE_LINE_ID. Any solutions?Hi, I’m working on a query that previously ran within seconds, but after adding the lastLEFT JOIN, the execution time has increased significantly—even for a single chang… -
What is the table name used to display group names in the report?Hi everyone, Does anyone know which table we can use to display the highlighted grouping in the cash management report? Thanks -
BI Publisher - English Text Alignment Issue in Arabic SessionHello, I am working on a BI Publisher report that contains both English and Arabic text. The issue I am facing is that English text appears misaligned when the session l…
-
Combining 3 columns and get unique values out of itHi, I am trying to combine 3 attributes named S1,S2,S3 which has the person number and then need to find unique values out of it. Can help please help me understand how …Ruvina Khan 21 views 3 comments 0 points Most recent by Ashish-Oracle Oracle Fusion Data Intelligence
-
4Security based data actionsWe're using a system that allows drilling into other reports through data actions, but users only have access to a portion of the reports that are listed. If a user sele…Doug Mackay 21 views 0 comments 4 points Started by Doug Mackay Oracle Fusion Data Intelligence Idea Lab
-
2When the employee open a report we need to send one email to same employeeDescriptionWhenever the employee open a report we need to send one email to the same employee. Once the employee select all the perameters and click on apply button auto…Malak 3 views 0 comments 2 points Started by Malak Oracle Transactional Business Intelligence Idea Lab
-
1Global setting to add for All report In Oracle Analytics PublisherWe kindly request that a global setting be implemented for all reports in a single step. The report properties should be modified to reflect the global settings, as we a…
-
Grouping Columns based on Data like MTD,QTD,YTD in OAC/OTBIHello, We have a requirement to display Data based on the Time Series to group MTD Data Columns under MTD Group Column in OAC/OTBI We can display data by placing columns…
-
How to create a report with Opening,Closing,Inbound and Outbound stock?I want to create a report like below format, but as Inbound and outbound qty change whenever a new entry hit, so i'm unable to achieve it datewise or you could say a Sta…
-
4Can we increase Maximum Sample Data Size Limit in Data Model?Hello, We have requirement to increase Data model limit beyond 1 MB to implement some custom changes. But when we are trying to increase the Size limit, we are not able …Upeshjain 23 views 2 comments 4 points Most recent by markcasas Oracle Transactional Business Intelligence Idea Lab
-
OTBI Report Too Slow / Not Generating ResultsSummary: Have created a report to pull all roles for all users (Audit purposes), and admittedly there is an excessive amount of data to pull. That being said, when runni…User_DKPSX 1.1K views 11 comments 0 points Most recent by User_ABC0S Oracle Transactional Business Intelligence
-
BI Publisher data does not match OAC dataI created a report in BI Publisher, made the connection in FDI to BI Publisher, created a dataset using data augmentation, connected to Oracle Autonomous Data Warehouse …SERGIO BARRETO 75 views 11 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion ERP Analytics -
2Allow an Alert of what Workbooks and Visualizations will be Affected By UI OperationsBefore an UI operational change is made to a custom (or OOTB) artifact ensure an activity (warning/notice) that would list all workbooks affected by the change. For inst…LCDavis-Oracle 21 views 0 comments 2 points Started by LCDavis-Oracle Oracle Analytics Cloud and Server Idea Lab
-
3Allow History/Audit Logging Information for KEY METRICS Tracing/TrackingWhen a custom Key Metric names are updated/deleted etc.. this action can change the behavior of the workbook or analysis. Causing error due to the original artifact bein…LCDavis-Oracle 21 views 0 comments 3 points Started by LCDavis-Oracle Oracle Analytics Cloud and Server Idea Lab
-
BIP Reports are ending in Error with ORA-56733: logical I/O limit exceeded - call abortedBIP Reports completing with 'Time Out' ERROR after running around 3 hours and exceeding the Data Model 'Query Time out" limit and displaying below error message Waiting …
-
11Custom shapes for visualizationsLet the user upload custom shapes for visualizations Picto Scatter Bar Examples:Victor H 21 views 0 comments 11 points Started by Victor H Oracle Analytics Cloud and Server Idea Lab -
How to get other fields or more information from ERP fusion modulesI have the following business need: We want to create an AP report to have consolidated information when preparing payments. This report contains detailed information ab…