How to create scorecard cubes with TM1

matthewk September 12, 2013 IBM Cognos ExpressIBM Cognos TM1

How to create scorecard cubes with TM1

The purpose of scorecard is to enable broader range of staff in an organisation to have a better understanding of its strategies, and the relationships of those strategy goals. For example, to grow net profit, the organisation may seek ways to reduce expenses and/or increase sales, quite obvious. But what are the key success factors or performance indicators that the business should be focusing on, and how are those KPIs are performing? For example, to reduce expenses, the organisation may be focusing on improving the production efficiency of a certain product, and this KPI may depend on the amount of R & D invested in this product. Gaining understanding of the business goals and their connections, will help the key decision makers to translate goals into objectives, and and objectives into planning. Graphical View of KPIs

The scorecard feature provides users with a graphical display of the performance and connection of those key metrics, using existing planning data.


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.

  1. Define Scorecard Dimensions
  2. 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.

  3. Create Scorecard Cube
  4. 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.

  5. Define Impact Diagram
  6. 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.

  7. Create Strategy Map
  8. 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.


Once you have created your metrics cube, a scorecard cube view can be added to another application and deployed to users. This scorecard view can be accessed using TM1 Applications Web and Cognos Insight.


ScorecardTM1Cognos TM1Metric CubeStrategyCorporate StrategyStrategy MapImpact DiagramCustom DiagramActual vs. Target