Parameters

Purpose

Parameters help users build & analyse their stories while using Linked fields. Flexibility to pass user context or selection of field1 value as variable to generate field2 values, as long field1 & field2 have relationship & mapping defined using property type "Linked to property" in field1 definition.

Parameters can be used to display a set of field values from a certain field dynamically with help of another field (linked to the property). It helps in mapping field values as a variable.

Couple of scenarios explained in detailed below for reference -

• Display cost centers field values based on Profit center

• Display Time members based on the Version

Parameter can be defined based on User Context or Book Context

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

• Book Context - parameter value for field is based on excel cell value Tagged to read from.

Prerequisites

Parameters required the relationship between the Fields to be defined using the property type "Link to Property" defined in the field, with field values mapped accordingly with each other.

example - To maintain relationship between Costcenter & Profitcenter - Costcenter will need to have "Linked to property" tagged to Profit center.

Additionally the Costcenter - Profitcenter mapping to be maintained in this property value.