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

An Example Scenario

For this example, the member name “Albany” appears under both the New York and California

members in a Market dimension as well as in a Customer dimension. With duplicate member

name support, Essbase can simply display “Albany” under New York and California in both

dimensions. Depending on the options you select, the qualified member name can be shown as

an Excel comment,

For this example, only the “Show Qualified Member Names as Comments” check box has been

selected in the Display tab of the Essbase Options dialog box.

In the spreadsheet, using the example of the duplicate name “Albany,” if the user hovers over

the indicator for Albany, New York, in the Market dimension, the cell comment reads:

<esskey>[Market].[New York].[Albany]</esskey>

If the user hovers over the indicator for Albany, New York, in the Customer dimension, the cell

comment reads:

<esskey>[Customer].[New York].[Albany]</esskey>

Further, if the user hovers over the indicator for Albany, California, in the Customer dimension,

the cell comment reads:

<esskey>[Customer].[California].[Albany]</esskey>

In a complex spreadsheet, the cell comment allows the user to easily pinpoint a member

combination.

In the above examples, if the “Show Qualified Member Names on Sheet” check box is selected,

for the instances of Albany in the Customer and Market dimensions, the qualified member name

is displayed directly on the worksheet.

Note:

To show qualified member names as comments, you must enable the “Comment Indicator only”

option in Microsoft Excel.

This task is optional. Optional tasks do not need to be performed as part of the tutorial. They are provided for information

only.

In Spreadsheet Add-in, to display duplicate member names:

1. Select Essbase > Options.

2. In the Display tab, select one or both of the following options from the Duplicate Members group:

● Show Qualified Member Names on Sheet to view the qualified member name on the sheet.

● Show Qualified Member Names as Comments to view the qualified member name when the cursor is hovered

over the comment indicator in a cell. When you use this option, ensure that the Comment indicator only

option of Excel is selected.

3. Click OK to close the dialog box.

Basic Tutorial

1 2 ... 61 62 63 64 65 66 67 68 69 70 71 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 66