Creating a Table of Contents for Multiple Worksheets

When you create multiple worksheets, you can specify whether Essbase creates a text file that lists all replicated worksheets created, their creation date, and their replicated member content.

To create a table of contents for the replicated worksheets:

Select Essbase, and then Cascade.
From Essbase Cascade Options, select Format Options.
Under Table of Contents, select Include Table of Contents.

Essbase creates a file named Prefix0Suffix.lst in the directory you specified, where Prefix and Suffix are prefix and suffix names you specified. If you do not specify a prefix or suffix, the default table of contents file name is 0.lst. Examples of table of contents file names are two0.lst, Budget0.lst, and tran0num.lst. The prefixes and suffixes you define can be a maximum of 8 characters each; however, your system may truncate the file name to use only a total of 8 characters.