My Oracle Support Banner

SQL Query Over-inclusion Issue in Custom Subject Area with Degen Attributes in Fusion Data Intelligence (Doc ID 3010457.1)

Last updated on MARCH 14, 2024

Applies to:

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

Symptoms

After developing a custom subject area in Semantic Model Extension and adding Degen attributes to the fact, the subject area was published. Upon selecting one degen attribute and one fact measure column in the workbook criteria, the generated Physical SQL query includes all other Fact degen attributes unnecessarily. But, the displayed results are accurate.

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
References


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