Popular Tags
- OTBI 1,401
- Reporting 1,365
- FDI 961
- Analysis and Data Visualization 953
- BI Publisher 816
- Analysis 663
- Administration 553
- Oracle Fusion Analytics 543
- OBIEE 421
- Analytics 342
- OAC 336
- BI Publisher Data Models 335
- Security 271
- Answers 261
- Analyses 253
- Developers 240
- HCM 237
- BIP 232
- Data Modelling and Datasets 218
- Data Connectivity 205
- ERP Analytics Content 199
- BI Publisher Report Templates 184
- Report Output 180
- Agents 151
- Customizing Reports 146
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
-
Internal FDI table for user-role assignmentIs there an FDI table with the details of user to licensed role mapping? (e.g. HCM Consumer) We found dw_user_role_data_asgnmnts_d but this only shows roles related to s… -
Custom Oracle Analytics SecurityWe have custom ERP roles that successfully mapped to Oracle Analytics. We have also gone through and added the mapping to the custom roles that were created in Oracle An… -
How to subscribe to a specific workbook canvas?Hello, I am struggling to subscribe to a specific workbook canvas and hopefully anyone can help. I want to receive through email the snapshot view of a certain canvas. -
How to enable AI Assistant featureHello, I've imported new spreadsheet and created new dataset and now I'm trying to use AI Assistant in FDI, but I'm receiving this message. Is there a documentation in o…
-
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… -
sql query for candidate interview interviewer detailsI need the SQL query to fetch interviewer details from the interview schedule in oracle fusion recruiting I already have a query, but irc_is_schedules_b table is not sto…
-
Change the date format to YYYY-MM-DD in BI Publisher Web Layout EditorI am not able to change the date format to YYYY-MM-DD in BI Publisher Web Layout Editor( Currently it is showing YYYY-MM-DDTimestamp). I am getting proper backend output…
-
Dynamic filter in FAW for Fiscal YearHi, I am trying to create a filter in FAW workbook that shows last 3 Fiscal Years dynamically, say FY2021, FY2022 and FY2023 and users can select/deselect the options as… -
Is there a way to clear a database table daily before the pipeline loads?Is there a way to clear out a database table for one of our data augmentations before running the daily pipeline load? We have a need to load in brand new data every day…
-
user who having combined roles they cant able to see the right data. one role overtake another role.one of the user having combination of HR Specialist view all data and Line manger. But, she only see line manager access data. I tried to create security configuration f…
-
How to populate FDI with HCM data?We have a running environment of FDI but no data on it. How to read data from HCM cloud instance? Thank you -
What attributes are used to calculate prebuilt metrics in FDI?I am trying to understand what fields are being utilised to calculate prebuilt metrics in Fusion Data Intelligence Platform. For example, we utilise Legal Employer Senio… -
Making a new subject area available for reportingWe have created a new subject area in FDI. Create a branch with the appropriate steps Merge the branch into the main branch Modified the system generated security config…
-
FDI Connectors General AvailabilityHi All, I see that all the available connectors in FDI are under preview mode and are not suggested to use in Production. Could you please confirm when these connectors … -
Is there a way to schedule Modern View reports quarterly?I am not seeing a way to schedule a Modern View report quarterly. In Classic View you can choose monthly and then choose the 4 months you want, but not seeing that optio… -
How to use OTBI subject areas in Oracle FDI?Hi, I am trying to pull/use OTBI subject areas in Oracle FDI. Is there a way to do so? Thanks, Ruvina
-
SEC_SECURE_BY_OBJ_MEMBER_USER limitationsHi, I've been experiencing limitations on some common attributes like Legal Employer, and my client as well. I have another account user who is not experiencing these li… -
Which data do i bring from ERP to report on resource utilisation in FDIWe have fresh install of FDI and I need to report on the resource/employee availibility/utilisation. With OTBI, I can use Project Resource Management - Resource Manageme… -
How can you change a dimension into a fact?When subtracting 2 dates, the result is a number; however, it creates an attribute. Here is the formula: TIMESTAMPDIFF(SQL_TSI_DAY, {date 1},{date2}) How can I change it… -
Convert FDI Workbook Tables into DatasetsWhat is the most direct way to convert a table that a user has created within a workbook into a standalone dataset? I understand the table visualization can exported to …