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

1. Select all cells in the worksheet.

2. From the Excel menu bar, select Edit > Clear > Formats.

To turn off styles:

1. Select Essbase > Options and, select the Display tab.

2. In the Cells option group, clear the Use Styles check box, and click OK.

Note:

If you turn styles off without clearing them from the worksheet, the styles remain in the current

worksheet view when you refresh the view. The styles remain to avoid removing any styles that

you may apply to individual cells using native worksheet formatting options.

Displaying Aliases for Member Names

An alias is alternate name for a database member. You can create reports that use the database

member name, which is often a stock number or a product code, or an alias name, which can

be more descriptive. Aliases are defined by the Essbase application designer. Each database can

contain one or more alias tables.

For example, members of Product in the Sample Basic database are defined as codes, such as

100 and 200. A descriptive alias for each member of Product, such as Colas and Root Beer, is

defined in an alias table. In some cases, alias names may vary depending on the combination of

other database members. For example, a Product member may have a different alias for each

market in which it is sold. For more details about member names and aliases, see the Spreadsheet

Add-in online help or the Hyperion Essbase - System 9 Database Administrator's Guide.

➤ To display the alias of a member rather than its database name:

1 In cell C2, double-click the secondary mouse button to drill up on Actual.

2 Press and hold down the Alt key and drill down (double-click) on Product in cell D1.

3 Select Essbase > Options, and select the Display tab.

4 In the Aliases option group, select the Use Aliases check box to display member aliases.

5 Select Default from the Alias drop-down list, as shown in Figure 49.

Formatting the Worksheet

1 2 ... 56 57 58 59 60 61 62 63 64 65 66 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 61