The Destination Options page enables you to select where and in what form the cascaded worksheets are to be created, and specify the prefix and suffix of the file names or workbooks.
Destination Directory—Enables you to specify the directory where the cascade operation is to create the worksheets.
Browse—Click to display the Browse dialog box to locate the desired directory.
Separate Workbooks—Select to place the cascaded worksheets into multiple workbooks.
One Workbook, Separate Sheets—Select to place cascaded worksheets into multiple worksheets within one workbook.
Printer—Select to send cascaded worksheets to the default printer.
Printer—Click to display the Printer dialog box to specify the printer to use.
Open Created Files—Select to open each file in the spreadsheet, as it is created.
A cascade can create more worksheets than can fit into memory. Therefore, the Open Created Files option should not be used with a large number of worksheets.
Overwrite Existing Files—Select to indicate that cascaded worksheets replace worksheets with matching names, which is the default setting.
Prefix—Enables you to assign a prefix to the file names Essbase creates. By default, Essbase generates worksheet names that are numbered incrementally, starting from 1. For example, if a prefix of BUD is defined, Essbase names the worksheets: BUD1, BUD2, and so on.
If you do not specify a prefix or suffix, Essbase names the worksheets incrementally 1, 2, and so on.
Do not specify a prefix and suffix combination that leaves no characters free for Essbase to create unique file names. If you duplicate file names, Essbase overwrites the duplicate with the last cascaded worksheet.
Suffix—Enables you to assign a suffix to the file names Essbase creates. By default, Essbase generates worksheet names that are numbered incrementally, starting from 1.
If you do not specify a prefix or suffix, Essbase names the worksheets incrementally 1, 2, and so on.
Do not specify a prefix and suffix combination that leaves no characters free for Essbase to create unique s. If you duplicate file names, Essbase overwrites the duplicate with the last cascaded worksheet.
Cascade Information Page (Essbase Cascade Options Dialog Box)