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:

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

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