Specifying Multiple Worksheet Names

Using the Cascade command, you can assign customized prefixes and suffixes to the replicated worksheets. The Prefix and Suffix boxes enable you to assign a prefix and suffix to file names Essbase creates, respectively. The default is to generate worksheet names that are numbered from 1 through n, where n is the total number of worksheets to create. The syntax for file names is PrefixnSuffix.xls.

When the One Workbook, Separate Sheets option is applied, the Workbook box enables you to specify a name for the workbook. By default, Essbase uses the same naming convention specified for the prefix and suffix to name the worksheets within a workbook.

To specify the file name of replicated worksheets:

Select Essbase, and then Cascade.
From Essbase Cascade Options, select Destination Options.
Under Naming Information, enter the prefix for the worksheet name in Prefix.
When you assign a prefix or suffix in the Naming Information group box, the worksheet files that are generated as a result of executing the Cascade command are named with the prefix or suffix that you specify. The default is to generate worksheet names that are numbered 1 through n, where n is the total number of worksheets created.
The syntax for the file names is PrefixnSuffix.xls for Excel. If you do not specify a prefix or suffix, Essbase creates the worksheets 1.xls, 2.xls, and so on. If you are creating one workbook, the same naming convention is used for the worksheet names within the workbook.

Enter the suffix for the worksheet name in Suffix.

Caution!

Do not specify a prefix and suffix combination that leaves no characters free for Essbase to create unique file names. 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. If file names are duplicated, Essbase overwrites the duplicate file name with the last cascaded worksheet.

If you selected One Workbook, Separate Sheets under Destination Types, enter the name of the workbook under Workbook.

See the Oracle Essbase Spreadsheet Add-in User's Guide for an example of a report created after a Cascade operation.