nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Union Tables within A DV Dataset

Bryan K

When creating a dataset in DV mode, it would be helpful to add a Union option, in addition to Join.

Find more posts tagged with

Data Modelling and Datasets

Needs Votes

Status: Needs Votes

Comments

Jamie Anderson-Oracle

Hi @Bryan K - Have you checked out the functionality within Data Flows yet?
If so, what about Data Flows does not address what you are trying to do?

Bryan K

Yes I am familiar with Data Flow and it does work well. Adding it to the Datasets would save an extra step, and save from creating additional datasets from the output of the Data Flow union. Additionally, you may need to account for the reload time/schedule of the dataset when scheduling a dataflow/sequence to run.

Top Leaders

mgoswami 45

Govardhana Gurumal 34

Bhavin Desai 17

Victor H 16

Andrew at MKL 2

Top Ideas

Enhancement Request: Data Role and Security Lineage in FDI Query Execution
Hi All, In our organization, data security is highly customized and complex. A single user can have multiple custom data roles assigned based on different security contexts, such as Line Manager, Regional Manager, Country, Area of Responsibility (AOR), Organization, and other business-specific access rules. One of the…
Enhancement Request: Data Role and Security Lineage in FDI Query Execution
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } Hi All, In our organization, data security is highly customized and complex. A single user can have multiple custom data roles assigned based on different security contexts, such as Line Manager,…
Enable Public Access to Reports and Dashboards in Oracle Fusion Data Intelligence (FDI)
Idea / Enhancement Request Oracle Analytics Cloud (OAC) has introduced the capability to provide public access to analytics content using the BI Public Role, allowing reports and dashboards to be shared with users without requiring authentication. I would like to propose extending similar functionality to Oracle Fusion…
DATA PIPELINES CAPABILITY FOR NON FUSION SOURCES IN ORACLE FUSION DATA INTELIGENCE
hi All, The existing FDI pre-built artifacts/Common Subject Areas give us useful information about data reload and warehouse refresh activities. However, I see a gap when troubleshooting Data Augmentation execution at row level. For example, we have a BI Publisher report returning approximately 1M rows, but the…
Enable the Option to Hide Fusion SCM Content in FDI Reporting Configuration
In Fusion Data Intelligence (FDI) release 26.R3.P4, Reporting Configuration provides options to hide Human Capital Management (HCM) and Enterprise Resource Planning (ERP) content. However, an equivalent option is not available for Fusion Supply Chain Management (SCM) content. SCM content remains visible in the catalog…