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

9 Click OK again.

Even though you have defined styles, they are not enabled until you select the Use Styles check

box from the Essbase Options dialog box and refresh the worksheet.

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

11 In the Cells option group, select the Use Styles check box to enable the styles, and then click OK.

12 Select Essbase > Retrieve to refresh the worksheet and apply the styles.

Essbase displays parent member names in bold, navy font.

13 In cell A2, drill down (double-click) on Qtr1.

Essbase displays Jan, Feb, and Mar in a regular font, because these members do not have

underlying children.

Figure 46 Styles Applied to Parent Members

Applying Styles to Dimension Members

In addition to applying styles to parent members, as you did in the previous exercise, you can

also apply styles to members of a dimension in a database. Applying styles to dimensions makes

it easy to view the various dimension members in Spreadsheet Add-in.

➤ To apply styles to dimensions:

1 Select Essbase > Options and select the Style tab.

2 In the Dimensions group box, select the Year check box.

3 Select the Cell Border check box to create a border around each cell that contains a member from the

selected dimension.

4 From the Background Color drop-down list, select Yellow.

Formatting the Worksheet

1 2 ... 52 53 54 55 56 57 58 59 60 61 62 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 57