KPI Account Group

The KPI Account Group integration table stores KPI account groups and their characteristics.

Use KPI account groups to:

  • Categorize and structure financial accounts for KPI calculations.
  • Provide a mapping layer between financial accounts and KPI.
  • Support mappings from base-level financial account elements.
Note: KPI account groups do not support mappings from consolidated parent elements and require the same account type as the mapped financial accounts.

KPI Account Group business object is used only by Financial Reporting application.

This table shows the properties of the KPI Account Group 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 A unique identifier of a KPI account group. nvarchar R
Name Caption displayed when a language-specific translation is not available. nvarchar R
ParentID If applicable, an identifier of the parent KPI account group.
Note: A corresponding record with the specified ID must exist in the KPI Account Group table. The record can be either a newly created entry that is not published to the database or an existing entry that is stored in the database.
nvarchar U
Weight Controls the roll‑up to parent elements.

Base elements use the default value of 1.

 float U
OrderPosition Position of a KPI account group in the resulting dimension. integer U
Type The financial account type of a KPI account group.

These values are allowed:

  • A: Assets
  • L: Liabilities
  • R: Revenues
  • E: Expenses
  • Q: Equity
 nvarchar R
GrowthImpact Positive or negative growth effect on the parent KPI account group.

These values are allowed:

  • P: positive impact
  • N: negative impact

The default value for the parent KPI account group indicates no growth impact.

The default values of a base KPI account group are:

  • Assets: Positive impact.
  • Liabilities: Negative impact.
  • Income: Positive impact.
  • Expenses: Negative impact.
  • Equity: Positive impact.
 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