Show TOC

Function documentationInsert Members Locate this document in the navigation structure

 

You use this feature to insert an explicit set of members before the current row or column of an EvDRE report or input schedule.

Features

You can use the following features:

  • You can insert an explicit set of members that are valid for insertion. You can define the set by using the same syntax available in the MemberSet fields (comma-delimited list; for example, BAS, DEP). See MemberSet Parameter.

    Note Note

    Keep the MemberSet in sync with the list of insertable members.

    Do not define a suppressed expansion on one set of members (like Cash, AccRec, or Inventory) but also allow for the insertion of a different set of members (like Banks, AccPay, or OtherLiabs). This may send values to cells that do not appear on the screen, when other values exist in the database for these cells.

    End of the note.

  • You can use the Insert option in COLUMN keys, enabling you to insert a new column on the fly into the sheet.

  • You can also activate the insert mechanism on the Column keys, enabling you to insert new columns into the sheet on the fly.

  • Do not insert members in rows (or columns) containing EV_BEFORE or EV_AFTER placeholders.

Note Note

The Insert operation is not allowed on rows (or columns) containing EV_BEFORE or EV_AFTER placeholders.

End of the note.

Activities

Replace the Insert parameter Y with an explicit set of members that are valid for insertion.

Example

Expansion 3

Row

BAS(TOTALCURRENTASSETS)

Y

BAS(TOTALCURRENTASSETS)

The system inserts the FormattedRange into the report design. When a formatted member set range has been defined, the insert action automatically triggers the insertion of the entire set.

Note Note

You can disable this automatic insertion by using the Insert option in the dimension using a formatted range.

The system does not activate the automatic insertion of the entire set if the member set is not formatted; that is. if the set is defined with a one-column range (or directly defined in the MemberSet field).

End of the note.

The system does not automatically insert the entire set if the member set is not formatted (if the set is defined with a one-column range or directly defined in the MemberSet field).