Remove Group by Option

Remove Group By Option is an advanced property that is hidden by default. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties.

The Remove Group By Option property determines when Group By conditions and aggregations can be omitted in specific SQL generation scenarios, depending on which of the following options you select:

• Remove aggregation and Group By when Select level is identical to From level (default): This setting provides the common behavior of omitting Group By conditions and aggregations if the level of the SELECT clause is identical to the level of the FROM clause. For example, a SQL statement that only includes the ID column for the Store attribute in the SELECT clause and only includes the lookup table for the Store attribute in the FROM clause does not include any Group By conditions.
• Remove aggregation and Group By when Select level contains all attribute(s) in From level: You can choose to omit Group By conditions and aggregations in the unique scenario of including multiple attributes on a report, which are built from columns of the same table in the data warehouse. For example, you have separate attributes for shipping data such as Shipping ID, Shipping Time, and Shipping Location which are mapped to columns in the same table which has the primary key mapped to Shipping ID. By selecting this setting, when these three attributes are included on a report, Group By conditions and aggregations for the shipping attributes are omitted.

Levels at Which You Can Set This

Database instance, report, and template