Arrow Storage Products EN106 Guia do Utilizador descarregar pdf (Página 153)

Figure 163 Destination Options Tab

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 a single workbook,

the same naming convention is used for the worksheet tab names within the workbook.

Caution!

Do not specify a prefix and suffix combination that leaves no characters free for Essbase to create

unique file names. If file names are duplicated, Essbase overwrites the duplicate file name with

the last cascaded worksheet.

14 Click the Format Options tab, as shown in Figure 169.

Figure 164 Format Options Tab

Creating Multiple Worksheets from Data

153

1 2 ... 148 149 150 151 152 153 154 155 156 157 158 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 153