The expansion replicates the sheet defining the expansion in several sheets (one sheet per expanded member), generating a book of reports for the desired set of members.

The generated sheets are named after the member being expanded in the sheet.

The page key defining the page member of the sheet dimension also contains the hard coded ID of the current member.

Each of the resulting tabs contains a replica of the starting EVDRE function, where the chosen dimension's member specified in the PAGEKEY is the (hard-coded) member ID associated with the current sheet.

The starting sheet defining the expansion is the first sheet of the expanded set. The starting sheet also has the chosen dimension's ID hard-coded in the page key, even if it initially contained a reference to the current view (by the use of EvCVW, for example).

The member set defining the sheet expansion cannot be specified as relative to the content of the page key (because it becomes hard-coded).

Otherwise, the workbook is not reusable for further expansions on different current views (of the dimension expanded in the sheets).

The member set of the sheet expansion can be either self-defined or you can relate it to what is defined in the current view bar by pointing to another cell in the sheet.

When you perform an expansion across sheets, the following restrictions apply: