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

This section of the tutorial starts with a new worksheet.

Formatting Text and Cells

In a spreadsheet report, many hierarchical levels of database information are displayed. By

defining and applying visual cues, or styles, to the text and cells in the worksheet, you can easily

keep track of specific database members, dimensions, and cell functions. Styles are an effective

way of viewing and distinguishing data in Spreadsheet Add-in.

Keep in mind that applying styles requires additional processing during a retrieval request. If

you need to remove styles, see “Removing Styles” on page 60.

This portion of the tutorial describes the following tasks:

● “Applying Styles to Parent Members” on page 55

● “Applying Styles to Dimension Members” on page 57

● “Applying Styles to Data Cells” on page 59

● “Precedence of Overlapping Styles” on page 59

● “Removing Styles” on page 60

For a discussion of the relationships among Essbase database members, see “Database Outlines”

on page 17.

Applying Styles to Parent Members

Each dimension in a database may contain a large number of hierarchical levels. As you view

data in the worksheet, you may not be familiar with all the hierarchical levels of the database

outline. To indicate which members have underlying children, you can apply formatting styles

to parent members, including those with attributes.

➤ To apply styles to parent members:

1 Select File > New or click to open a new worksheet.

2 Select Essbase > Retrieve.

Note:

You should still be connected to the Sample Basic database. If you are not connected, follow the

steps in “Connecting to a Database” on page 33.

3 In cell A2, drill down (double-click) on Year.

4 Select Essbase > Options.

5 In the Essbase Options dialog box, select the Style tab.

The Style tab is available only when you are connected to a database.

Essbase displays the Style tab, as shown in Figure 44.

Formatting the Worksheet

1 2 ... 50 51 52 53 54 55 56 57 58 59 60 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 55