Modelling

SAP Strategy Management’s modelling capabilities help organisations design a performance-centric data model. With the ability to create a standardised performance management data repository, SAP Strategy Management’s modelling ensures that a consistent set of metrics is used to align operational execution with strategy.

SAP Strategy Management starts from the assumption that data may be sourced from multiple resources around the business and is source agnostic supporting load from structured sources, flat files or Excel. There is no dependency on SAP BW.

Where SAP BW is available, the BI Connector Interface (BICA) within SAP Strategy Management provides a pre-built connector to integrate into SAP BW to enable the build of models and the dimensional structure based on existing hierarchies, exposing existing queries for data load.

A single data point can be used in multiple metrics and KPIs to minimise data load duplication and metrics or KPIs can be created as a product of the combination of multiple metrics or calculations.

SAP Strategy Management’s inbuilt multi-dimensional OLAP database provides the ability to switch the view of data almost instantly from one dimension to another without the need to re-run queries.

Key features and benefits

  • Shared data repository: Provides an accurate, consistent understanding of data — such as data origin and dimension definitions.
  • Immediate response: No requirements to re-run queries on external systems when changing dimensions or periodicity.
  • Out of the box integration with SAP BW: Pre-built connector to SAP BW incorporated within the system ready to leverage existing investments.
  • Model Designer interface: Supports the creation of models without the need for programming knowledge simplfying proof of concept development.

Modelling examples

  • A key indicator of success for this organisation is the market share that they command in a diverse but highly structured market. Benchmark data is regularly available from a central industry body in an Excel spreadsheet that details the revenue achievement for each of the 40 product categories for the 150 organisations active in the market and how that revenue was split by the 7 channels in the market. The organisation’s target is to be position X in each of the product categories where they operate. Loading the base spreadsheet values into SAP Strategy Management, the revenue for each of the product categories and channels within each category is calculated and ranked. The organisation’s achievement is then compared to the achievement of position X so that they can chart their progress and compare their performance both against their target position and the performance of any of their competitors in a given category or channel.
  • Combined Operating Ratio is a key indicator for a financial services organisation. The ratio is derived by combining net claims, net commissions and net expenses, each of which is derived from multiple data elements, with the policies applicable to each of the relevant categories. The multiple data elements are loaded into SAP Strategy Management’s PAS database and the relevant calculations performed to create the ratio, which can then be compared to their target ratio.

Next: Administration


Tel: +44 (0)870 166 2435, Fax: +44 (0)870 054 8795, Email: info@issel.co.uk

© 1996-2017 ISSEL Intranet Software Solutions (Europe) Ltd. All rights reserved

Site Map