Creating a derived metric

Derived metrics can be created in the following:

• As part of the design or analysis of a report. This allows you to create these metrics while focusing on a given report.

  You can create a derived metric in any report. This includes reports connected to an Intelligent Cube, reports returning information directly from a data warehouse, Freeform SQL reports returning information from an Excel spreadsheet, and so on.

• In Report Services documents. You can define a derived metric based on one or more metrics from the document's datasets. For instructions to create derived metrics in Report Services documents, refer to the Document Creation Help.
• In Visual Insight dashboards. You can quickly and easily add simple derived metrics to a Visual Insight (VI) dashboard on the fly. For instructions to create derived metrics in VI dashboards, see the Strategy Web Help.