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 laterInformation 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 |