My Oracle Support Banner

FDI: Unable to Join Custom Dimension With Seeded Facts (Doc ID 3014720.1)

Last updated on APRIL 10, 2024

Applies to:

Fusion Analytics Warehouse - Version N/A and later
Information in this document applies to any platform.

Symptoms

Crafted a custom dimension table and endeavoring to integrate it with a Seeded Fact table. However, upon specifying the join criteria, the key columns are not being displayed.

For instance, goal is to establish a custom dimension to capture the Natural Account Hierarchy. Nevertheless, upon attempting to integrate this dimension with the Seeded ERP fact tables, encountered an anomaly.

It seems that the key columns essential for the join are missing, leaving only the amount columns visible. This discrepancy appears to be specific to the ERP fact tables, as functionality remains unaffected for the HCM Fact tables.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.