Show TOC

EPMInsertCellsBeforeAfterBlockLocate this document in the navigation structure

This function inserts cells before or after a block of members for a specified dimension.

If the source range that you want to insert is smaller than the destination range in the report:
  • the first cells of the source range are inserted before the block of members.
  • the subsequent exceeding cells of the source range are copied and duplicated in all the cells of the destination range until the end of the report is reached.
Note The inserted cells are considered as "false" members. An inserted member is identified by a formula beginning with =EPMInsertedMember(.
Parameter Description
reportID ID of one or several reports
Dimension On a Planning and Consolidation connection, specify the dimension name. For other connections, specify the hierarchy name; to specify a hierarchy, enter: dimension.hierarchy
Before Specify where the cells must be inserted. Enter TRUE to insert the cells before the members, FALSE to insert the cells after the members.
Range Specify the cell range containing the content that you want to insert
Note When several reports share an axis, here is how the EPMInsertCellsBeforeAfterBlock function behaves: if you want to insert the cells in the master report only, you specify only the master report ID (using the reportID parameter); if you want to insert the cells only in a child report, you must specify both IDs (using the reportID parameter): the ID of the master report and the ID of the child report; if you want to insert the cells in several child reports, you must specify all IDs (using the reportID parameter): the ID of the master report and the IDs of the child reports. You must always specify the master report ID.