Custom Groups and Consolidations

Grouping Attribute Elements

A custom group is a set of special filters that can be placed on a template. A custom group is made up of an ordered collection of elements called custom group elements.

Consolidations are used to specify the data that you want to view in your report. They allow you to group attribute elements in new ways without changing the metadata and warehouse definitions.

Both of these objects allow you to qualify a report on a row-by-row basis.

Custom Group and Consolidation Comparison summarizes the differences between these objects.

Information about custom groups includes:

• About Custom Groups: Grouping Attribute Elements with Banding and Filtering
• Custom Group Effects on SQL Generation
• Custom Group Structure on Reports
• Creating a Custom Group
• Editing and Formatting a Custom Group
• Determining Custom Group Interaction with the Report Filter
• Deleting a Custom Group, Element, or Ccondition

Information about consolidations includes:

• Consolidations: Grouping Attribute Elements with Arithmetic and Logical Operators
• Consolidation Elements
• Evaluation Order
• Consolidations and SQL
• Consolidation Example

If you have a large number of objects to create or edit, you can also use MicroStrategy Command Manager to work with these objects. Command Manager manipulates MicroStrategy objects by means of user-created scripts rather than a graphical user interface. For more information about Command Manager, see the Automating Administrative Tasks chapter in the System Administration Help. For specific Command Manager syntax for working with custom groups or consolidations, open Command Manager and click Help.