KB4377: How to create a consolidation in MicroStrategy

What are consolidations?
Consolidations are used within templates to specify the data users wish to view in their report. Consolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. Consolidations enable users to create customized groupings that allow row calculations between elements of a given attribute.
 
How can users access the Consolidation Editor?
To access the Consolidation Editor, execute the following:

• From the File menu, go to New and choose Consolidation.
   
  

•  
  NOTE: Users must be granted 'Create Application Objects' and 'Use Consolidation Editor' privileges.
  

 
How do users create a consolidation?

• The methods below may be used to create a new consolidation element:
   
  
• From the Object Browser, drag and drop an attribute element into the Elements for this consolidation section.
• Under Elements for this consolidation, select 'Click here' to add a new consolidation element.
• Under Elements for this consolidation, right-click and select Add Element.
• On the toolbar, click Add Element.
• From the Elements menu, choose Add Element.
•  
  The following is an example of a 'Customer Geography' consolidation:
   
  

• Save the consolidation.
• Place the newly created consolidation in the template.
   
  

KB4377