Inserting members

The Insert Members tab provides greater flexibility in working with a dataset than the Insert Block task by enabling you to manually insert a subset of a selected dataset anywhere in the worksheet, one dimension at a time and one or more members at a time.

Insert Members enables you to pick and choose which dimensions and which members to show on the worksheet. Unlike the Insert Block task, any dimension can be inserted as an on-grid or off-grid dimension, and any on-grid or off-grid dimension can be oriented as an Across or Down dimension. This data can be inserted on a worksheet as supplemental information to a block of data, or it can be inserted onto a new worksheet.

The Insert Members task is used in conjunction with the Insert Value task. Insert Members adds the dimension member name, and Insert Values adds the value associated with the selected data slice.