Table of Contents

Measure facts

Overview

This is a simple input tool for maintaining historical data for the driver based module.


Select a value in the “Dataset” and “Measure” filter at the top and click the “Refresh” button to enable the save button.

Add new rows as needed or paste selection. When pasting data, make sure to paste dimension ids. A dropdown will evaluate the id against the corresponding dimension and render the dimension description. If no description is rendered, just the id, this indicates that the id does not exist in the dimension.

Column Descriptions

  • Dataset:
    DatasetID. Mandatory.

  • Departm.:
    Department id. Mandatory.

  • Product:
    Product id. Mandatory.

  • Market
    Market id. Mandatory.

  • Supplier
    Supplier id. Optional. If no value is provided, the default value # is set

  • Dim1:
    Dim1 id. Optional. If no value is provided, the default value # is set

  • Dim2:
    Dim2 id. Optional. If no value is provided, the default value # is set

  • Dim3:
    Dim3 id. Optional. If no value is provided, the default value # is set

  • Dim4:
    Dim4 id. Optional. If no value is provided, the default value # is set

  • Cp Legal Entity:
    Counterpart legal entity id. Optional. If no value is provided, the default value # is set

  • Measure:
    The measure id. Mandatory.

  • Value 0..9:
    The value. Numeric. Value will default to 0 if no value is provided. Any amounts must be given in the home currency.

  • Year yyyy:
    4-digit year, for example 2020. Mandatory

  • Month 1-12:
    Month number, 1-12. Mandatory

Applies to: img Planner 4.2 or later

Project
Project id. Optional. If no value is provided, the default value # is set.

Activity
Activity id. Optional. If no value is provided, the default value # is set.


Dimension combinations found in the source and not in the input module for either the last 12 months actuals or any of the (optional) historical reference columns, will automatically be processed into the module on forecast rollover.

The module can also be updated manually by clicking the “Apply…” button in the:

Applies to: img Planner 5 or later

“Models” page of the “Driver based modelling” workbook.

Applies to: img Planner 4.x

“Sales Forecast Setup” page of the “Sales Forecast Setup” workbook.

How to`s


Applies to: img Planner 5.4 or later

Applies to: img Planner 5.2.4 or later

Applies to: img Planner 5.0 or 5.1

Applies to: img Planner 4.x

Edit this page