Creating Scorecard Cubes
You can create a scorecard metric cube in TM1 applications with four steps:
First, click on the Create Scorecard link, which can be found on the top right corner of the main model design screen. And the steps are shown in a diagram, with links for each step.
- Define Scorecard Dimensions
Metrics dimension: a list of KPIs that are applicable to the business, such as revenue, expense, R & D, customer satisfaction, and market share, etc. This dimension has an additional attribute, Performance Pattern, which specifies the behaviour of a favourable variance against a KPI. Otherwise, it is a standard TM1 dimension, that similar features such as insert dimension calculations and formatting.
Metric indicator dimension: a list of measures and indicators. When creating a new metric indicator dimension, the dimension is pre populated with a default list of measures and indicators. If additional measures and indicators are needed, you can add them to this dimension.
- Create Scorecard Cube
The next step is to create a scorecard cube. The scorecard metric cube is similar to a standard TM1 cube, which contains scorecard metric and indicator dimensions. Other dimensions can be included in the scorecard cube, such as time and geography locations. Rules or links will need to be put in place to pull data through from other cubes, similar to a standard TM1 cube.
- Define Impact Diagram
The impact map defines the relationships between each of the metrics within the cube, and impact flows between them. For example, increase R&D would increase market share,which in turn increase revenue.
You can preview what your impact map looks like in the preview tab, you can drill down to individual metrics and expand on its connections.
- Create Strategy Map
Here you can define the business' objectives, and the metric measures applicable to each objectives. For example, if an objective is to grow revenue, the metrics to measure the success may be to increase R&D and reduce customer complaints.
Also, you can define the connections between different objectives, for example, reduce expenses would increase operational profit.
Similar to Impact Diagram, you can also preview how your strategy map looks like by going to the Preview tab.