Arrow Storage Products EN106 Podręcznik Użytkownika Strona 4

  • Pobierz
  • Dodaj do moich podręczników
  • Drukuj
  • Strona
    / 200
  • Spis treści
  • BOOKMARKI
  • Oceniono. / 5. Na podstawie oceny klientów
Przeglądanie stron 3
Members ........................................................ 18
Attributes ........................................................ 19
Formulas ........................................................ 19
Aliases .......................................................... 19
Consolidations .................................................... 19
Chapter 3. Basic Tutorial ............................................................ 21
Getting Acquainted with Spreadsheet Add-in ................................. 21
Registering Spreadsheet Add-in ........................................ 22
Adding Spreadsheet Add-in ........................................... 22
Starting Spreadsheet Add-in .......................................... 23
Installing the Essbase Toolbar for Excel .................................. 23
Using the Essbase Toolbar ............................................ 24
Accessing Online Help .............................................. 26
Enabling Mouse Actions ............................................. 26
Preparing to Begin the Tutorial ........................................... 28
Enabling Compatibility with Hyperion Smart View for Office .................. 28
Setting Essbase Options .............................................. 29
Following Guidelines During the Tutorial ................................. 32
Reviewing the Sample Basic Database .................................... 33
Retrieving Data ....................................................... 33
Connecting to a Database ............................................ 33
Changing a Password ............................................... 35
Retrieving Data from a Database ....................................... 35
Canceling a Data Retrieval Request ..................................... 37
Restoring the Previous Database View ................................... 37
Drilling Down to More Detail ......................................... 38
Drilling Up to Less Detail ............................................ 41
Customizing Drill-Down and Drill-Up Behavior ............................ 42
Pivoting, Retaining, and Suppressing Data ................................... 44
Pivoting Rows and Columns .......................................... 44
Retaining a Data Subset .............................................. 47
Removing a Data Subset ............................................. 49
Navigating Through the Worksheet Without Retrieving Data .................. 49
Suppressing Missing Values, Zero Values, and Underscore Characters ............ 52
Formatting the Worksheet ............................................... 54
Formatting Text and Cells ............................................ 55
Displaying Aliases for Member Names ................................... 61
Displaying Both Member Names and Aliases .............................. 62
iv
Contents
Przeglądanie stron 3
1 2 3 4 5 6 7 8 9 ... 199 200

Komentarze do niniejszej Instrukcji

Brak uwag