Calculate Derived metrics at the level of all attributes in the report objects

Hello there,

I found an excellent TN that can save some time. Maybe you already have to create a derived metric that was calculate using all attribute that you have in the report objects and not in the grid and you couldn’t find a way to do that. There is a hidden option that you can enable to allow that option.

You just have these steps:


  • Locate the XML file sys_defaults.xml which can be found in the path C:\Program Files (x86)\MicroStrategy\Web ASPx\WEB-INF\xml.
  • Right-click on this file and edit it using a text editor.
  • Search for the showAggFromBaseOnMetricEditor flag and change it from the default value of 0 to 1.
  • Save and close.
  • Restart Web Server.
  • Log into Web, create a new report with the desired attributes and metrics, run the report, and create a new Derived Metric.
  • As can be seen in the screenshot below, the Aggregate from base setting is now available, whereas previously it did not appear.
  • Note that this setting can only be applied in Web, however, it will take effect when reports are run via Desktop or Web.
  • 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.

Hope it helps.

God bless you


Copied from


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.