Strategy and Objective
The hierarchy supports one level only. Objectives are defined directly under a strategy. Deeper hierarchy levels are not supported.
Each strategy must have at least one assigned objective.
The StrategyObjective integration table must contain at least these records:
- Objective record: An objective that is assigned to a strategy. The ParentID field is specified.
- Strategy record: The strategy definition. The ParentID field is not specified.
A strategy can reference a new record that is not stored in the database or an existing record that is stored in the database. One objective can be assigned to multiple strategies.
This table shows an example of records in the StrategyObjective integration table:
| ID | Name | ParentID | Other Properties |
|---|---|---|---|
| Objective1 | Objective 1 | Strategy1 | |
| Strategy1 | Strategy 1 |
Strategy and Objective business object is used only by Financial Reporting application.
This table shows the properties of the Strategy and Objective 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 the strategy or objective. | nvarchar | R | |||
| Name | Caption displayed when a language-specific translation is not available. | nvarchar | R | |||
| ParentID | References the ID of the parent strategy or objective in the hierarchy.
If the record is a strategy, no value is used. If the record is an objective, the value is the strategy ID. |
nvarchar | U | |||
| Weight | Numeric value that indicates the relative importance or weighting of the strategy or objective. The default value is 1. | float | U | |||
| OrderPosition | Position of the strategy or objective in the dimension. | integer | 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 |