Define Financial KPI Elements

Explanation

This activity is used to define Financial KPI Elements that are used as input when defining Financial KPIs. An element is always defined in a Cube and Company Group context and will always be based on a node in an Accounting Structure. The type of structure to be associated with the element should thus be defined, typically a Balance Sheet or Income Statement structure. A Financial KPI Element refers to a specific measure in the current target OLAP cube in the context of a Hierarchy Node in a cube Hierarchy in a specific cube dimension, e.g, this means that an element for operating result can be defined by using cube measure Act YTD in measure group GL ANALYSIS and using node "Operating Result" as defined in the Accounting Structure for IS that is connected to the used Company Group. Both aggregated nodes in an accounting structure as wells as individual accounts on the lowest level can be used. For nodes the identity is the node description. For accounts the identity is the account identity.

The Dimension Name and the Hierarchy Name comes from the OLAP cube and can be manually entered if known, else it is possible to use List of Values as long as SQL Server AMO and ADOMD in Microsoft SQL Server 2014 Feature Pack has been downloaded and installed on the client machine. However using List of Values will list all available cube dimensions as well as all attributes and hierarchies in that dimension, so it will still be necessary to know what dimension and hierarchy to choose. The Dimension Name can typically be ACC STRUCT IS CG and the Hierarchy Name ISHy. The Hierarchy Node will list all available nodes in the Accounting Structure defined by the Structure Type in the Company Group.

Prerequisites

This activity has the following prerequisites:

• Configuration Settings must have been done in order to define database and servers
• Downloading of SQL Server AMO and ADOMD in Microsoft SQL Server 2014 Feature Pack and installation on current client machine if OLAP cube specific List of Values functionality is required.
• KPI Company Group information must have been defined
• OLAP Cube Set-up must have been made
• The target OLAP cube Dimension Name and Hierarchy Name must be known (even if List of Values is enabled and used)

System Effects

As a result of this activity:

• Once the necessary Financial KPI Elements have been defined it will be possible to define Financial KPIs

Window

Financial KPI Element

Related Window Descriptions

Financial KPI Element
Financial KPI Elements
Connection Settings
KPI Company Group
OLAP Cube Set-up

Procedure

To perform this activity,

1. Open the Financial KPI Element window.
2. Define an Element ID and a Description for the element
3. Define the Element Scope, i.e. the Cube ID and Company Group ID that the element belongs to. Also specify the Structure Type that applies for the element in the current scope.
4. Define the Cube Source, i.e. the OLAP cube Dimension Name, the Hierarchy Name in the dimension and Hierarchy Node.
   Dimension Name and Hierarchy name must be known. It is possible to get List of Values support to browse available cube dimensions as well as available hierarchies and attributes in a dimension. Still it is important to know dimension and dimension hierarchies that are supported.
5. The Hierarchy Node Type defines whether the value to be used represents a structure node or a leaf.
6. The Hierarchy Node refers to a node or a leaf in the Accounting Structure defined by Structure Type in the referenced Company Group.
   
   
   • If Hierarchy Node Type is Node then Hierarchy Node should contain the description of the selected accounting structure node.
   • If Hierarchy Node Type is CodePartValue then Hierarchy Node should contain the identity of the selected accounting structure leaf.