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

Using the Essbase Cascade feature, you can create multiple worksheet files based on a single

database view. You can specify at what level of detail you want to replicate the worksheets to

tailor the information to each recipient’s needs.

The Sample Basic database contains data for beverage products sold in different states across the

U.S. For example, assume that you want all product managers to review and respond to a

proposed budget and to return their changes to the finance department. You must create a

worksheet for each combination of budget and P&L data to distribute to the product managers

for their respective products.

➤ To create this set of worksheets:

1 Select File > Open.

2 From the \AnalyticServices\client\sample directory, open the P&l.xls file.

This file contains the data that you need to replicate for each worksheet.

3 Select Essbase > Retrieve.

Notice that the retrieval uses the Use Aliases option, which is already set for this file in the Essbase

Options dialog box. In this example, product 200 changes to Root Beer, which is its preassigned

alias.

4 Select Central (in cell B1) and Root Beer (in cell B2) as the members to be represented in the resulting

worksheets.

5 Select Essbase > Cascade.

Essbase displays the Essbase Cascade Options dialog box.

6 Click the Cascade Information tab.

The Cascade Information page contains the list of members that you selected and the options

for specifying the level at which the selected members are retrieved into the cascaded worksheets.

For more information on each option, see the Spreadsheet Add-in online help.

7 Select Central in the Member list box, and select Same level in the Choose Level for Selected Member

option group.

8 Select Root Beer in the Member list box, and select Next level (the default setting), as shown in

Figure 162.

Creating Multiple Worksheets from Data

151

1 2 ... 146 147 148 149 150 151 152 153 154 155 156 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 151