Calculated Metric

The Calculated Metric integration table stores metadata and configuration for calculated metrics. Calculated metrics derive values from other data with a mathematical formula.

Calculated Metric business object is used only by Financial Reporting application.

This table shows the properties of the Calculated Metric business object and uses these abbreviations:

  • BP: Budgeting & Planning
  • CO: Financial Consolidation
  • FR: Financial Reporting
  • WB: Workforce Budgeting
  • R: Required
  • U: Used but optional
Field Description Type BP CO FR WB
ID Unique identifier of the calculated metric. nvarchar R
Name Caption displayed when a language-specific translation is not available. nvarchar R
Description Detailed explanation of the calculated metric’s purpose, logic, or use. nvarchar U
GrowthImpact Indicates whether the calculated metric has a positive or negative impact on growth.

These values are allowed:

  • P: positive impact
  • N: negative impact
  • NA: Not Applicable
 nvarchar R
OrderPosition Position of an element in the resulting dimension. integer U
HasCurrencySelectionEnabled Enables a selection of the currency for the calculated metric.

These values are allowed:

  • 1: Selection of the currency is available
  • 0 or blank: Selection of the currency is disabled
 boolean U
HasUnitOfMeasureSelectionEnabled Enables a selection of the unit of measure for the calculated metric.

These values are allowed:

  • 1: Selection of unit of measure is available
  • 0 or blank: Selection of unit of measure is disable
 boolean U
UnitOfMeasure The unique ID of a unit of measure within the Unit of Measure business object.

The UnitOfMeasure value references the ID of the business object defined by the DefaultNameUsage property for FinancialDimensionID = 13 in the Business Object Configuration business object.

FOr example, For FinancialDimensionID = 13, if the DefaultNameUsage property specifies Analysis01, the UnitOfMeasure value references the ID property of the Analysis01 business object.

 nvarchar U
Group

Category or grouping to which the calculated metric belongs.

These values are allowed:

  • Liquidity
  • Leverage
  • Efficiency
  • Profitability
  • Others
 nvarchar R
Calculation

Formula or expression that defines how the calculated metric is calculated.

The formula supports mathematical operations such as an addition, subtraction, multiplication, and division.

The calculation formula is required for example, ([MAPG_2100] + [MAPG_2200]) / [MAPG_1000].

 nvarchar U
OrderPosition Shows the order of the calculated metric. integer U
FormatString Format pattern that is used for showing metric values. nvarchar U
LangEN Name translated into English. nvarchar U
LangDE Name translated into German. nvarchar U
LangFR Name translated into French. nvarchar U
LangES Name translated into Spanish. nvarchar U
LangJA Name translated into Japanese. nvarchar U
LangPT_BR Name translated into Portuguese (Brazilian). nvarchar U
LangRU Name translated into Russian. nvarchar U
LangIT Name translated into Italian. nvarchar U
LangZH_CHS Name translated into Chinese (Simplified). nvarchar U
LangCS Name translated into Czech. nvarchar U
LangNL Name translated into Dutch. nvarchar U
LangDA Name translated into Danish. nvarchar U
LangSV Name translated into Swedish. nvarchar U
LangNO Name translated into Norwegian. nvarchar U
LangPL Name translated into Polish. nvarchar U
LangTH Name translated into Thai. nvarchar U
LangFI Name translated into Finnish. nvarchar U
LangKO Name translated into Korean. nvarchar U
LangMS Name translated into Malaysian. nvarchar U
LangFR_CA Name translated into French (Canadian). nvarchar U
LangZH_TW Name translated into Chinese (Traditional). nvarchar U
LangID Name translated into Indonesian. nvarchar U
LangVI Name translated into Vietnamese. nvarchar U