Parameters

Purpose

Parameters help users build and analyze their stories while using linked fields. They provide flexibility to pass user context or select a field1 value as a variable to generate field2 values, as long as field1 and field2 have a relationship and mapping defined using the property type "Linked to property" in the field1 definition. Parameters can be used to dynamically display a set of field values from one field with the help of another field (linked to the property). This helps in mapping field values as a variable.

A couple of scenarios explained in detail below for reference:

• Display cost center field values based on the profit center.

• Display time members based on the version.

Parameters can be defined based on User Context or Book Context:

• User Context: Parameter value for the field is based on the user context/selection from the add-in.

• Book Context: Parameter value for the field is based on the Excel cell value tagged to read from.

Caution: Prerequisites: Parameters require the relationship between the fields to be defined using the property type "Link to Property" in the field, with field values mapped accordingly with each other. Example: To maintain the relationship between cost center and profit center, the cost center will need to have "Linked to property" tagged to the profit center. Additionally, the cost center and profit center mapping needs to be maintained in this property value.