A
access
to databases, (1), (2)
to Essbase data, (1), (2)
to linked partitions
to multiple applications
using drill-through reports
access permissions
for linked partitions
accessing
data
from Hybrid Analysis
from relational source
drill-through
Essbase commands
linked objects, (1), (2), (3)
linked partitions
multiple databases, (1), (2)
ad hoc reporting, (1), (2)
ad hoc reports, (1), (2)
Add button
add-ins, managing
adding
filters, (1), (2)
members, (1), (2)
modules to Essbase
adjusting
column widths
adjusting column width
adjusting column widths
Advanced Interpretation mode
described
retrieving generation names
retrieving level names
Advanced Interpretation option
alias member combinations
alias names, displaying, (1), (2)
aliases
definition of
displaying
process of
with member names
with Query Designer results
aliases and member names, using
All Levels option
alphabetical sort order
alternate names. See aliases.
API
application partitions. See linked partitions.
applications/databases
Sample Basic, (1), (2), (3), (4)
sample for drill-through
Sample Interntl
Sample Xchgrate
applying
filters, (1), (2)
subsetting rules
applying queries
ascending sort order
in drill-through reports
asymmetric reports
pivoting
Attach Linked Object dialog box, (1), (2), (3), (4), (5), (6), (7)
attaching reporting objects to cells. See linking.
attaching to databases. See connecting.
attribute dimensions
applying visual cues
changing fonts and colors
attribute members, drill down behavior
attributes
changing visual cues
comparing Boolean
comparing text
creating cascade reports
selecting base dimensions
selecting members, (1), (2)
attributes, drill down, (1), (2)
audit files
auto logouts
C
Calculate menu equivalent, (1), (2)
calculating databases
with calculation scripts
Calculation command, (1), (2), (3)
calculation function
calculation macro
calculation scripts
calculations
databases, (1), (2)
dynamic
reducing calculation time
specifying latest time period
substitution variables
with Dynamic Time Series
cancel calculation function
cancel calculation macro
canceling retrievals
Cascade command, (1), (2), (3)
cascade function
Cascade Information page
cascade levels, selecting
cascade macro
Cascade menu equivalent, (1), (2)
Cascade Options dialog box
cascading sheets
creating table of contents
destination
formatting options
level of detail
output type
cascading worksheets
creating table of contents
creating table of contents for
destination directory of
detail level
format information
location of
names of
output type
specifying names
suppressing missing rows in
Cell function
Cell macro
cell notes
accessing
accessing linked
creating
editing
Linked Reporting Objects dialog box and
linking to cells
viewing
cell ranges
keeping
removing
retrieving
selecting nonadjacent
with drill-through
cell retrieve function
cells
accessing linked partitions
applying styles
attaching reports. See linking.
EssCell function in
formatting, (1), (2)
in data cells
of dimension members
of Dynamic Calculation members
of parent members
formulas in, (1), (2), (3)
linked reporting objects
linking files to
linking notes to
retrieving a range of
retrieving values
selecting nonadjacent
with nondatabase values
Change Password dialog box, (1), (2), (3)
changing
passwords
reports
row and column orientation, (1), (2)
session options, (1), (2)
spreadsheet format
worksheet options, (1), (2), (3)
child members
changing fonts and colors of
changing visual cues
Clear All button
Clear button
Clear command
clearing
filters
member selections
styles
visual cues
clearing styles
client
software
collapsing data views, (1), (2), (3), (4). See also drill
colors, changing
column limits, (1), (2)
column widths, adjusting
columns
adjusting width, (1), (2)
blank
displaying as rows
displaying selected
filtering by
keeping selected
nested
ordering
pivoting
removing selected
retrieving into
selecting
sorting, (1), (2)
columns, drill-through
choosing
selecting display order
selecting for retrieval from relational source
sorting
commands
Calculation
Cascade
Clear
Connect, (1), (2), (3)
Disconnect
Essbase
FlashBack
Keep Only
Linked Objects
Member Selection
Navigate Without Data
Pivot
Remove Only
Retrieve
Undo
Zoom In
Zoom Out
comparison operators, (1), (2)
compatibility with Smart View, enabling
compatibility, enabling with Smart View
concurrent
database access
updates to server
concurrent database access
conditional retrievals
Connect command, (1), (2), (3), (4), (5)
Connect menu equivalent, (1), (2)
connecting. See also disconnecting
to a database, (1), (2)
to a relational data source, (1), (2)
to Essbase
to Integration Server, (1), (2)
to Integration Services
to multiple databases
to relational data sources
viewing current connections
connection function
connection macro
connections, database, viewing
constants, level, VBA
conversions, currency
creating
ad hoc reports
cell notes
member filters
queries
reports
currency conversions
modifying exchange rates
reporting
sample databases
settings
Currency Report command, (1), (2)
Currency Report dialog box
Currency Report menu equivalent, (1), (2)
current time period. See Dynamic Time Series.
Customize button
customizing drill-through reports
customizing reports, (1), (2)
D
data
calculating
changing orientation
comparing values
comparison operators
displaying
dynamically calculating
filtering
filtering by comparing data values
filtering by ranking data values
filtering, in drill-through reports
formatting
locking
missing
navigating
pivoting, (1), (2)
ranking data values
relational, and drill-through reporting
removing sets
retaining subsets
retrieving, (1), (2)
sorting, (1), (2), (3)
transposing
unlocking
updating, (1), (2)
data cells
changing colors of
changing fonts of
data filter panel, shortcut menus
data filters, applying multiple
data ranges, retrieving
data restrictions, deleting
data retrieval, (1), (2)
data retrieval basics
data retrieval function
data retrieval macro
data sort order, and drill-through reporting
data sort order, selecting
data sorts, creating
data source, connecting to
data source, relational
database calculations
Database Note dialog box
database notes, viewing
databases
calculating, (1), (2)
concurrent access
connecting to
connecting to multiple
disconnecting from
exiting
linked. See linked partitions.
loading
locking
logging off
logging on
restoring previous views
sample, (1), (2), (3)
selecting
switching
viewing connections
default sort order
defining filters, (1), (2)
deleting
filters
filters, in drill-through reports
LROs
members
selected members
styles
descendants, expanding to
descending sort order
in drill-through reports
Destination Options page
destinations
cascaded sheets
Query Designer queries
detaching. See disconnecting.
dimension members, (1), (2)
dimensions
applying styles
attribute, selecting
changing colors of
changing fonts of
currency conversion and
drilling down on, (1), (2)
drilling up on
pivoting
Disconnect
command
dialog box
Disconnect command, (1), (2)
disconnect function
disconnect macro
Disconnect menu equivalent, (1), (2)
disconnecting
forced logouts
from Essbase
from Integration Server
discontinuous rows and columns
disk space, effect on Dynamic Calculation
display
options
order of columns in drill-through reports
Display options
basic tutorial and
display order, selecting
Display page (Essbase Options dialog box)
Display Unknown Member message
Display Unknown Member option
displaying
error messages
information messages
Save dialog box for member selection
unknown members, (1), (2)
warning messages
displaying data
distributed sheets. See cascading sheets.
distributing multiple worksheets with cascade
double-clicking
enabling
for drilling
for linked object browsing, (1), (2)
drill
by double-clicking
Formula Fill
retain formulas during
to less detail
drill down
on attributes, (1), (2)
drill-through
accessing, (1), (2)
cells, defining styles for
described
installing, (1), (2)
Integration Services
multiple cell selection
sample
database
drill-through report
file
saving filters
starting
tutorial guidelines
tutorial requirements, (1), (2)
using
drill-through cell
Drill-Through Login dialog box
Drill-Through Wizard
customizing reports with
dialog box, (1), (2)
introductory screen
drilling across columns
drilling down
level 0 attribute members
on shared members
to more detail
to portion of detail
to sample of members, (1), (2)
with spaces in spreadsheet
drilling up
on shared members
to less detail
duplicate member names
displaying the qualified member name
enabling display of qualified member name as comment
enabling display of qualified member name on sheet
example
overview
qualified member name, defined
working with
duplicating sheets. See cascading sheets.
Dynamic Calc members, applying styles to
Dynamic Calculation members, applying styles to
dynamic calculations
changing visual cues
retrieving
Dynamic Time Series
defined
specifying latest time period, (1), (2)
dynamic time series
selecting by
specifying latest period
specifying latest period of time dimension
viewing members
E
Edit Cell Note dialog box, (1), (2)
Edit menu
Edit URL dialog box, (1), (2)
editing
cell notes
URLs
editing filters, (1), (2)
enabling
compatibility with Smart View
double-clicking to browse linked objects
Essbase toolbar
FlashBack setting
Hybrid Analysis
mouse actions, (1), (2)
Navigate Without Data
entering passwords
error codes
error messages, displaying, (1), (2)
Essbase
Cascade Options dialog box
commands
connecting to
Disconnect dialog box
disconnecting from
exiting
logging off
logging on
Member Selection dialog box
Member Selection dialog box, from Query Designer
Options dialog box, (1), (2)
registering
System Login dialog box, (1), (2)
toolbar, activating
VBA library
Essbase
commands
connecting to
exiting
logging off
logging on
registering
VBA library
Essbase Add-In Manager dialog box
Essbase API, connecting Excel with
Essbase Calculation dialog box
Essbase Cascade Options dialog box
Cascade Information page
described
Destination Options page
Format Options page
Essbase Currency Report dialog box
Essbase Disconnect dialog box
Essbase Integration Server drill-through. See drill-through.
Essbase macros
Essbase Member Selection dialog box
Essbase menu
viewing, (1), (2)
Essbase Options
basic tutorial and
Essbase Options dialog box
described
Display page
Global page
Mode page
Style page
Zoom page
Essbase Options menu equivalent, (1), (2)
Essbase System Login dialog box, (1), (2), (3), (4)
Essbase toolbar
activating
Essbase toolbar
EssCalculate macro
EssCancelCalc macro
EssCascade macro
EssCell function
error messages
syntax
EssCell macro
EssConnect macro
EssDisconnect macro
EssFlashBack macro
EssGetCurrency macro
EssGetDataPoint macro
EssGetGlobalOption macro
EssGetMemberInfo
EssGetSheetOption macro
EssGetStyle macro
EssKeepOnly macro
EssMenuCalculate macro
EssMenuCascade macro
EssMenuConnect macro
EssMenuCurrencyReport macro
EssMenuDatalessNav macro
EssMenuDisconnect macro
EssMenuFlashBack macro
EssMenuHelp macro
EssMenuKeepOnly macro
EssMenuLinkedObjects macro
EssMenuLock macro
EssMenuMemberSelect macro
EssMenuOptions macro
EssMenuPivot macro
EssMenuQueryDesigner macro
EssMenuRemoveOnly macro
EssMenuRetrieve macro
EssMenuRetrieveLock macro
EssMenuSend macro
EssMenuUnlock macro
EssMenuVCalculation function
EssMenuVCascade function
EssMenuVConnect function
EssMenuVCurrencyReport function
EssMenuVDatalessNav function
EssMenuVDisconnect function
EssMenuVFlashBack function
EssMenuVKeepOnly function
EssMenuVLinkedObjects function
EssMenuVLock function
EssMenuVMemberSelection function
EssMenuVOptions function
EssMenuVPivot function
EssMenuVQueryDesigner function
EssMenuVRemoveOnly function
EssMenuVRetrieve function
EssMenuVRetrieveLock function
EssMenuVSend function
EssMenuVUnlock function
EssMenuVWizard function
EssMenuVZoomIn function
EssMenuVZoomOut function
EssMenuWizard macro
EssMenuZoomIn macro
EssMenuZoomOut macro
EssPivot macro
EssRemoveOnly macro
EssRetrieve macro
EssSendData macro
EssSetCurrency macro
EssSetGlobalOption macro
EssSetGlobalOptions macro
EssSetMenu macro
EssSetSheetOption macro
EssSetSheetOptions macro
EssSetStyle macro
EssUnlock macro
EssVCalculate function
EssVCancelCalc function
EssVCascade function
EssVCell function
EssVConnect function
EssVDisconnect function
EssVFlashBack function
EssVFreeDataPoint function
EssVFreeMemberInfo function
EssVGetCurrency function
EssVGetDataPoint function
EssVGetGlobalOption function
EssVGetHctxFromSheet function
EssVGetMemberInfo function
EssVGetSheetOption function
EssVGetStyle function
EssVKeepOnly function
EssVLoginSetPassword function
EssVPivot function
EssVRemoveOnly function
EssVRetrieve function
EssVSendData function
EssVSetCurrency function
EssVSetGlobalOption function
EssVSetMenu function
EssVSetSheetOption function
EssVSetStyle function
EssVUnlock function
EssVZoomIn function
EssVZoomOut function
ESSXLVBA.TXT
EssZoomIn macro
EssZoomOut macro
establishing a connection, (1), (2), (3), (4)
example VBA code
Excel
clearing formats
creating a VBA module
mouse actions
sample tutorial files
VBA functions
exchange rates
Execute button
executing drill-through reports
executing reports
exiting Essbase
expanding
data views
data views with Zoom In, (1), (2)
member lists
to descendants
expanding formulas when drilling
external files
F
files
accessing
accessing linked
editing
linking to data cells
sample for tutorial
filter operators
filtering
data
members, (1), (2)
filtering data
filters
applying
clearing
creating
defining
deleting
editing
in drill-through reports
operators
renaming
saving
saving in drill-through reports
selecting
viewing
Find Member dialog box, (1), (2)
finding members
finding members, in Spreadsheet Add-in
FlashBack command, (1), (2), (3)
disabling
FlashBack function
FlashBack macro
FlashBack menu equivalent, (1), (2)
focusing on members
with Keep Only, (1), (2)
with Remove Only, (1), (2)
font
style list
font colors, changing, (1), (2)
Font dialog box, (1), (2)
font styles
fonts, changing, (1), (2)
forced logouts
formatted sheets
pivoting in
formatted worksheets
retrieving with
rules for retrieving
formatting
data cells
linked objects, (1), (2)
read-only
read/write
dimension members
displaying aliases
displaying aliases and names
Dynamic Calculation members
linked object cells, (1), (2)
parent members
repeating member labels
spreadsheets
text and cell styles
formatting options
for cascaded sheets
formatting worksheets without retrieving data
formula arrays, preserving
Formula Fill option, (1), (2)
Formula Preservation mode
Formula Fill
pivoting in
restrictions with, (1), (2)
Retain on Keep and Remove Only
Retain on Retrieval, (1), (2)
formula preservation mode, (1), (2)
formula preservation, restrictions
formulas
changing visual cue
EssCell
expanding when drilling
in cells, (1), (2)
partitions and
preservation
effects on other operations
enabling, (1), (2)
restrictions with
retrieving with
Free-Form mode
described
retrieving
retrieving in Template Retrieve mode
free-form reporting, (1), (2)
entering generation and level names in
retrieving data
free-form retrieval
FreeDataPoint function
FreeMember function
functions
calling
declaring
VBA
I
in-cell editing
indenting member names
information messages, displaying, (1), (2)
installation, drill-through, (1), (2)
Integration Server
Integration Services, connecting to, (1), (2)
Interntl sample database
introductory screen, Drill-Through Wizard
L
labels
applying styles
displaying with aliases
member names and
repeating
latest period
selecting
specifying
latest time period
selecting
specifying
Latest Time Period option
latest time period, specifying
launching
drill-through
level 0 attribute members
examples, (1), (2), (3), (4), (5)
rules for drilling down
level constants
level names
retrieving
selecting by
suppressing shared members
viewing members
level options
for zooming in
levels
cascading by
drilling down, (1), (2)
entering names
limitations, on subset conditions
limits
worksheet size, (1), (2)
linked files, viewing
Linked Object Browser
dialog box
linked objects
accessing, (1), (2), (3)
changing style of
enabling double-clicking to get
reporting objects. See LROs.
Linked Objects Browser
accessing, (1), (2), (3), (4)
dialog box
Linked Objects Browser dialog box, (1), (2), (3), (4), (5)
Linked Objects command, (1), (2), (3), (4), (5), (6), (7)
Linked Objects menu equivalent, (1), (2)
linked partitions
access permissions for
accessing from spreadsheet
cells, applying styles
linked partitions, accessing
Linked Reporting Objects
applying styles
cell notes
creating
external files
Linked Reporting Objects dialog box
linking
cell notes
external files
partitions
linking URLs
list, cascaded sheets
lists, drill-through reports
locating members
Lock command, (1), (2)
Lock menu equivalent, (1), (2), (3), (4)
locking data, (1), (2)
locking data blocks, with multiple users
locking data during send
log files
logging off
Essbase. See disconnecting.
logging off databases
logging on
Drill-Through Login dialog box
Essbase System Login dialog box
to databases
Essbase
to Essbase, (1), (2)
to Integration Server
to Integration Services
to multiple databases
to relational data sources, (1), (2)
logical operators
logouts, forced or auto
LROs
deleting
M
macro functions
EssCell
macro language
macros and Excel, opening
managing Essbase add-Ins
manual calculation mode
member attributes
member criteria, specifying
member filters, multiple
member formula, viewing
member information
Member Information dialog box, (1), (2)
member names
aliases for
aliases, displaying
alternate. See aliases.
applying styles
colors, changing
displaying with aliases
fonts, changing
formatted sheets
indenting
repeating, (1), (2), (3)
selecting by
viewing members
with EssCell function
Member Preview dialog box, (1), (2)
member properties
Member Retention option
member select panel, shortcut menus
Member Selection command, (1), (2), (3)
Member Selection dialog box
Member Selection menu equivalent, (1), (2)
Member Selection Preview dialog box
Member Selection, with Query Designer
member selections
clearing
displaying dialog for saving
opening
saving
techniques for, (1), (2), (3)
members
adding, (1), (2)
aliases for
applying filtering criteria
applying styles, (1), (2)
attributes, selecting
collapsing
deleting, (1), (2)
deleting selection rules
deselecting
display order, selecting
drilling down on, (1), (2)
drilling up on
Dynamic Calculation
Dynamic Time Series
filtering
finding, (1), (2), (3)
maximum number to preview, setting
previewing
previewing filtering results
removing
reordering display of
retaining
searching
searching for in Query Designer
selecting, (1), (2), (3), (4)
shared, suppressing
sort order, selecting
specifying latest period of time dimension
viewing
by Dynamic Time Series
by generation name
by level name
by member name
member information
memory
conserving
menu equivalents
spreadsheet macro
Visual Basic
message types, displaying
messages
disabling
enabling
messages (Essbase)
display options
EssCell
unknown member
metadata sampling
defined
level 0 attribute members and
limitations for Hybrid Analysis
missing data, replacing
missing Essbase menu, (1), (2)
missing rows, suppressing in replicated worksheets
missing values, replacing
missing values, suppressing
disabled
in cascaded sheets
option unavailable
Mode options
basic tutorial and
Mode page (Essbase Options dialog box)
money. See currency conversions.
mouse button
moving
columns
data
rows and columns. See pivot.
multi-cell selection, with drill-through
multidimensional data, how to read
multiple cell selection, with drill-through
multiple databases
accessing
multiple filter conditions
multiple worksheets, copying format of
N
names
applying styles
displaying with aliases
entering generation
entering level
repeating
naming workbooks
Navigate With or Without Data command, (1), (2)
Navigate Without Data command
Navigate Without Data menu equivalent, (1), (2)
navigating data
navigating without retrieving data, (1), (2), (3)
navigation panel, shortcut menus
nested columns or rows
Next Level option
no access data labels
defining
replacing
nonadjacent cells
notes, database, viewing
notes, linking to data cells
null values
numeric values, preserving
O
Open Query dialog box
Open Selection Object dialog box
opening
member selections
queries
selection rules
operators
operators, comparison, (1), (2)
optimizing reports
option settings
basic tutorial and
options
Cascade
Display, (1), (2)
Global, (1), (2)
global spreadsheet
Mode, (1), (2)
retrieval modes
settings for advanced tutorial
settings for drill-through tutorial
spreadsheet styles
Style
Zoom, (1), (2)
zooming
Options command, (1), (2)
Options dialog box
ordering
columns
columns in drill-through reports
rows
rows in drill-through reports
outlines
Dynamic Calculation members
Dynamic Time Series members
output, cascaded sheets
overlapping styles
P
parameters, VBA functions
parent members
applying styles to
parent members, changing visual cues
partitions
passwords
entering
passwords, changing, (1), (2), (3)
pattern matching, (1), (2)
pivot
asymmetric reports and
by dragging
described, (1), (2)
effect on text
formatted sheets and
formula preservation and
rows or columns, (1), (2)
unavailable
without retrieving data
Pivot command, (1), (2), (3), (4)
Pivot function
Pivot macro
Pivot menu equivalent, (1), (2)
pivoting data, formatted worksheet
power loss, effect of abnormal shutdown
preferences. See options.
preserving formula arrays
preserving formulas, (1), (2)
preserving formulas, restrictions
previewing
member selections
members
setting maximum number of members for
primary mouse button
Q
qualified member names, displaying
queries
applying, (1), (2)
applying all
applying styles
closing
creating, (1), (2)
deleting
Open Query dialog box
opening , (1), (2)
Save As Query dialog box
saving, (1), (2), (3)
Query Designer
applying option settings
applying spreadsheet options to
connecting to multiple databases
creating queries
equivalent menu function
filtering data
introducing
keyboard shortcuts
menu equivalents
messages
messages and confirmations
right-click menus
save as query dialog box
searching for members
Query Designer command, (1), (2)
quitting Essbase
R
read-only cells
read-only data cells, changing style of
read/write cells
read/write data cells, changing style of
reading data from the server
rearranging columns
registering Spreadsheet Add-in
relational data source, (1), (2)
relational data, accessing
relational databases
metadata sampling in
relational source
remote databases . See linked partitions.
Remove Only command, (1), (2), (3)
described
in Formula Preservation mode
Remove Only function
Remove Only macro
Remove Only menu equivalent, (1), (2)
Remove Unselected Groups option
removing. See also deleting
a set of data
members
styles
visual cues
renaming filters
reordering
member display
members
Repeat Member Labels option
repeating member names, (1), (2)
replacing
missing data labels
no access data labels
replicating worksheets
copying format
creating table of contents
specifying detail level
specifying names
specifying the destination directory
specifying the output type
suppressing missing rows
report script commands
reports
ad hoc
ad hoc currency
creating multiple
creating the view
customizing
defining the layout
free-form, (1), (2), (3)
optimizing
placement in spreadsheet
selecting
reports, creating
ad hoc, (1), (2)
Cascade
Member Selection
Query Designer
reports, drill-through
accessing
customizing
disconnecting from
executing
selecting to view or customize
restoring
FlashBack and, (1), (2)
previous database views
restoring database views
restrictions, with Formula Preservation
Retain on Keep and Remove Only option
Retain on Retrieval option
disabled
enabled, (1), (2)
Retain on Zooms option, (1), (2)
retaining
data subsets
formulas, (1), (2)
when drilling
when retaining data
when retrieving, (1), (2)
selected members
retaining data sets
retrieval mode options
retrievals, canceling
Retrieve & Lock command, (1), (2)
Retrieve command, (1), (2), (3)
retrieve function
retrieve macro
Retrieve menu equivalent, (1), (2)
retrieve style information function
retrieve style information macro
retrieving
Advanced Interpretation mode and
conditional
data
into formatted worksheets
into worksheet with formulas
using a function
data ranges
Dynamic Calc members
Dynamic Calculation members
formula preservation and
Free-Form mode and
functions
in Free-Form mode
in template retrieve mode
increasing speed, (1), (2)
into columns
less detail
more detail
performance impact, (1), (2)
range of cells
retaining formulas and, (1), (2)
selected cells
starting process and
substitution variables
return values
row limits, (1), (2)
rows
blank
deleting during pivot
displaying as columns
displaying selected
filtering by
keeping discontinuous
nested
pivoting
removing selected
suppressing values in, (1), (2)
rules for retrieving data
running calculations
S
sample
databases
connecting to, (1), (2)
described, (1), (2)
in drill-through
files for tutorial, location
Sample Basic
connecting to
described
Sample Data (Zoom In) command
Sample Data command, (1), (2)
sample directory
sample VBA code
sampling
Sample Data command, (1), (2)
sampling data. See metadata sampling.
sampvba.xls, (1), (2)
Save As Query dialog box
Save Selection Object dialog box
saving
drill-through filters
filters
member selections, (1), (2)
queries, (1), (2), (3)
selection rules
saving queries
searching for members
in Spreadsheet Add-in
in Query Designer
secondary mouse button, (1), (2)
security warnings
Select Columns and Display Order dialog box, (1), (2)
Select Data Filters dialog box
Select Data Sort Order dialog box, (1), (2)
Select Drill-Through Report dialog box, (1), (2)
Select Filter Values from the List dialog box, (1), (2)
selecting
cascade levels
cells to keep
cells to remove
column display order
columns for reports
columns to include in report
data filters
data sort order
latest period
latest time period
member names from a list, (1), (2), (3)
members, (1), (2)
multiple cells in spreadsheet
multiple cells, with drill-through
nonadjacent cells
range of cells for retrieval
reports to view/customize
session options, (1), (2)
single cells in spreadsheet
worksheet options, (1), (2), (3)
selection rules
deleting
opening
saving
Send command, (1), (2)
send data function
send data macro
Send menu equivalent, (1), (2)
sending
data to Essbase Server
sending data to server, (1), (2), (3)
server
changing passwords for
connecting to, (1), (2)
disconnecting from
Essbase Integration Server
name, (1), (2)
updating data on
set currency function
set currency macro
Set Filter on Column dialog box, (1), (2)
set global options function
set global options macro, (1), (2)
Set Login Password function
set sheet option function
set sheet options macro
set style function
set style macro
sets
removing
shared members
changing visual cue
drilling down
drilling up
shared members, applying styles to
sheet destination, Cascade option
sheets. See worksheets.
shortcut menus
data filter panel
member select panel
navigation panel
shortcuts, keyboard
shortcuts, mouse actions
shutdown, abnormal
Smart View
Spreadsheet Add-in and
Smart View, enabling compatibility with Spreadsheet Add-in
sort order
in drill-through
sorting
data, (1), (2)
multiple columns
rows
sorting criteria
specifying
latest period
latest period to-date
spreadsheet layout
Spreadsheet Add-in
drill-through and
registering
Smart View and
spreadsheet layout, specifying
spreadsheet macro menu equivalents
spreadsheet macros and functions
spreadsheet options
applying to Query Designer
setting
spreadsheet reports, designing layout
Spreadsheet Toolkit
spreadsheets
accessing drill-through
cascading
containing macros, opening
creating multiple
displaying aliases, (1), (2)
displaying member names
distributing
drilling options
global options, (1), (2)
mode options
preserving formulas
reading multidimensional data in
repeating member labels
retrieving data
setting options
suppressing missing and zero values
zoom options
SQL data source, connecting
SQL syntax, filters
starting
data retrieval
drill-through
starting drill-through
status of database connections
style options
Style page (Essbase Options dialog box)
styles
applying
to data cells
to dimension members
to dimensions
to drill-through cells
to linked partition cells
to linked reporting object cells
to members
to parent members
to Query Designer results
to shared members
attribute dimensions
clearing
copying into worksheets
defining
dimension members
hierarchy of
Integration Services drill-through
linked objects
members
overlapping
read-only cells
read/write cells
removing
selecting members
stored in ESSBASE.INI
subset conditions, maximum
Subset dialog box, (1), (2)
subsets
defining members
retaining
subsetting criteria, applying
substitution variables
substitution variables, retrieving
suppressing
missing and zero values
missing values
option disabled
shared members, (1), (2)
underscore characters
zeros
symmetric reports
system failure
T
table of contents, with Cascade
template mode, (1), (2)
template retrieve mode, (1), (2)
terminating database connections. See disconnecting.
termination, abnormal
text
formatting
hierarchy of styles
pivoting
preserving formatted
time periods
title members, (1), (2)
title members, with drill-down
to-date calculations, specifying
toolbar (Essbase)
icons on, (1), (2)
toolbar, Essbase
top-level members, (1), (2)
transparent partitions. See linked partitions.
transposing data
tutorial
basic
Display options for
Global options for
Mode options for
Zoom options for
basic tasks
guidelines
prerequisites
restarting
U
UDA
pattern matching
specifying member criteria and
underscore characters
suppressing, (1), (2)
Undo command. See FlashBack command.
undoing a command
undoing actions
unknown members
displaying, (1), (2)
prevent from displaying
Unlock command, (1), (2)
unlock function
unlock macro
Unlock menu equivalent, (1), (2)
unlocking data, (1), (2), (3)
up-to-date calculations
updating
data, (1), (2)
passwords
server data, (1), (2)
URL option in Attach Linked Object dialog box
URLs
accessing
accessing linked
attaching
editing, (1), (2)
length limits
viewing
Use Aliases option
Use Both Member Names and Aliases option
Use Sheet Options with Query Designer option
user name, entering
user-defined attributes. See UDA.
using drill-through
using Drill-Through Wizard
Z
zero rows, suppressing
zero values
suppressing
suppressing options disabled
zeros, suppressing
Zoom commands, customizing
Zoom In command, (1), (2), (3)
drilling down options
selecting levels
Zoom In function
Zoom In macro
Zoom In menu equivalent, (1), (2)
Zoom options
basic tutorial and
zoom options
Zoom Out command, (1), (2), (3)
Zoom Out command, drilling up options
Zoom Out function
Zoom Out macro
Zoom Out menu equivalent, (1), (2)
zooming in on Hybrid Analysis members
zooming out