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

15 Select the Copy Formatting check box to copy the formatting of the source worksheet into each cascaded

worksheet.

Copy formatting copies only the visual cues set using Essbase and the cell formatting that you

set using the worksheet. It does not copy formulas, column formatting, worksheet formatting,

or graphs.

16 In the Header and Footer text boxes, specify a header or footer name to be used for all of the cascaded

worksheets.

17 In the Sheet Formatting group box, select the Suppress Missing Rows check box so that rows containing

only #Missing values are not replicated.

18 In the Table of Contents group box, select the Include Table of Contents check box.

This creates a Table of Contents text file that lists all replicated worksheets, their creation dates,

and their member content. By default, Essbase names the Table of Contents file with the

extension

.lst.

19 Click OK to create the cascaded worksheets.

Essbase rapidly creates the cascaded worksheets. As each worksheet is created, it is automatically

saved, closed, and logged in the Table of Contents. Each individual file is saved in the directory

that you specified, named

Bud1.xls through Bud10.xls. When the Cascade is completed,

Essbase returns you to the original worksheet view (that is, the source file).

20 Using a text editing application, open the Table of Contents file from the destination directory that you

specified earlier. This file is named

BUD0.LST and contains a list of all cascaded worksheets, as shown in

Figure 165.

Figure 165 Table of Contents File for Cascaded Worksheets

21 Select File > Close to close the worksheet.

You do not need to save the worksheet.

You can create multiple worksheet files based on the attributes of a product. Type in the attribute

names in the top row of the worksheet. Select the attribute names and select Essbase > Cascade.

Proceed as previously described.

154

Advanced Tutorial

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

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 154