Group By

When viewing the derived logic item in the Workbench, the Group By field enables the logic item to override the displayed member in the appropriate dimensions field. You can override to group the dimension based on the value entered in the Group By field. Use this field to hard code the returned member, or append hard-coded values to the original members by entering a hard-coded member and an asterisk (*) in the Group By field.

For example, by placing the word “Cash” in the row with account selected for dimension, the Import form displays “Cash” in the Account field for the logic item. If you place “L-*” in the Group By field, the import form displays “L-1100” where 1100 is the original account that passed the logic criteria.

If you enter no value in the Group By field, no grouping occurs for this dimension, and a separate logic item is created for each unique dimension member.