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
-
Is there a way to extend the data retention period in FDI for longer than 3 months?We would like a way to retain data for longer than 3 months in FDI. We do understand that this data is only wiped out if there is a refresh done of the environment, but … -
How to query custom metrics, for content exploration workbooksFDI has a content explorer for out of the box metrics. Is there an internal table that stores the custom created key metrics? Our goal is to create a version of the cont… -
Recipients don't receive dashboard/report exports emailsWe set up SMTP mail server using steps described in: Use the SMTP Mail Server in Oracle Cloud Infrastructure for Email Delivery and are able to create schedules to send …
-
What are "_c" attributes in DFFs?There are several attributes seen in the DFF configuration screen that end with "_c". Please see screenshot. What is the purpose of these attributes and should they be u…
-
PVO help needed for data augmentationHi, I'm trying to pull HCM data through data augmentation and I'm struggling a bit. I'm trying to have a report with all the legal employer information (name, tax regist… -
Can Master-detail analyses in a dashboard be linked on hierarchical column?In a dashboard in FDI, two analyses (pivot tables) are displayed - both based on the same subject area and use a common hierarchical column (Region>Country>State). When …
-
Filter selectionHello, I am currently working on limiting the selectable values in a year filter. Currently the year filter is displaying values from 1950 till 2050. However, I would li… -
OTBI Prompt Value getting truncatedHi all, We are seeing a weird issue in OTBI prompt . When we select prompt value for the first time it returns the data , but 2nd time it automatically shows a truncated…
-
Query error when joining two Procurement SAs: Purchase Order with ReceiptsThe attached error is seen when any field from Procurement - Receipts is being added to fields from Procurement - Purchase Order
-
Deprecated table DW_GL_SLA_RECON_CF showing up in Financials - GL Detail Transactions SA reportAfter activating the CAA subject area, we observed that one of our reports are erroring with the following message: State: HY000. Code: 17001. [nQSError: 17001] Oracle E…
-
How to Suppress Rows with Zero AmountsHow do we suppress rows with zero amounts on fields of measure? I can't filter out zeroes because the filter type is "range." I tried using a CaseIf function and the op…
-
BI Publisher Excel Templates - Not returning dataSummary BI Publisher report with custom excel template is not returning data Content HI All, As we have report with bit more columns than usual reports, that cannot fit …
-
How to assign role to userHi Team, I have a security console in FAW. However, when I try to assign a role to a user to get the Create option to build reports, I do not see any option to assign a …
-
How to pull PVO and add them as SMEHi, My client wants me to make the email addresses available in FDI. I did a data augmentation to be able to use this table and I would like to make it available on the …
-
Display no data if less then 8 records are used for the graphHello everyone, We are looking to implement a logic that ensures no data is displayed in graphs or KPI cards when the underlying dataset contains 8 or fewer records (als…
-
Sql Query to fetch details of offer creation in Oracle Recruiting CloudHi Team, I am currently encountering an issue with an SQL query. It appears that the query is returning multiple assignment numbers for candidates who have Moved to HR i…
-
HMC users can't access FDI (oac)Hi, My instances had been created in the wrong place, they are now in the same prod and test environment as HCM. I finally managed to have my HCM users synced with my FD…
-
FDI export features/limitationsHi, Is it normal that when I try to export my reports (around 15 columns) in PDF or even when I try to select the print feature, my reports are cut and not the whole rep…
-
FDI: How to Get access to "Oracle - CX - CDM" folder under Catalog > Shared folder.Hi, I would like to get access to the CX-CDM shared folder in Oracle Analytics. I don't know how to get the access, I only see the Fusion ERP folder.
-
FDI - BIP Connector - Unable to create datasetHi, I am able to connect to a BIP report and was able to refresh metadata. In the data Augmentation, I see only "Create Dataset" and in that i am not able to see any Pil…