My Oracle Support Banner

FDI: Additional Degen Attributes Being Included in the Group By Clause of the Physical Query (Doc ID 3015881.1)

Last updated on APRIL 19, 2024

Applies to:

Fusion Analytics Warehouse - Version 23.R3.x and later
Information in this document applies to any platform.

Goal

Created a custom subject area through Semantic Model Extension and incorporated a fact table. During the process of adding the fact table to the Semantic model, designated several columns as Degen attributes.

After publishing the model, when generating a report based on any one Degen attribute and a fact measure column, the physical query includes all other fact Degen attributes in the group by section and presents the result.

Could there be any data-related concerns arising from the inclusion of these additional Degen attribute columns in the group by clause?

 

Solution

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
Goal
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.