User`s guide

Repeating Member Labels ............................................ 63
Working with Duplicate Member Names ................................. 65
Creating Queries Using Essbase Query Designer ............................... 67
About Creating and Changing Queries ................................... 68
Creating Queries ................................................... 68
Saving Queries .................................................... 74
Applying Queries .................................................. 76
Deleting Queries ................................................... 77
Viewing Messages and Confirmations ................................... 77
Accessing Help .................................................... 78
Connecting to Multiple Databases from Essbase Query Designer ................ 78
Applying Worksheet Options to Essbase Query Designer Results ................ 79
Selecting Members .................................................... 80
Saving and Disconnecting ............................................... 87
Saving a Worksheet ................................................. 87
Disconnecting from Essbase .......................................... 87
Logging Off ...................................................... 88
On to Advanced Tasks .................................................. 88
Chapter 4. Advanced Tutorial .......................................................... 89
Preparing to Begin the Tutorial ........................................... 89
Connecting to a Database ............................................ 89
Setting Essbase Options .............................................. 91
Performing Advanced Retrieval Tasks ...................................... 94
Filtering Data ..................................................... 94
Sorting Data ...................................................... 99
Retrieving Data into Asymmetric Reports ................................ 101
Drilling Down to a Sample of Members ................................. 103
Working with Formatted Worksheets ................................... 104
Preserving Formulas When Retrieving Data .............................. 109
Retrieving a Range of Data .......................................... 112
Retrieving Data by Using a Function ................................... 114
Retrieving Dynamic Calculation Members ............................... 117
Specifying the Latest Time Period for Dynamic Time Series ................... 119
Using Free-Form Reporting to Retrieve Data ............................. 122
Retrieving Data Using Visual Explorer .................................. 130
Using Linked Reporting Objects ......................................... 133
Linking a File to a Data Cell .......................................... 134
Linking a Cell Note to a Data Cell ..................................... 137
Contents
v