Hyperion(r) Database Administrators Guide Help
Index
Symbols Numbers A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Symbols
! (bang) command
adding to report scripts
terminating reports
! (exclamation points)
in names in scripts and formulas
" (double quotation marks)
enclosing member names, (1), (2), (3)
in application and database names
in dimension and member names
in ESSCMD commands
in formulas, (1), (2), (3)
in header information
in report scripts
terms in scripts and formulas, (1), (2)
# (pound sign) in array and variable names
#MI values
inserting into empty fields, (1), (2), (3)
instead of #MISSING
#MISSING values, (1), (2), (3)
aggregating
defaults for
effects on calculation order, (1), (2), (3), (4)
setting behavior for
averages and
calculations and
CLEARDATA command
disabling
during calculations
formatting in reports
in calculations
inserting into empty fields, (1), (2)
parents and
replacing with text
reporting samples, (1), (2)
skipping, (1), (2)
sorting data with
specifying in data source
testing for
viewing with Personal Essbase
#NOACCESS value
$ (dollar signs) in array and variable names
$ fields
$ALT_NAME setting
% (percent signs)
as codes in data source
in names in scripts and formulas
in report scripts
% operators
defining member consolidations
in calc scripts
in mathematical operations
in unary operations, (1), (2), (3)
& (ampersands)
as delimiters in logs
in calc scripts, (1), (2)
in names
in names in scripts and formulas
in report scripts
& commands, (1), (2)
( ) (parentheses)
in calc scripts
in dimension and member names
in formulas
indicating negative numeric values in fields
report scripts, (1), (2)
* (asterisks)
as codes in data source
as delimiters in logs
in application and database names
in names in scripts and formulas, (1), (2)
options in reports
used as wildcard
* operators, (1), (2), (3), (4)
+ (plus signs)
as codes in data source
in application and database names
in dimension and member names
in member names
in names in scripts and formulas, (1), (2)
+ operators
defining member consolidations
in mathematical operations
in unary operations, (1), (2), (3)
member consolidation
, (commas)
as file delimiter
displaying in reports
in application and database names
in data fields
in dimension and member names
in formulas
in header records
in member combinations
in names in scripts and formulas, (1), (2)
suppressing in reports, (1), (2)
. (periods)
in application and database names
.EQD files(EQD)
/ (slashes)
as codes in data source
in application and database names
in names in scripts and formulas, (1), (2)
/ operators
defining member consolidations
in calc scripts
in mathematical operations
in unary operations, (1), (2), (3)
/* */ character pairs, (1), (2)
// (double slashes) in report scripts
: (colons)
as delimiters in logs
in application and database names
in formulas
in names in scripts and formulas, (1), (2)
:: (double colons) in formulas
; (semicolons)
end a calc script
end ENDIF statement
in application and database names
in calc scripts, (1), (2)
in ESSCMD syntax
in formulas, (1), (2), (3)
in names in scripts and formulas, (1), (2)
insert formulaend-of-line
< (less than signs)
in application and database names
in dimension and member names
in names in scripts and formulas, (1), (2)
in report scripts
= (equal signs)
in application and database names
in calc scripts
in dimension and member names
in formulas
in names in scripts and formulas
in report scripts
> (greater than signs)
in application and database names
in names in scripts and formulas
-> operator
-> operators
in formulas, (1), (2)
inserting in calc scripts
inserting in formulas, (1), (2)
overview, (1), (2)
usage examples, (1), (2)
? (question marks)
in application and database names
used as wildcard
@ (at signs)
in dimension and member names
in names in scripts and formulas, (1), (2)
@ABS function
@ACCUM function, (1), (2)
@ALLANCESTORS function
@ALLOCATE function, (1), (2)
@ANCEST function
@ANCESTORS function
@ANCESTVAL function
@ATTRIBUTE function, (1), (2)
@ATTRIBUTEBVAL function
@ATTRIBUTESVAL function
@ATTRIBUTEVAL function, (1), (2), (3)
@AVG function
@AVGRANGE function, (1), (2)
@CALCMODE function
@CHILDREN function
@COMPOUND function
@COMPOUNDGROWTH function
@CONCATENATE function
@CORRELATION function
@COUNT function
@CURGEN function
@CURLEV function
@CURRMBR function
@CURRMBRRANGE function
@DECLINE function
@DESCENDANTS function, (1), (2)
@DISCOUNT function
@EXP function
@FACTORIAL function
@GEN function
@GENMBRS function
@GROWTH function
@IALLANCESTORS function
@IANCESTORS function
@ICHILDREN function
@IDESCENDANTS function, (1), (2)
@ILSIBLINGS function
@INT function
@INTEREST function
@IRDESCENDANTS function
@IRR function
@IRSIBLINGS function
@ISACCTYPE function
@ISANCEST function
@ISCHILD function
@ISDESC function
@ISDESCENDANTS function
@ISGEN function
@ISIANCEST function
@ISIBLINGS function
@ISICHILD function
@ISIDESC function
@ISIPARENT function
@ISISIBLING function
@ISLEV function
@ISMBR function, (1), (2)
@ISPARENT function
@ISSAMEGEN function
@ISSAMELEV function
@ISSIBLING function
@ISUDA function
@LEV function
@LEVMBRS function
@LIST function
@LN function
@LOG function
@LOG10 function
@LSIBLINGS function
@MATCH function
@MAX function
@MAXRANGE function
@MAXS function
@MAXSRANGE function
@MDALLOCATE function, (1), (2)
@MDANCESTVAL function
@MDPARENTVAL function
@MDSHIFT function
@MEDIAN function
@MEMBER function
@MERGE function
@MIN function
@MINRANGE function
@MINS function
@MINSRANGE function
@MOD function
@MODE function
@MOVAVG function
@MOVMAX function
@MOVMED function
@MOVMIN function
@NAME function
@NAME function to return member name as a string
@NEXT function
@NEXTS function
@NPV function
@PARENT function
@PARENTVAL function, (1), (2)
@POWER function
@PRIOR function, (1), (2)
@PRIORS function
@PTD function, (1), (2), (3)
@RANGE function
@RANK function
@RDESCENDANTS function
@RELATIVE function
@REMAINDER function
@REMOVE function
@ROUND function
@RSIBLINGS function
@SANCESTVAL function
@SHIFT function
@SHIFTMINUS function
@SHIFTPLUS function
@SIBLINGS function
@SLN function
@SPARENTVAL function
@SPLINE function
@STDEV function
@STDEVP function
@STDEVRANGE function
@SUBSTRING function
@SUM function
@SUMRANGE function
@SYD function
@TODATE function, (1), (2)
@TREND function, (1), (2)
@TRUNCATE function
@UDA function
@VAR function, (1), (2), (3)
@VARIANCE function
@VARIANCEP function
@VARPER function, (1), (2), (3), (4)
@WITHATTR function, (1), (2)
@XREF function, (1), (2)
[ ] (brackets)
in application and database names
in names in scripts and formulas, (1), (2)
\ (backslashes)
in application and database names
in dimension and member names
in formulas
in names in scripts and formulas
^ (carets)
as delimiters in logs
_ (underscores)
converting spaces to, (1), (2)
in array and variable names
in report scripts
{ } (braces)
in dimension and member names
in names in scripts and formulas, (1), (2)
in report scripts, (1), (2)
| (vertical bars)
in dimension and member names
~ (tildes)
as character in headings
as codes in data source
as delimiters in logs
~ operators, (1), (2), (3), (4)
- (hyphens, dashes, minus signs)
as codes in data source
in data fields
in dimension and member names
in member names
in names in scripts and formulas
in report scripts
- operators
defining member consolidations
in mathematical operations
in unary operations, (1), (2), (3)
' (single quotation marks)
in application and database names
in dimension and member names
(tildes)
in names in scripts and formulas
Numbers
0 (zero) values
calculating
excluding in time balances
formatting in reports, (1), (2)
including in time balances
replacing with labels
skipping, (1), (2)
.123 files
.A files
A
A, average time balance codes in data source
abnormal shutdown. See exception logs.
aborting data loads
@ABS function
absolute values
access
application-level settings
assigning/reassigning user, (1), (2), (3), (4)
cells in blocks, (1), (2)
checking information about
concurrent
controlling, (1), (2), (3), (4), (5)
data sources
replicated partitions and
data targets, (1), (2)
database permissions for users
defining global levels
getting started tips
global levels
internal structures optimizing
levels defined in filters
linked objects
local
locked data blocks, (1), (2)
maintaining data integrity
matrix-style
modifying, (1), (2), (3)
multi-user
optimizing, (1), (2)
outlines
partitioned databases, (1), (2), (3)
troubleshooting
remote databases
restricting, (1), (2)
Server Agent
setting database
simultaneous, (1), (2)
transactions and, (1), (2)
unspecified members
Access databases. See SQL databases
Access DBs setting, (1), (2)
access levels
Account Dimension Properties page (Dimension Properties)
account reporting values
accounts
administrators, (1), (2)
users, (1), (2)
Accounts dimension
usage examples
accounts dimension
calculating first/last values in, (1), (2), (3)
calculating time period averages
calculating variance for
calculation passes for
calculations on, (1), (2), (3)
creating
currency applications
description
flipping values in
setting
setting member properties in data source
time balance members in
two-pass calculations and
unary operations in
usage examples
usage overview
accounts tags
checking for
@ACCUM function, (1), (2)
accumulation of values
actual expense vs. budgeted
getting variance, (1), (2), (3)
setting properties
actual sales reporting samples, (1), (2)
ad hoc calculations
ad hoc currency reporting
add as sibling build method
attribute associations
adding
See also building; creating; defining
alias tables to outlines, (1), (2)
aliases to calc scripts
aliases to formulas
comments to calc scripts
comments to dimensions
comments to report scripts
dimensions to outlines, (1), (2), (3), (4)
performance considerations, (1), (2)
restructuring and
dynamically calculated members to calculations
equations to calc scripts, (1), (2)
formulas to calc scripts, (1), (2), (3), (4)
formulas to oulines
formulas to report scripts
header information
headers to data sources, (1), (2), (3), (4)
headings to reports, (1), (2), (3), (4)
members
as children of specified parent
as siblings of lowest level
as siblings with matching strings
build methods
example for, (1), (2)
for currency conversions, (1), (2)
guidelines for
restrictions
through header information in the data source
to dimensions, (1), (2), (3), (4), (5)
to member fields, (1), (2)
to outlines, (1), (2)
members to report scripts, (1), (2)
in precise combinations
with common attributes
operators to formulas
page breaks to reports, (1), (2)
prefixes or suffixes to fields
records to data sources, (1), (2), (3)
shared members to outlines, (1), (2), (3)
caution for placing
text to calc scripts
text to formulas
titles to reports
values to empty fields
values to existing values
variables to formulas
variables to report scripts, (1), (2), (3), (4)
Adding Dimensions dialog box
addition
consolidation codes in data source
prerequisite for
setting member consolidation properties
addition operator (+)
unary operations
addition operators (+)
defining member consolidations
in unary operations, (1), (2)
mathematical operations
member consolidation
adjusting buffer size
Application Manager
adjusting column length
adjusting retrieval buffer size
Administration Services
adjusting retrieval sort buffer size
Administration Services
Admin page (Partition Wizard)
Adminiatration Servicesr
setting index cache size
Administration Services
adding users to groups
adjust retrieval buffer size
adjust retrieval sort buffer size
annotating databases
application
copy
delete
build calc script
changing data cache size
changing Essbase kernel settings
copying
outlines
creating
applications
databases with Administration Services
new users
database
copy
delete
defining calculations
as default
deleting
logs, (1), (2), (3)
deleting a substitution variable
deleting logs
display used and unused ports
enable memory cache locking
execute a calculation script
open existing calc script
rename application
rename database
review application log
run a calc script
run calculations
set retrieval buffer size
setting
current alias table
setting index cache size
setting substitution variables
start database
starting/stopping applications
starting/stopping databases
updating a substitution variable
view average clustering ratio
view current data compression settings
view data block size
view logs
viewing logs
viewing the application log
administrative accounts
setting up
administrative requests
administrators
controlling partitioned updates
getting started with Essbase
getting started with Hyperion Essbase
maintenance routines
maintenance tasks
minimizing downtime
usage prerequisites
user-management tasks, (1), (2), (3)
Admnistration Services
view user and group lists
.ADW files
AFTER command
usage examples, (1), (2)
agent event logs. See OLAP Server logs.
Agent log
agent logs. See OLAP Server logs.
Agent. See Server Agent
AGENTLOGMSGLEVEL setting
AGENTPORT
AGENTTHREADS setting
aggregation
See also consolidation
formulas vs.
missing values
calculations and, (1), (2)
effects on calculation order, (1), (2), (3), (4)
in calculations
AGTSVRCONNECTIONS
control the maximum number of threads to OLAP Server
AGTSVRCONNECTIONS setting in essbase.cfg
AIX servers. See UNIX platforms
.ALG files
alias combinations
creating
defined
Alias Combinations page (Member Properties)
alias field type
in header records
in rules files
nulls and, (1), (2)
alias tables
clearing contents
copying
creating, (1), (2)
described
importing/exporting, (1), (2), (3)
including in report scripts
introducing, (1), (2)
loading
maximum per outline
removing from outlines
renaming
reserved generation names in
selecting, (1), (2)
setting as current with Administration Services
setting as current with Application Manager, (1), (2)
updating
ALIAS. See alias field type
aliases
adding to calc scripts
adding to formulas
adding to report scripts, (1), (2), (3)
caution for
allowing changes
build methods and
creating, (1), (2)
attribute dimension build example
based on member combinations
caution for, (1), (2), (3)
guidelines for
parent/child dimension build example
defined
displaying, (1), (2)
in Calc Script Editor
in Formula Editor
displaying in reports, (1), (2)
duplicate generation fields and
editing names
entering in fields
expanding/contracting member list
introducing
maximum characters in names
multiple
shared members and
sorting members by
specifying for Dynamic Time Series members
with embedded blanks
@ALLANCESTORS function
ALLINSAMEDIM command
usage
@ALLOCATE function
allocation
calculation examples, (1), (2), (3), (4)
calculation functions
storage, (1), (2)
example
Allocation Manager, (1), (2)
Allow Application to Start option
Allow Association Chgs option
Allow Commands option
Allow Connects option
Allow Formula Changes option
Allow Moves option
Allow Property Changes option
Allow Updates option
ALLSIBLINGS command
usage
alphabetizing members
alter application (MaxL), (1), (2)
alter database
MaxL statement
alter database
alter database (MaxL), (1), (2), (3), (4), (5)
changing database storage settings
alter system (MaxL), (1), (2), (3)
alter user (MaxL), (1), (2)
altering. See changing; editing
alternate hierarchies (in Hyperion MBA). See shared members
alternate names. See aliases
ampersands (&)
in calc scripts, (1), (2)
in names
in names in scripts and formulas
in report scripts
analysis
defining objectives
example
getting started tips
optimizing
single-server applications, (1), (2)
analytical functions, key
allocations
ratios
trend analysis
analyze logs
Log Analyzer
analyzing database design
guidelines
@ANCEST function
ancestor/descendant relationships
defining calculation order for
ancestor-descendant relationships
@ANCESTORS function
ancestors
checking for
currency conversions and
defined
getting, (1), (2)
new members with no
ANCESTORS command
usage
@ANCESTVAL function
anchoring dimensions
AND operator
select/reject criteria, (1), (2)
annotate database
Administration Services
annotating
See also comments
data cells
databases
partitions, (1), (2), (3)
.APB files
API directory
API function calls
API functions
location
using VBA functions
.APP files
App Access button, (1), (2), (3)
APP directory
security file information
application
migrating using Administration Services
parallel calculation level
rename
Application Copy dialog box
Application Designer permission
Application designer permission
Application Desktop window
application directory, (1), (2)
application event logs. See application logs.
application files
Application Information dialog box
application log
calculation time
dimensions calculated
Application Log Viewer. See Log Viewer
application logs
contents described
deleting in Application Manager
deleting on restart
delimiters
disk space and
dynamic calculator cache usage
dynamically calculated members
example
last row committed
message categories
overview
setting messages logged
viewing
viewing contents, (1), (2)
Application Manager
adding calc scripts
adding dimensions
adding members
annotating databases
build calc script
caution for clearing data
changing data cache size
changing Essbase kernel settings
clearing alias tables
copying
alias tables
applications
databases
outlines, (1), (2)
copying objects
create calculation script
creating
alias tables
applications
databases with Application Manager
rules files
substitution variables
creating calc scripts, (1), (2)
creating reports, (1), (2)
creating text files
defined
defining calculations
as default
deleting
alias tables
applications
databases
logs
objects
substitution variables
deleting users
described
importing/exporting alias tables, (1), (2)
loading data
moving members
naming generations and levels
opening
outlines, (1), (2)
report scripts
overview
registering custom-defined functions
removing linked objects
renaming
alias tables
applications
databases
objects
replicating data
restructuring partitioned databases
running calc scripts, (1), (2), (3)
saving outlines
selecting
applications
data sources, (1), (2)
databases
set retrieval sort buffer size
setting
current alias table
default calculation
index cache size
isolation levels
setting data compression
setting index cache size
sorting members
specifying disk volumes
specifying file size
starting/stopping applications, (1), (2)
starting/stopping databases, (1), (2)
synchronizing outlines
transferring files from client to server
updating substitution variables
verifying outlines
view average clustering ratio
view data block size
viewing
and changing user access
applications and databases
linked objects
logs
viewing storage information
viewing the application log
Application Programming Interface. See API
application server, (1), (2)
Application Services window
Application Settings dialog box
global application access
minimum database access settings
options
specifying application file size
application startup, results of
Application Tools
defined
Applications
monitoring
applications
See also partitioned applications
analytical vs transaction processing
associating index files with
associating with calc scripts, (1), (2), (3)
building
components
copying, (1), (2)
copying using MaxL
creating, (1), (2)
for currency conversions
for Personal Essbase
on client
prerequisites
with Administration Services
with Application Manager
creating using MaxL
creating with ESSCMD
creating with MaxL
currency conversions and
customizing
data distribution characteristics
deleting
deleting using MaxL
designing partitioned
deciding which type
scenarios for, (1), (2), (3)
designing simple, (1), (2)
designing single-server, (1), (2)
developing
process summarized
implementing global security
inaccessible
interruptions
loading
automatically
with related database
logging errors
maintaining
modifying database outlines
monitoring, (1), (2)
naming rule
opening
overview
partitioned
benefits of, (1), (2)
choosing when not to use
choosing when to use
porting, (1), (2)
creating backups for
redefining information for
to UNIX platforms
renaming
renaming using MaxL
sample, (1), (2)
selecting
simultaneous access
size considerations
starting
starting using MaxL
stopping, (1), (2)
all opened
before backup
when transactions are running
with Administration Services
with Application Manager
stopping using MaxL
storing
terminating requests
viewing
information about, (1), (2), (3)
log contents
Applications list box
Applications page (Server Information)
Apply Outline Changes dialog box
applying
See also setting
changes to outlines, (1), (2)
locks, (1), (2), (3), (4)
privileges to groups
skip properties
APPLYOTLCHANGEFILE command
ARBORPATH
.ARC files
archive files
restoring from
ARCHIVE.LST file
archiving
data
data targets
Area Definition dialog box
defining linked areas, (1), (2)
defining replicated areas
defining transparent areas, (1), (2)
Area Specific Member Mapping dialog box
areas
See also partitions
changing shared
defined
Dynamic Time Series members in
linked partitions
mapping to specific, (1), (2), (3)
in Partition Wizard
replicated partitions
transparent partitions
Areas page (Partition Wizard), (1), (2), (3)
arithmetic operations
currency conversions
formulas and, (1), (2)
missing values and
performing on fields
performing on members
prerequisite for
report scripts
specifying in data source
arranging
cells in blocks
data blocks
dimension build
position of fields in rules file
dimensions in outlines
fields, (1), (2)
members in dense dimensions
members in outlines, (1), (2)
ARRAY command
declare data variables
usage example
arrays
as variables, (1), (2)
declaring
naming
ASC command
usage example
ascending sort order
applying to output
members in outlines
ASCII characters ignored in data loads
ASCII files
calc scripts in
creating, (1), (2)
cross-platform compatibility
data sources
dumping security information to
loading, (1), (2)
multiple
opening
ASCII text, (1), (2)
assets
Assign Filters dialog box
assigning
See also defining; setting
access levels to linked objects
aliases to members, (1), (2)
based on combinations
attributes to dimensions
filters to users and groups
generic passwords
privileges
global access
to users and groups
properties to dimensions, (1), (2), (3), (4)
overview, (1), (2), (3)
properties to members, (1), (2)
values to member combinations
values to variables
variance reporting properties
Associate Client Outline dialog box
Associate Server Outline dialog box, (1), (2)
associating
applications with calc scripts, (1), (2)
attributes
automatically
example rules file
in Outline Editor
through dimension build
calc scripts with outlines
databases with calc scripts, (1), (2), (3)
databases with reports
filters with outlines
members with report scripts
multilevel attribute dimensions
new applications with calc scripts
new databases with calc scripts
parents with members
rules files
with data sources
with outlines, (1), (2), (3)
asterisks (*)
as codes in data source
in application and database names
in names in scripts and formulas, (1), (2)
used as wildcard
ASYM command
entering in report scripts
usage
asymmetric columns
changing headings
creating
dynamically calculating values
in reports
in source data, (1), (2)
overriding groupings
asymmetric reports
creating, (1), (2)
defined
formatting
symmetric reports vs.
at signs (@)
in dimension and member names
in names in scripts and formulas, (1), (2)
attaching to databases. See connections
attachments
See also linked reporting objects
limiting size
removing
saving
viewing in Application Manager
@ATTRIBUTE function, (1), (2)
attribute associations
allowing changes
base dimensions, (1), (2)
field type
lost in cut or copy and paste
requirements
Attribute Calculations dimension
accessing members from
changing member names
default member names
described
instead of consolidation symbols
instead of member formulas
members, default
properties of
retrieving multiple members from
ATTRIBUTE command, (1), (2)
usage
attribute dimensions
associating with base dimensions in Outline Editor
comparison with standard dimensions
creating in Outline Editor
defining in dimension build
deleting members
described, (1), (2)
generation or level reference numbers
members
overview
prefixes and suffixes
preventing creation, (1), (2), (3)
multilevel
building and associating
names as field types, (1), (2)
outline design
restructuring
summary of dimension building rules
tagging
type
using to avoid redundancy
attribute fields
defining using rules files
position in rules file
attribute members
options in dimension build
using in report scripts
attribute parent field type
example
in header records
in rules files
nulls and, (1), (2)
attribute values, (1), (2), (3)
@ATTRIBUTEBVAL function
attributes
advantages
as values resulting from formulas
associating
automatically
in Outline Editor
through dimension build
associating aliases through dimension build
Boolean type
changing default member names
described
duplicate values
calculating
accessing calculated data
Attribute Calculations dimension
default calculation
Essbase functions
examples
multiple calculations
performance considerations
process
using attributes in formulas
calculation functions
date type
changing the member name format
duplicate values
defined
design considerations
mapping
member name format
member names
numeric type
defined
defining ranges
duplicate values
ranges
size of ranges
process for defining in Outline Editor
setting types
shared member design approach
standard dimension design approach
text type
time-dependent values
types
UDAs
alternative design approach
feature comparison
setting
user-defined
See also UDAs
using in partitions
@ATTRIBUTESVAL function
@ATTRIBUTEVAL function, (1), (2), (3)
ATTRPROD.RUL
.ATX files
audit log files
audit logs
Autoconfigure Dense/Sparse option
automating routine operations
average clustering ratio
viewing in Administration Services
viewing size in Application Manager
average time balance property
average time balances specified in data sources
averages
Attribute Calculations dimension
determining with formulas, (1), (2)
for time periods, (1), (2)
reporting examples, (1), (2)
setting time balances
@AVG function
Avg member, Attribute Calculations dimension
@AVGRANGE function, (1), (2)
B
B, time balance codes in data source
background process
detecting
running Essbase as
backing up databases
by exporting
files to back up
overview
preparing
backslashes (\)
in application and database names
in dimension and member names
in formulas
in names in scripts and formulas
backups
export method
file list
file system method
restoring after system failures
restoring from
security
.BAK file
.BAK files
balance sheet accounts
bang command (!)
adding to report scripts
terminating reports
.BAS files
base dimensions
associating with attribute dimensions in Outline Editor
defined, (1), (2)
member associations
members
associating with attributes in Outline Editor
attribute formulas
attributes
Basic databases. See Demo Basic database; Sample Basic database
BASIC directory
basic equations
basic reporting techniques
creating simple reports, (1), (2)
developing free-form reports
editing report scripts, (1), (2), (3), (4)
implementing security
opening
report scripts
opening report scripts
running report scripts, (1), (2), (3)
saving report scripts
.BAT files
batch files
and ESSCMD scripts
report scripts and
running
batch mode
command-line syntax for
creating scripts for
dynamic calculations and
error-handling
examples
importing and calculating
printing reports
updating SQL scripts
file-name extensions and
MaxL
overview
shutting down server
syntax
updating outlines
when to use
batch processing time
BEFORE command
usage example
BEGINARCHIVE command, (1), (2)
partitioned applications and
benefits of Essbase
BIN directory
ESSCMD files
Bitmap cache
effects from parallel calculation
bitmap compression
described
estimating block size
specifying
bitmap dimensions
bitmap, calculator cache
black squares (Report Viewer)
blank fields
adding values to
in data source
in rules file
blanks. See white space
block calculation mode
block density (defined)
BLOCKHEADERS command, (1), (2)
blocks. See data blocks
.BND files
Boolean
attribute dimension type, (1), (2)
attributes
changing default member names
described
duplicate values
expressions in rules files
for select/reject criteria, (1), (2)
functions, in formulas, (1), (2)
Boolean expressions
for select/reject criteria
grouping
usage example
Boolean operators, (1), (2)
BOTTOM command
entering in report scripts, (1), (2), (3)
precedence
restrictions, (1), (2)
upper limits
usage
usage example
bottom-up
partitioning
bottom-up calculation
transparent partitions
bottom-up ordering
calculations
dynamic builds, (1), (2), (3)
examples, (1), (2)
bottom-up partitioning
defined
braces ({ })
in dimension and member names
in names in scripts and formulas, (1), (2)
in report scripts, (1), (2)
brackets ([ ])
in application and database names
in names in scripts and formulas, (1), (2)
BRACKETS command, (1), (2)
overriding
branches
Calc Script Editor
aliases
dimensions
members
data hierarchies, (1), (2)
Formula Editor
aliases
dimensions
members
outlines
sharing members
browser for editing objects, (1), (2)
budgets
allocating values, (1), (2)
comparing actual to budgeted, (1), (2)
example database for forecasting
example for increasing
generating and loading new
getting variance, (1), (2)
partitioned applications and
variance reporting and
buffered I/O as default
buffers, (1), (2)
See also caches
extracted data row cells
increasing size
setting internal
sorted data
build methods
adding members
as children of specified parent
as sibling with matching strings
as siblings of lowest level
bottom-up ordering
creating
multiple roll-ups, (1), (2)
creating shared members
at different generations, (1), (2)
at same generation, (1), (2)
including branches, (1), (2)
defined
defining parent/child relationship
description
null processing, (1), (2)
selecting, (1), (2)
supported for associating attributes
top-down ordering
valid field types
BUILDDIM command, (1), (2)
building
See also adding; creating
applications
calc script in Calc Script Editor
calc scripts
in Calc Script Editor, (1), (2)
restrictions
syntax for
with Application Manager
database outline
databases
development process for
example for
prerequisites for
dimensions, (1), (2), (3), (4), (5)
dynamically. See dynamic builds
guidelines for, (1), (2)
prerequisites, (1), (2), (3)
with data sources, (1), (2), (3), (4), (5)
with dynamically calculated members
with rules files, (1), (2), (3), (4)
dynamic calculations, (1), (2)
restrictions, (1), (2), (3)
formulas, (1), (2)
with Formula Editor
multiple roll-ups
new calc script
reports, (1), (2), (3)
basic techniques, (1), (2)
free-form
with API function calls
shared members dynamically, (1), (2), (3), (4)
Building and designing a security system
building dimensions
example for
builds. See dynamic builds
business models
checklist for creating
creating as a part of database design
Cache Memory Locking
described
C
caches
as storage units
calculator, (1), (2), (3)
described
disabling
getting information about, (1), (2)
locking memory for
managing, (1), (2)
optimizing read/writes
setting size, (1), (2)
sizing
data cache
data file cache
fine-tuning
index cache
overview
viewing statistics
when changes take effect
CALC ALL command
block ordering and
currency conversions
dynamic calculations and
dynamically calculated members and
for database calculation
Intelligent Calculation and, (1), (2), (3)
partitioned applications and
usage overview, (1), (2), (3)
CALC AVERAGE command
CALC COL command. See CALCULATE COLUMN command
CALC command
CALC DIM command
dynamically calculated members and
for database calculation
Intelligent Calculation and, (1), (2), (3), (4)
usage examples, (1), (2), (3)
CALC FIRST command
CALC LAST command
CALC ROW command. See CALCULATE ROW command
Calc Script button (Application Manager)
calc script calculations
Calc Script Editor
building calc scripts, (1), (2), (3)
changing scripts
checking syntax, (1), (2), (3)
copying scripts
expanding/contracting dimensions
expanding/contracting member branches
finding and replacing text
opening
saving calc scripts, (1), (2)
searching for members
undoing last action
calc script files, (1), (2)
naming, (1), (2)
opening, (1), (2)
selecting, (1), (2)
calc scripts
adding
aliases
comments
equations, (1), (2)
formulas, (1), (2)
text
aggregating missing values in
applying conditions
attaching to databases
building in Calc Script Editor, (1), (2), (3), (4)
calculating member formulas
calculation order
changing, (1), (2)
checking syntax
copying, (1), (2)
in file system
creating with Application Manager
currency conversions, (1), (2)
declaring variables in, (1), (2)
defined, (1), (2)
defining
as default
execution access
defining equations
deleting, (1), (2)
displaying completion notices with
dynamic calculations and, (1), (2)
examples, (1), (2), (3), (4)
formulas in
generating statistical information
grouping formulas and dimensions, (1), (2), (3)
inserting
calculation commands, (1), (2)
variables
Intelligent Calculation and, (1), (2), (3), (4)
loading, (1), (2), (3)
names with special characters, (1), (2)
overriding default calculation order
performing multiple calculation passes
examples, (1), (2)
printing
restrictions
running
calculating Sample Basic
information messages after
on partitioned applications
with Application Manager
with ESSCMD, (1), (2)
with MaxL, (1), (2)
saving, (1), (2), (3)
on client workstations, (1), (2)
syntax for
checking, (1), (2)
guidelines
troubleshooting
two-pass calculations, (1), (2), (3), (4), (5)
UDAs and
undoing changes
unlocking
usage overview, (1), (2), (3)
using formulas
viewing application log contents
CALC TWOPASS command
usage examples, (1), (2), (3)
CALCDEFAULT command
CALCHASHTBLMEMORY
and parallel calculation
CALCHASHTBLMEMORY setting
CALCLINE command
CALCLOCKBLOCK setting
@CALCMODE function
CALCMODE configuration setting
CALCOPTCALCHASHTBL
and parallel calculation
CALCOPTCALCHASHTBL setting
CALCOPTFRMLBOTTOMUP setting
CALCPARALLEL
checking parallel calculation status
CALCULATE COLUMN command
usage examples, (1), (2)
Calculate Database dialog box
canceling operations
running calc scripts
Calculate permission
calculate privilege
defined, (1), (2)
filters and
CALCULATE ROW command, (1), (2)
restrictions
usage examples, (1), (2), (3)
calculated columns
adding totals
clearing values, (1), (2)
creating, (1), (2), (3)
calculated data
filtering
formatting, (1), (2)
calculated values vs. input values
Calculation
locking blocks
parallel vs. serial
calculation
permission required to run
calculation commands, (1), (2)
computation
control
declaring temporary variables for
functions, custom-defined
iterating through
macros, custom-defined
specifying global settings
calculation script commands
SET MSG
calculation scripts
clearing databases after export
calculation scripts. See calc scripts
calculations, (1), (2)
See also calc scripts; dynamic calculations
account reporting values
across multiple processors
ad hoc
adding formulas to, (1), (2), (3), (4)
with Formula Editor
assigning constants
associating with specific database, (1), (2), (3), (4)
attributes
accessing calculated data
Attribute Calculations dimension
default calculation
described
examples
multiple calculations
performance considerations
process
using attributes in formulas
basic concepts
block mode
blocks with dirty status
bottom-up
calc scripts vs.
caution for changing outlines and, (1), (2)
cell mode
checklist for defining
concurrent and memory usage
controlling flow, (1), (2), (3)
currency conversions, (1), (2), (3)
links and
dates
default
overriding
setting, (1), (2), (3)
defining global behavior
defining order
cells, (1), (2)
data blocks
dimensions
forward references and
members, (1), (2)
designing for optimal
difference between actual and budgeted
displaying completion notices
displaying settings
entire database
executing in ESSCMD
executing in MaxL
extending capabilities
failing
first-time
fixing unexpected results, (1), (2)
getting current state
getting information about
handling missing and zero values
members across multiple parents
members in outlines
members with different operators
missing values and, (1), (2), (3)
monitoring, (1), (2)
monthly assets
multiple databases
operator precedence
optimizing, (1), (2)
with attributes
with bottom-up calculation
with calc scripts
with dynamic calculations, (1), (2)
with Intelligent Calculation
with interdependent values
with two-pass calculations
optimizing with search
overview, (1), (2), (3)
partial list of members
partitioned applications
with replicated partitions
with transparent partitions, (1), (2), (3), (4)
performance and multi-users
performance, with attributes
performing multiple passes, (1), (2), (3), (4)
examples, (1), (2)
period-to-date values, (1), (2)
preventing delays
recovering
relationships between members
report scripts, (1), (2)
examples, (1), (2), (3)
rolling averages
running
default
in batch mode, (1), (2), (3)
setting up two-pass, (1), (2), (3)
shared members
simulating
single-server applications, (1), (2), (3)
specified dimensions
statistics
stopping
subsets of data, (1), (2), (3)
example
with Intelligent Calculation
testing
top-down
types described, (1), (2)
using MaxL
variance performance
with a series of dimensions
with a series of member formulas
year-to-date values
calculator cache
and parallel calculation
as storage unit
bitmap
disabling
maximum size
optimizing, (1), (2)
overview
setting size, (1), (2)
sizing
calculator hash tables, (1), (2)
and parallel calculation
canceling
archiving operations
calculations
changes to calc scripts
ESSCMD operations, (1), (2)
captures
carriage return as file delimiter
case conversions, (1), (2)
case sensitivity
field type designation in header record
member names
case-sensitive names
converting case, (1), (2)
defining selection criteria for, (1), (2)
for databases
improved for applications
report scripts
setting for database, (1), (2)
case-sensitive passwords
case-sensitive searches
Calc Script Editor
Field Properties dialog
Formula Editor, (1), (2)
Report Editor
cash flow, (1), (2)
catalogs, (1), (2), (3)
category conversion property
CCONV command, (1), (2)
usage examples, (1), (2)
usage overview, (1), (2)
CCONV TOLOCALRATE command
CCTRACK setting
cell calculation mode
cells
accessing
simultaneously in different databases
annotating
contents
copying range of
determining calculation order for, (1), (2)
examples, (1), (2), (3), (4)
empty
caution for storing
linking objects to
mapping to targets
ordering in blocks
partitioning and, (1), (2), (3)
removing linked objects
returning unique values for
centering data, (1), (2)
example
centralized data repositories
.CFG files, (1), (2)
See also configurations
change data cache size
Administration Services
Application Manager
change logs, (1), (2)
restructuring and
updating
change logs. See outline change logs., (1), (2)
Change Password dialog box
changes
affecting only outlines
applying to outlines, (1), (2)
discarding partition
impacting restructures
overriding incremental restructuring
overwritten
relational storage manager and
tracking outline
unable to make
undoing
viewing outline
changing
See also editing; altering
access privileges, (1), (2), (3)
alias table names
aliases
attribute associations
calc scripts, (1), (2)
consolidations
data, (1), (2), (3)
prerequisite for
data values
default storage properties
dimension names
dimension properties, (1), (2), (3), (4)
dimensions
default configurations
for currency conversions
Essbase kernel settings
with Administration Services
formulas, (1), (2)
headings in reports
Hyperion Essbase kernel settings
scope and precedence
with Application Manager
linked partitions
member combinations for linked objects
member names
members
outlines, (1), (2), (3)
caution for, (1), (2), (3)
dynamically
for currency conversions
with rules files
passwords with Administration Services
passwords with Application Manager
report layouts
security settings
security settings with Administration Services
security settings with Application Manager
system password
character searches. See searches
character strings
in calculation formulas
character strings. See strings
characters
calc scripts
end-of-file markers and special
forbidden at the beginning of a name
formulas
ignored in data sources
ignored in report extraction
in array and variable names
log delimiters
maximum
in aliases
in application and database names
in application names
in database names
in dimension names
in member names, (1), (2)
in URLs
numeric in member names
quoting in scripts and formulas, (1), (2)
valid in numeric data fields
checking
disk space
forward references
syntax
Calc Script Editor, (1), (2), (3)
Formula Editor, (1), (2)
check-out facility
.CHG files, (1), (2)
updating
child
See also parent/child relationships
adding as member of specified parent
as only member (implied sharing)
calculation order for outlines
checking for
consolidation properties and
currency conversions and
defined
dimension as
member as, (1), (2)
rolling up
shared member as
child field type
in header records
in rules files
sharing members, (1), (2), (3)
child processes
@CHILDREN function
CHILDREN command
entering in report scripts
usage
choosing
alias tables, (1), (2)
applications for loading
with ESSCMD
build methods, (1), (2)
calc script files, (1), (2)
data sources, (1), (2), (3), (4), (5)
using Windows
data targets
data to partition, (1), (2), (3)
databases for loading
with ESSCMD
dimension storage type, (1), (2), (3)
dimension type
guidelines for
fields
members
for dynamic calculations
members for column groupings
members for dynamic calculations, (1), (2)
members for report scripts, (1), (2), (3)
from Dynamic Time Series
with ATTRIBUTE command
with Boolean operators
with conditions
with substitution variables
with TODATE command
with user-defined attributes
with wildcards
with WITHATTR command
multiple dimensions and members
multiple files, (1), (2)
multiple members
partition type, (1), (2), (3), (4), (5)
in Partition Wizard, (1), (2), (3), (4)
records, (1), (2), (3)
report script files, (1), (2)
SQL data sources
values for dynamic calculations, (1), (2)
guidelines for, (1), (2)
clean status
caution for sparse dimensions
clearing data and
Intelligent Calculation and
marking blocks with, (1), (2)
partial calculations and
Clear Alias Table dialog box
Clear Data Combinations page (Data Load Settings)
CLEARALLROWCALC command
CLEARBLOCK command, (1), (2)
CLEARBLOCK DYNAMIC command, (1), (2), (3)
CLEARDATA command
partitioned applications and
usage overview, (1), (2)
clearing
See also deleting
alias tables
application and OLAP Server log contents
data, (1), (2), (3), (4)
caution
in calculated columns, (1), (2)
locks
log contents
member combinations
values in transparent partitions
CLEARLOGFILE setting
CLEARROWCALC command
CLEARUPDATESTATUS command
client
interfaces
accessing linked objects and
workstations
as used in Hyperion Essbase
caution for loading data from
troubleshooting connections
client window
client workstations
caution for improper shutdown
deleting calc scripts
limitations
recovering from improper shutdowns
writing calc scripts to, (1), (2)
clients, (1), (2)
communicating with server
types described
client-server applications
See also single-server applications
client-server model, (1), (2)
typical configuration
Close dialog box
saving partition definitions
closing
See also exiting; quitting; stopping
applications, (1), (2)
all opened
before backup
applications in Administration Services
with related database
applications in Application Manager
with related database
databases, (1), (2)
Partition Wizard
.CNT files
codes in data source
setting member properties
COLCALC1.REP
COLCALC2.REP
COLCALC3.REP
COLGROUP.REP
COLHEADING command
Collapse to Ancestor command
collapsing
alias member lists
Calc Script Editor lists
Formula Editor lists
outline hierarchies
colons (:)
in application and database names
in formulas
in names in scripts and formulas, (1), (2)
column calculation commands
COLUMN command
entering in report scripts
column formatting commands, (1), (2), (3)
column headings
adding to calculated columns
adding to reports, (1), (2)
changing
defined
displaying
for loading asymmetric columns
multi-line
names truncated
repeating
SQL data sources
suppressing
column widths
columns
See also fields
adjusting length
calculating in reports, (1), (2)
creating asymmetric
creating calculated, (1), (2)
defining as fields
fixed-width
formatting
formatting for data load, (1), (2)
mapping specific fields only
nesting in reports
numbering
ordering in data sources
overriding grouping in reports
parent/child data sources
replacing empty fields with text
restricting number of
setting as data field
switching with rows
symmetry in reports
using attributes in
combining fields. See joining fields, (1), (2), (3)
command prompt
command-line interface
See also ESSCMD; server console
ESSCMD
running batch files
commands
See also specific command
calculation types listed
caution for processing
computation
control
data extraction, (1), (2), (3)
declaring temporary variables for
entering in ESSCMD scripts
entering in report scripts
ESSCMD syntax
global calculation settings
iterating through
member selection, (1), (2)
page layout, (1), (2)
performance-related
report formatting, (1), (2), (3), (4), (5)
caution for usage, (1), (2)
report output
Server Agent
sorting, (1), (2)
commas ( , )
as file delimiter
displaying in reports
in application and database names
in data fields
in dimension and member names
in formulas
in header records
in member combinations
in names in scripts and formulas, (1), (2)
suppressing in reports, (1), (2)
COMMAS command, (1), (2)
overriding, (1), (2)
comment fields
comments
See also annotating
adding to dimensions
adding to members
calc scripts
display options
report scripts
storing
viewing in Application Manager
commission, (1), (2), (3)
returning from calc scripts
commit
threshold adjustments with parallel calculation
Commit Block setting, (1), (2)
Commit Row setting, (1), (2), (3)
commit threshold adjustments and parallel calculation
commits
data loads failing and, (1), (2), (3)
initiating, (1), (2)
managing
rollbacks and
setting isolation level
with ESSCMD, (1), (2)
updating isolation level
committed access
about
caution for
locks and, (1), (2), (3)
rollbacks and
setting, (1), (2), (3)
common currency
communications
client-server models, (1), (2), (3)
communications protocols
Company database
provided with Hyperion Essbase
comparing
data values, (1), (2), (3)
timestamps for outlines
complete loads
completion notices
Complex Formula
performance example
complex formulas, (1), (2), (3)
@COMPOUND function
compounded interest
@COMPOUNDGROWTH function
compression
as default
checking compression ratio in Administration Mservicesr
checking compression ratio in Application Manager
enabling/disabling, (1), (2)
estimating block size
fragmentation allowance, (1), (2)
optimal configuration
overview
ratio
repetitive values, (1), (2)
specifying/changing
viewing settings information
compression ratio, checking in Administration Services
compression ratio, checking in Application Manager
compression settings, changing with MaxL
computing data relationships
@CONCATENATE function
concatenating fields
concurrency, data
concurrent calculations, (1), (2)
overview
conditional blocks
conditional equations
conditional operators, (1), (2)
conditions
adding to report scripts, (1), (2)
examples, (1), (2), (3)
logical, (1), (2)
setting for ESSCMD
specifying
for data loads, (1), (2)
in formulas, (1), (2)
testing, (1), (2)
Confignuration parameter
CALCPARALLEL
configurable variables
setting
configuration files, (1), (2)
configurations
activating change logs
changing
checking
clearing logs
creating multiple exception logs
creating outline change logs
currency calculations
database
delimiting logs
determining optimal
dimensions
automatic
changing default setting
determining optimal
manual
enabling incremental restructuring
Hyperion Essbase kernel settings and
Intelligent Calculation
logging spreadsheet updates
resetting error log
limits
resetting error logs
files
limits
setting dimensions automatic vs manual
setting number of threads
setting outline change file size
viewing settings information, (1), (2)
configuring multiple agents on a single server
Confirm Delete dialog box, (1), (2)
Confirm Password text box, (1), (2)
Confirmation dialog box
Connect page (Partition Wizard)
connection passwords
connections
communications protocols
databases with data cells
losing
multiple servers
partitioned applications, (1), (2), (3)
preventing system failures, (1), (2)
terminating
for specific user
troubleshooting
Connections dialog box
consecutive values
consistency, data
consistency. See data integrity
console. See server console
consolidation
changing
codes in data source
default order
defined
defining for members, (1), (2)
display options
excluding members from, (1), (2)
fixing unexpected results, (1), (2)
levels within a dimension
operators listed
performance considerations
restrictions
specifying requirements for
consolidation paths
defining, (1), (2)
checklist for
consolidation properties
described
setting, (1), (2)
consolidations (in Hyperion MBA). See defaults, calculations
constants, (1), (2)
contracting. See collapsing
control information
conventions. See naming conventions
conversions
See also currency conversions
case, (1), (2)
positive/negative values
white space
in data loads
to underscores in data load
converting
dates
spaces to underscores
coordinates (data values)
Copy Alias Table dialog box
copy application
Administration Services
copy database
Administration Services
Copy Filter dialog box
Copy Group dialog box
Copy to Server Object dialog box
Copy User dialog box
COPYAPP command
COPYDB command, (1), (2), (3)
COPYFILTER command
copying
See also duplicating; replicating
alias tables
applications, (1), (2)
base dimension members
calc scripts
data, (1), (2), (3), (4), (5)
database outlines
databases, (1), (2)
filters
from data targets
objects
outline files, (1), (2), (3)
outlines
with Application Manager
security profiles, (1), (2)
text
in calc scripts
in formulas
in report scripts
@CORRELATION function
correlation coefficient, calculating
corrupted data, (1), (2)
operations causing, (1), (2)
restoring and
cost of goods
example for allocating
@COUNT function
Count member, Attribute Calculations dimension
count, calculating
country dimension
creating
currency applications
description
specifying
usage overview
country-specific data. See locales
.CPL files
crashes
exception logs for
getting information about
minimizing, (1), (2)
recovering from, (1), (2), (3)
suggested procedures
restructuring and
transaction rollbacks and
Create Alias Table dialog box
create application (MaxL)
create application as (MaxL)
Create Blocks on Equations option, (1), (2)
Create Currency Database dialog box
create database (MaxL), (1), (2)
Create Field Using Join dialog box, (1), (2)
Create Field Using Text dialog box
create group (MaxL)
create location alias (MaxL)
Create New Application dialog box, (1), (2)
Create New Database dialog box, (1), (2)
Create/Delete Applications permission
Create/Delete Applications privilege type
Create/Delete Users/Groups permission
Create/Delete Users/Groups privilege type
CREATEAPP command
CREATEDB command
CREATEGROUP command
CREATELOCATION command
CREATEVARIABLE command
creating
See also adding; building
alias combinations
alias tables, (1), (2)
aliases, (1), (2)
based on member combinations
caution for, (1), (2), (3)
guidelines for
applications, (1), (2)
for currency conversions
for Personal Essbase servers
on client
prerequisites
with Application Manager
backups
data blocks
data load rules
database outlines, (1), (2)
example for
from data sources
guidelines for
prerequisites for
with Outline Editor, (1), (2)
databases, (1), (2)
for Personal Essbase servers
on client
process summarized
with Administration Services
with Application Manager
Dynamic Calc And Store members
Dynamic Calc members
ESSCMD script files, (1), (2)
fields, (1), (2)
with joins
filters, (1), (2)
for partitioned databases, (1), (2)
formulas, (1), (2)
examples, (1), (2), (3)
syntax for
with Formula Editor
writing equations
header records, (1), (2)
linked partitions, (1), (2)
linked reporting objects
member groups, (1), (2)
multiple roll-ups, (1), (2)
outline change logs
outline files
outlines
for currency conversions
outlines for currency conversions
partition definition files
partitions, (1), (2), (3), (4), (5)
for currency conversions, (1), (2)
process summarized
replicated partitions, (1), (2)
report files
report scripts, (1), (2)
basic techniques, (1), (2)
parts described
with Application Manager
rules files, (1), (2)
process overview
scripts for batch processing
shared members, (1), (2), (3), (4)
for different generations, (1), (2)
for same generation, (1), (2)
guidelines for, (1), (2)
with Outline Editor
with rules files
shared roll-ups
substitution variables
text files, (1), (2)
transparent partitions
two-dimensional reports, (1), (2)
UDAs, (1), (2)
user groups, (1), (2)
user groups with Administration Services
user groups with Application Manager
creating applications
with Administration Services
with MaxL
creating databases
as optimized
ESSCMD
MaxL
creating new users
with Administration Services
with Application Manager
creating queries
cross-dimensional members
in formulas, (1), (2), (3), (4)
Cross-dimensional operator
replacing on the left side of an equation for performance
cross-dimensional operator (->), (1), (2), (3)
inserting in calc scripts
inserting in formulas, (1), (2)
overview, (1), (2)
usage examples, (1), (2)
crosstab defined
.CSC files
cubes
CURCAT. See currency category field type
@CURGEN function
CURHEADING command
@CURLEV function
CURNAME. See currency name field type
currency
ad hoc report
defining country-specific
effects of adding new markets
exchange rates, (1), (2), (3)
calculation options
formatting in reports
currency applications
creating
overview, (1), (2), (3)
sample
currency category
dimension (example)
currency category field type
in header records
in rules files
nulls and, (1), (2)
CURRENCY command
overriding
usage overview
Currency Conversion
description of product
currency conversions
adding members, (1), (2)
base to local exchange
calculating in report scripts
creating outlines for, (1), (2), (3)
creating partitions for, (1), (2)
defining
dynamic calculations and
getting information about
Intelligent Calculation and
keeping local and converted values
links and calculating
mathematical operations
overview
overwriting local values
recovering from errors
reporting
running, (1), (2), (3)
saving outline changes, (1), (2)
suppressing in reports
tagging dimensions for
currency database (defined)
currency database types
currency fields
Currency Name dimension (example)
currency name field type
in header records
in rules files
nulls and, (1), (2)
currency names, (1), (2), (3)
defining
Currency page (Database Information)
Currency page (Database Settings), (1), (2)
Currency Partition dimension, (1), (2), (3)
creating
usage overview
currency partition dimension
description
currency partitions
caution for transparent
creating
currency sample databases
linking
currency symbols
Currency Time dimension (example)
Currency Type dimension (example)
@CURRMBR function
@CURRMBRRANGE function
custom-defined function
creating a Java class
registering using Application Manager
custom-defined functions
function category
using in formulas
drop using MaxL
input parameters
memory considerations
performance considerations
registering
security required
custom-defined macros
customizing
applications
Data Prep Editor
Essbase kernel
file delimiters
Hyperion Essbase kernel
Outline Editor, (1), (2)
page layouts, (1), (2)
examples, (1), (2)
views
cutting text
Calc Script Editor
Formula Editor
Report Editor
D
dashes (-)
in dimension and member names
in member names
in names in scripts and formulas
in report scripts
data
accessing. See access
backing up
calculated vs. input
categorizing. See dimensions
centering in reports, (1), (2)
example
changing, (1), (2), (3)
prerequisite for
clearing, (1), (2), (3), (4), (5)
in calculated columns, (1), (2)
computing relationships
concurrency
consistency
controlling flow
copying, (1), (2), (3), (4), (5)
corrupted, (1), (2), (3)
operations causing, (1), (2)
derived
developing logical structures for
distribution characteristics
entering in data sources, (1), (2)
exporting, (1), (2), (3)
for backups
into other forms
reporting example
exporting using MaxL or ESSCMD, (1), (2)
importing, (1), (2)
improving access to, (1), (2)
in targets
irrelevant
loading
description, (1), (2)
dynamic calculations and
for testing purposes
from external sources, (1), (2), (3), (4)
from partitioned applications, (1), (2), (3)
from rules files
getting information about
incrementally
optimizing, (1), (2), (3), (4)
overview, (1), (2), (3), (4)
prerequisites, (1), (2)
restrictions, (1), (2), (3), (4)
supported formats
tips, (1), (2)
troubleshooting problems with
unauthorized users and
managing
manipulating remote
missing
not associated with members
organizing
partitioning guidelines, (1), (2), (3)
pivoting
protecting
recalculating, (1), (2)
after exporting
after member name changes
after repositioning members
Dynamic Calc And Store members
examples
for Personal Essbase servers
in sparse dimensions, (1), (2)
Intelligent Calculation and, (1), (2)
two-pass calculations and
referencing in dimensions, (1), (2)
refreshing
reloading exported, (1), (2)
replicating, (1), (2)
reporting combinations, (1), (2)
restoring from backups
sharing, (1), (2)
across multiple sites, (1), (2)
disabling, (1), (2), (3), (4)
in partitioned databases, (1), (2), (3)
sorting for reports, (1), (2), (3), (4)
examples, (1), (2), (3)
storing. See storage
synchronizing, (1), (2), (3)
partitioning and
time-sensitive
transactions and redundant, (1), (2)
validating
viewing, (1), (2)
in data targets
with Data Prep Editor, (1), (2)
viewing in different perspectives
data analysis
defining objectives
example
getting started tips
optimizing
single-server applications, (1), (2)
data block size
viewing in Administration Services
viewing size in Application Manager
data blocks
accessing locked, (1), (2)
and index system
as multidimensional arrays
calculating dirty
calculating values in, (1), (2)
caution for partial calculations
defining calculation order
calculations and
categorizing
checking characteristics of
checking structural integrity
clearing values, (1), (2)
compressing
creating from Intelligent Calculations
defined
exporting
locking, (1), (2)
with committed access, (1), (2)
with uncommitted access
managing
marking as clean/dirty, (1), (2)
ordering
removing
renumbering
restructuring, (1), (2)
retrieving, (1), (2), (3)
setting transactions for, (1), (2)
size considerations, (1), (2)
storing
two-dimensional example
updating
viewing locks
with no values
data cache
as storage unit
defined
described
fine-tuning
setting size, (1), (2)
data cache size
changing with Administration Services
changing with Application Manager
data cells. See cells
data compression
as default
changing using MaxL
checking compression ratio in Administration Services
checking compression ratio in Application Manager
enabling/disabling, (1), (2)
estimating block size
fragmentation allowance, (1), (2)
optimal configuration
overview
ratio
repetitive values, (1), (2)
specifying/changing
viewing settings information
data concurrency
data consistency
data consistency. See data integrity
data coordinates
data extraction, (1), (2)
characters ignored
data extraction commands, (1), (2)
defined
data fields
defined in data source
defining columns as
entering data
formatting, (1), (2)
in data sources, (1), (2)
invalid
reversing values in
with no values, (1), (2)
data file cache
as storage unit
defined
described
fine-tuning
setting size
Data File Properties dialog box
defining header information
mapping fields
setting file delimiters
undoing field operations
data files
See also files
allocating storage for
backing up
caution for recovery and
cross-platform compatibility
definition
estimating size
list to backup
opening, (1), (2)
restructuring, (1), (2)
size
setting maximum
viewing
spanning multiple volumes
data filters
assigning
copying
creating, (1), (2), (3), (4)
defining in Application Manager, (1), (2)
editing
inheriting, (1), (2), (3)
overlap conflicts, (1), (2)
overriding, (1), (2)
overview, (1), (2)
removing
renaming
restrictions on applying
saving
viewing existing
write access to database
data hierarchies
relationships defined, (1), (2)
data integrity, (1), (2)
checks failing
committed access and
maintaining
retaining duplicate data
uncommitted access and
validating
data load
error logs. See DATALOAD.ERR.
fields
free-form
load rules in the source data
mode
parallel processing, (1), (2), (3)
parent members
rules
creating
defined
described
when to use
use of threads, (1), (2)
Data Load Completed dialog box, (1), (2), (3)
Data Load dialog box, (1), (2)
building dimensions
changing outlines
selecting data sources, (1), (2)
Data Load Properties page
naming fields
Data Load Rules button (Application Manager)
Data Load Settings dialog box
changing data values
clearing existing values
defining header information
defining selection criteria
flipping field values
data loading
stages
Data Manager
overview
data points. See cells
Data Prep Editor
building dimensions, (1), (2), (3), (4)
creating rules files, (1), (2)
customizing
defining header information
dimension building mode
displaying
dimension building fields
records
enabling/disabling toolbar
loading data sources, (1), (2)
opening, (1), (2)
selecting data load or dimension build view
validating rules files, (1), (2)
viewing rules files
window
data redundancy overhead
Data Replication dialog box
data repositories
location
data sets
copying portions
distribution
non-typical
typical nature of data
data sources
accessing data
replicated partitions and
adding headers, (1), (2), (3), (4)
adding records, (1), (2), (3)
altering to build dimensions
appending information to
associating with rules files
building dimensions, (1), (2), (3), (4), (5)
changing outlines
copying
creating outlines with
creating shared roll-ups from multiple
debugging
defined
defining
for multiple partitions
for replicated partitions
for transparent partitions, (1), (2)
entering data, (1), (2)
field types
described, (1), (2)
invalid
fixing
partial loads, (1), (2)
for dimension builds
formatting, (1), (2), (3), (4)
overview
free-form, (1), (2), (3)
identifying
load failing
loading, (1), (2), (3), (4)
in Data Prep Editor, (1), (2)
prerequisites
troubleshooting problems, (1), (2)
logging into
losing connections to
mapping information
mapping members
linked partitions, (1), (2)
replicated partitions, (1), (2), (3)
transparent partitions, (1), (2)
member names differing from targets
members with no ancestor specified
missing members, (1), (2)
numbering members
opening
opening in Data Prep Editor
optimizing, (1), (2)
ordering
columns
fields, (1), (2)
records, (1), (2), (3)
overview, (1), (2), (3)
partitioning information for
propagating outline changes, (1), (2), (3)
process summarized, (1), (2)
remote data retrievals and
removing members
replicating derived data
replicating members
replicating partial sets
selecting, (1), (2)
how to
SQL
using Application Manager
using Windows
selecting text or spreadsheet
setting member properties
specifying
field type
specifying shared areas, (1), (2), (3)
supported
unavailable, (1), (2)
updating changes to, (1), (2)
validating rules files from
viewing, (1), (2)
with different values
with new member lists
Data Storage dialog box, (1), (2)
data storage property
setting
data storage. See storage; Hyperion Essbase kernel
data subsets
calculating, (1), (2), (3)
example
with Intelligent Calculation
clearing
copying
copying to Personal Essbase
prerequisites
loading, (1), (2)
data targets
accessing data, (1), (2)
archiving
calculations and, (1), (2)
changing data in
changing outlines
copying from
defined
defining
for multiple partitions
for replicated partitions
for transparent partitions, (1), (2)
logging into
losing connections to
mapping information
mapping members to data sources
linked partitions, (1), (2)
replicated partitions, (1), (2), (3)
specifying specific areas
transparent partitions, (1), (2)
member names differing from source
missing data
partitioning information for
propagating outline changes, (1), (2), (3)
process summarized, (1), (2)
selecting
specifying shared areas, (1), (2), (3)
updating changes to, (1), (2), (3)
viewing data in linked partitions
data values, (1), (2), (3)
See also missing values; range of values
accumulating
assigning
to member combinations
to variables
averaging
for time periods, (1), (2), (3)
non-zero values and
reporting examples, (1), (2)
with formulas, (1), (2)
changing
comparing, (1), (2)
comparing example
compression and repetitive, (1), (2)
defined
displaying specific
distribution among dimensions
duplicating
dynamically calculating, (1), (2), (3)
entering in empty fields
filtering
flipping
formatting in reports, (1), (2)
examples
identical
inconsistent
incorrect
interdependent
location
looking up
measuring
member with no
negative
flipping
variance as
nulls, (1), (2)
optimizing in sparse dimensions
ordering in reports, (1), (2)
example
out of range
overwriting, (1), (2), (3)
for currency conversions
placing retrieval restrictions, (1), (2)
example
reading multiple ranges
referencing, (1), (2), (3), (4)
retrieving
dynamically calculated, (1), (2), (3), (4)
from other databases
from remote databases, (1), (2), (3)
retrieving for reports
setting maximum rows allowed
with conditions, (1), (2), (3), (4)
rolling up
rounding, (1), (2)
scaling
setting maximum number of
storing, (1), (2)
temporary, (1), (2)
truncating
unable to change
unexpected
unique
assigning #MISSING values to
Intelligent Calculation and
unknown
variables as
void
Data Values page (Data Load Settings)
adding to or subtracting from existing values
flipping field values
database
exporting methods
larger than 2 GB, exporting
parallel calculation level
rename, (1), (2)
Database Access options (Database Settings)
database administrators. See administrators
database cells
accessing
simultaneously in different databases
annotating
copying range of
determining calculation order for, (1), (2)
examples, (1), (2), (3), (4)
empty
caution for storing
linking objects to
mapping to targets
ordering in blocks
partitioning and, (1), (2), (3)
removing linked objects
returning unique values for
Database Copy dialog box
database design
attribute dimensions
Database Designer permission
Database designer permission
Database Designer privilege. See DB Designer privilege
database directory
database files
backing up
corruption and
essential files
on different operating systems
Database Filter layer, (1), (2)
Database Information dialog box, (1), (2), (3)
cache hit ratios
performance checks
Database Locks dialog box
database objects
calc scripts
data sources
linked reporting objects
member select definitions
outlines
report scripts
rules files
security definitions
spreadsheet queries
database outlines. See outlines, (1), (2)
database processing as server function
Database Properties
adjust retrieval buffer size
adjust retrieval sort buffer size
run a calc script
Database Properties dialog box
changing Essbase kernel settings
Database Properties window
check index and data file sizes
check performance
viewing latest database settings
database restructuring
using incremental
Database Settings dialog box
calc options settings
changing Essbase kernel settings
changing Hyperion Essbase kernel settings
global database access
setting
currency conversion links
retrieval buffer size, (1), (2), (3)
settings described
databases
See also data; partitioned databases
accessing, (1), (2)
remote
analytical vs transaction processing
annotating
annotating with Administration Services
associating
with calc scripts, (1), (2), (3), (4)
with reports
associating index files with
attaching to. See connections
backing up
building
development process for
example for
prerequisites for
building an outline
calculating multiple
checking
operational status
which databases are currently running
checklist for analyzing
closing related application in Administration Services
closing related application in Application Manager
configuring
copying, (1), (2)
copying using MaxL
creating, (1), (2), (3)
for Personal Essbase
on client
process summarized
with Administration Services
with Application Manager
creating accounts for, (1), (2), (3)
creating using MaxL
currency conversions and
deleting
deleting using MaxL
determining scope
distributing. See partitioning
fine tuning
identifying data sources
implementing common security
implementing global security
linking related, (1), (2)
loading applications with
minimizing downtime
mission-critical
multidimensional defined
naming rules
navigating between, (1), (2)
non-contiguous portions in
objects
opening
optimizing access, (1), (2)
to large
optimizing retrieval
overview
partitioning, (1), (2)
guidelines for, (1), (2)
sample applications showing
permission
planning prerequisites
processing requests
protecting data
putting in archive or read-only mode
rebuilding
reducing size
related information among
reloading after porting
removing
partitions
removing dimensions
restructuring and
renaming
renaming using MaxL
restoring from backups
restructuring, (1), (2)
changing outlines and, (1), (2)
dynamic calculations and
immediately, (1), (2)
in partitioned applications
Intelligent Calculation and, (1), (2)
process described
sample
selecting
with ESSCMD
size determinations, (1), (2), (3)
slicing
splitting, (1), (2)
starting
automatically
automatically using Administration Services
stopping, (1), (2)
taking out of archive or read-only mode
terminating requests
testing design
typical contents
updating, (1), (2)
viewing
in Application Manager
information about, (1), (2)
viewing statistical information
with differing dimensionality
Databases list box
DATACOPY command, (1), (2), (3)
currency conversions and
partitioned applications and
usage overview, (1), (2)
DATAERRORLIMIT setting, (1), (2), (3)
DATALOAD.ERR
See also error log files
example
loading
maximum errors logged
overview
renaming
setting
using to debug data load problems
viewing
DATALOAD.TXT
date
attribute dimensions
changing the member name format
tagging
attributes
defined, (1), (2)
duplicate values
date calculations, (1), (2)
examples
dates, in calculation formulas
day-to-date calculations
.DB files
DB Designer privilege
dBASE data files
dBASE databases. See SQL databases
dBASE index files
.DBB files
.DBF files
.DDB files, (1), (2), (3)
.DDM files
.DDN files
deadlocks
deallocation (storage), (1), (2)
debugging data loads
debugging tool
DECIMAL command, (1), (2), (3)
decimal points
declaring
arrays
variables, (1), (2), (3)
@DECLINE function
Default table (aliases)
updating during builds
defaults
aggregating missing values
application settings
cache size
calculations
setting, (1), (2), (3)
calculator cache
currency type
data storage, (1), (2)
dimension properties
dynamic builds
error log locations
for database settings
Intelligent Calculation
login information
maximum lock time
member selection for reports
members names
outline change log size
retrieval buffers, (1), (2)
time balance tags
variance reporting tags
Define Attribute Dimensions dialog box
Define Filter dialog box
Define SQL dialog box
defining
See also adding; creating; setting
a single data value
area-specific mappings
calc script as default
calculation order
cells, (1), (2)
data blocks
dimensions
dynamically calculated values, (1), (2)
forward references and
members, (1), (2)
calculations (checklist for)
columns as fields
consolidation paths, (1), (2)
checklist for
currency conversions
custom attributes
data sources
for multiple partitions
for replicated partitions
for transparent partitions, (1), (2)
data storage properties
data targets
for multiple partitions
for replicated partitions
for transparent partitions, (1), (2)
dimension properties, (1), (2), (3), (4)
caution for two-pass tags
dimensions as flat, (1), (2)
dynamic calc properties
field type, (1), (2)
filters in Application Manager, (1), (2)
global access levels
member properties, (1), (2), (3), (4)
as label only
members as label only
multiple layout reports
page layouts, (1), (2), (3)
parent/child relationships
partitioned areas
linked partitions, (1), (2)
replicated partitions, (1), (2)
transparent partitions, (1), (2)
partitions, (1), (2), (3)
linked, (1), (2)
multiple
replicated, (1), (2)
transparent, (1), (2)
with Partition Wizard, (1), (2), (3), (4)
selection/rejection criteria, (1), (2)
multiple for single field, (1), (2)
on multiple fields
shared member properties, (1), (2)
sort order
two-pass calculations, (1), (2)
UDAs
definition files. See partition definition files
delays
Delete Alias Table dialog box
delete application
Administration Services
delete database
Administration Services
delete logs
OLAP Server and application in Application Manager
OLAP Server logs and application logs in Administration Services
DELETEAPP command
Deleted Dimensions dialog box
DELETEDB command
DELETEGROUP command
DELETELOCATION command
DELETELOG command
DELETEUSER command
DELETEVARIABLE command
deleting
See also clearing
aliases
applications
calc scripts, (1), (2)
contents from alias tables
data blocks
databases
dimensions
restructuring and
filters
formulas
items from outlines
linked objects
locks, (1), (2), (3), (4)
automatically
logs, (1), (2)
logs in Application Manager
members from data sources
objects
partitions
substitution variables
temporary files
text
in calc scripts
in formulas
in report scripts
user groups with Administration Services
user groups with Application Manager
users, (1), (2)
users with Application Manager
white space in fields
deleting dimensions from outlines
deleting users and groups
DELIMITEDMSG setting
DELIMITEDMSG to filter logs
DELIMITER setting
delimiters
~ (tildes) as default
See also file delimiters
application logs and
commas in numbers
exports/imports, (1), (2)
member lists
OLAP Server logs and
report script commands, (1), (2)
Demo application
Demo Basic database
sample reports
dense dimensions
See also dimensions; sparse dimensions
attribute design approach
calculating values in, (1), (2), (3)
examples, (1), (2), (3)
defined
dynamically calculating, (1), (2), (3), (4)
implications for restructuring and, (1), (2)
Intelligent Calculation and, (1), (2)
location in outline, (1), (2)
member order and
partitioning, (1), (2)
referencing values in, (1), (2)
reporting on
selecting
selection scenarios, (1), (2)
setting
storing
viewing member combinations, (1), (2)
vs sparse dimensions
density
depreciation, (1), (2)
derived data
DESC command
described
usage example
@DESCENDANTS function, (1), (2)
descendants
checking for
clearing
currency conversions and
defined
moving
DESCENDANTS command
entering in report scripts
usage
descending sort order
applying to output
members in outlines
desiging, building, and maintaining
design checklists
analyzing database scope
creating business models
defining calculations
defining consolidations
defining dimension properties
identifying data sources
partitioning databases, (1), (2)
selecting partition types
design guidelines
attributes
dimensions
outlines
Designer permission
designer permissions
designing
See also building; creating
for optimal calculations, (1), (2)
partitioned applications, (1), (2), (3), (4)
scenarios for, (1), (2), (3)
reports, (1), (2)
simple applications, (1), (2), (3)
single-server applications, (1), (2)
Designing and building a security system
Designing, building, and maintaining partitions
Desktop window. See Application Desktop window
detail members
developing applications
process summarized
Diagnostic Information
diagnostic information
quick reference table
diagnostic tools
overview
dialog boxes
informational
refreshing pages in
differences
between attributes and UDAs
between standard and attribute dimensions
DIMBOTTOM command
entering in report scripts
usage
DIMBUILD.ERR
example
loading
maximum errors logged
overview
renaming
setting
viewing
dimenion building rules
summary for attribute dimensions
dimension
as highest consolidation level
dimension build
associating
aliases with attributes
base dimension members with attributes
attribute members options
defining
attribute dimensions
standard dimensions
error logs. See DIMBUILD.ERR.
fields
mode
position of fields in rules file
Dimension Build Completed dialog box, (1), (2)
Dimension Build Settings dialog box
adding members, (1), (2)
creating rules files, (1), (2)
naming dimensions
setting properties
Dimension Build Settings page (Dimension Build Settings)
dimension building
field types
rules
setting mode in Data Prep Editor
Dimension Building Properties page (Field Properties)
Dimension Definition page (Dimension Build Settings)
dimension fields
formatting
in data source, defined
dimension names
maximum length
Dimension Properties dialog box
Dimension Properties page (Dimension Properties)
Dimension Specification dialog box
adding comments
applying time balance tags
defining dimension type, (1), (2), (3), (4), (5), (6)
dimension type
setting
DIMENSIONBUILD.TXT
dimensions
See also dense dimensions; sparse dimensions; attribute dimensions; standard dimensions; base dimensions
adding and deleting
adding comments to
adding members, (1), (2), (3), (4), (5), (6)
example for, (1), (2)
for currency conversions, (1), (2)
guidelines for
partitioned applications
restrictions
adding to outlines, (1), (2), (3), (4)
performance considerations, (1), (2)
restructuring and
applicable to business models
arranging in hierarchies, (1), (2)
associating formulas with
attribute
See also attribute dimensions
described
attribute vs standard
auto-configuring, (1), (2)
base
See also base dimensions
defined
building, (1), (2), (3), (4)
dynamically See dynamic builds
example for
guidelines for, (1), (2)
prerequisites, (1), (2), (3)
with dynamically calculated members
with rules files
calculating members in, (1), (2)
calculating series of
calculator cache and
categorized
changing
default configurations
for currency conversions
changing properties, (1), (2), (3), (4)
clearing member combinations
consolidation levels
creating filters for
databases with different
defined
defining as flat, (1), (2)
defining properties, (1), (2), (3), (4)
caution for two-pass tags
deleting
restructuring and
deleting from outline
determining optimal configuration, (1), (2)
determining valid combinations
displaying
in Calc Script Editor
in Formula Editor
in outlines
displaying information about
examples
time-balanced data, (1), (2)
fixing as constant
getting member combinations
getting started with setting up
grouping in calc scripts, (1), (2), (3)
handling missing values in
identified in data source
inheritance characteristics
irrelevance across
mapping fields to
missing
missing members
moving in outlines
naming, (1), (2), (3)
naming levels in current
nesting
non-specific
optimum order in outline
ordering
ordering members
predefined types described
referencing data in, (1), (2)
relationship among members, (1), (2), (3), (4)
renaming
selection guidelines
separating sparse and dense
sharing members, (1), (2)
single-server models
sorting, (1), (2)
sparse-dense recommendations
splitting
standard
See also standard dimensions
alternative for attributes
compared with attribute types
described
standard vs dynamic
tagging
as Currency Partition
as specific type
for currency conversion
two-pass calculations and
types
updating
DIMTOP command
usage
direct I/O
direct I/O, adjusting cache sizes
direct I/O, using in place of buffered I/O
directories
API
application
database
default
for calc scripts
for error logs
default for calc scripts
error logs
spreadsheets as data sources
text files as data sources
dirty status
calculating blocks with
clearing data and
copying data and
currency conversion and
Intelligent Calculation and
marking blocks with, (1), (2)
resulting from reloads
Disabled Usernames dialog box
disabling member sort
discarding records
disconnecting
from server
other users
session or request
discontinuous field selection
@DISCOUNT function
discount, calculating
disk drives
copying applications to
copying databases to
viewing information about, (1), (2)
Disk Drives page (Server Information)
disk I/O, reducing, (1), (2)
disk space
allocating, (1), (2)
example
application logs and
availability for restructuring
calculations for determining
compressed block size
data file storage, (1), (2)
data redundancy overhead
database overhead
fragmentation allowance
checking, (1), (2)
conserving
estimating
for linked reporting objects
freeing, (1), (2), (3)
OLAP Server logs and
out of
outline change logs and
partitioned databases, (1), (2)
with replicated partitions
with transparent partitions
unused and fragmented
Disk Swapping option
disk volumes
allocation and
backing up data on
caution for specifying name only
data files and
data storage and multiple
deallocating, (1), (2)
index files and
specifying
with Application Manager
with ESSCMD
updating storage settings
Disk Volumes setting, (1), (2)
display filter (MaxL)
display group (MaxL), (1), (2), (3), (4), (5), (6)
display location alias (MaxL)
display options
data in reports, (1), (2)
formulas
headings in reports, (1), (2)
outlines
reports
display port information
display system (MaxL) to show available unused ports
display user (MaxL), (1), (2), (3), (4), (5), (6), (7)
display user (MaxL) to show total number of installed ports
display user in group (MaxL)
DISPLAYALIAS command
displaying
access settings
active filters
aliases, (1), (2)
in Calc Script Editor
in Formula Editor
application information, (1), (2), (3)
application logs
applications
available ports, (1), (2)
changes to outlines
current users, (1), (2), (3)
data, (1), (2), (3)
in targets
with Data Prep Editor, (1), (2)
data sources, (1), (2)
data targets
database
information, (1), (2)
databases
dimensions
in Calc Script Editor
in Formula Editor
in outlines
dynamically calculated members, (1), (2)
field operations
formulas, (1), (2)
inactive users
informational messages, (1), (2), (3)
linked objects, (1), (2)
locked data
locks
logs, (1), (2), (3)
member combinations, (1), (2)
member names in reports
members in outlines, (1), (2)
names for generations and levels
partitions, (1), (2)
records
replace operations
selection/rejection criteria
Server Agent commands
server information
software version
specific values
storage information
text in Outline Editor
unique values
distributed client-server model defined
distributed databases. See partitioning
distribution (multidimensional models)
dividing
databases
fields
dividing applications. See partitioned databases; partitions; splitting, databases
dividing databases
division
consolidation codes in data source
consolidation property
modulus operations
.DLL files
DLSINGLETHREADPERSTAGE setting
DLTHREADSPREPARE setting
DLTHREADSWRITE setting
Do Not Share option
dynamic builds and, (1), (2), (3), (4)
DOCS directory, (1), (2), (3)
documentation
suggested audience
typographical conventions
documents, linking external
dollar signs ($)
in array and variable names
dollar values
converting to US$
double quotation marks (")
enclosing member names, (1), (2)
in application and database names
in dimension and member names
in ESSCMD commands
in formulas, (1), (2), (3)
in header information
in report scripts
terms in scripts and formulas, (1), (2)
double slashes (//) in report scripts
downtime
drill
to display data
drilling across, (1), (2), (3)
facilitating
drop application (MaxL)
drop database (MaxL)
drop function (MaxL)
drop group (MaxL)
drop location alias (MaxL)
drop user (MaxL)
D-T-D time series member, (1), (2)
dummy
parents
strings
DUMP command (Agent)
DUPGEN. See duplicate generation field type
DUPGENALIAS. See duplicate generation alias field type
DUPLEVEL. See duplicate level field type
DUPLEVELALIAS. See duplicate level alias field type
duplicate
data
generations
members
duplicate generation alias field type
arranging in rules files
in header records
in rules files
nulls and
duplicate generation field type
arranging in rules files
creating shared members
in header records
in rules files
nulls and
duplicate level alias field type
arranging in rules files
in header records
in rules files
nulls and
duplicate level field type
arranging in rules files
in header records
in rules files
nulls and
sharing members
duplicate members
See also shared members
duplicating
See also copying; replicating
data
data values
outlines
dynamic builds
adding new members
as child of specified parent
to dimensions with similar members
to end of dimensions
arranging fields
bottom-up ordering, (1), (2), (3)
creating shared members, (1), (2)
for different generations, (1), (2)
for same generation, (1), (2)
with rule files
generation references and
global options
introduction, (1), (2)
level references and
members without specified ancestor
parent/child references and, (1), (2)
process summarized
restrictions
selecting build method, (1), (2)
selecting field types for
top-down ordering, (1), (2)
validating rules files
with Data Prep Editor, (1), (2), (3), (4)
with data sources, (1), (2), (3), (4), (5), (6)
with rules files
Dynamic Calc And Store members
adding to calculations
adding to formulas
clearing values
creating
currency conversions and
dense dimensions and
loading data into
partitioning, (1), (2)
replicating
reporting on
retrieving values
selecting, (1), (2)
specifying in data source
viewing
Dynamic Calc And Store property
applying, (1), (2), (3)
described, (1), (2)
removing
Dynamic Calc members
adding to calculations
adding to formulas
Attribute Calculations dimension
creating
currency conversions and
loading data into
partitioning, (1), (2), (3)
replicating, (1), (2)
reporting on
retrieving values
selecting, (1), (2)
specifying in data source
viewing
Dynamic Calc property
and sparse dimensions, (1), (2)
and two-pass members
applying, (1), (2), (3)
in Application Manager
description
removing
dynamic calculations
asymmetric data
Attribute Calculations dimension
building, (1), (2)
restrictions, (1), (2), (3)
building dimensions with
calc scripts and, (1), (2)
choosing members
guidelines for, (1), (2)
choosing values, (1), (2)
guidelines for, (1), (2)
database design
defined
defining order, (1), (2)
exporting data and
formulas applied to members
optimizing retrieval
partitioned databases
replicated partitions
retrieving values, (1), (2), (3), (4)
transparent partitions
usage overview, (1), (2), (3)
viewing application
dynamic calculator cache
configuration settings
overview
sizing, (1), (2), (3)
summary of activity
viewing usage information
dynamic dimension building
adding members to outlines, (1), (2), (3)
generation references
level references
dynamic dimensionality
for separating data into sparse and dense dimensions
for storing and retrieving data
dynamic dimensions
level references
dynamic references
defining header information
description
record numbers in
Dynamic Time Series Member Information dialog box
defining aliases
enabling/disabling members, (1), (2)
Dynamic Time Series members, (1), (2)
enabling/disabling, (1), (2)
generation names for
in shared areas
inserting in report scripts
listed
reporting on
selecting
specifying aliases for
E
E, expense property code in data source
East database
partitioning
provided with Hyperion Essbase
Edit Alias dialog box
Edit User dialog box
modifying access settings
editing
See also changing
aliases
filters
linked files
partitions
report scripts, (1), (2), (3), (4)
security profiles
user groups
editors
calc scripts and
ESSCMD commands and
formulas and
report scripts and
electronic mailboxes
ELSE operator
usage examples, (1), (2)
ELSE statement
ELSEIF statements
calc scripts
formulas, (1), (2)
empty database cells
caution for storing
empty fields
adding values to
blank fields in rules file
in data source
emptying. See clearing
ENDARCHIVE command
partitioned applications and
ENDFIX command, (1), (2), (3)
allocating costs, (1), (2)
allocating values
calculating product/market shares
calculating range of values
calculating subsets of values
clearing data blocks
clearing subsets of values
copying subsets of values
currency conversions and
Intelligent Calculation and, (1), (2), (3)
optimizing calculations with, (1), (2), (3)
ENDHEADING command
entering in report scripts
modifying headings
usage example
ENDIF statement
calc scripts
interdependent formulas in
member formulas in
semicolons with
syntax
formulas
purpose of
semicolons with
syntax
usage examples, (1), (2)
ENDLOOP command, (1), (2)
end-of-file markers
end-of-line character, (1), (2)
ESSCMD commands
inserting in calc scripts, (1), (2), (3)
inserting in formulas
Environment Variables list box
environments
See also UNIX platforms; Windows platforms
.EQD files
equal signs (=)
in application and database names
in calc scripts
in dimension and member names
in formulas
in names in scripts and formulas
in report scripts
equations, (1), (2)
See also formulas
cross-dimensional operator and, (1), (2), (3)
inserting in calc scripts, (1), (2)
report scripts
.ERR files
.ERR files. See error log files
error codes and numbers
error handling (Hyperion Essbase kernel)
error logs, (1), (2)
default directory for
empty
loading
maximum number of records in, (1), (2), (3)
missing
names and locations
renaming
resetting
record count, (1), (2)
setting
error message categories
error messages. See application logs, exception logs, and OLAP Server logs.
error-handling commands
errors
application logs and
calc scripts
checking for
currency conversions
ESSCMD, (1), (2)
exception logs and
fixing for dynamic builds
formulas and
formulas and dynamically calculated members
formulas,checking for
handling fatal
loading data, (1), (2)
locking, (1), (2)
matching member omitted
mismatches
OLAP Server logs and
partition validation
pinpointing
Report Extractor
restructuring and
storage allocation
time-out, (1), (2)
unknown member
ESBBEGINREPORT function
ESBENDREPORT function
ESBREPORT function
ESBREPORTFILE function
.ESM files, (1), (2), (3)
.ESN files, (1), (2)
.ESR files
Essbase
architecture
benefits
development features described
displaying software version number
getting started tips
guide prerequisites
parallel login processing
products summarized
program files, (1), (2)
quick reference to menus and dialog boxes
quitting, (1), (2)
starting
starting with quicklogin
Essbase Administration Services
Essbase client. See clients
Essbase Config page (Server Information)
Essbase kernel
changing settings
Essbase kernel settings
Essbase Server Agent. See Server Agent
Essbase server. See server
Essbase System Login dialog box
ESSBASE.BAK
ESSBASE.CFG, (1), (2), (3)
dynamic calculator cache settings, (1), (2)
setting messages added to application logs
setting messages added to OLAP Server logs
ESSBASE.LOG, (1), (2)
ESSBASE.LOG files
ESSBASE.SEC
and filters
backup of
ESSBEGINREPORT function
ESSCMD
See also specific command
canceling operations, (1), (2)
caution for processing commands
checking structural integrity
defined
deleting logs
entering commands
error-handling, (1), (2)
ESTIMATEFULLDBSIZE
loading update log files
operational modes
performance-related commands
referencing files
replicating data
running, (1), (2)
calc scripts, (1), (2)
caution for pausing systems and
in interactive mode
reports, (1), (2)
setting
isolation levels
substitution variables
transaction isolation levels
shutting down server
specifying
data compression
disk volumes
starting
prerequisites
starting applications
starting databases
starting/stopping applications
stopping applications
stopping databases
syntax
updating replicated partitions
viewing dynamic calculator cache activity
writing script files
ESSCMD script files
creating, (1), (2)
naming
quotation marks in
running
sample
within operating system batch files
ESSCMD.EXE
ESSENDREPORT function
ESSGBEGINREPORT function
ESSGREPORTFILE function
Essnet library
connection between Essbase and network
ESSREPORT function
ESSREPORTFILE function
ESSSVR (application server), (1), (2)
ESTIMATEFULLDBSIZE command
Estimating calculations
estimating disk space
linked reporting objects
estimating time for a calculation
Euro currency symbol
EUROPEAN command
overriding
usage
event logs. See logs.
events
Excel spreadsheets. See Spreadsheet Add-in
exception error logs. See exception logs.
Exception Handler
location of writes
exception logs
contents described
example
names and locations
overview
overwriting
saving
viewing
EXCEPTIONLOGOVERWRITE setting
exchange rates, (1), (2)
calculating options
defining
sample database
exclamation points (!)
See also bang command
in names in scripts and formulas
excluding members from consolidations, (1), (2)
exclusive locks. See Write locks
.EXE files
Execute Calc Scripts dialog box
execute calculation (MaxL), (1), (2)
Execute permission
Existing Members options in dimension build
EXIT command
EXIT command (Agent), (1), (2)
exiting
See also closing; quitting; stopping
Essbase
Partition Wizard
@EXP function
expanding
alias member lists
Calc Script Editor lists, (1), (2), (3)
Formula Editor lists, (1), (2), (3)
outline hierarchies
expense property, (1), (2)
specifying in data source
expense vs. non-expense items
exponentiation
exponents
calculating
export (MaxL), (1), (2)
EXPORT command, (1), (2)
columnar format
partitioned applications and
export files
Export Server Alias Table Object dialog box
exported data reloads, (1), (2)
exporting
alias tables, (1), (2)
data, (1), (2), (3)
for backups
in parallel
into other forms
recalculating
reporting example
databases larger than 2 GB
LROs
external data sources
for loading data, (1), (2), (3), (4)
linking to cells
prerequisites for loading
supported
extraction
characters ignored
commands, (1), (2)
data, (1), (2)
extraction commands
defined
F
F, first time balance code in data source
@FACTORIAL function
factorials
failures
calculations
getting information about
preventing, (1), (2)
recovering from, (1), (2), (3)
suggested procedures
restructuring and
transaction rollbacks and
fatal errors
FEEDON command
fetches
Field Edits page (Data File Properties)
field names
adding prefixes or suffixes to
assigning to data fields
changing case
SQL data sources
validating
field operations
field ordering for logs
Field Properties dialog box
adding members, (1), (2)
adding prefixes and suffixes
applying case conversions
converting white space to underscores
defining columns as fields
mapping fields
naming fields
removing white space
replacing text strings
scaling data values
setting field types
field types
data sources, (1), (2), (3)
invalid
dimension building properties
dynamically referencing
restrictions for rules files
setting for record selection, (1), (2)
setting member properties, (1), (2)
shared members, (1), (2), (3), (4), (5), (6)
caution for creating
specifying, (1), (2)
valid build methods
fields
See also columns
adding prefixes or suffixes to values
arranging, (1), (2), (3)
building dynamically, (1), (2)
changing case
clearing existing values
concatenating multiple
copying, in rules files
creating
by splitting
with joins
defined
defining columns as
defining operations for rules files
delimiters/separators. See file delimiters
displaying in Data Prep Editor
empty
adding values to
in data source
in rules file
replacing with text
entering data, (1), (2)
excluding specific from data loads
formatting rules, (1), (2), (3)
in data sources
invalid
manipulating in rules files
mapping
changing case
inserting text in empty fields
replacing text strings
specific only, (1), (2)
to member names
moving
naming
position in rules file, (1), (2)
processing nulls in, (1), (2)
removing white space in
reversing values in
select/reject criteria
selecting
setting retrieval specifications, (1), (2)
size and optimal loads
undoing operations on
File Delimiter page (Data File Properties)
file delimiters
customizing
formatting rules
in header information
mapping files
setting, (1), (2)
file locks, (1), (2)
file system
backing up databases with
managing files with
types on server
file-name extensions
batch files
calc scripts
error logs
ESSCMD script files
in ESSCMD
listed, (1), (2)
live reporting object files
outline change files
report files
report scripts
rules files
temporary files
text files
files
See also data files; rules files; text files
attaching external to cells
backing up, (1), (2)
caution for recovery and
compatibility across platforms
copying across operating systems
editing linked
essential for Essbase
estimating size
implementing security for
importing, (1), (2), (3)
locating end-of-file markers
location of sample report scripts
logging data load errors
logging dimension builds
logging outline changes
opening, (1), (2)
program, (1), (2)
referencing in ESSCMD
referencing using ESSCMD
renaming with FTP
restrictions for linking
restructuring
running multiple report scripts
selecting multiple for loading, (1), (2)
sending report output to
specifying size for linked, (1), (2)
storing
temporary for full restructures
transferring compatible
types
compatibility across platforms
types described, (1), (2)
updating log
with long names
Files page (Database Information)
Filter Access privilege
filters
and attribute functions
AND relationship
assigning
copying
creating, (1), (2), (3)
for partitioned databases
defined on seperate rows
defining in Application Manager, (1), (2)
deleting
displaying in MaxL
editing
in the security (.SEC) file
inheriting, (1), (2), (3)
insert into logs with DELIMITEDMSG
on entire members
on member combinations
OR relationship
overlap conflicts, (1), (2)
overriding, (1), (2)
overview, (1), (2)
removing
renaming
restrictions on applying
saving
using member set functions
viewing existing
write access to database
Filters dialog box
financial applications
allocating costs
allocating values, (1), (2)
calculating product and market share
comparing actual to budgeted expense, (1), (2)
containing time-sensitive data
estimating sales and profits
example for building
forecasting values
getting budgeted data values
getting variance for actual to budgeted, (1), (2)
load from different sources
loading new budget values
financial functions, (1), (2)
formulas and, (1), (2), (3)
Intelligent Calculation and
Find dialog box
Calc Script Editor, (1), (2)
Formula Editor, (1), (2)
Report Editor
finding
end-of-file markers
members in Calc Script Editor
members in Formula Editor
specific values, (1), (2)
text in formulas
first time balance property
specifying in data source
first-time calculations
first-time users
FIX/ENDFIX command, (1), (2), (3)
allocating costs
allocating values, (1), (2)
calculating product/market shares
calculating range of values
calculating subsets of values
clearing data blocks
clearing subsets of values
copying subsets of values
currency conversions and
Intelligent Calculation and, (1), (2), (3)
optimizing calculations with, (1), (2), (3)
FIXCOLUMNS command
fixed-size overhead, (1), (2)
fixed-width columns
flags (partitions)
flat dimensions, (1), (2)
flat files
loading
FLAT2SQL.REP
flipping data values
Font dialog box, (1), (2)
fonts, (1), (2)
forecasting values
examples
functions, (1), (2)
foreground startup
format
database outlines
formats
See also formatting commands
alias tables
calculated data, (1), (2)
columns for data load, (1), (2)
comments
data sources, (1), (2), (3), (4)
overview
export
free-form data sources, (1), (2), (3)
header information
import specifications and
linked object restrictions
member mappings
report output
sample report, (1), (2), (3), (4)
suppressing in reports, (1), (2)
tab-delimited
formatting commands, (1), (2)
calculations, (1), (2)
caution for usage, (1), (2)
defined
display options, (1), (2)
listed
nesting
output
report headings, (1), (2), (3)
formatting styles (documentation)
Formula Editor
building formulas, (1), (2), (3)
checking syntax, (1), (2)
deleting formulas, (1), (2)
expanding/contracting dimensions
expanding/contracting member branches
finding and replacing text
opening, (1), (2)
saving formulas
searching for members
undoing last action
formula field type
in header records
in rules files
nulls and, (1), (2)
formula limitations and parallel calculation
formulas, (1), (2), (3)
adding aliases
adding series to calc scripts
adding text to
adding to calc scripts, (1), (2), (3)
adding to report scripts
allowing changes
applied to members, (1), (2), (3), (4), (5), (6)
applying to data subsets
associating with dimensions or members
calculating twice, (1), (2), (3)
with Intelligent Calculation, (1), (2)
calculation mode used
caution for sparse dimensions
changing
complex, (1), (2)
creating
examples, (1), (2), (3), (4)
syntax for
writing equations
cross-dimensional operator and
cross-dimensional references in, (1), (2)
defined
deleting
displaying, (1), (2)
dynamic calculations and, (1), (2)
errors in, (1), (2)
examples
finding and replacing text in
grouping in calc scripts, (1), (2), (3)
in partitioned applications, (1), (2)
in time and accounts dimensions
inserting operators
inserting variables
Intelligent Calculation and
names with special characters, (1), (2)
nesting, (1), (2)
optimizing
partitions and
performance considerations, (1), (2)
printing
saving
setting conditions for, (1), (2)
shared members and
simple, (1), (2)
top-down
troubleshooting, (1), (2)
types described
forward calculation references
FoxPro databases. See SQL databases
fragmentation (defined)
fragmentation allowance
free-form
data load
data sources
formatting, (1), (2)
reports
freeing memory
FTP file transfers
full restructure
temporary files created
Function Templates dialog box
functions, (1), (2)
See also specific @function
allocation
API
applying in filter definitions
applying to subsets
Boolean
calc scripts and
calculation mode
date and time
defining multiple members and
defining partitioned areas with, (1), (2), (3)
financial calculations with
forecasting
formulas and, (1), (2), (3), (4)
generating member lists, (1), (2)
Intelligent Calculation and
mathematical
member set
range
relationship
report generation
returning specific values
statistical
functions, custom-defined
fundamentals
future values, calculating
@GEN function
G
GEN field type. See generation field type
GEN numbers. See generation reference numbers
General page (Database Information)
General page (Database Settings)
Generate Currency Outline button
Generate Currency Outline dialog box
generating
account reporting values
member lists, (1), (2), (3)
reports, (1), (2), (3)
basic techniques, (1), (2)
free-form
with API function calls
Generation and Level Names dialog box
generation field type
arranging in rules files
in header records
in rules files
null values and
generation names
adding to report scripts, (1), (2)
creating, (1), (2)
displaying
for Dynamic Time Series members
static
generation reference numbers
associating attributes dynamically
building shared members
defined
Dynamic Time Series members, (1), (2)
entering in rules files
generating
generation references build method
creating shared members
discussion
guidelines for using
null processing
sample rules file, (1), (2)
shared members
valid build types
generation references defined
Generation/Level Names page (Dimension Properties)
generations
checking for
defined, (1), (2)
duplicate
Dynamic Time Series members and, (1), (2), (3)
levels vs
naming, (1), (2), (3)
reversing numerical ordering
sharing members, (1), (2)
at multiple
sorting on
generic passwords
@GENMBRS function
GENREF.RUL
GENREF.TXT
GETALLREPLCELLS command
GETAPPSTATE command
GETATTRIBUTESPECS command
GETATTRINFO command
GETCRDBINFO command
GETDBINFO command, (1), (2), (3)
GETDBSTATS command, (1), (2), (3), (4)
GETMBRCALC command
GETPARTITIONOTLCHANGES command
GETPERFSTATS command
getting started with Essbase
getting started with Hyperion Essbase
GETUPDATEDREPLCELLS command
global
formatting commands, (1), (2)
global access settings
applications
defining
types listed
global calculation commands
Global ESSBASE.CFG Settings list box
global options (dynamic builds)
global placeholders
Global Properties page (Field Properties)
adding prefixes and suffixes
applying case conversions
converting white space to underscores
defining columns as fields
removing white space
replacing text strings
scaling data values
setting ignored values
global replacement
data load
Global Setting page (Dimension Build Settings)
goal seeking calculations
GOTO command
granularity
greater than signs (>)
in application and database names
in names in scripts and formulas
gridlines (Data Prep Editor)
Group Membership dialog box
groups
assigning filters to
assigning privileges to
assigning users to, (1), (2)
copying security profiles
creating member, (1), (2)
creating or copying using MaxL
creating user, (1), (2)
creating user with Administration Services
creating user with Application Manager
defined, (1), (2)
defining security, (1), (2), (3)
deleting
deleting users
deleting using MaxL
deleting with Administration Services
deleting with Application Manager
displaying in MaxL, (1), (2), (3), (4), (5), (6)
displaying membership using MaxL
editing user information
formulas and dimensions in calc scripts, (1), (2), (3)
getting list of
modifying access settings, (1), (2), (3)
overriding column
renaming
returning valid users, (1), (2)
security settings
security types
selecting members for report
viewing current settings
@GROWTH function
guest accounts
guidelines
analyzing database design
.H files
H
handles
handling missing values
reporting example
handling zero values
hardware platforms
Hash tables
effects from parallel calculation
hash tables, (1), (2)
Header Definition page (Data Load Settings)
header information
adding, (1), (2), (3), (4)
dynamic references
formatting
header records
creating, (1), (2)
defined
defining load rules
identifying missing dimensions with
skipping, (1), (2)
specifying location of
Header Records page (Data File Properties)
headers. See header information; header records
HEADING command
HEADING1.REP
HEADING2.REP
headings
See also column headings; field names; row headings
adding to complex reports, (1), (2)
adding to free-form reports
currency conversion
customizing, (1), (2)
display options, (1), (2)
forcing immediate display
formatting, (1), (2), (3)
multiple layout reports
page
suppressing display
using attributes in
help
API functions
calc scripts
configuration variables
configurations
files
loading sample applications
Report Writer commands and definitions
Server Agent
Help button (Application Desktop)
HELP command (Agent)
hierarchies
Calc Script Editor
aliases
dimensions
members
calculation order and
data
relationships defined, (1), (2)
dynamic builds
Formula Editor
aliases
dimensions
members
outlines
expanding/contracting
unbalanced in outlines
hierarchy
members
history-to-date calculations
hit ratios, caches
.HLP files
hosts
HP-UX servers. See UNIX platforms
H-T-D time series member, (1), (2)
HTML files
Hyperion Essbase
fundamentals
getting started tips
Hyperion Essbase kernel
active transactions and failures
allocating storage
caches used
changing settings
scope and precedence
with Application Manager
components
compressing data
cross-platform compatibility
customizing, (1), (2)
error handling
linked reporting objects and
locking procedure
overview, (1), (2)
setting isolation levels, (1), (2)
specifying data compression
starting
Hyperion Essbase Query Designer
hyphens (-)
in dimension and member names
in member names
in names in scripts and formulas
in report scripts
I/O access mode
@IALLANCESTORS function
@IANCESTORS function
I
IANCESTORS command
usage
IBM DB2 relational storage manager
@ICHILDREN function
ICHILDREN command
usage
usage example
identical values
identifying data sources
@IDESCENDANTS function, (1), (2)
IDESCENDANTS command
usage
usage example
IF/ELSEIF... statements
calc scripts
nested statements
formulas
nested statements
purpose of
IF/ENDIF statements
calc scripts
interdependent formulas in
member formulas in
semicolons with
syntax
formulas
purpose of
semicolons with
syntax
usage examples, (1), (2)
IFERROR command
Ignore Conflicts option
Ignore Tokens page (Data File Properties)
ignoring
#MISSING and zero values, (1), (2)
end-of-file markers
fields when mapping, (1), (2)
lines in rules files, (1), (2)
multiple fields in data load
specific fields in data load
specific records in data load
@ILSIBLINGS function
immediate restructuring, (1), (2)
IMMHEADING command
implementing security measures
for users and groups, (1), (2), (3), (4)
globally
guidelines for
partitioned databases, (1), (2)
planning
system server, (1), (2), (3)
implied shared relationships, (1), (2), (3)
Import Member Mappings dialog box
Import Server Alias Table Object dialog box
importing
alias tables, (1), (2)
data, (1), (2)
files, (1), (2), (3)
LROs
member mappings
improper shutdown
improving performance, (1), (2), (3)
See also optimizing
RESETDB
inaccessible applications
inactive users
INCBUILDDIM command
INCEMPTYROWS command
overriding
usage
INCFORMATS command
INCMASK command
INCMISSINGROWS command, overriding
inconsistent values
incorrect data values
increase number of threads
increasing performance
incremental data load
Incremental restructuring
using
incremental restructuring
disabled
files
INCRESTRUC parameter
INCZEROROWS command
overriding
.IND files, (1), (2), (3)
INDENT command
indentation
turning off
usage
INDENTGEN command
usage
usage example
index
advantage of small
checking structural integrity
defined
determining optimal size, (1), (2), (3)
disadvantage of large
dynamic calculations and
managing, (1), (2)
optimizing, (1), (2)
rebuilding. See restructuring
removing references to linked files
restructuring
retrieving linked reporting objects
spanning multiple pages
updating
usage described
index cache
as storage unit
described
fine-tuning
managing
optimizing read/writes
setting size, (1), (2)
index cache size
setting with Administration Services, (1), (2)
setting with Application Manager
index entries
as pointer to data block
for data blocks
managing
index files
allocating storage for
associated with current application
caution for recovery and
cross-platform compatibility
defined
size
setting maximum
view in Administration Services
viewing in Application Manager
Index Manager
overview
index page
linked reporting objects and
managing
index searches
viewing information about
information dialog boxes
information flow
informational messages, (1), (2), (3)
application logs and
OLAP Server logs and
inheritance
currency categories
filters, (1), (2), (3)
privileges, (1), (2)
properties
initialization process (Hyperion Essbase kernel)
initializing rules files
.INM files, (1), (2)
.INN files, (1), (2)
input blocks
input data, (1), (2)
reloading exported data
restructuring and
input/output (I/O)
Insert Arguments option, (1), (2)
inserting text in Calc Script Editor
inserting. See adding
installation information
installer
security level of
installing multiple agents on a single server
installing Personal Essbase
insufficient privileges
@INT function
integers. See numbers; values
integrity. See data integrity
Intelligent Calculation
block size and efficiency
controlling with calc scripts
currency conversions and, (1), (2), (3)
default calculations and
enabling/disabling, (1), (2)
large indexes and
limitations, (1), (2)
overview, (1), (2)
partial calculations and
recalculating data and
restructuring and
setting as default
time balance properties and
turning on/turning off
two-pass calculations and, (1), (2), (3)
Intelligent Calculation option
interactive mode (ESSCMD)
canceling operations
command-line syntax for
defined
entering commands
file-name extensions and
overview
running ESSCMD from
interdependent values, (1), (2)
interdimensional irrelevance
@INTEREST function
interest, calculating
interfaces
accessing linked objects and client
international applications. See locales
international formats, (1), (2)
Interntl database
changing Scenario dimension in
contents described
linking
opening outline
provided with Hyperion Essbase
saving outline changes
INTERNTL sample database
interpolation, with spline
invalid fields in data sources
inventory
calculating first/last values, (1), (2)
calculating period-to-date values
currency categories and
getting averages
tracking, (1), (2)
investments
IPARENT command
usage
@IRDESCENDANTS function
@IRR function
irrelevant data
@IRSIBLINGS function
@ISACCTYPE function
@ISANCEST function
@ISCHILD function
@ISDESC function
@ISDESCENDANTS function
@ISGEN function
@ISIANCEST function
@ISIBLINGS function
@ISICHILD function
@ISIDESC function
@ISIPARENT function
@ISISIBLING function
@ISLEV function
@ISMBR function, (1), (2)
isolation level
parallel calculation
isolation levels
calculations and, (1), (2)
canceling calculations and
caution for data loads, (1), (2)
committed and uncommitted access
locks and, (1), (2), (3), (4)
rollbacks and, (1), (2)
setting
with Application Manager
with ESSCMD, (1), (2)
with Hyperion Essbase kernel
updating
@ISPARENT function
@ISSAMEGEN function
@ISSAMELEV function
@ISSIBLING function
@ISUDA function
J
Java
Archives, creating
creating a Java class for CDF
using for custom-defined functions
Join Fields dialog box
joining fields, (1), (2)
JVM memoryh considerations
K
kernel settings, options
L
L, last time balance code in data source
label members
See also label only property
dynamically calculating
label only property
defining
description
specifying in data source
usage example
labels
defining
replacing missing values with, (1), (2)
language support (programming)
languages
country-specific dimensions, (1), (2)
requirements for partitioning
large databases, (1), (2), (3)
large-scale reports, (1), (2)
last time balance property
example
specifying in data source
LATEST command
latest time period
layout commands, (1), (2)
layouts. See page layouts
.LCK files
leading spaces
leaf members
defined
restructuring
leaf nodes
less than signs (<)
in application and database names
in dimension and member names
in names in scripts and formulas, (1), (2)
in report scripts
@LEV function
Level
parallel calculation
setting for parallel calculation
level 0 blocks, (1), (2)
exporting
restructuring
level 0 members
See also leaf members
calculations on, (1), (2), (3)
in two-dimensional reports
required in source data
storing
level field type
arranging in rules files
in header records
in rules files
null values in
sharing members
level names
adding to report scripts, (1), (2)
creating, (1), (2)
displaying
static
level numbers
determining for shared members, (1), (2)
generating
level reference numbers
associating attributes dynamically
entering in rules files
level references
described
sample rules file for
level references build method
creating multiple roll-ups
creating shared members, (1), (2), (3)
example rules file, (1), (2)
guidelines for
null processing
sample rules file for
shared members, (1), (2), (3)
valid field types
LEVEL.RUL
LEVEL.TXT
LEVELMUL.RUL
levels
checking for
defined
naming, (1), (2), (3)
period-to-date reporting
sorting on
@LEVMBRS function
.LIB files
libraries
.LIC files
License Info page (Server Information)
licensing, (1), (2)
getting information for, (1), (2)
partitioning product suite
licensing ports
line formatting
linear regression, with @TREND function
lines, skipping in rules files, (1), (2)
LINK command
usage
usage example
Link Properties dialog box
LINK.REP
linked databases. See linked partitions
linked files
displaying contents
editing
LRO object type
restrictions
specifying size, (1), (2)
storing
linked object catalogs, (1), (2)
Linked Objects Browser
changing linked partitions
editing objects, (1), (2)
linked objects. See linked reporting objects (LRO)
linked partitions
attaching to cells
changing
creating, (1), (2), (3), (4), (5)
defined
described
disadvantages
guidelines for selecting, (1), (2)
implementing security measures
mapping members, (1), (2)
port usage
testing
linked reporting objects (LRO)
assigning access levels
changing member combinations
checking structural integrity
creating
estimating disk space for
format restrictions
limiting size using Administration Services
limiting size using Application Manager
overview
removing from cells
restructuring and
retrieving
storage management
types supported
viewing, (1), (2)
Linked Reporting Objects dialog box
links
currency conversions
linked reporting objects
missing
partitioned databases
related databases, (1), (2)
supported types
@LIST function
list of members, generating
LISTALIASES command
LISTGROUPS command, (1), (2)
LISTGROUPUSERS command
LISTLINKEDOBJECTS command, (1), (2)
LISTLOCATIONS command
lists
expanding/contracting in Calc Script Editor, (1), (2), (3)
expanding/contracting in Formula Editor, (1), (2), (3)
generating member, (1), (2), (3)
multiple, with @LIST
referencing, (1), (2)
LISTUSERS command, (1), (2), (3), (4), (5), (6), (7)
LISUSERS command, (1), (2)
LMARGIN command
@LN function
LOADALIAS command
LOADAPP command
LOADDATA command
loading data without rules file
loading free form data
locating files
LOADDB command, (1), (2)
loading
alias tables
applications
automatically
with related database
calc scripts, (1), (2), (3)
data, (1), (2), (3)
dynamic calculations and
for testing purposes
from external sources, (1), (2), (3), (4)
from partitioned applications, (1), (2), (3)
from rules files
getting information about
incrementally
optimizing, (1), (2), (3), (4)
overview, (1), (2), (3), (4)
prerequisites, (1), (2)
restrictions, (1), (2), (3), (4)
supported formats
tips, (1), (2)
troubleshooting problems with
unauthorized users and
data sources, (1), (2), (3), (4)
in Data Prep Editor, (1), (2)
prerequisites
troubleshooting problems, (1), (2)
databases
automatically
automatically using Administration Services
error logs
failed records only
output files
report scripts, (1), (2)
rules files, (1), (2)
prerequisites
sample applications (problems with)
specific fields only
specific records
spreadsheets, (1), (2), (3)
multiple
SQL data sources, (1), (2)
troubleshooting problems with
subsets of data, (1), (2)
text files, (1), (2)
multiple
update log files
local access
local currency
locales
See also currency conversions
dimensions defining, (1), (2)
partitioned applications and
locating
end-of-file markers
members in Calc Script Editor
members in Formula Editor
specific values, (1), (2)
text in formulas
location aliases
advantages
creating using MaxL
displaying using MaxL
editing or deleting
Location Aliases dialog box
locationi aliases
deleting using MaxL
lock files
Lock Manager
overview
Lock Partition Definition Files option
Locking Blocks during calculation
locking caches into memory
locking errors, (1), (2)
locks
applying, (1), (2), (3), (4)
committed access and, (1), (2)
contention
displaying
generating reports and
loading data
managing
maximum time to hold
partition definition files
removing, (1), (2), (3), (4)
automatically
setting for new users, (1), (2), (3)
time-out settings
types described
uncommitted access and
wait intervals
.LOG files, (1), (2), (3)
@LOG function
log delimiter choices
log files
spreadsheet changes
log files. See logs.
Log Viewer
checking calculations
displaying
dynamically calculated members
retrieval factor
@LOG10 function
logarithms
calculating, (1), (2)
calculating exponents
logical conditions, (1), (2)
See also Boolean expressions
login
parallel processing
LOGIN command, (1), (2)
login scripts (ESSCMD)
logins
entering user name and password
limiting attempts
partitioned applications
process overview
setting up
LOGMESSAGELEVEL setting
logouts
forced using MaxL statement
from Application Manager, (1), (2)
from Server Agent
LOGOUTUSER command (Agent)
logs
calc scripts
calc scripts and
captures failing
clearing contents
creating multiple exception logs
data load errors
deleting
deleting contents
deleting in Application Manager
dimension builds
dynamically calculated members
OLAP Server
outline changes, (1), (2)
overview
restructuring and
updating
Server Agent activity
server-specific
system errors, (1), (2), (3)
updating
viewing
viewing contents, (1), (2), (3)
viewing retrieval factor
long file names
LOOP/ENDLOOP command, (1), (2)
loops
losing connections
loss, tracking
Lotus 1-2-3 spreadsheets. See Spreadsheet Add-in
LRO catalog
.LRO files, (1), (2), (3)
LRO Manager
overview
LRO. See linked reporting objects (LRO)
LROs
exporting using MaxL
importing using MaxL
@LSIBLINGS function
.LST files
M
M, time balance codes in data source
macros, custom-defined
Main Database (defined)
main window
Application Manager
Application Services
maintaining applications
maintaining data integrity
maintenance tasks
backing up data
managing applications and databases
porting applications across platforms
running Essbase
mapping
area-specific partitions, (1), (2), (3)
in Partition Wizard
attributes
cells
columns with no members
data source/data target members
linked partitions, (1), (2)
replicated partitions, (1), (2), (3)
transparent partitions, (1), (2)
databases with location aliases
fields to dimensions
files (.TXT)
member fields to outlines
members
members to member fields, (1), (2), (3)
members with different names
partitioned members
partitions
defining manually, (1), (2)
replicated partitions
specific fields only, (1), (2)
transparent partitions
Mappings page (Partition Wizard)
defining linked mappings
defining replicated mappings
defining transparent mappings
margin (profit)
margins
market share (calculation example)
marketing sample reports
marking blocks as clean and dirty, (1), (2)
markup
MASK command
entering in report scripts, (1), (2)
overriding
usage
masks, (1), (2)
@MATCH function
Match Whole Word option
Formula Editor
matching case, (1), (2), (3), (4), (5)
matching members, (1), (2)
mathematical calculations
mathematical functions, (1), (2)
mathematical operations
currency conversions
formulas and
missing values and
performing on fields
performing on members
prerequisite for
report scripts, (1), (2)
specifying in data source
mathematical operators, (1), (2)
inserting in calc scripts
inserting in formulas
matrix-style access
@MAX function
Max member, Attribute Calculations dimension
maximum number of threads spawned by Agent
MaxL
creating custom-defined macro
deleting logs, (1), (2)
drop function records
error detection
exporting LROs
importing LROs
register custom-defined function
registering custom-defined functions
running
calculations
running calc scripts
shutting down server
specifying isolation level settings
starting a database
starting a database automatically
starting/stopping applications
starting/stopping databases
updating replicated partitions
Maxl
MAXLOGIN
limit number of simultaneous user sessions
limit number of user sessions
@MAXRANGE function
@MAXS function
@MAXSRANGE function
@MDALLOCATE function
@MDANCESTVAL function
.MDB files
@MDPARENTVAL function
@MDSHIFT function
.MDX files
Measures dimension (example)
calculating period-to-date values
changing for currency conversions
media failure
@MEDIAN function
median, calculating
@MEMBER function
member codes
property tags
specifying
member consolidation properties
described
setting, (1), (2)
member descriptions (in Hyperion MBA). See alias tables
member fields
defined in data source
duplicate members and
entering data
formatting
formatting rules
in data source
invalid
mapping requirements, (1), (2), (3)
member lists
calculating subset of
generating, (1), (2), (3)
referencing, (1), (2)
member names
case sensitivity
maximum length
Member Properties dialog box
creating aliases, (1), (2)
creating UDAs
defining data storage properties
renaming members
setting consolidation properties
setting two-pass calculations
setting variance reporting tags
tagging for Dynamic Calculations
tagging members as label only
member properties display option
member selection
commands
sorting members and
in spreadsheets
Member Selection dialog box
defining linked areas, (1), (2)
defining replicated areas, (1), (2)
defining transparent areas, (1), (2)
mapping partitioned members, (1), (2), (3)
member set functions, (1), (2)
applying to subsets of members
described
generating lists
in filter definitions
inserting in formulas
withing FIX command
Member Specification dialog box
creating dynamically calculated members, (1), (2)
members
See also shared members
adding, (1), (2)
as children of specified parent
as siblings, (1), (2)
example for, (1), (2)
for currency conversions, (1), (2)
guidelines for
restrictions for
through header information in the data source
to dimensions, (1), (2), (3), (4), (5)
to member fields, (1), (2)
to outlines, (1), (2)
adding comments about
adding to report scripts, (1), (2)
in precise combinations
with common attributes
applying skip properties
assigning
alias combinations
aliases to, (1), (2)
properties to, (1), (2)
values to combinations
assigning aliases to
associating base dimension members with attributes
in Outline Editor
associating formulas with
associating with report scripts
Attribute Calculations dimension
attribute dimensions
naming
prefixes and suffixes
preventing creation
resulting from formulas
avoiding naming conflicts
calculating across multiple parents
calculating relationships between
caution for sorting with shared
changing
changing combinations for linked objects
changing properties
clearing
containing no data
creating dynamic for time series, (1), (2)
data distribution among
default operator
defined, (1), (2)
defining calculation order for, (1), (2)
defining consolidations for, (1), (2)
deleting from attribute dimensions
dependent on others
displaying
combinations, (1), (2)
in outlines, (1), (2)
in reports
duplicate
dynamically building, (1), (2), (3), (4), (5)
dynamically calculating, (1), (2)
restrictions
excluding from consolidation, (1), (2)
getting values for specific combinations
grouping, (1), (2)
in data hierarchies
inserting in calc scripts, (1), (2)
inserting in formulas
irrelevant across dimensions
leaving unsorted
mapping names to dimensions
matching specified, (1), (2)
missing in data sources, (1), (2)
moving in outlines
moving to new parents
names as range of values, (1), (2), (3)
naming, (1), (2), (3)
maximum character length
nesting in reports
numbering in data sources
of attribute dimensions
sorting
ordering in dense dimensions
partitioning
relationships described, (1), (2)
removing from data sources
renaming
replicating, (1), (2)
report example for missing
searching in the Calc Script Editor
searching in the Formula Editor
selecting for dynamic calculations, guidelines for, (1), (2)
selecting multiple
sharing identical values
sorting, (1), (2)
sorting in reports
specifying as case-sensitive
storing
testing for
unique combinations for
unspecified
with no data values
with non-changing names
member-specific formatting commands
memory, (1), (2)
checking available
clearing, (1), (2), (3)
dynamically calculated values and, (1), (2)
estimating requirements
index cache size and
index size and, (1), (2)
locking caches into memory
setting cache size, (1), (2)
first-time calculations
setting cache sizes
shortage
storing data
swapping
memory buffers, (1), (2)
Memory Cache Locking
with Administration Services
menus
typographic conventions
@MERGE function
merging member lists
messages
displaying for calculations, (1), (2), (3)
example for displaying
metadata
metadata (in Hyperion MBA). See outlines
MIDDLE.REP
migrating
applications across servers
databases across servers
migration
@MIN function
Min member, Attribute Calculations dimension
minimizing resources
Minimum Database Access options (Application Settings)
Minimum Database Access options (Database Settings)
@MINRANGE function
@MINS function
@MINSRANGE function
minus signs (-)
as codes in data source
in data fields
in dimension and member names
in member names
in names in scripts and formulas
in report scripts
miscellaneous text
mismatches
MISS_LBL.REP
MISSING displayed in cells
missing links
missing members, (1), (2)
missing values
adding place holder for
aggregating
effects on calculation order, (1), (2), (3), (4)
averages and
calculating, (1), (2), (3)
caution for data loads and
caution for dimension fields
definition
formatting in reports
handling, (1), (2), (3)
identifying in data fields
in calculations
inserting into empty fields
optimal entry for
overriding default for
replacing with labels
reporting samples, (1), (2)
skipping, (1), (2)
sorting data with
testing for
viewing with Personal Essbase
MISSINGTEXT command
usage
usage example
mission-critical databases
@MOD function
@MODE function
mode, calculating
Modifications page (Database Information)
Modify Outline option
caution for disabling
modifying
See also editing
access privileges, (1), (2), (3)
alias table names
aliases
calc scripts, (1), (2)
consolidations
data, (1), (2), (3)
prerequisite for
data values
default storage properties
dimension names
dimension properties, (1), (2), (3), (4)
dimensions
default configurations
for currency conversions
formulas, (1), (2)
headings in reports
Hyperion Essbase kernel settings
scope and precedence
with Application Manager
linked partitions
member combinations for linked objects
member names
members
outlines, (1), (2), (3)
caution for, (1), (2), (3)
dynamically
for currency conversions
with rules files
passwords, (1), (2)
report layouts
security settings
security settings with Administration Services
security settings with Application Manager
system password
modulus, calculating
monitoring
applications, (1), (2)
calculations, (1), (2)
Monitoring applications
Monitoring parallel calculation
month-to-date calculations. See M-T-D calculations.
@MOVAVG function
Move Field dialog box
moving
fields
members and dimensions
members to new parents
moving average, calculating
moving between databases, (1), (2)
moving maximum, calculating
moving median, calculating
moving minimum, calculating
@MOVMAX function
@MOVMED function
@MOVMIN function
MS Access databases. See SQL databases
M-T-D time series member, (1), (2)
multidimensional arrays
multidimensional models
conceptual overview
data distribution in
operations not supported
storage requirements
multidimensional structure
organizing
multi-line column headings
multiple
layout report
partitions
transactions
multiple agents
installing on a single server
multiple export files for databases
multiple-pass calculations, (1), (2), (3)
examples, (1), (2)
usage overview
multiplication
setting data consolidation properties
multiplication operators
multithreading, (1), (2)
setting number of threads
multi-user environments
performance considerations
running ESSCMD in
N
N, never allow data sharing code in data source
@NAME function
Named Pipes connections
names
See also column headings; field names; aliases
NAMESCOL command
NAMESON command
NAMEWIDTH command
naming
arrays and variables
batch files
calc script files, (1), (2)
dimensions, (1), (2), (3)
ESSCMD script files
fields
filters
generations, (1), (2), (3)
levels, (1), (2), (3)
members, (1), (2), (3), (4)
members of attribute dimensions
rules files
shared members
naming conflicts, (1), (2)
naming conventions
aliases, (1), (2)
applications, (1), (2)
case sensitivity, (1), (2)
databases, (1), (2)
dimensions
fields
generations and levels
members, (1), (2)
passwords
report files
rules files
UNIX files
natural logarithms
calculating
calculating exponents
navigating between databases, (1), (2)
negative numbers, formatting in reports, (1), (2)
negative values
flipping
in data fields
variance as
nesting
column headings
columns in reports
dimensions
formatting commands
formulas, (1), (2)
IF statements, (1), (2)
members in reports
quotation marks in ESSCMD commands
net present values
network administrators. See administrators
networks
optimizing resources, (1), (2)
reducing traffic during data load
securing
transferring data via, (1), (2)
never share property
description
setting in data source
Never Share tag
New button (Application Manager)
New Group dialog box
new line
as command separator
as file delimiter
New User dialog box
new users
NEWPAGE command
@NEXT function
@NEXTS function
no access
No Conversion property
currency conversions and
no loads
#NOACCESS value
node
See also branches; trees
NOINDENTGEN command
usage
usage example
non expense property, (1), (2)
non-attribute dimension
See standard dimension
None access level, (1), (2), (3)
None Currency Conversion property
none time balance property
non-typical data sets
NOROWREPEAT command
NOSKIPONDIMENSION command
NOT operator, (1), (2)
Note dialog box, (1), (2), (3)
notes
adding to databases
adding to partitions, (1), (2), (3)
annotating to data cells
display options
storing
viewing in Application Manager
no-wait I/O
.NP files
@NPV function
null values
level references build method
null processing
numbering
columns in reports
members in data sources
report pages
numbers
calc scripts and
calculated columns
formatting, (1), (2)
formulas and
in array and variable names
in names
in source data fields
options for loading, (1), (2)
rounding, (1), (2)
truncating
numeric
attribute dimensions
sorting members in outline
tagging
attributes
defined
defining member names in ranges
duplicate values
size of ranges
fields
with commas
fields in data source
parameters
entering in ESSCMD scripts
numeric parameters
Numeric Range Rules dialog box
numerical ordering (generations)
NUMERICPRECISION setting
O
O, label only code in data source
object handles
object references
objects
See also linked reporting objects
copying
creating filters for
deleting
linking to cells
locking, (1), (2)
overview
renaming
unlocking
.OCL files
clearing
.OCN files
.OCO files
ODBC drivers
ODBC files
OFFCOLCALCS command
OFFROWCALCS command
OFSAMEGEN command
usage
OLAP
fundamentals
getting started tips
history
OLAP Server
defined
deleting logs
viewing logs
OLAP Server logs
contents described
deleting
deleting on restart
delimiters
disk space and
example
message categories
overview
setting messages logged
viewing
.OLB files, (1), (2)
.OLG files, (1), (2)
OLTP vs OLAP
ONCOLCALCS command
Online Analytical Processing. See OLAP
Online Transaction Processing. See OLTP
ONLY parameter for SET MSG
ONROWCALCS command
ONSAMELEVELAS command
usage
Open button (Application Manager)
Open Client Data Files dialog box
opening data sources
opening spreadsheets, (1), (2)
opening text files
updating dimensions
Open Client Object dialog box
selecting calc script files
Open Server Data File Object dialog box
opening data sources
opening spreadsheets, (1), (2)
opening text files
updating dimensions
Open Server Object dialog box
opening report scripts
selecting calc script files
open tasks
opening
applications
Calc Script Editor
calc script files, (1), (2)
Data Prep Editor, (1), (2)
data sources
databases
Formula Editor, (1), (2)
outlines
caution for
Partition Manager
Report Editor
report script files, (1), (2)
rules files, (1), (2)
sample applications (problems with)
spreadsheets, (1), (2)
SQL data sources, (1), (2)
text files
operating system
information, (1), (2)
multithreaded
recovery
operations
See also transactions
automating routine
canceling
archiving
calculations
canceling ESSCMD, (1), (2)
causing corruption, (1), (2)
displaying field
displaying replace
failed
maintaining data integrity for
missing values and mathematical
restructure types defined
undoing, (1), (2)
viewing information about, (1), (2)
operators
See also specific operator
calc scripts and, (1), (2)
consolidation listed
creating Boolean expressions with
cross-dimensional, (1), (2), (3)
inserting in calc scripts
inserting in formulas, (1), (2)
overview, (1), (2)
usage examples, (1), (2)
default for members
display options
formulas and, (1), (2), (3), (4)
inserting in formulas
mathematical, (1), (2)
calc scripts
formulas
order of precedence
resetting in report scripts
unary, (1), (2)
usage overview, (1), (2)
optimization
basic tasks
RESETDB
optimizing
access, (1), (2)
caches
calculator cache, (1), (2)
calculations, (1), (2), (3)
with bottom-up calcs
with calc scripts
with dynamic calculations, (1), (2)
with Intelligent Calculation
with interdependent values
with two-pass calculations
data analysis
data loading, (1), (2), (3), (4), (5)
data manipulation
data sources, (1), (2)
disk read/writes, (1), (2)
indexes, (1), (2)
loading of sparse dimensions
network resources, (1), (2)
outlines, (1), (2)
performance, (1), (2), (3), (4), (5)
queries, (1), (2)
readability
replication
reports, (1), (2), (3)
restructures, (1), (2)
retrieval, (1), (2)
sparse dimensions
storage
transparent partitions
Optimizing Hyperion Essbase
optimizing performance
cross-dimensional operator
optional parameters
options
See also display options
application access
application security settings
calculations, (1), (2)
dimension builds
dimension updates
dynamic builds, (1), (2)
Essbase kernel
generating currency outlines
global access, (1), (2)
Hyperion Essbase kernel, (1), (2)
isolation levels
level and generation numbering
password management
restructuring outlines
saving partition definitions
setting up rules files
viewing
currently set installation
linked reporting objects
OR operator
select/reject criteria, (1), (2)
Oracle databases. See SQL databases
ORDER command
usage example, (1), (2)
ORDERBY command
entering in report scripts, (1), (2)
precedence
usage
usage example
ORDERBY.REP
ordering
cells in blocks
data blocks
data values, (1), (2)
example
dimensions in outlines
fields, (1), (2)
members in dense dimensions
members in outlines, (1), (2)
output values
ordinary user permission, (1), (2)
organizational databases
organizing data (tutorial)
.OTL files, (1), (2)
.OTM files
.OTN files, (1), (2)
.OTO files
OUTALT command
OUTALTMBR command
entering in report scripts
usage
OUTALTNAMES command
entering in report scripts
usage
usage example
OUTALTSELECT command
usage
outline
attribute prefixes and suffixes
Outline button (Application Manager)
outline calculation
outline change logs
contents described
example
overview
restructuring and
setting size
updating
viewing
outline design
attribute dimensions
performance considerations, (1), (2)
Outline Editor
adding comments
adding dimensions
applying time balance tags
associating attribute dimensions with base dimensions
associating base dimension members with attributes
Attribute Calculations dimension
changes and restructuring impact
components
enabling/disabling
creating
aliases
aliases for member combinations
dynamically calculated members
shared members
UDAs
creating dynamically calculated members
creating outlines
customizing, (1), (2)
defining
accounts dimension type
attribute dimension type
attributes
country dimension type
data storage properties
dimension type
time dimension type
defining dimension type
Currency Partition
removing dynamically calculated members
renaming dimensions and members
selecting multiple members
setting consolidation properties
setting two-pass calculations
setting variance reporting tags
starting
tagging members as label only
updating dimensions
viewing outline members
outline files
copying, (1), (2), (3)
creating
cross-platform compatibility
saving
outline synchronization
described
shared members
Outline Synchronization Editor
Outline Update dialog box
OUTLINECHANGELOG parameter
OUTLINECHANGELOG setting
OUTLINECHANGELOGFILESIZE setting
outline-only restructure
outlines
accessing
adding alias tables, (1), (2)
adding dimensions, (1), (2), (3), (4)
performance considerations, (1), (2)
restructuring and
adding members, (1), (2)
applying changes, (1), (2)
associating
calc scripts with
member fields with
rules files with, (1), (2), (3), (4)
associating filters with
bottom-up ordering
changes impacting restructuring
changing, (1), (2), (3)
caution for, (1), (2), (3)
dynamically
with rules files
controlling location of
copying
with Application Manager
copying in file system
copying with Administration Services
copying with Application Manager
creating, (1), (2)
example for
for currency conversions, (1), (2), (3)
from data sources
guidelines for
prerequisites for
with Outline Editor, (1), (2)
creating formulas for
customizing view
defined, (1), (2), (3)
drafting for single-server databases
expanding/contracting
format
hierarchical arrangement
improving readability
member relationships described, (1), (2)
modifying for currency conversions
naming
dimensions and members
generations and levels
opening existing
caution for
optimizing, (1), (2)
optimum order of dimensions
ordering dimensions
ordering members, (1), (2)
purpose
rearranging members and dimensions
removing
removing items, (1), (2)
renaming
repeating elements
restructuring
prerequisites for
rules
saving, (1), (2)
caution for
description
instructions
sharing members, (1), (2), (3)
caution for placing
sparse-dense recommendations
synchronizing, (1), (2)
process summarized, (1), (2)
warning for not applying changes
with Application Manager
with Partition Wizard
with report scripts
top-down ordering
tracking changes
updating, (1), (2)
verifying, (1), (2)
viewing
changes to
dimensions in
dynamically calculated members
update information
with unbalanced hierarchies
OUTMBRALT command
OUTMBRNAMES command
output
displaying in columns
formatting
options
ordering
reporting example
security information
selecting specific values for
sorting
OUTPUT command
output files
See also log files
loading
saving
overhead, (1), (2), (3)
checking compression ratio
overlapping partitions
overriding
column groupings in reports
data filters, (1), (2)
default calculation order
default calculations
file locks
incremental restructuring
security and permissions
overwriting error logs
overwriting existing values
for currency conversions
with values in data source, (1), (2)
ownership
.PAG files, (1), (2), (3)
P
page breaks
in report scripts
suppressing, (1), (2)
PAGE command
entering in report scripts
in page layout
usage example
page files
See also data files
page headings
adding to complex reports
adding to free-form reports
customizing, (1), (2)
defined
display options
forcing immediate display
suppressing
using attributes in
page layout commands, (1), (2)
page layouts
See also reports
adding titles
centering data, (1), (2)
example
changing
customizing, (1), (2)
examples, (1), (2)
formatting, (1), (2), (3), (4)
problems with
formatting samples, (1), (2), (3), (4)
inserting page breaks, (1), (2)
numbering pages
switching row/column display
PAGEHEADING command
PAGELENGTH command
overriding
usage
PAGEONDIMENSION command
usage
usage example
.PAN files, (1), (2)
Paraellel calculation
effect on hash tables
paralle calculation
enabling in calculation script
Parallel calculation
analysis of feasibility
and UNCOMMITTED requirement
checking status
commit threshold adjustments
effect on bitmpa cache
enabling
feasibility analysis
increased speed
introduction
levels
monitoring performance
partition limitations
procedure for enabling
requirements for use
serial vs. parallel
setting levels
parallel calculation
and calculator cache
and other Essbase fetaures
calculator hash tables
checking current settings
commit threshold adjustments
definition
enabling
formula limitations
identifying additional tasks
identifying tasks.
isolation level
monitoring
overview
requirements
restructuring limitations
retrieval performance
transparent partition limitations
uncommitted mode
parallel processing
data load
login
parameters
enclosure in quotation marks (ESSCMD)
entering in ESSCMD scripts
referencing files
PARCHIL.RUL
PARCHIL.TXT
@PARENT function
parent
defined
PARENT command
usage
parent field type
in header records
in rules files
sharing members, (1), (2), (3)
parent/child references build method
creating multiple roll-ups
creating shared members, (1), (2), (3)
creating shared roll-ups from multiple data sources
described
example rules file
guidelines for using
sharing members, (1), (2), (3)
valid field types
parent/child relationships
data sources
defining
dynamic calculations and, (1), (2), (3)
parent-child relationships
parentheses
in calc scripts
in dimension and member names
in formulas
in report scripts, (1), (2)
indicating negative numeric values in fields
parents
as shared members
assigning children to, (1), (2), (3)
associating members with
calculation order for outlines
calculations with multiple
checking for
getting, (1), (2)
in time dimensions
loading data into
rolling up, (1), (2)
setting values as average
sharing members
specifying for existing members
with only one child
@PARENTVAL function, (1), (2)
PAREXPORT command, (1), (2)
partial loads
invalid members
value out of range
Partition
limitiations with parallel calculation
partition areas
changing shared
defined
defining, (1), (2), (3)
Dynamic Time Series members in
mapping to specific, (1), (2), (3)
in Partition Wizard
partition definition files
creating
locking
Partition Information dialog box
Partition Manager
changing links
creating partitions, (1), (2), (3), (4)
defining partitioned areas
replicated partitions, (1), (2)
transparent partitions, (1), (2)
editing partitions
opening
partition size, disk volumes
Partition Wizard
closing
defining area-specific mappings
defining partitioned areas, (1), (2), (3)
described
editing partitions
mapping linked members, (1), (2)
mapping partitioned members
mapping replicated members, (1), (2), (3)
mapping transparent members, (1), (2)
saving partition definition
validating partitions
partitioned applications
accessing data
adding members
calculating
transparent
connecting to, (1), (2), (3)
creating, process summarized
described
designing, (1), (2), (3)
scenarios for, (1), (2), (3)
disadvantages of
examples of
language requirements
loading data, (1), (2), (3)
performing calculations on
replicated partitions and
transparent partitions and, (1), (2), (3), (4)
retrieving data
running calc scripts
single-server vs.
troubleshooting access to
types of
updating, (1), (2), (3), (4)
guidelines
remote data and
viewing current state
partitioned databases
accessing, (1), (2), (3)
adding partitions for currency conversions, (1), (2)
calculating
transparent
creating accounts for, (1), (2), (3)
described
dynamically calculating values
filtering, (1), (2)
implementing security measures, (1), (2)
linking data values
maintaining
restructuring, (1), (2)
sample applications showing
sharing data, (1), (2), (3)
storing data, (1), (2)
sparse member combinations and
with replicated partitions
with transparent partitions
synchronizing data across partitions
synchronizing outlines, (1), (2)
with Partition Wizard
testing, (1), (2)
time series reporting
troubleshooting connections
workflow
partitioning
mapping attributes
using attributes in, (1), (2)
partitioning product suite
licensing
Partitions
partitions
See also partitioned applications; partitioned databases, areas
advantages
annotating, (1), (2), (3)
calculating
transparent
controlling updates to
creating, (1), (2), (3), (4), (5)
for currency conversions, (1), (2)
process summarized
defined
defining, (1), (2), (3)
linked, (1), (2)
multiple
replicated, (1), (2)
transparent, (1), (2)
with Partition Wizard, (1), (2), (3), (4)
deleting
discarding changes to
dynamic calculations and, (1), (2)
editing
getting type
mapping guidelines, (1), (2)
mapping members
overlapping
parts described
performance
improving
port usage, (1), (2), (3)
primary/secondary sites defined
restructuring performance and
saving definitions
selecting type, (1), (2), (3), (4), (5)
in Partition Wizard, (1), (2), (3), (4)
top-down vs. bottom-up
troubleshooting
usage examples
replicated partitions
transparent partitions
using attributes in
validating
viewing currently defined, (1), (2)
PASSWORD command
Password Management options (Server Settings)
passwords
assigning generic
changing system
changing with Administration Services
changing with Application Manager
connections
entering in logins
forcing users to change, (1), (2), (3)
in partitions
masking, (1), (2)
setting
new users, (1), (2)
partitioned databases
pasting
calc scripts into Calc Script Editor
formulas into Formula Editor
text into calc scripts
text into formulas
path information
pattern matching, (1), (2)
payroll
percent signs (%)
as codes in data source
in names in scripts and formulas
in report scripts
percentages
allocating
calculating, (1), (2)
displaying in reports, (1), (2)
returning variance, (1), (2), (3)
setting consolidation properties
specifying in data source
Performance
example of complex formula effects
increase with periodic tasks
monitoring parallel calculation
replacing cross-dimensional operator on left side of equation
performance
calculation
checking, (1), (2)
getting information about, (1), (2)
improvement techniques
linked partitions and, (1), (2)
multi-user considerations, (1), (2)
optimizing, (1), (2), (3), (4), (5), (6), (7)
recommended settings
replicated partitions and
transparent partitions and
performance statistics
caches
performance-related storage settings, (1), (2)
scope
periodic year to date (in Hyperion MBA). See dynamic time series members
periods (.)
in application and database names
period-to-date calculations
period-to-date values
calculating, (1), (2)
retrieving
permission
assigning/reassigning user
setting database
Supervisor
permissions
Application Designer
Application or Database designer
application-level settings
Calculate (or execute)
Create/Delete Applications
Create/Delete Users/Groups
database
Database Designer
designer
linked reporting objects
ordinary user (no access)
Read
routine operations and
scope of
Supervisor
user types
Write
Personal Essbase
copying data to
prerequisites
copying outlines to, (1), (2)
creating applications and databases
installing
loading data
loading output files
viewing data
PIDs, finding for Hyperion Essbase applications
pivoting
.PL files
platforms
porting applications across, (1), (2)
creating backups for
redefining information for
porting applications to UNIX servers
plus signs (+)
as codes in data source
in application and database names
in dimension and member names
in member names
in names in scripts and formulas, (1), (2)
.PM files
pointers
data blocks
member combinations
shared data values, (1), (2)
populating replicated partitions
porting applications, (1), (2)
creating backups for
redefining server information
to UNIX platforms
ports
and linked partitions
and replicated partitions
and transparent partitions
changing default values used by Agent
displaying available
displaying installed
displaying list of available, (1), (2)
freeing
licensed and multithreading
protocol-specific assignments
reserved
running out of
PORTS command
usage overview
PORTS command (Agent)
positive values
variance as
pound sign (#) in array and variable names
@POWER function
power down (caution)
power failures. See failures; recovery
power loss
precedence
calculations
Precendence
parallel calculation setting
precision
predefined Dynamic Time Series members
enabling/disabling, (1), (2)
generation names for
in shared areas
listed
specifying aliases for
predefined routines, (1), (2)
prefixes
adding to fields
assignment sequence in data build
attribute member names, (1), (2), (3)
member and alias names
Pre-image Access option
preventing calculation delays
preventing system failures, (1), (2)
primary roll-ups, (1), (2), (3)
Print Calc Script dialog box
printed documentation
suggested audience
typographical conventions
printing
calc scripts
formulas
reports, (1), (2)
PRINTPARTITIONDEFFILE command
PRINTROW command
@PRIOR function, (1), (2)
@PRIORS function
privileges
applying to groups
assigning
global
to users and groups
assignment examples, (1), (2)
changing, (1), (2), (3)
inheritance from group
inheriting, (1), (2)
insufficient
layers defined
linked reporting objects
planning for user access
replicating
setting filters and, (1), (2)
transactions and, (1), (2)
types listed, (1), (2)
procedural commands
Procedure
parallel calculation
process IDs, finding for Hyperion Essbase applications
processes
monitoring
processing requests
processors
calculations across multiple
running multiple concurrently
product and market shares
Product dimension example
product version
profit and loss, (1), (2)
example for tracking
profit margins
dynamically calculating
program files, (1), (2)
programming interface. See API (Application Programming Interface)
programming-specific files
propagating outline changes. See synchronizing
properties
changing dynamically, (1), (2), (3), (4)
consolidation, (1), (2), (3)
currency conversion
data storage, (1), (2)
defining
caution for two-pass tags
for dimensions, (1), (2)
for members, (1), (2)
defining for dimensions, (1), (2)
defining for members, (1), (2)
as label only, (1), (2)
design checklist for
dimension building
field types
dynamic calculations
setting dynamically
shared member, (1), (2)
time balance
Time Series
two-pass calculations
variance reporting, (1), (2)
properties bar (Outline Editor)
properties in outlines
property field type
in header records
in rules files
nulls and, (1), (2)
specifying in data source
protecting data
See also security
@PTD function, (1), (2), (3)
P-T-D time series member, (1), (2)
PURGELINKEDOBJECTS command, (1), (2)
PURGEOTLCHANGEFILE command
purging logs
PUTALLREPLCELLS command
PUTUPDATEDREPLCELLS command
PYRAMIDHEADERS command, (1), (2)
Q
Q-T-D time series member, (1), (2)
quarterly values
quarter-to-date calculations
example
queries
optimizing performance
saving
query
as client function
query governors
query limits
question marks (?)
in application and database names
used as wildcard
quicklogin
QUIT command (Agent), (1), (2)
quitting
See also closing; exiting; stopping
Essbase, (1), (2)
Partition Wizard
quotation marks, double (")
and ESSCMD commands
enclosing member names, (1), (2), (3)
in application and database names
in calc scripts
in dimension and member names
in formulas, (1), (2)
in report scripts
in scripts and formulas, (1), (2)
quotation marks, single (')
in application and database names
in dimension and member names
QUOTEMBRNAMES command
@RANGE function
R
range functions, (1), (2), (3), (4)
formulas and
range of values
calculating
copying
data exceeding
duplicate members in
member names as, (1), (2), (3)
optimizing data loads with
reading multiple
report member selection, (1), (2)
setting automatically
ranges
numeric
caution regarding inserting new values
dimension building summary
numeric attributes, (1), (2)
automatic building
building multilevel (example)
different sizes
@RANK function
ranking values
raw data sources
viewing
@RDESCENDANTS function
Read locks
described
with committed access
with uncommitted access
Read Only privilege
Read permission
Read privilege, (1), (2)
Read/Write privilege
read-only mode
backups and
reads
getting number of
optimizing
read-write mode
backups and
rearranging fields, (1), (2)
reboot (caution)
rebuilding databases
recalculating data, (1), (2), (3), (4)
after exporting
Dynamic Calc And Store members
examples
for Personal Essbase servers
in sparse dimensions, (1), (2)
Intelligent Calculation and, (1), (2)
two-pass calculations and
reconfiguring dimensions
Record View Count dialog box
records
See also rows
adding to data sources, (1), (2), (3)
as headers in rules files, (1), (2)
bottom-up ordering and
defined
defining operations for rules files
defining roll-ups for, (1), (2), (3)
in data source
loading specific range
maximum logged, setting
missing from error logs, (1), (2)
rejecting for loads
reloading failed
selecting, (1), (2), (3)
setting parent/child relationships
sorting to optimize data loading
top-down ordering and
types in data sources
viewing, (1), (2)
with extra fields
recovery
calculations not completing
caution for loading data and
failed operations
improper shutdowns
managing
procedures
redundant data and
restructuring databases
server crashing, (1), (2), (3)
suggested procedures
redefining server information
reducing database size
reducing network traffic
redundant data, (1), (2)
references
caution for
data values, (1), (2), (3)
dynamic, (1), (2)
record numbers in
dynamically calculated members
filters and updating
forward calculation
generation
null processing
sample rules file, (1), (2)
shared members
level
example rules file, (1), (2)
null processing
sample rules file
shared members, (1), (2), (3)
linked files
lists, (1), (2)
objects
parent/child
example rules file
sharing members, (1), (2), (3)
specific values
referencing files with ESSCMD
refresh replicated partition (MaxL)
refreshes
data
dialog boxes
Region dimension example
registration
of custom-defined functions
Reject Record dialog box
rejection criteria
defining multiple for single field
defining on multiple fields
example
locating end-of-file markers with
specifying in rules file, (1), (2)
relational databases. See databases
relational storage manager
relationship among members, (1), (2), (3), (4)
report example for missing
relationship functions
formulas and, (1), (2)
Intelligent Calculation and
@RELATIVE function
reloading database files
reloading exported data, (1), (2)
@REMAINDER function
remainders
remote locations
accessing
manipulating data
retrieving data, (1), (2), (3)
remote partitions. See transparent partitions
remote shutdowns
@REMOVE function
Remove Unspecified option
REMOVECOLCALCS command
entering in report scripts
usage
REMOVELOCKS command
removing
See also clearing
aliases
applications
calc scripts, (1), (2)
contents from alias tables
data blocks
databases
dimensions
restructuring and
filters
formulas
items from outlines, (1), (2)
linked objects
locks, (1), (2), (3), (4)
automatically
logs
logs in Application Manager
members from data sources
members from member lists
objects
partitions
substitution variables
temporary files
text in calc scripts
text in formulas
text in report scripts
user groups with Administration Services
user groups with Application Manager
user locks
users, (1), (2)
white space in fields
Rename Alias Table dialog box
rename application
Administration Services
Rename Application dialog box, (1), (2)
RENAME command
rename database
Administration Services
Rename Database dialog box
Rename Filter dialog box
Rename Group dialog box
Rename Object dialog box
Rename User dialog box
RENAMEDB command
RENAMEFILTER command
RENAMEUSER command
renaming
alias tables
applications
databases
dimensions
error logs
files with FTP
filters
members
objects
users and groups
renumbering data blocks
.REP files, (1), (2)
Replace dialog box
replace operations
replacing
empty fields with values
files from backups
missing values with text, (1), (2)
text in formulas
text strings
replicated partitions
creating, (1), (2), (3), (4), (5), (6)
defined
disadvantages
dynamically calculated values in
example of
guidelines for selecting, (1), (2)
implementing security measures
improving performance
mapping members, (1), (2), (3)
by importing
port usage
updating data, (1), (2), (3)
guidelines
usage restrictions
replicating
partial data sets
problems with
Replication Properties dialog box
REPORT command
Report Editor
creating scripts
described
editing scripts, (1), (2), (3)
opening
running report scripts
specifying output destinations, (1), (2)
text editing commands
Report Extractor
associating members with dimensions
described
errors
extracting data
extraction order
generating free-form reports
ignored characters
internal numerical comparisons
report files
creating
naming
report formatting
commands, (1), (2)
report formatting commands
calculations, (1), (2)
caution for usage, (1), (2)
defined
display options, (1), (2)
listed
nesting
output
report headings, (1), (2), (3)
types described
report generation functions
report output commands
Report Output Options dialog box
described
opening
Report Script button (Application Manager)
report script examples
adding aliases, (1), (2)
calculations, (1), (2), (3)
changing data combinations
creating asymmetric columns
customizing page layouts, (1), (2)
formatting layouts, (1), (2), (3), (4)
grouping rows
handling missing values
narrowing member selection
nesting columns
ordering data
restricting data retrieval
sorting data values, (1), (2), (3)
report script files
adding scripts
default location
location of sample
naming
opening, (1), (2)
report scripts
See also reports
adding comments
adding conditions, (1), (2)
examples, (1), (2), (3)
adding members, (1), (2)
adding variables, (1), (2), (3), (4)
associating members with
batch files and
caution for aliases in
caution for non-changing names in
copying
in file system
creating, (1), (2)
basic techniques, (1), (2)
parts described
creating with Application Manager
currency conversions and
defined
defining page layouts, (1), (2), (3)
editing, (1), (2), (3), (4)
exporting data with
formatting
calculated values, (1), (2)
report layouts, (1), (2), (3)
reports
formatting calculated values
inserting
equations in
formulas in
inserting UDAs
loading, (1), (2)
names with special characters, (1), (2)
naming restrictions
ordering data values, (1), (2), (3)
resetting operators
run in batch mode
running
basic techniques, (1), (2), (3)
examples
in ESSCMD
single line only
with Application Manager
running with Application Manager
saving
selecting members
with common attributes
selecting members for column groups
selecting precise member combinations
sorting members
suppressing shared member selection
synchronizing outlines with
unlocking
using attribute members
wildcards in
Report Viewer
Report Writer
See also report scripts
commands described
creating text files, (1), (2)
main components
online help
optimizing retrieval, (1), (2)
reporting objects (linked)
assigning access levels
changing member combinations
checking structural integrity
creating
estimating disk space for
format restrictions
limiting size
overview
removing from cells
restructuring and
retrieving
storage management
types supported
viewing, (1), (2)
REPORTLINE command
reports
See also time series reporting
ad hoc currency
adding blank spaces
adding calculated columns, (1), (2)
adding headings, (1), (2), (3)
adding page breaks, (1), (2)
adding titles
adjusting column length
associating with databases
basic techniques
building, (1), (2), (3)
basic techniques, (1), (2)
with API function calls
calculating currency conversions
changing
headings in columns
layouts
clearing values in calculated columns, (1), (2)
creating two-dimensional, (1), (2)
customizing page layouts, (1), (2)
examples, (1), (2)
defining multiple layouts
designing, (1), (2), (3)
designing headings
developing free-form
displaying member names
dynamically calculated values and
eliminating data duplication
improving readability
numbering columns
optimizing, (1), (2), (3)
ordering output values
printing, (1), (2)
problems with formatting
repeating column/row headings, (1), (2)
replacing missing values
restricting data retrieval, (1), (2)
example
retrieving data values
setting maximum rows allowed
with conditions, (1), (2)
saving, (1), (2)
setting up output destinations, (1), (2)
suppressing formatting in, (1), (2)
terminating
updating
variance reporting examples
repositories
REPTKBYTESORTBUF setting
requests, (1), (2)
Dynamic Calculations and
partitioned applications
processing
processing as server function
terminate specific requests using MaxL
terminating using Application Manager
Requirements
parallel calculation use
reserved names
reserved words, (1), (2)
RESETDB to improve performance
RESETOTLCHANGETIME command
RESETSTATUS command
resources
checking usage
minimizing
optimizing network, (1), (2)
partitioning databases and, (1), (2)
restarting system
restoring databases from backups
restoring security settings
RESTRICT command
entering in report scripts, (1), (2)
NUMERICPRECISION parameter
usage
usage example
RESTRICT.REP
Restructure Database dialog box, (1), (2)
restructure operations
incremental
optimizing, (1), (2)
outline changes impacting
restructuring
attribute dimensions
data blocks, (1), (2)
data files, (1), (2)
databases, (1), (2)
changing outlines and, (1), (2)
dynamic calculations and
immediately, (1), (2)
Intelligent Calculation and, (1), (2)
process described
indexes
linked reporting objects and
outlines
prerequisites for
partitioned databases, (1), (2)
recovery and, (1), (2)
restructuring conflicts
restructuring limitations with parallel calculation
retrieval buffer
sizing with MaxL
Retrieval Buffer Size option
retrieval buffers, (1), (2), (3)
retrieval factor
displaying
retrieval performance and parallel calculation
Retrieval Sort Buffer Size option
Administration Services
in Application Manager
retrieval time
reducing
Retrieval Wizard
retrieving
cross-database values
data blocks, (1), (2), (3)
data values for reports
placing restrictions on, (1), (2), (3)
setting maximum rows allowed
with conditions, (1), (2), (3), (4)
data values from remote databases, (1), (2), (3)
Dynamic Time Series members
dynamically calculated values, (1), (2), (3), (4)
linked reporting objects
member combinations
partition type
period-to-date values
specific values, (1), (2)
unique values
values for sparse dimensions
reversing data values
RLE data compression
described
specifying
rollbacks
after application shutdown
after database shutdown
after server shutdown
outlines
rolling average values
rolling back transactions. See recovery
roll-ups
See also consolidation
building multiple
examples, (1), (2), (3)
implementing
maximum number in records, (1), (2)
member consolidation and
multiple data sources
optimizing
ordering in rules files
setting for time balance properties
shared members, (1), (2)
root member, defined
@ROUND function
rounding, (1), (2)
routine operations
routines, (1), (2)
row calculation commands
ROW command
entering in report scripts
usage example
row headings
adding to reports
defined
names truncated
repeating
suppressing
ROWAVG.REP
ROWCALC1.REP
ROWCALC2.REP
ROWGROUP.REP
ROWREPEAT command
entering in report scripts
usage
usage examples
rows
See also records
attributes in report scripts
calculating totals
calculation sample reports, (1), (2), (3)
formatting
empty values in
missing values in
with different member names
grouping in reports
in data sources
restrictions on retrieval
setting qualifications for retrieval, (1), (2), (3)
setting transactions levels
switching with columns
.RPT files
@RSIBLINGS function
.RUL files
See also rules files
rules
creating aliases
creating shared members
data entry in member fields
data load
creating
when to use
data loads
defining attribute dimensions
defining attributes
defining dimension type, (1), (2)
dimension builds
formatting data sources, (1), (2), (3), (4)
formatting free-form data sources, (1), (2)
replicated partitions
replicating
data
transparent partitions, (1), (2)
UDAs
rules files
adding members with, (1), (2)
associating
with data sources
with outlines, (1), (2), (3), (4)
associating aliases with attributes
attribute associations
bottom-up ordering, (1), (2)
building dimensions, (1), (2), (3), (4)
building shared members
different generation, (1), (2)
same generation, (1), (2)
with branches, (1), (2)
changing field names
copying
copying in file system
creating, (1), (2)
process overview
creating new fields
cross-platform compatibility
for dimension builds
generation references and, (1), (2), (3)
header records and, (1), (2)
initializing
invalid
level references and, (1), (2), (3), (4)
loading, (1), (2)
prerequisites
logging load errors
manipulating fields in
naming
opening
optimizing usage
options for setting up
parent/child builds, (1), (2), (3), (4)
position of fields, (1), (2)
replacing text strings
restrictions for entering field types
saving, (1), (2), (3)
setting global options
specifying field types
SQL data sources and, (1), (2)
top-down ordering
usage overview, (1), (2), (3), (4)
validating, (1), (2), (3)
troubleshooting problems with
with blank fields
Run button (Application Manager)
RUNCALC command
Run-Length Encoding. See RLE data compression
running
batch files, (1), (2)
calc scripts, (1), (2), (3), (4)
on partitioned applications
calc scripts with Application Manager
currency conversions, (1), (2), (3)
ESSCMD, (1), (2)
caution for pausing systems while
in interactive mode
multiple report script files
report scripts
basic techniques, (1), (2), (3)
examples
in ESSCMD
single line only
with Application Manager
report scripts with Application Manager
RUNREPT command
run-time information
Run-time page (Database Information), (1), (2)
S
salary databases, (1), (2)
sales
allocating percentages for
estimating profits
period-to-date values
reporting
sample for market selection
sample for percentages
samples for actual, (1), (2)
year-to-date and rolling averages
Sampeast application
partitioning examples
replicated partitions in, (1), (2)
transparent partitions in
Sampeast East database
provided with Hyperion Essbase
Sample application
creating simple reports
currency conversion databases
Sample Basic database
batch mode processes
consolidation example
creating calc scripts
creating formulas for outlines
creating outlines for
defining calculations for, (1), (2)
actual values
allocating values, (1), (2)
allocating values across one dimension
data subsets
forecasting future values
forward references and
increasing budgets
percentage of variance
product and market share
sales and profit
shared members in
specific cells, (1), (2), (3), (4)
dense dimensions in, (1), (2), (3)
dynamically calculating data
generating reports
header and mapping information in
Intelligent Calculations on, (1), (2), (3)
loading new budget values
optimal dimension configurations
optimizing calculations in, (1), (2), (3), (4)
partitioning examples, (1), (2), (3), (4)
provided with Hyperion Essbase
report calculations in
report formatting examples, (1), (2), (3)
sample reports
selecting members for reports, (1), (2)
sorting example
sparse dimensions in, (1), (2), (3)
two-pass calculations in
Sample database
INTERNTL
XCHGRATE
sample databases
SAMPLE directory
sample ESSCMD script files
sample questions
sample reports
adding aliases, (1), (2)
changing data combinations
creating asymmetric columns
customizing page layouts, (1), (2)
formatting layouts, (1), (2), (3), (4)
grouping rows
handling missing values
narrowing member selection
nesting columns
ordering data
restricting data retrieval
sorting data values, (1), (2), (3)
using attributes, (1), (2)
using attributes in member selection
sample script files
Samppart application
partitioning examples
replicated partitions in, (1), (2)
transparent partitions in
Samppart Company database
provided with Hyperion Essbase
@SANCESTVAL function
Save As command
Save Client Object dialog box
saving calc scripts, (1), (2)
Save Server Object dialog box
copying outlines
saving calc scripts, (1), (2), (3)
saving rules files, (1), (2)
SAVEANDOUTPUT command
SAVEROW command
restrictions
usage
usage example
saving
attachments
calc scripts, (1), (2), (3)
on client workstations, (1), (2)
filters
formulas
outline files
outlines, (1), (2), (3), (4)
caution for
output files
partition definitions
report scripts
reports, (1), (2)
rules files, (1), (2), (3)
security profiles, (1), (2), (3)
scalability
scaling data values
schedule report scripts to run in batch mode
scope
checklist for analyzing
determining
scopeEssbase kernel settings
.SCR files, (1), (2)
script files. See ESSCMD script files
scripts. See calc scripts; report scripts
searches
case-sensitive, (1), (2), (3), (4), (5)
large indexes and
members in Calc Script Editor
members in Formula Editor
returning specific values, (1), (2)
sequential
text
in calc scripts
in formulas
viewing information about index
season-to-date calculations
.SEC files, (1), (2), (3)
secondary fields, (1), (2)
secondary roll-ups, (1), (2), (3)
Security
designing and building a system
security, (1), (2)
See also access; filters; privileges
access levels listed, (1), (2), (3)
application-level settings
backup files
changing for users and groups
changing for users and groups with Administration Services
changing for users and groups with Application Manager
checking information about
custom-defined functions
disconnect session or request
for applications and databases
implementing, (1), (2)
for users and groups, (1), (2), (3), (4)
globally
guidelines for
system server, (1), (2), (3)
information file
layers defined
linked reporting objects
managing, (1), (2), (3)
for large number of users
modifying user access settings
planning for
profiles
copying, (1), (2)
creating
deleting users and groups
editing
saving, (1), (2), (3)
sample solutions, (1), (2)
saving information to ASCII files
setting up for partitioned databases, (1), (2)
security definitions
security file
backup of
contents of
cross-platform compatibility
filter storage
restoring
Security System
See also security
security types
Create/Delete Users/Groups
defined
ordinary
.SEL files, (1), (2)
SELECT command, (1), (2), (3)
select criteria. See selection criteria
Select Database dialog box
Select Record dialog box
Select Server, Application and Database dialog box
select statements. See SQL databases
selecting
alias tables, (1), (2)
applications for loading
with ESSCMD
build methods, (1), (2)
calc script files, (1), (2)
data sources, (1), (2), (3), (4), (5)
using Windows
data targets
data to partition, (1), (2), (3)
databases for loading
with ESSCMD
dimension storage type, (1), (2), (3)
dimension type
guidelines for
fields
members for dynamic calculations
guidelines for, (1), (2)
members for report scripts, (1), (2), (3)
from Dynamic Time Series
with ATTRIBUTE command
with Boolean operators
with conditions
with substitution variables
with TODATE command
with user-defined attributes
with wildcards
with WITHATTR command
members, for column groupings
multiple dimensions and members
multiple files, (1), (2)
multiple members
partition type, (1), (2), (3), (4), (5)
in Partition Wizard, (1), (2), (3), (4)
records, (1), (2), (3)
report script files, (1), (2)
SQL data sources
values for dynamic calculations, (1), (2)
guidelines for, (1), (2)
selection criteria
defining multiple for single field
defining on multiple fields
specifying in rules file
semantic errors, (1), (2)
semicolons (;)
in application and database names
in calc scripts, (1), (2), (3), (4)
in ESSCMD syntax
in formulas, (1), (2), (3)
in names in scripts and formulas, (1), (2)
separators
See also file delimiters
commas in numbers
member lists
report script commands, (1), (2)
sequential searches
Serial calculation
introduction
server
AGTSVRCONNECTIONS
application startup
caution for improper shutdown
caution for rebooting
changing system password for
client requests and, (1), (2), (3)
client/server model described
communicating with clients
connecting to. See connections
crashes, recovering from, (1), (2), (3)
suggested procedures
cross-platform compatibility
disconnecting users
displaying
access settings
current users, (1), (2), (3)
ports
displaying version number
Essbase components
functionality described, (1), (2)
getting information about, (1), (2)
initial connection and disconnection
interruptions
loading data from
logging errors
logging out of, (1), (2)
logging out users
moving data sources to
parallel calculation level
partitioning databases across multiple
redefining information
restrictions
securing, (1), (2), (3)
SERVERTHREADS
setting internal buffer
shutting down, (1), (2)
simultaneous access by multiple users
simultaneous updates by multiple users
starting
system supervisor defined
terminating requests
unavailable, (1), (2)
writing calc scripts to
Server Agent
See also server console
accessing
activity recording
as traffic coordinator
defined
displaying available commands
handling requests
monitoring applications
multiple installations on a single server
overview client-server communications, (1), (2)
running as background process
setting number of threads
server applications. See client-server applications
server console
remote shutdowns
shutting down server, (1), (2)
starting applications
starting databases
starting Essbase server
stopping applications, (1), (2)
multiple simultaneously
stopping databases
server errors
server event logs. See OLAP Server logs.
Server Information dialog box
server interface
server logs. See OLAP Server logs.
server requirements
multithreaded operating system
Server Settings dialog box
auto logoff
password management
SERVERTHREADS setting
sessions
terminate user's session using MaxL
terminating using Application Manager
SET AGGMISSG command
and allocating costs
and member combinations
described, (1), (2)
SET CACHE command
SET CALCHASHTBL
and parallel calculation
SET CALCHASHTBL command, (1), (2)
performance considerations and
set calcparallel
SET CALCTASKDIMS
SET CLEARUPDATESTATUS command
calculating subsets with
concurrent calculations and
Intelligent Calculation and, (1), (2), (3), (4), (5)
multi-pass calculations, (1), (2)
parameters listed
two-pass calculations
Set Current Alias Table dialog box
Set Database Note dialog box
Set Default Calc dialog box
SET FRMLBOTTOMUP command, (1), (2)
Set isolation level to uncommitted
set isolation level to uncommitted
Administration Services
SET LOCKBLOCK command, (1), (2)
SET MSG calculation script command
SET MSG command
SET MSG DETAIL command
SET MSG ONLY
SET MSG SUMMARY command
usage example
SET NOTICE command, (1), (2), (3)
SET UPDATECALC command, (1), (2)
SET UPDATECALC OFF command
SET UPTOLOCAL command
SETALIAS command
SETAPPSTATE command
SETCENTER command
SETDBSTATE command
changing data compression
precedence, (1), (2)
running in batch mode
setting
index page size, (1), (2)
specifying data compression
SETDBSTATEITEM command
aggregating missing values, (1), (2), (3)
changing data compression
increasing retrieval buffer
precedence, (1), (2)
running in batch mode
scope of storage settings
setting
retrieval buffer size, (1), (2)
transaction isolation levels, (1), (2), (3)
specifying
data compression
disk volumes, (1), (2)
SETDEFAULTCALCFILE command
SETPASSWORD command
SETROWOP command
entering in report scripts
usage
setting
See also assigning; defining; applying
attribute types
cache size, (1), (2)
first-time calculations
cache sizes
conditions in formulas, (1), (2)
configurable variables
consolidation properties, (1), (2)
data cache size
data file cache size
default calculations, (1), (2), (3), (4)
delimiters
dimension and member properties
file delimiters, (1), (2), (3)
fonts and typefaces
global options, (1), (2)
index cache size
internal server buffer
maximum records logged
member consolidation properties
messages in application logs
messages in OLAP Server logs
outline change log size
passwords and user names
new users, (1), (2)
overview
partitioned databases
properties dynamically
report output destinations, (1), (2)
retrieval buffer size, (1), (2)
for data sorts
transaction isolation levels
with ESSCMD, (1), (2)
setting the number of threads for server
shared areas. See partition areas
shared library files
shared locks. See Read locks
shared member property, (1), (2)
shared members
adding to outlines, (1), (2), (3)
caution for placing
affect on consolidation paths
at different generations
building dynamically, (1), (2)
at same generation, (1), (2)
building dynamically, (1), (2)
building dynamically, (1), (2), (3), (4)
calculating, (1), (2)
caution for sorting
creating, (1), (2), (3), (4)
for different generations, (1), (2)
for same generation, (1), (2)
guidelines for, (1), (2)
with Outline Editor
with rules files
described
design approach for attributes
different generations
getting
guidelines, (1), (2)
implicit, (1), (2), (3)
linked reporting objects and
parent/child
most versatile build method
partitioned applications and, (1), (2)
properties
relationship implied
reorganizing
rolling up
same generation
sample rules files
generation references
level references, (1), (2), (3)
parent/child references, (1), (2), (3)
suppressing for report generation
with branches
building dynamically, (1), (2)
with outline synchcronization
shared partition areas
shared roll-ups
sharing data, (1), (2)
across multiple sites, (1), (2)
in partitioned databases, (1), (2), (3)
never allow property, (1), (2), (3)
not allowing
sharing members. See shared members
sheets. See Spreadsheet Add-in; spreadsheets
shell scripts (UNIX)
SHGENREF.RUL
SHGENREF.TXT
@SHIFT function
@SHIFTMINUS function
@SHIFTPLUS function
SHLEV.RUL
SHLEV.TXT
Show Warnings option, (1), (2)
shutdown (caution for improper)
SHUTDOWNSERVER command
shutting down server
from ESSCMD
from MaxL
from Server Agent
sibling
defined
@SIBLINGS function
siblings
adding as members, (1), (2)
calculation order in outlines
checking for
consolidation properties and
dimensions as
getting
members as, (1), (2)
rolling up
SIBLOW.RUL
SIBLOW.TXT
SIBPAR.TXT
SIBSTR.RUL
SIBSTR.TXT
Sign Flip option
Simple application
adding standard dimension to outline
adding stored members to outline
changing outline
creating
organizing data
removing a dimension from outline
simple formulas, (1), (2)
simple interest
simulated calculation
simulating calculations
single quotation marks (')
in application and database names
in dimension and member names
single-server applications
adding dimensions, (1), (2)
analyzing data, (1), (2)
analyzing database scope, (1), (2)
creating outlines
defining calculations, (1), (2), (3)
designing, (1), (2)
identifying data sources
implementing security
partitioned vs.
planning process, (1), (2)
size
array variables
data blocks
controlling
data files, setting maximum size
determining cache
estimating database, (1), (2), (3)
factors determining for database
field and optimal loads
getting information on cache
index files, setting maximum size
linked files, (1), (2)
minimizing for linked objects
optimizing index, (1), (2)
outline change logs
planning for optimal
reducing database
setting cache, (1), (2)
first-time calculations
setting data cache
setting data file cache
setting index cache
setting limits for linked objects
setting retrieval buffer, (1), (2)
for data sorts
sizing
dynamic calculator cache
skip #MISSING and/or zero values in a range
SKIP command
usage
usage example
Skip Missing property
skip next #MISSING and/or zero values
skip properties
Skip Zeros property
SKIPONDIMENSION command
skipping
#MISSING and zero values, (1), (2)
fields when mapping, (1), (2)
lines in rules files, (1), (2)
multiple fields in data load
records in data load
specific fields in data load
.SL files
slashes (/)
as codes in data source
in application and database names
in names in scripts and formulas, (1), (2)
slicing
defined
for different perspectives
@SLN function
smoothing data
SMP (symmetric multiprocessing), (1), (2)
.SO files
software version
Solaris servers. See UNIX platforms
Sort Descending command
sort order
defining
members in outline
output
SORTALTNAMES command
SORTASC command
SORTDESC command
SORTGEN command
sorting
data for reports, (1), (2), (3)
examples, (1), (2), (3)
data with missing values
dimensions and members, (1), (2)
members in reports
records to optimize data loading
sorting commands, (1), (2)
SORTLEVEL command
usage
usage example
SORTMBRNAMES command
precedence in sorts
usage
SORTNONE command
source data
changing case
source outline (defined)
space. See white space
spaces
in application and database names
in dimension and member names
@SPARENTVAL function
SPARSE command
sparse dimensions
See also dense dimensions; dimensions
calculating values in, (1), (2), (3), (4)
defined
defining member combinations for, (1), (2)
Dynamic Calc, (1), (2)
dynamically calculating, (1), (2), (3), (4), (5)
formulas and
grouping member combinations
implications for restructuring and, (1), (2)
Intelligent Calculation and
location in outline, (1), (2)
marked as clean
optimizing, (1), (2)
optimizing loading
partitioning
recalculating values in, (1), (2)
reporting on
returning values for
selecting
selection scenarios, (1), (2)
setting
storing
storing member combinations
unique member combinations
vs dense dimensions
sparse restructure
specifying port increment with PORTINC
specifying port values
AGENTPORT
SERVERPORTBEGIN and SERVERPORTEND
Specifying settings
isolation levels with MaxL
speed up. See optimizing
@SPLINE function
spline, calculating
split dimensions
Split Field dialog box
splitting
databases, (1), (2)
fields
Spreadsheet Add-in
ad hoc currency reporting
as Essbase client
defined
getting Dynamic Time Series members
linked partitions and, (1), (2)
linked reporting objects and, (1), (2)
maintaining data integrity
optimizing retrieval, (1), (2)
running calc scripts
specifying latest time period
viewing database information
spreadsheet files
spreadsheets
data source
default locations
loading, (1), (2), (3)
multiple
logging updates
opening, (1), (2)
supported for data loading
SQL databases
batch mode example
data source
field names in
loading, (1), (2)
troubleshooting problems with
opening, (1), (2)
troubleshooting connections
SQL select statements
SSAUDIT parameter
SSAUDITR parameter
SSLUNKNOWN setting
stages of data loading
standard deviation, calculating
standard dimensions
attribute formulas on
comparison with attribute dimensions
defining in dimension build
described
START command (Agent), (1), (2)
start database
Administration Services
start value
ranges in numeric attributes
STARTHEADING command
entering in report scripts
usage
usage example
starting
application server
applications
databases
ESSCMD
prerequisites
Hyperion Essbase kernel
Outline Editor
server
startup commands
startup information, (1), (2)
startup settings
restoring
statement terminator, (1), (2)
ESSCMD commands
in report scripts
inserting in calc scripts, (1), (2), (3)
inserting in formulas
statements
calc scripts and, (1), (2), (3), (4)
formulas and, (1), (2)
static member names
statistical calculations
generating with calc scripts
statistical functions
statistical variance, calculating
statistics
checking cache
Statistics page (Database Information)
Statistics tab (Database Information)
Status
checking parallel calculation
status
current calculation state
data loads, (1), (2)
partitioned applications
viewing database information
viewing server information, (1), (2)
S-T-D time series member, (1), (2)
@STDEV function
@STDEVP function
@STDEVRANGE function
STOP command (Agent), (1), (2), (3)
stopping
See also closing; exiting; quitting
applications, (1), (2)
before backup
with related database in Administration Services
with related database in Application Manager
calculations
data loads
databases, (1), (2)
server, (1), (2)
stopping applications (MaxL)
storage
See also Hyperion Essbase kernel
allocating disk space, (1), (2)
example
bitmap compression option
checking disk space
data blocks and, (1), (2), (3)
data compression
data files
data values, (1), (2)
deallocation and, (1), (2)
default properties
dynamically calculated values, (1), (2)
with attributes
fine-tuning
index files
inefficient data blocks
internal structures optimizing
linked reporting objects, (1), (2), (3)
local
multiple applications
optimizing
partitioned databases, (1), (2)
sparse member combinations and
with replicated partitions
with transparent partitions
planning for
restructuring and
RLE compression method
server configurations
temporary variables
viewing information about
Storage page (Database Information)
Storage page (Database Settings)
setting
data file cache size, (1), (2)
index cache size, (1), (2), (3)
index page size, (1), (2), (3)
specifying
data compression
disk volumes
storage settings, (1), (2)
scope
store data property
store property
description
stored members
adding and deleting
strings
See also characters
adding fields by matching
adding members by matching
as tokens
calc scripts as
dummy
options for loading, (1), (2)
preceded by &
replacing for data loads
strings, in calculation formulas
subexpressions
subsets of data
calculating, (1), (2), (3)
example
with Intelligent Calculation
clearing
copying
copying to Personal Essbase
prerequisites
loading, (1), (2)
substitution variables
adding to report scripts, (1), (2), (3)
creating
guidelines for
creating using MaxL
deleting
deleting using MaxL
formulas and
free-form reports and
inserting in calc scripts, (1), (2)
updating
updating using MaxL
usage overview
Substitution Variables dialog box, (1), (2)
@SUBSTRING function
subtotals, (1), (2)
subtracting
values from existing values
subtraction
consolidation codes in data source
prerequisite for
setting member consolidation properties
suffixes
adding to fields
assignment sequence in data build
attribute member names, (1), (2), (3)
member names
@SUM function
Sum member, Attribute Calculations dimension, (1), (2)
summaries
reporting example
summary information
Summary page (Partition Wizard)
@SUMRANGE function
sums, (1), (2)
SUPALL command
SUPBRACKETS command
overriding
usage example
SUPCOLHEADING command
SUPCOMMAS command
SUPCURHEADING command
SUPEMPTYROWS command
entering in report scripts
usage
Supervisor permission, (1), (2)
SUPEUROPEAN command
SUPFEED command
usage
usage example
SUPFORMATS command
SUPHEADING command
SUPMASK command
SUPMISSINGROWS command
usage
usage example
SUPNAMES command
SUPOUTPUT command
SUPPAGEHEADING command
usage
usage example
SUPPMISSING command
suppressing report formatting, (1), (2)
SUPPRESSMISSING command
SUPSHARE command
SUPSHAREOFF command
SUPZEROROWS command
SUPZEROS command
swap space
swapping devices
Sybase SQL Server. See SQL databases
@SYD function
SYM command
entering in report scripts
usage
usage example
symmetric columns
symmetric multiprocessing (SMP), (1), (2)
symmetric reports
asymmetric reports vs.
calculated columns in
changing column headings
creating, (1), (2)
defined
formatting
outputting column groups
overriding column groupings
Synchronize Outline dialog box
synchronizing
data, (1), (2), (3)
partitioning and
outlines, (1), (2)
process summarized, (1), (2)
warning for not applying changes
with Application Manager
with Partition Wizard
outlines with report scripts
syntax
See also formats
calc scripts
calculation commands
checking in Calc Script Editor, (1), (2), (3)
checking in Formula Editor, (1), (2)
comments
ESSCMD
formulas, guidelines for
report scripts
member selection
substitution variables
user-defined attributes
with wildcards
verifying for filters
syntax errors
finding in calc scripts
finding in formulas
formulas and dynamically calculated members
stepping through
system administrators. See administrators
system errors, (1), (2), (3)
logs locations and names
system failures. See failures; recovery
System Info page (Server Information)
system information, (1), (2)
system password
changing
system security. See security
System Supervisor
T
T, two-pass calc code in data source
tab
as column separator
as command separator
as file delimiter
in names
TABDELIMIT command
entering in report scripts
usage
tab-delimited formats
tables. See alias tables; databases
tabs
in application and database names
tags
See also properties
assigning to members
display options
usage examples
target outline
See also targets
targets
accessing data, (1), (2)
calculations and, (1), (2)
changing data in
changing outlines
copying from
defined
defining
for multiple partitions
for replicated partitions
for transparent partitions, (1), (2)
displaying
logging into
losing connections to
mapping information
mapping members to data sources
linked partitions, (1), (2)
replicated partitions, (1), (2), (3)
specifying specific areas
transparent partitions, (1), (2)
member names differing from source
missing data
partitioning information for
propagating outline changes, (1), (2), (3)
process summarized, (1), (2)
selecting
specifying shared areas, (1), (2), (3)
updating changes to, (1), (2), (3)
viewing data in linked partitions
.TCP files
TCP/IP connections
.TCT files, (1), (2)
.TCU files, (1), (2)
technical support
temporary files
deleting
temporary values, (1), (2)
terminate
specific request using MaxL
user session using MaxL
terminating server connections
caution
for specific user
testing
calculations
database design
for missing values
partitions, (1), (2)
text
See also annotating; comments
adding to calc scripts
adding to empty fields
attribute dimension type
attribute type
case conversions, (1), (2)
copying and pasting, (1), (2), (3)
cutting, (1), (2), (3)
defining as labels
displaying in Outline Editor
fields
finding and replacing
in formulas
in data sources
inserting in formulas
linked reporting object
replacing missing values with, (1), (2)
storing
strings
replacing in rules file
TEXT command
usage, (1), (2)
usage example
text editors
calc scripts and
ESSCMD commands and
formulas and
report scripts and
text files
calc scripts in
creating, (1), (2)
cross-platform compatibility
data sources
default locations
dumping security information to
loading, (1), (2)
multiple
opening
text masks, (1), (2)
text strings. See strings
The Beverage Company (TBC), (1), (2)
third-party backup utility
threads
data load processing, (1), (2)
threshold (transactions)
tildes (~)
as codes in data source
in headings
tildes ()
in names in scripts and formulas
time
estimated for calculation
time balance first/last properties
described, (1), (2)
in combination with skip property
setting
time balance properties
described
examples for usage, (1), (2)
time balance tags
calculating accounts data
time balanced data
calculating averages
missing and zero values
specifying in data sources
Time dimension
currency applications
time series members and, (1), (2), (3)
usage example
time dimension
calculating values, (1), (2)
defining formulas for
description
setting
specifying, (1), (2), (3)
time balance members and
two-pass calculations and
usage example, (1), (2)
time-out errors, (1), (2)
time-out settings
locks
transactions
time periods
budgeting expenses for
determining first value for, (1), (2)
determining last value for, (1), (2)
getting average for, (1), (2)
time-sensitive data
time series reporting
calculating averages
calculating period-to-date values
creating dynamic members for, (1), (2)
getting first/last values, (1), (2), (3)
partitioned databases
retrieving period-to-date values
skipping missing or zero values
Time Series tags
Intelligent Calculation and
listed
time zones
time-out settings
locks, (1), (2)
timestamps, comparing
TIMINGMESSAGES setting
titles, (1), (2)
@TODATE function, (1), (2)
TODATE command
usage
tokens
toolbar
Data Prep Editor
Formula Editor
Outline Editor, (1), (2)
enabling/disabling
Script Editor
tools for extending Essbase applications
TOP command
caution for usage
entering in report scripts, (1), (2), (3)
precedence
restrictions
upper limits
usage
usage example
TOP.REP
top-down calculation
top-down ordering
calculations
dynamic builds, (1), (2), (3)
top-down partitioning
defined
totals, (1), (2)
tracing calculations, (1), (2)
trailing spaces
transaction control files
Transaction Control Table (TCT), (1), (2)
Transaction Manager
overview
Transaction page (Database Settings), (1), (2)
accessing locked blocks
transactions
actions triggering
canceling calculations and
caution for committed access
caution for data loads, (1), (2)
committing, (1), (2)
defined
forcing at load completion
initiating commits, (1), (2)
locks and, (1), (2), (3)
managing
multiple
predictability
processing, (1), (2)
required privileges, (1), (2)
rolling back
rolling back after shutdown, (1), (2), (3)
server crashes and active
setting isolation levels
with Application Manager
with ESSCMD, (1), (2)
with Hyperion Essbase kernel
tracking
updating isolation levels
wait intervals
transparent members
transparent partition limitations with parallel calculation
transparent partitions
advantages
calculating
clearing values in
creating, (1), (2), (3), (4)
currency conversions and, (1), (2), (3)
data loading and
defined
described
disadvantages
dynamically calculated values in
example of
formulas and, (1), (2)
guidelines for selecting, (1), (2)
implementing security measures
improving performance, (1), (2), (3)
mapping members, (1), (2)
port usage
usage restrictions
using attributes in
tree icon
trees
See also branches
data hierarchies, (1), (2)
moving members in
outlines
@TREND function
trends, calculating
troubleshooting, (1), (2)
calc scripts
connections
data loading
formulas
partitions
@TRUNCATE function
truncated names
truncating values
two-dimensional
data blocks
two-dimensional reports, (1), (2)
two-pass
two-pass calculation
enable
two-pass calculation property
usage example
two-pass calculations, (1), (2)
as default
examples, (1), (2)
calc scripts and, (1), (2), (3), (4), (5)
dynamic calculations and, (1), (2)
Intelligent Calculation and, (1), (2)
setting up, (1), (2)
usage examples
.TXT files. See text files
typefaces
types
setting attribute
tagging dimensions
typographical conventions
U
UCHARACTERS command
UCOLUMNS command
@UDA function
UDA command
selecting members with
usage example
UDA field type
in header records
in rules files
nulls and, (1), (2)
UDAs
adding to report scripts
allowing changes
calc script example
checking for
compared with attributes
creating
described
design approach for attributes
flipping values in data load
rules for creating
shared members and
UDATA command
usage example
UNAME command
UNAMEONDIMENSION command
unary operators, (1), (2)
usage overview, (1), (2)
unauthorized users, (1), (2)
unavailable server or data sources, (1), (2)
UNCOMMITTED
and parallel calculation
uncommitted access
about
commits and
handling transactions with
locks and, (1), (2)
rollbacks and
setting, (1), (2), (3)
uncommitted mode
parallel calculation
UNDERLINECHAR command
usage
usage example
underlining
UNDERSCORECHAR command
underscores ( _ )
converting spaces to, (1), (2)
in report scripts
underscores (_)
in array and variable names
undoing
calc scripts builds
database operations
unexpected values
Uniform Resource Locators. See URLs
unique data values
assigning #MISSING values to
Intelligent Calculation and
UNIX platforms
basic memory requirements
file naming conventions
freeing memory
monitoring applications
running batch files
running Essbase in background
specifying disk volumes
starting Essbase server
unknown member errors
unknown values
UNLOADALIAS command
UNLOADAPP command
UNLOADDB command
unloading applications (MaxL)
unlocking databases
after allotted maximum lock time
with Application Designer privilege
unlocking objects, (1), (2)
UNLOCKOBJECT command
unspecified members
Untitled report script
update log files
UPDATECALC setting
system failures and
UPDATEFILE command
updates
getting information about outline
troubleshooting
UPDATEVARIABLE command
updating
alias tables
cache sizes
changed blocks only
data compression
data sources, (1), (2)
data targets, (1), (2), (3)
databases, (1), (2)
dimensions
indexes
logs
outlines
partitioned applications, (1), (2), (3), (4)
guidelines
with remote data
references
reports
requests. See transactions
spreadsheets
substitution variables
transaction isolation settings
volume settings
upgrades
upper level blocks, (1), (2)
dynamically calculating, (1), (2), (3), (4)
recalculating values in
restructuring and
URLs
linking to cells
manipulating with Application Manager
maximum character length
storing
Use Aliases option, (1), (2)
Use Dimension Property Settings option
User Database Access dialog box
user groups
assigning filters to
assigning privileges
creating, (1), (2)
creating with Administration Services
creating with Application Manager
defined, (1), (2)
defining security settings, (1), (2), (3)
deleting with Administration Services
deleting with Application Manager
editing
modifying access settings, (1), (2), (3)
removing members
renaming
returning members, (1), (2)
viewing current settings
user interface
See also Application Manager
accessing linked objects and clients
user locks
viewing and removing with Application Manager
user-management tasks, (1), (2), (3)
user names
disabling, (1), (2), (3), (4)
entering, (1), (2), (3)
user types
Create/Delete Users/Groups
defined
ordinary, (1), (2)
Supervisor
User/Group Application Access dialog box
User/Group Security dialog box
copying security profiles, (1), (2)
creating new users
deleting users and groups
editing existing groups
editing user profiles
managing users and groups
renaming users and groups
user-defined macros
validating
users
accessing locked blocks, (1), (2)
activating disabled
assigning
application access, (1), (2), (3), (4)
application permission
filters
privileges
to groups, (1), (2)
changing access privileges, (1), (2)
changing passwords using MaxL
changing passwords with Administration Services
changing passwords with Application Manager
creating accounts for, (1), (2)
creating new with Administration Services
creating new with Application Manager
defining security, (1), (2), (3)
deleting user with Application Manager
deleting using MaxL
disconnecting from servers
displaying
access settings
defined users
inactive users
displaying current, (1), (2)
displaying in MaxL, (1), (2), (3), (4), (5), (6)
editing security settings
limiting login attempts
limiting maximum number of sessions
logging out, (1), (2), (3)
login procedure
maintaining information for
removing, (1), (2)
renaming
renaming using MaxL
replicating privileges
security settings
security types
setting global access levels
unauthorized, (1), (2)
USERS command
usage overview
USERS command (Agent)
V
V, Dynamic Calc and Store code in data source
VALIDATE command, (1), (2)
partitioned applications and
Validate page (Partition Wizard)
Validate Rules dialog box, (1), (2)
VALIDATEPARTITIONDEFFILE command
validating
data integrity
field names
partitions
rules files, (1), (2), (3)
troubleshooting problems
validity checking
values, (1), (2)
See also missing values; range of values
accumulation
assigning to member combinations
assigning to variables
averaging
for time periods, (1), (2)
non-zero values and
reporting examples, (1), (2)
with formulas, (1), (2)
changing
comparing, (1), (2)
compression and repetitive, (1), (2)
defined
displaying specific
distribution among dimensions
duplicating
dynamically calculating, (1), (2), (3)
entering in empty fields
example of comparing
filtering
flipping
formatting in reports, (1), (2)
examples
identical
in a database, (1), (2)
inconsistent
incorrect
interdependent
looking up
measuring
member with no
negative
flipping
variance as
nulls, (1), (2)
of attributes, (1), (2), (3)
optimizing in sparse dimensions
ordering in reports, (1), (2)
example
out of range
overwriting, (1), (2), (3)
for currency conversions
placing retrieval restrictions, (1), (2)
example
reading multiple ranges
referencing, (1), (2), (3), (4)
retrieving dynamically calculated, (1), (2), (3), (4)
retrieving for reports
setting maximum rows allowed
with conditions, (1), (2), (3), (4)
retrieving from remote databases, (1), (2), (3)
rolling up
rounding, (1), (2)
scaling
setting maximum number of
storing, (1), (2)
temporary, (1), (2)
truncating
unable to change
unexpected
unique
assigning #MISSING values to
Intelligent Calculation and
unknown
variables as
void
@VAR function, (1), (2), (3)
VAR command
variables
adding to report scripts, (1), (2), (3), (4)
assigning values
creating substitution
creating using MaxL
declaring, (1), (2), (3)
deleting
deleting using MaxL
free-form reports and
inserting in calc scripts, (1), (2)
naming
setting configurable variables
updating
updating using MaxL
@VARIANCE function
variance
See also statistical variance, calculating
dynamically calculating
returning, (1), (2)
usage examples, (1), (2), (3), (4)
variance percentages
calculating
returning, (1), (2)
variance reporting properties, (1), (2)
setting
@VARIANCEP function
@VARPER function, (1), (2), (3), (4)
Verify dialog box
verifying
See also validating
outline content on save
outlines
path information
values retrieved in loads
VERSION command (Agent)
version compatibility
version numbers
vertical bars ( | )
in dimension and member names
View Log File dialog box, (1), (2), (3)
view logs
Log Analyzer
OLAP Server and application in Administration Services
OLAP Server and application in Application Manager
OLAP Server in Application Manager
OLAP Server logs in Application Manager
View menu, (1), (2)
view user locks
viewing
access settings
active filters
aliases, (1), (2)
in Calc Script Editor
in Formula Editor
application information, (1), (2), (3)
application logs, (1), (2)
applications
available ports, (1), (2)
changes to outlines
current users, (1), (2), (3)
data, (1), (2), (3)
in targets
with Data Prep Editor, (1), (2)
data load error logs
data sources, (1), (2)
data targets
database
statistics
database information, (1), (2)
database statistics
databases
dimension build error logs
dimensions
in Calc Script Editor
in Formula Editor
in outlines
dynamically calculated members, (1), (2)
exception logs
field operations
formulas, (1), (2)
inactive users
informational messages, (1), (2), (3)
linked objects, (1), (2)
locked data
locks
logs, (1), (2), (3)
member combinations, (1), (2)
member names in reports
members in outlines, (1), (2)
names for generations and levels
OLAP Server logs
outline change logs
partitions, (1), (2)
records
replace operations
selection/rejection criteria
Server Agent commands
server information
software version
specific values
storage information
text in Outline Editor
unique values
user and group lists with Administration Services
viewing the application log
views
customizing
virtual cubes (in Hyperion MBA). See transparent partitions
virtual memory
void mappings
volume names
volumes
allocation and
data files and
data storage and multiple
deallocating, (1), (2)
index files and
specifying
with Application Manager
with ESSCMD
updating storage settings
.W95 files
W
Wait settings
locks
transactions
warnings
application logs and
OLAP Server logs and
partition validation
report processing, (1), (2)
week-to-date calculations
white space
as file delimiter
converting to underscores, (1), (2)
cross-dimensional operator and
data entry
dropping, (1), (2)
formulas
in dimension and member names
in names
in report layouts
report scripts
WIDTH command
wildcard matches
wildcards in report scripts
window
Application Desktop
Application Services
Windows Explorer
Windows File Manager
Windows platforms
freeing memory
monitoring applications
@WITHATTR function, (1), (2)
WITHATTR command, (1), (2), (3)
usage
wizards
workstations
Write access
write access
Write locks
described
with committed access
with uncommitted access, (1), (2)
Write permission
Write privilege, (1), (2)
writes
data compression and, (1), (2)
error logs
getting number of
optimizing
W-T-D time series member, (1), (2)
X
X member code
X operator, (1), (2)
X, Dynamic Calc code in data source
XCHGRATE database
adding members
contents described
displaying outlines
linking with Application Manager
Xchgrate database
provided with Hyperion Essbase
XCHGRATE sample database
.XCP files, (1), (2)
.XLL files
.XLS files
@XREF function
Y
year-to-date calculations, (1), (2)
Y-T-D time series member, (1), (2)
Z
Z, time balance codes in data source
zero values
excluding in time balances
formatting in reports, (1), (2)
including in time balances
replacing with labels
skipping, (1), (2)
ZEROTEXT command
zoom
See drill.