The Format Options page enables you to specify header and footer information, suppress missing rows, and generate a list of the files created for your worksheets.
Copy Formatting—Select to copy the formatting (styles set using the Style page of the Essbase Options dialog box) of the source worksheet into each cascaded worksheet.
Copy Formatting does not copy formulas, column formatting, worksheet formatting, or graphs. It does copy styles you set using Essbase and cell formatting you set using the spreadsheet.
Header—Enables you to specify a header name for all cascaded worksheets.
Footer—Enables you to specify a footer name for all cascaded worksheets.
Suppress Missing Rows—Select to exclude missing rows from appearing in the cascaded worksheets.
Include Table of Contents—Select to create a text file containing a list that displays the member content and the dates of the cascade files. This file is named Prefix0Suffix.LST.
Cascade Information Page (Essbase Cascade Options Dialog Box)
Destination Options Page (Essbase Cascade Options Dialog Box)