KB326135: How to group data by metric values using derived attributes in MicroStrategy Secure Enterprise 10.x.

OVERVIEW
Consider a scenario where a metric is defined as seen below:
 

Case(([Metric1] > 0), "Positive", ([Metric1] < 0), "Negative", 0)

Users may want to group by the values of "CaseMetric" so that the values of "Metric1" are grouped according to positive and negative values, but since it is only possible to use attributes in the group-by of a document it is not possible to group by "CaseMetric" directly.
 
In Strategy Secure Enterprise 10.x, it is possible to duplicate a metric as a derived attribute so that it is possible to group by the metric values.
 
STEPS TO IMPLEMENT

• In a document in Strategy Web, create a new derived attribute. This can be done by right mouse clicking on an object in the document and choosing the option "Insert New Attribute"
  

• In the derived attribute editor define the attribute using the metric whose values the user wishes to use in the grouping. In the screenshot below the metric used in the derived attribute definition is the "CaseMetric" metric discussed above.
  

•  
  

  
  CaseMetric

  
  
• Once the new derived attribute is created it can then be added to the grouping of the document as shown below.