Popular Tags
- OTBI 1,429
- Reporting 1,384
- FDI 1,064
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 673
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 409
- Analytics 384
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 256
- Analyses 253
- BIP 248
- Developers 243
- Data Modelling and Datasets 224
- Data Connectivity 208
- ERP Analytics Content 205
- BI Publisher Report Templates 201
- Report Output 183
- Oracle Analytics Cloud 170
- Customizing Reports 156
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
-
SQL Command To Prompt User To Select From A Pre-Defined Drop-Down ListIs there a way to prompt the user running your SQL query to pick from a drop-down list of pre-defined values? For example, I want the user to select one of 3 possible va… -
Important Reminder: Changes to the FAWService user - switch to JWT AuthenticationDoc Reference: https://docs.oracle.com/en/cloud/saas/analytics/23r1/fawag/update-data-source-connection-details.html Blog Reference: https://blogs.oracle.com/analytics/p… -
Oracle SQL Bind Variables BETWEEN Dates In BI PublisherHello, I have an SQL query to return a list of terminated employees that I’m trying to use in BI Publisher. The goal is to prepare a report where the user can enter a da…
-
Custom Security in Fusion Analytics Warehouse.Summary FAW Custom Security features Content Below are the list of Blogs we have currently published on Custom Security Custom Data Security in nine simple steps Blog on… -
Receiving columns empty in subject area "Financials - AP Expense"Hi all. We are in Fusion Analytics Warehourse release 23.R1.P4. I noticed that into the subject area "Financials - AP Expense", the columns Receipt Number and Receipt Li…
-
How to load custom data from Oracle HCM Cloud to Fusion Analystics Warehouse (FAW)?Summary: Can anyone please explain how to load the custom data from Oracle HCM Cloud to FAW?
-
need to read and report data from flat files coming from 3 different non-oracle applicationshi, i need to be able to read data (from 3 different sources) and report off it. the data can come as flat files on a daily basis. I am new to FAW, Can somebody suggest …
-
Detailed Headcount Analysis - By Configured Bands using BI Classic ViewSummary Headcount dashboards in this catalog, are built using BI Classic. Please download and explore the dashboards. Content Navigate to BI Classic and import the attac…
-
How to get the latest completion date along with the new due date? (Learning Assignment)Summary: We want to get in the report the latest completion date of the learner and the new due date in each course in 1 row for each learner. However, we are getting 2 …
-
OTBI values show as %Dear All kindly find the below: I have created a report analytic i have a column that show me the difference between 2 formulas how can i modify it so i can see the valu…
-
OTBI value to hyperlinkDear All Kindly find the below: How can i modify the value in an OTBI dashboard to be as a hyperlink ? I have a PPM OTBI report i want that the project number when I cli…
-
Creating an analysis report value 0 not showingDeal ALL I created an analytic for PPM with invoice and revenue and a column that calculate invoice- revenue when i went to result I found that there are some contracts …
-
How to get calculation involving dates to treat as a measure rather than an attribute?Summary: The result of a calculation being an attribute prohibits the use of calculation in visualizations. I would like to convert it from a time attribute to a measure… -
Can DFF VO's be used as a source for Data AugmentationSummary: It seems that the requirement to whitelist VO's in order to use them as a source in data augmentations is not there anymore. Does any one know which release onw… -
Growth Rate Calculations for Hire & TerminationSummary Calculate quarterly , half-yearly & yearly Hire & Termination growth rate Content This DV uses hire headcount, voluntary termination headcount, involuntary termi…
-
Is it possible to exclude Weekends for Days open calculation in BI reporting?Summary: Is it possible to exclude Weekends for Days open calculation in BI reporting? Content (required): Hi, We have a requirement to identify the Requisitions which a…
-
Adding People Group and Service Dates using Data AugmentationSummary: Adding People Group and Service Dates using Data Augmentation Content (required): We are trying to bring the people group field and service dates (Enterprise St…
-
Is it possible to connect smartview to oracle fusion essbase cubes?Summary: Is it possible to connect smartview to oracle fusion essbase cubes? Content (required): Is it possible to connect smartview to oracle fusion essbase cubes? Vers…
-
Missing data from incremental loadWe have noticed some of our headcount falling off even though they remain active employees we cannot pull them up in FAW. This is affecting about 22 folks that remain ac…
-
Enable 'Area of Responsibility' functional area in FAWSummary: Enable Area of Responsibility functional area in FAW Content (required): Hi Team, We have enabled the area of responsibility functional area in FAW but its not …