MicroStrategy ONE
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 theSELECT
clause is identical to the level of theFROM
clause. For example, a SQL statement that only includes the ID column for the Store attribute in theSELECT
clause and only includes the lookup table for the Store attribute in theFROM
clause does not include anyGroup 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