KB41447: The ability to create a Derived Metric that calculates at the level of an attribute placed in the Report Objects window but not the grid

Follow the steps below in order to enable the "Aggregate from base" setting.  This is a hidden setting that will enable Derived Metrics to calculate at the level of attributes that are placed in the Report Objects window, but not directly on the grid.

1. Locate the XML file sys_defaults.xml which can be found in the path C:\Program Files (x86)\MicroStrategy\Web ASPx\WEB-INF\xml.
2. Right-click on this file and edit it using a text editor.
3. Search for the showAggFromBaseOnMetricEditor flag and change it from the default value of 0 to 1.
4. Save and close.
5. Restart Web Server.
6. Log into Web, create a new report with the desired attributes and metrics, run the report, and create a new Derived Metric.
7. As can be seen in the screenshot below, the Aggregate from base setting is now available, whereas previously it did not appear.
8. Note that this setting can only be applied in Web, however, it will take effect when reports are run via Desktop or Web.
9. This setting can be used to calculate a Derived Metric at the level of an attribute that is in the Reports Objects window but not on the grid.