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

● You must install the following components on your client computer:

❍ A 32-bit version of Excel

❍ Essbase Spreadsheet Add-in

❍ The Drill-through module

The drill-through module is installed automatically when you install Spreadsheet Add-

in. This module is transparent until you invoke it from the Linked Objects Browser. For

more information on installation, contact the Essbase system administrator.

● The Essbase system administrator must install the Essbase Server.

● You must have access to Integration Services and to an instance of Essbase Server. For more

information, contact the Essbase system administrator or the person who administers

Integration Services at your organization.

● You must have access to the underlying relational database (typically using a username and

password that are different from those that you use for Essbase). To obtain the appropriate

access, contact the Essbase system administrator or the person who administers Integration

Services at your organization.

● Make sure that the Essdt.xls sample drill-through report spreadsheet is available in the

\AnalyticServices\client\sample directory.

● To use the Essdt.xls sample drill-through report spreadsheet, you need to log in to a

computer with both Essbase Server and Integration Services installed. You must perform a

member and data load and calculate the data for the sample Essbase database that you will

access from Spreadsheet Add-in.

● The sample database that contains the drill-through report must be set up and running. The

sample drill-through reports used in this tutorial (called “Market Detail,” “Measures Detail,”

and “Product Detail”) are available with the sample spreadsheet files. Contact the person at

your organization who installs Integration Services to find out the name of the sample

database to use for drill-through.

For more information on Essbase installations, see the Essbase Integration Services Installation

Guide. For more information on Essbase installations, see the Hyperion Essbase - System 9

Installation Guide.

Keep in mind the following guidelines during the tutorial:

● Each tutorial task builds upon the previous one, and tasks must be followed in succession.

● Optional tasks are displayed in gray boxes. These tasks are included for your reference only

and should not be performed as part of the tutorial. You can find more information on these

tasks in the Drill-Through online help.

● The examples used in this tutorial are based on the sample database that is included with

the Integration Services installation. Contact the person at your organization who installs

Integration Services for information about accessing the sample database.

● Set the options in the Essbase Options dialog box as described in “Setting Essbase Options”

on page 165. If the option settings are different, the illustrations presented in this chapter

may not match the spreadsheet view.

164

Using Drill-Through

1 2 ... 159 160 161 162 163 164 165 166 167 168 169 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 164