Tab filter properties

List of tab filter properties

Note: the list of properties displayed varies depending on the type of dimension used as the filter.

Element	Description
Reference FX rates	Allows you to indicate a different FX rate from the one defined in the table, for the entity for the scenario/period in use, to be used in the form navigation step.
Sign change	This allows the user to change the sign in which the account is displayed. If the sign of a filter included in a formula changes, the formula will automatically account for the sign change.
Complementary	This allows the user to exclude a specific filter or node from a node of filters in a hierarchy. Thus, the system displays the entire hierarchy of the filter’s parent node or excluded node, except for the specific filter or node. Note: the additional filter is identified by the prefix and works on hierarchies but not groupings.
Size	Indicates the dimension to which the selected element belongs. Non-editable property.
Dividing factor	Allows you to set the factor for the calculation of the average amount for a defined number of days or by period.
Dictionary	Allows the user to associate dictionary items in the languages enabled in the environment with rows. When the form is run, instead of the description, the sheet name shows the dictionary item translated into the user’s language. For more details, see Dictionaries.
Advanced selection	This allows the user to define a set of elements that the system must dynamically recover when running the form. For more details, see Dynamic matrices.
Navigation	Only visible if a parametric filter on the Scenario dimension has been selected. Allows the user to set criteria for navigating between scenarios (previous, next and reference). For more details, see Navigating scenario parameters.
Period Difference	Only visible if a parametric filter on the Period dimension has been selected. Allows the user to set criteria for navigating between periods. For more details, see Navigating period parameters.
Formula	Allows you to define elements calculated as formulas within the sheet. For more details, see Formula filters.
Hide	Allows you to hide sheets when the form is run.
Segment	Allows you to view intercompany data related to the entities of an entity node called a segment. This property’s default value is defined in advanced form settings (see Settings window) and used on all the tab filters set on entity dimensions, custom dimension 2 or the counterparty entity. This value can be overridden when designing the form.