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

➤ To display the name and alias of a member:

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

2 In cell C2, select Colas, and then select Essbase > Pivot.

3 In cell C3. select Year, and then select Essbase > Pivot.

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

5 In the Aliases option group, select the check box for Use Both Member Names and Aliases for Row

Dimensions.

Be sure that Use Aliases is already checked.

6 Click OK to return to the worksheet, and select Essbase > Retrieve.

The result is shown in the section called “Starting Spreadsheet Add-in”. Essbase displays both

member names and their aliases for row dimensions. Because the only row dimension in this

example that has preassigned aliases is Product, only the Product members display their aliases.

Region members simply repeat the member name instead of displaying an alias.

Figure 51 Result of Displaying Both Member Names and Aliases

Repeating Member Labels

By default, Essbase displays member labels only once for each nested row and column group. If

you are connected to a large database when using Spreadsheet Add-in, you may have to scroll

down or across the worksheet to see additional data rows and columns.

In some cases, as you scroll down or across, member labels disappear from view. Essbase provides

a feature for repeating member labels in each row or column cell that represents a data point,

so that you can always see a member label in the worksheet view.

➤ To repeat member labels down and across the worksheet:

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

2 In the Aliases option group, clear the Use Both Member Names and Aliases for Row Dimensions check

box, as shown in Figure 52.

3 In the Cells option group, select the Repeat Member Labels check box, and then click OK.

Formatting the Worksheet

1 2 ... 58 59 60 61 62 63 64 65 66 67 68 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 63