AddMember

Use this option within a Row definition to add an icon to the form which, when clicked, enables users to select members to add to the form. The new members are added to the form and the user can then enter data for these members.

You can use the AddMember option with the Account, ICP, and Custom dimensions.

Note:

NoData cells can be suppressed by using the SuppressNoDataRows keyword or selecting the applicable check box on the form.

Syntax

AddMember:MemberList
         

Replace MemberList with the list name from which users will be able to add members to the form.

Caution:

You can reference only one member list per AddMember line.

To use this option, two separate row definitions are needed:

  • A summary row that displays totals for the member list and has the AddMember option.

    Note:

    The summary row cannot be suppressed.

  • A list row that has the same POV specified in the summary row, except that it has a list for the dimension to which members are being added. The list must contains at least the members from the summary row list.

    Note:

    The list row can be placed before or after the summary row.

Example

R1=A#SalesInterco.I{[Base]}
R2=A#SalesInterco.I#[ICP Entities],
AddMember:I{[Base]}

In this example, Row 1 specifies the [Base] member list for the Intercompany Partner dimension. Row 2 specifies the total for the member list and the member list to be used with the AddMember icon.

Note:

You can use the AddMember option in multiple rows in a form, but each summary row needs its own list row.