.jpg)
The first row specifies that Account members must begin with 11. The second row specifies that the Entity member must be Tx. The third row specifies that the ICP members must be between 00 and 99. The last row specifies that the UD1 (Custom1) member must be 00, 01. or 02. Imported source records that do not meet all of the listed criteria are excluded from the calculated results.
As illustrated in the following tables, for example 2, FDM derives two logic accounts from multiple source records. Two logic accounts are derived because two Group By cells include hard-coded values and two Group By cells include asterisk values. Therefore, within every source record that meets the specified criteria, the original Account and Entity members are replaced with the members listed in the Group By field. The other dimensions return all or some of the original members, as determined by the entries in the Group Level field.