Popular Tags
- OTBI 1,442
- Reporting 1,390
- FDI 1,103
- Analysis and Data Visualization 982
- BI Publisher 850
- Analysis 679
- Oracle Fusion Analytics 583
- Administration 555
- OAC 444
- OBIEE 433
- Analytics 400
- BI Publisher Data Models 353
- Security 292
- Answers 264
- HCM 262
- BIP 260
- Analyses 255
- Developers 244
- Data Modelling and Datasets 228
- Data Connectivity 210
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 191
- Report Output 184
- Fusion Data Intelligence 170
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Fusion Data Intelligence
Ask questions about Oracle Fusion Data Intelligence platform, the next generation of Oracle Fusion Analytics Warehouse built for Oracle Fusion Cloud Applications. Get answers from experts on data pipelines, security, permissions, ready-to-use analytics, data models, prebuilt AI and machine learning (ML) models.
Discussion List
- 
             How to create a test user in Test environmentI have inherited FDI from a predecessor and need to set up a test user to use for configuring SSO. I am not sure where or how to stop and we are using FDI for our HCM da… How to create a test user in Test environmentI have inherited FDI from a predecessor and need to set up a test user to use for configuring SSO. I am not sure where or how to stop and we are using FDI for our HCM da…
- 
             Set Up a Mail Server to Deliver Reports- OAC/FDIHi Team, Just wanted to check what is the best practice for configuring a SMTP server. should we use existing SMTP server which is available for scheduling OTBI reports … Set Up a Mail Server to Deliver Reports- OAC/FDIHi Team, Just wanted to check what is the best practice for configuring a SMTP server. should we use existing SMTP server which is available for scheduling OTBI reports …
- 
             Fusion Analytics Warehouse TrainingFusion Analytics Warehouse Training Fusion Analytics Warehouse TrainingFusion Analytics Warehouse Training
- 
             Create the average assignment count on OAC/FAWHi, I have a report to produce using the assignment count KPI for different years. I've been struggling in FAW to create the calculation that would allow me to display t… Create the average assignment count on OAC/FAWHi, I have a report to produce using the assignment count KPI for different years. I've been struggling in FAW to create the calculation that would allow me to display t…
- 
             This Calculation is brokenI imported this Excel with 2 checks names: It gives me 2 lines: For line 1 (i.e. check 1) I want to check how many persons have birth date less than 1940. For line 2 (i.…Stefano_Mazzocca 31 views 4 comments 0 points Most recent by Bret Grinslade - Oracle Analytics-Oracle This Calculation is brokenI imported this Excel with 2 checks names: It gives me 2 lines: For line 1 (i.e. check 1) I want to check how many persons have birth date less than 1940. For line 2 (i.…Stefano_Mazzocca 31 views 4 comments 0 points Most recent by Bret Grinslade - Oracle Analytics-Oracle
- 
             Dataset Storage vs. Database ConnectionFrom the perspective of an FDI end-user concerned with saving their datasets, data flows, and workbooks in an optimal manner for scaling and long-term usage (access/shar… Dataset Storage vs. Database ConnectionFrom the perspective of an FDI end-user concerned with saving their datasets, data flows, and workbooks in an optimal manner for scaling and long-term usage (access/shar…
- 
             Customization in FDI1)We need to read data from a different database (adw) in to FDI to create data modelling on top of it. So took the following approach but it gives error saying query ag… Customization in FDI1)We need to read data from a different database (adw) in to FDI to create data modelling on top of it. So took the following approach but it gives error saying query ag…
- 
             Timestamp like 21/09/2024 18:56:03Is it possible to have a column with such timestamp? I don't see anything like that: Timestamp like 21/09/2024 18:56:03Is it possible to have a column with such timestamp? I don't see anything like that:
- 
             Help do find Final discharge location description (FDG Report)I am running a query based on the FDG tables and need information about the FINAL DISCHARGE LOCATION. Within the table JG_FSCL_DOC_LINES_ALL, we can access the ship_to_l… Help do find Final discharge location description (FDG Report)I am running a query based on the FDG tables and need information about the FINAL DISCHARGE LOCATION. Within the table JG_FSCL_DOC_LINES_ALL, we can access the ship_to_l…
- 
             Report/Dashboard Resource/Sharing CenterWe’re relatively new to FDI and are working to make the most of the out-of-the-box FDI dashboards and reports. However, we’ve noticed that they don’t quite align with th… Report/Dashboard Resource/Sharing CenterWe’re relatively new to FDI and are working to make the most of the out-of-the-box FDI dashboards and reports. However, we’ve noticed that they don’t quite align with th…
- 
             Exists condition in key metricIt it possible to add an exsists in custom metric? Let's say I have col "A", "B", and "C". In col "C" I want to count +1 when "A" >= 50 or when "B" = Y AND THERE IS NO O… Exists condition in key metricIt it possible to add an exsists in custom metric? Let's say I have col "A", "B", and "C". In col "C" I want to count +1 when "A" >= 50 or when "B" = Y AND THERE IS NO O…
- 
             Options to export dashboard raw dataWhat options exists to export the raw data being used to build dashboard canvases? For example, if we have 6 visuals on a single canvas that shows 6 months of trending d… Options to export dashboard raw dataWhat options exists to export the raw data being used to build dashboard canvases? For example, if we have 6 visuals on a single canvas that shows 6 months of trending d…
- 
             Multi-File Upload and Scheduled Refresh for FDI Analytics DataI would like to connect a series of large (multi-tab) excel files saved in a SharePoint folder to an existing Data Flow (to perform various analytics against dashboard d… Multi-File Upload and Scheduled Refresh for FDI Analytics DataI would like to connect a series of large (multi-tab) excel files saved in a SharePoint folder to an existing Data Flow (to perform various analytics against dashboard d…
- 
             FDI Audit (SOX) Access Review ReportHello Team, We are looking for FDI Audit(SOX) Access Review report related to User and Group details. Can you please let us know is there any report is available to see … FDI Audit (SOX) Access Review ReportHello Team, We are looking for FDI Audit(SOX) Access Review report related to User and Group details. Can you please let us know is there any report is available to see …
- 
             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… 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 link custom data to table?I need to build a table like this: "Date" is an incremental date, every day there is a new value "Control Name" is a custom text of 2 or more possible values "Num of lin… How to link custom data to table?I need to build a table like this: "Date" is an incremental date, every day there is a new value "Control Name" is a custom text of 2 or more possible values "Num of lin…
- 
             Can the default format option for a file export be changed?Is there a way to change the default format option for a file export in FDI? For example, changing the default option from PowerPoint to Excel? Can the default format option for a file export be changed?Is there a way to change the default format option for a file export in FDI? For example, changing the default option from PowerPoint to Excel?
- 
             Usage Tracking Subject Area is it possible to hide and/or mask columnIs it possible to hide and/or mask column Logical Query on Usage Tracking Subject Area. Want to hide column at the subject area layer. If not possible to hide column is … Usage Tracking Subject Area is it possible to hide and/or mask columnIs it possible to hide and/or mask column Logical Query on Usage Tracking Subject Area. Want to hide column at the subject area layer. If not possible to hide column is …
- 
             Application Roles ReappearingFor our groups we have taken down all application roles that are content duties in order to hide reports that were built by Oracle. However, when an update is applied to… Application Roles ReappearingFor our groups we have taken down all application roles that are content duties in order to hide reports that were built by Oracle. However, when an update is applied to…
- 
             Create average assignment count in oacHi, How can I create a report showing the average assignment count for 1 specific year (2024 - from jan to dec) based on worker category and gender ? I would have the ge… Create average assignment count in oacHi, How can I create a report showing the average assignment count for 1 specific year (2024 - from jan to dec) based on worker category and gender ? I would have the ge…