Parametrized mappings

You can use text parameters in cube mappings.

Parameters can be used, broadly, anywhere that elements can be used but, specifically, to set:

  • Target element
  • Clear area
  • Element if not found
  • Element if empty

Example of a parametrized cube mapping

This example loads data about water sales by stockists into a Sales cube.

  1. Create a cube mapping.
  2. Create parameters called, for example, pWater and pStockist.

    We recommend that you provide descriptions of the parameters, to help users to specify the correct values.

  3. Use the parameters in the fact mapping.
    • Reference single-value parameters with @[parameter_name]
    • Reference multi-value parameters with @@[parameter_name]. You can do this in the Clear area field, for example.n Values in multi-value parameters must be separated by the pipe (|) character.

    For example, use the parameters to specify the name of the target element.

  4. In the Mappings Overview dashboard, run the mapping.

    The Mapping Parameters dialog box is displayed.

  5. Specify a value and click Start.
Note: If a parameter is not referenced in a mapping, then you can leave it empty. But if a parameter is referenced, then you must provide a value. Leaving a used parameter empty does not send NULL or an empty string.