Index

Click a number next to an index entry to see the referenced page. The referenced information appears at the top of the resulting window.

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

terminating reports, 1

! (exclamation points)

adding to report scripts, 1

in names in scripts and formulas, 1

" (double quotation marks)

enclosing member names, 1, 2, 3

in application and database names, 1

in dimension and member names, 1

in ESSCMD commands, 1

in formulas, 1, 2, 3

in header information, 1

in report scripts, 1

terms in scripts and formulas, 1, 2

# (pound signs)

in array and variable names, 1

#MI values

inserting into empty fields, 1, 2, 3

instead of #MISSING, 1

#MISSING values, 1, 2, 3

aggregating

defaults for, 1

effects on calculation order, 1, 2, 3, 4

setting behavior for, 1

averages and, 1

calculations and, 1, 2, 3

disabling, 1

formatting in reports, 1

in calculations, 1

inserting into empty fields, 1, 2

parents and, 1, 2

replacing with text, 1

reporting samples, 1, 2

skipping, 1, 2

sorting data with, 1

specifying in data source, 1

testing for, 1

viewing with Personal Essbase, 1

#NOACCESS value, 1

$ (dollar signs)

in array and variable names, 1

$ fields, 1

$ALT_NAME setting, 1

% (percent signs)

as codes in data source, 1

in names in scripts and formulas, 1

in report scripts, 1

% operators

defining member consolidations, 1

in calc scripts, 1

in mathematical operations, 1

in unary operations, 1, 2, 3

& (ampersands)

in calc scripts, 1, 2

in member names, 1

in names in scripts and formulas, 1

in report scripts, 1

& commands, 1, 2

() (parentheses)

in calc scripts, 1

in dimension and member names, 1

in formulas, 1

in names in scripts and formulas, 1, 2

indicating negative numeric values in fields, 1

report scripts, 1, 2

* (asterisks)

as codes in data source, 1

in application and database names, 1

in names in scripts and formulas, 1, 2

options in reports, 1

used as wildcard, 1

* operators, 1, 2, 3, 4

+ (plus signs)

as codes in data source, 1

in application and database names, 1

in dimension and member names, 1

in member names, 1

in names in scripts and formulas, 1, 2

+ operators

defining member consolidations, 1

in mathematical operations, 1

in unary operations, 1, 2, 3

member consolidation, 1

, (commas)

as file delimiter, 1

displaying in reports, 1

in application and database names, 1

in data fields, 1

in dimension and member names, 1

in formulas, 1

in header records, 1

in member combinations, 1

in names in scripts and formulas, 1, 2

suppressing in reports, 1, 2

. (periods)

in application and database names, 1

in dimension and member names, 1

in names in scripts and formulas, 1

/ (slashes)

as codes in data source, 1

in names in scripts and formulas, 1, 2

/ operators

defining member consolidations, 1

in calc scripts, 1

in mathematical operations, 1

in unary operations, 1, 2, 3

/* */ character pairs, 1, 2

// (double slashes) in report scripts, 1

: (colons)

in application and database names, 1

in formulas, 1

in names in scripts and formulas, 1, 2

:: (double colons) in formulas, 1

; (semicolons)

in application and database names, 1

in calc scripts, 1, 2, 3, 4

in ESSCMD syntax, 1

in formulas, 1, 2, 3

in names in scripts and formulas, 1, 2

< (less than signs)

in application and database names, 1

in dimension and member names, 1

in names in scripts and formulas, 1, 2

in report scripts, 1

= (equal signs)

in application and database names, 1

in calc scripts, 1

in dimension and member names, 1

in formulas, 1

in names in scripts and formulas, 1

in report scripts, 1

> (greater than signs)

in application and database names, 1

in names in scripts and formulas, 1

-> operators, 1

in formulas, 1

inserting in calc scripts, 1

inserting in formulas, 1, 2

overview, 1, 2

usage examples, 1, 2

? (question marks)

in application and database names, 1

used as wildcard, 1

@ (at signs)

in dimension and member names, 1

in names in scripts and formulas, 1, 2

@ABS function, 1

@ACCUM function, 1, 2

@ALLANCESTORS function, 1

@ALLOCATE function, 1, 2

@ANCEST function, 1

@ANCESTORS function, 1

@ANCESTVAL function, 1

@ATTRIBUTE function, 1, 2

@ATTRIBUTEBVAL function, 1, 2

@ATTRIBUTESVAL function, 1, 2

@ATTRIBUTEVAL function, 1, 2, 3

@AVG function, 1

@AVGRANGE function, 1, 2

@CALCMODE function, 1

@CHILDREN function, 1

@COMPOUND function, 1

@COMPOUNDGROWTH function, 1

@CONCATENATE function, 1

@CORRELATION function, 1

@COUNT function, 1

@CURGEN function, 1

@CURLEV function, 1

@CURRMBR function, 1

@CURRMBRRANGE function, 1

@DECLINE function, 1

@DESCENDANTS function, 1, 2

@DISCOUNT function, 1

@EXP function, 1

@FACTORIAL function, 1

@GEN function, 1

@GENMBRS function, 1

@GROWTH function, 1

@IALLANCESTORS function, 1

@IANCESTORS function, 1

@ICHILDREN function, 1

@IDESCENDANTS function, 1, 2

@ILSIBLINGS function, 1

@INT function, 1

@INTEREST function, 1

@IRDESCENDANTS function, 1

@IRR function, 1

@IRSIBLINGS function, 1

@ISACCTYPE function, 1

@ISANCEST function, 1

@ISCHILD function, 1

@ISDESC function, 1

@ISDESCENDANTS function, 1

@ISGEN function, 1

@ISIANCEST function, 1

@ISIBLINGS function, 1

@ISICHILD function, 1

@ISIDESC function, 1

@ISIPARENT function, 1

@ISISIBLING function, 1

@ISLEV function, 1

@ISMBR function, 1, 2

@ISPARENT function, 1

@ISSAMEGEN function, 1

@ISSAMELEV function, 1

@ISSIBLING function, 1

@ISUDA function, 1

@LEV function, 1

@LEVMBRS function, 1

@LIST function, 1

@LN function, 1

@LOG function, 1

@LOG10 function, 1

@LSIBLINGS function, 1

@MATCH function, 1

@MAX function, 1

@MAXRANGE function, 1

@MAXS function, 1

@MAXSRANGE function, 1

@MDALLOCATE function, 1, 2

@MDANCESTVAL function, 1

@MDPARENTVAL function, 1

@MDSHIFT function, 1

@MEDIAN function, 1

@MERGE function, 1

@MIN function, 1

@MINRANGE function, 1

@MINS function, 1

@MINSRANGE function, 1

@MOD function, 1

@MODE function, 1

@MOVAVG function, 1

@MOVMAX function, 1

@MOVMED function, 1

@MOVMIN function, 1

@NEXT function, 1

@NPV function, 1

@PARENT function, 1

@PARENTVAL function, 1, 2

@POWER function, 1

@PRIOR function, 1, 2

@PTD function, 1, 2, 3

@RANGE function, 1

@RANK function, 1

@RDESCENDANTS function, 1

@RELATIVE function, 1

@REMAINDER function, 1

@REMOVE function, 1

@ROUND function, 1

@RSIBLINGS function, 1

@SANCESTVAL function, 1

@SHIFT function, 1

@SIBLINGS function, 1

@SLN function, 1

@SPARENTVAL function, 1

@SPLINE function, 1

@STDEV function, 1

@STDEVP function, 1

@STDEVRANGE function, 1

@SUBSTRING function, 1

@SUM function, 1

@SUMRANGE function, 1

@SYD function, 1

@TODATE function, 1, 2

@TREND function, 1, 2

@TRUNCATE function, 1

@UDA function, 1

@VAR function, 1, 2, 3

@VARIANCE function, 1

@VARIANCEP function, 1

@VARPER function, 1, 2, 3, 4

@WITHATTR function, 1, 2

@XREF function, 1, 2

[] (brackets)

in application and database names, 1

in names in scripts and formulas, 1, 2

\ (backslashes)

in application and database names, 1

in dimension and member names, 1

in formulas, 1

in names in scripts and formulas, 1

_ (underscores)

converting spaces to, 1, 2

in array and variable names, 1

in dimension and member names, 1

in report scripts, 1

{} (braces)

in dimension and member names, 1

in names in scripts and formulas, 1, 2

in report scripts, 1, 2

| (vertical bars)

in application and database names, 1

in dimension and member names, 1

~ (tildes)

as character in headings, 1

as codes in data source, 1

~ operators, 1, 2, 3, 4

- (hyphens, dashes, minus signs)

as codes in data source, 1

in data fields, 1

in dimension and member names, 1

in member names, 1

in names in scripts and formulas, 1

in report scripts, 1

- operators

defining member consolidations, 1

in mathematical operations, 1

in unary operations, 1, 2, 3

' (single quotation marks)

in application and database names, 1

in dimension and member names, 1

~ (tildes)

in names in scripts and formulas, 1

Numerics

0 (zero) values

calculating, 1

excluding in time balances, 1

formatting in reports, 1, 2

including in time balances, 1

replacing with labels, 1

skipping, 1, 2

A

.A files, 1

A, average time balance codes in data source, 1

aborted transactions, 1

aborting data loads, 1

@ABS function, 1

absolute values, 1

access, 1, 2, 3

assigning/reassigning user, 1, 2, 3, 4

cells in blocks, 1, 2

checking information about, 1

concurrent, 1

controlling, 1, 2, 3, 4, 5

data sources, 1

replicated partitions and, 1

data targets, 1, 2

defining global levels, 1, 2, 3

getting started tips, 1

global defined, 1

global levels, 1

internal structures optimizing, 1

levels defined in filters, 1

levels for users, 1

linked objects, 1

local, 1

locked data blocks, 1, 2

maintaining data integrity, 1

minimum database level, 1

modifying, 1, 2, 3, 4

multi-user, 1

optimizing, 1, 2

outlines, 1

overriding levels, 1

partitioned databases, 1, 2, 3

troubleshooting, 1

remote databases, 1

restricting, 1, 2

Server Agent, 1

setting database, 1

simultaneous, 1, 2

size considerations and, 1

transactions and, 1, 2

unspecified members, 1

Access databases. See SQL databases

Access DBs setting, 1, 2

Account Dimension Properties page (Dimension Properties), 1

account properties

shared members and, 1

account reporting values, 1

accounts

administrators, 1, 2

users, 1, 2

accounts dimension

calculating first/last values in, 1, 2, 3

calculating time period averages, 1

calculating variance for, 1

calculation passes for, 1

calculations on, 1, 2, 3

creating, 1

currency applications, 1

description, 1

flipping values in, 1

setting, 1

setting member properties in data source, 1

time balance members in, 1

two-pass calculations and, 1

unary operations in, 1

usage examples, 1, 2

usage overview, 1

accounts tags, 1

checking for, 1

@ACCUM function, 1, 2

accumulation of values, 1

activity logs, 1

actual expense vs. budgeted

getting variance, 1, 2, 3

setting properties, 1

actual sales reporting samples, 1, 2

ad hoc calculations, 1

ad hoc currency reporting, 1

add as sibling build method, 1

attribute associations, 1

adding

See also building; creating; defining

alias tables to outlines, 1, 2

aliases to calc scripts, 1

aliases to formulas, 1

comments to calc scripts, 1

comments to dimensions, 1

comments to report scripts, 1

dimensions to outlines, 1, 2, 3, 4, 5

performance considerations, 1, 2

restructuring and, 1

dynamically calculated members to calculations, 1

equations to calc scripts, 1, 2

formulas to calc scripts, 1, 2, 3, 4

formulas to oulines, 1

formulas to report scripts, 1

header information, 1

headers to data sources, 1, 2, 3, 4

headings to reports, 1, 2, 3, 4

members, 1

as children of specified parent, 1

as siblings of lowest level, 1

as siblings with matching strings, 1

build methods, 1

example for, 1, 2

for currency conversions, 1, 2

guidelines for, 1

restrictions, 1

through header information in the data source, 1

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, 1

with common attributes, 1

operators to formulas, 1

page breaks to reports, 1, 2

prefixes or suffixes to fields, 1

records to data sources, 1, 2, 3

shared members to outlines, 1, 2, 3

caution for placing, 1

text to calc scripts, 1

text to formulas, 1

titles to reports, 1

values to empty fields, 1

values to existing values, 1

variables to formulas, 1

variables to report scripts, 1, 2, 3, 4

Adding Dimensions dialog box, 1

addition

consolidation codes in data source, 1

prerequisite for, 1

setting member consolidation properties, 1

addition operator (+)

unary operations, 1

addition operators (+)

defining member consolidations, 1

in unary operations, 1, 2

mathematical operations, 1

member consolidation, 1

ADDUSER command, 1

adjusting buffer size, 1, 2

adjusting column length, 1

Admin page (Partition Wizard), 1

administrative accounts, 1

setting up, 1

administrative requests, 1

administrators, 1

controlling partitioned updates, 1

getting started with Hyperion Essbase, 1, 2

maintenance routines, 1

maintenance tasks, 1, 2

minimizing downtime, 1

usage prerequisites, 1

user-management tasks, 1, 2, 3

.ADW files, 1

AFTER command, 1

usage examples, 1, 2

Agent log file, 1, 2

Agent. See Server Agent

agents, 1

AGENTTHREADS setting, 1

aggregating missing values

in MaxL, 1

aggregation

See also consolidation

formulas vs., 1

missing values

calculations and, 1, 2

effects on calculation order, 1, 2, 3, 4

in calculations, 1

parents, 1

AIX servers. See UNIX platforms

.ALG files, 1

alias combinations

creating, 1

defined, 1

Alias Combinations page (Member Properties), 1

alias field type

in header records, 1

in rules files, 1

nulls and, 1, 2

alias tables

clearing contents, 1

copying, 1

creating, 1, 2

described, 1

importing/exporting, 1, 2

including in report scripts, 1

introducing, 1, 2

loading, 1

maximum per outline, 1

removing from outlines, 1

renaming, 1

reserved generation names in, 1

selecting, 1, 2

setting as current, 1, 2

updating, 1

ALIAS. See alias field type

aliases

adding to calc scripts, 1

adding to formulas, 1

adding to report scripts, 1, 2, 3

caution for, 1

allowing changes, 1

build methods and, 1

creating, 1, 2

attribute dimension build example, 1

based on member combinations, 1

caution for, 1, 2, 3

guidelines for, 1

parent/child dimension build example, 1

defined, 1

displaying, 1, 2

in Calc Script Editor, 1

in Formula Editor, 1

displaying in reports, 1, 2

duplicate generation fields and, 1

editing names, 1

entering in fields, 1

expanding/contracting member list, 1

introducing, 1

maximum characters in names, 1

multiple, 1

shared members and, 1

sorting members by, 1

specifying for Dynamic Time Series members, 1

with embedded blanks, 1

@ALLANCESTORS function, 1

ALLINSAMEDIM command

usage, 1

@ALLOCATE function, 1

allocation

examples, 1, 2, 3, 4

functions, 1

storage, 1, 2

example, 1

Allocation Manager, 1

Allow Application to Start option, 1

Allow Association Chgs option, 1

Allow Commands option, 1

Allow Connects option, 1

Allow Formula Changes option, 1

Allow Moves option, 1

Allow Property Changes option, 1

Allow Updates option, 1

ALLSIBLINGS command

usage, 1

alphabetizing members, 1

alter application (MaxL), 1, 2, 3, 4

alter database (MaxL), 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14

alter system

MaxL, 1

alter system (MaxL), 1, 2, 3, 4, 5

alter user (MaxL), 1, 2, 3, 4

altering. See changing; editing

alternate hierarchies (in Hyperion MBA). See shared members

alternate names. See aliases

ampersands (&)

in calc scripts, 1, 2

in member names, 1

in names in scripts and formulas, 1

in report scripts, 1

analysis, 1

defining objectives, 1

example, 1

getting started tips, 1

optimizing, 1

single-server applications, 1, 2

analyzing database design

guidelines, 1

@ANCEST function, 1

ancestor/descendant relationships, 1

defining calculation order for, 1

@ANCESTORS function, 1

ancestors

checking for, 1

currency conversions and, 1

defined, 1

getting, 1, 2

new members with no, 1

ANCESTORS command

usage, 1

@ANCESTVAL function, 1

anchoring dimensions, 1

AND operator, 1

select/reject criteria, 1, 2

annotating

See also comments

data cells, 1

databases, 1

partitions, 1, 2, 3

.APB files, 1

API (Application Programming Interface)

complete listing of functions, 1

introduction to, 1

API directory, 1

API function calls, 1

API functions, 1

using VBA functions, 1

.APP files, 1

App Access button, 1, 2, 3

APP directory

security file information, 1

Application Access dialog box, 1

Application Copy dialog box, 1

Application Designer access setting, 1, 2, 3

Application Designer privileges, 1

Application Desktop window, 1

application directory, 1, 2

application event log

calculation time, 1

deleting, 1

description of, 1

dimensions calculated, 1

dynamic calculator cache usage, 1

last row committed, 1

viewing, 1

application files, 1

Application Information dialog box, 1

Application Log Viewer. See Log Viewer

Application Manager, 1

adding dimensions, 1

adding members, 1

annotating databases, 1

as client interface, 1

caution for clearing data, 1

changing data compression defaults, 1

changing Hyperion Essbase kernel settings, 1

clearing alias tables, 1

copying

alias tables, 1

applications, 1

databases, 1

objects, 1

outlines, 1, 2

creating

alias tables, 1

applications, 1

databases, 1

rules files, 1

substitution variables, 1

creating calc scripts, 1, 2, 3

creating reports, 1, 2

creating text files, 1

defining calculations, 1

as default, 1

deleting

alias tables, 1

applications, 1

databases, 1

log files, 1, 2

substitution variables, 1

described, 1

enabling two-pass calculations, 1

importing/exporting alias tables, 1, 2

loading data, 1

maintaining security information, 1

moving members, 1

naming generations and levels, 1

opening

outlines, 1, 2

report scripts, 1

overview, 1

removing linked objects, 1

renaming

alias tables, 1

applications, 1

databases, 1

objects, 1

replicating data, 1

restructuring partitioned databases, 1

running calc scripts, 1, 2, 3, 4

saving outlines, 1, 2

selecting

applications, 1

data sources, 1, 2, 3

databases, 1

setting

cache size, 1, 2, 3

current alias table, 1

default calculation, 1

index page size, 1

isolation levels, 1

sorting members, 1

specifying data compression, 1

specifying disk volumes, 1

specifying file size, 1

starting/stopping applications, 1, 2, 3

starting/stopping databases, 1, 2, 3

synchronizing outlines, 1

transferring files from client to server, 1

updating substitution variables, 1

verifying outlines, 1

viewing

and changing user access, 1

applications and databases, 1

linked objects, 1

log files, 1, 2

storage information, 1

Application Programming Interface. See API

application server, 1, 2

Application Settings dialog box

global application access, 1

minimum database access settings, 1

options, 1

specifying application file size, 1

application startup, results of, 1

Application Tools, 1

applications, 1

See also partitioned applications

accessing, 1, 2, 3

analytical vs. transaction processing, 1

associating index files with, 1

associating with calc scripts, 1, 2, 3

building, 1

client-server architecture described, 1

components, 1

copying, 1, 2

copying using MaxL, 1

creating, 1, 2

for currency conversions, 1

for Personal Essbase, 1

prerequisites, 1

required privilege, 1

with Application Manager, 1

creating using MaxL, 1

currency conversions and, 1

customizing, 1, 2

data distribution characteristics, 1

deleting, 1, 2

deleting using MaxL, 1

designing partitioned, 1

deciding which type, 1

scenarios for, 1, 2, 3

designing simple, 1, 2, 3

designing single-server, 1, 2

developing, 1, 2, 3

process summarized, 1

displaying information using MaxL, 1

file types listed, 1

implementing global security, 1, 2

inaccessible, 1

interruptions, 1

loading

with related database, 1

logging errors, 1

maintaining, 1

monitoring, 1, 2

naming rule, 1

not stopping, 1

opening, 1, 2

operations not supported, 1

overview, 1

partitioned

benefits of, 1, 2

choosing when not to use, 1

choosing when to use, 1

porting, 1, 2

creating backups for, 1

redefining information for, 1

to UNIX platforms, 1

renaming, 1

renaming using MaxL, 1

sample, 1, 2

selecting, 1

size considerations, 1

starting, 1, 2, 3

from Server Agent, 1

starting using MaxL, 1

starting/stopping in MaxL, 1

stopping, 1, 2, 3, 4

all opened, 1

archiving and, 1

with related database, 1

stopping using MaxL, 1

storing, 1

viewing, 1

information about, 1, 2, 3, 4

log file contents, 1

Applications list box, 1

Applications page (Server Information), 1

Apply Outline Changes dialog box, 1

applying

See also setting

changes to outlines, 1, 2

locks, 1, 2, 3, 4, 5

privileges to groups, 1

skip properties, 1

APPLYOTLCHANGEFILE command, 1

ARBORDUMPPATH environment variable, 1

ARBORPATH, 1

.ARC files, 1

architecture, 1

client-server features, 1

archive files, 1

restoring from, 1

archiving

data, 1

data targets, 1

Area Definition dialog box

defining linked areas, 1, 2

defining replicated areas, 1

defining transparent areas, 1, 2

Area Specific Member Mapping dialog box, 1

areas

See also partitions

changing shared, 1

defined, 1

Dynamic Time Series members in, 1

linked partitions, 1

mapping to specific, 1, 2

in Partition Wizard, 1

replicated partitions, 1

transparent partitions, 1

Areas page (Partition Wizard), 1, 2, 3

arithmetic operations

currency conversions, 1

formulas and, 1, 2

missing values and, 1

performing on fields, 1

performing on members, 1

prerequisite for, 1

report scripts, 1

specifying in data source, 1

arranging

cells in blocks, 1

data blocks, 1

dimension build

position of fields in rules file, 1

dimensions in outlines, 1

fields, 1, 2

members in dense dimensions, 1

members in outlines, 1, 2

ARRAY command, 1

usage example, 1

arrays, 1

as variables, 1, 2

declaring, 1

naming, 1

ASC command, 1

usage example, 1

ascending sort order, 1

applying to output, 1

members in outlines, 1

ASCII characters ignored in data loads, 1

ASCII files

calc scripts in, 1

creating, 1, 2

cross-platform compatibility, 1

data sources, 1

dumping security information to, 1, 2

loading, 1, 2

multiple, 1

opening, 1

ASCII text, 1, 2

assets, 1

Assign Filters dialog box, 1

assigning

See also defining; setting

access levels to linked objects, 1

aliases to members, 1, 2, 3, 4

based on combinations, 1

attributes to dimensions, 1

filters to users and groups, 1

generic passwords, 1

privileges

global access, 1, 2, 3, 4

to users and groups, 1

properties to dimensions, 1, 2, 3, 4

overview, 1, 2, 3

properties to members, 1, 2

values to member combinations, 1

values to variables, 1

variance reporting properties, 1

Associate Client Outline dialog box, 1

Associate Server Outline dialog box, 1, 2

associating

applications with calc scripts, 1, 2, 3

attributes

automatically, 1

example rules file, 1

in Outline Editor, 1

through dimension build, 1

calc scripts with outlines, 1

databases with calc scripts, 1, 2, 3, 4

databases with reports, 1

filters with outlines, 1

members with report scripts, 1

multilevel attribute dimensions, 1

parents with members, 1

rules files

with data sources, 1

with outlines, 1, 2, 3

asterisks (*)

as codes in data source, 1

in application and database names, 1

in names in scripts and formulas, 1, 2

used as wildcard, 1

ASYM command

entering in report scripts, 1

usage, 1

asymmetric columns

changing headings, 1

creating, 1

dynamically calculating values, 1

in reports, 1

in source data, 1, 2

overriding groupings, 1

asymmetric reports, 1

creating, 1, 2

defined, 1

formatting, 1

symmetric reports vs., 1

at signs (@)

in dimension and member names, 1

in names in scripts and formulas, 1, 2

attaching to databases. See connections

attachments

See also linked reporting objects

limiting size, 1

removing, 1

saving, 1

setting maximum size using MaxL, 1

viewing in Application Manager, 1

@ATTRIBUTE function, 1, 2

attribute associations

allowing changes, 1

base dimensions, 1, 2

field type, 1

lost in cut or copy and paste, 1

requirements, 1

Attribute Calculations dimension

accessing members from, 1

changing member names, 1

default member names, 1

described, 1

instead of consolidation symbols, 1

instead of member formulas, 1

members, default, 1

properties of, 1

retrieving multiple members from, 1

ATTRIBUTE command, 1, 2

usage, 1

attribute dimension

members

using in report scripts, 1

attribute dimensions

associating with base dimensions in Outline Editor, 1

comparison with standard dimensions, 1

creating in Outline Editor, 1

defining in dimension build, 1

deleting members, 1

described, 1, 2

generation or level reference numbers, 1

members

options in dimension build, 1

overview, 1

prefixes and suffixes, 1

preventing creation, 1, 2, 3

multilevel

building and associating, 1

names as field types, 1, 2

outline design, 1

restructuring, 1

summary of dimension building rules, 1

tagging, 1

type, 1

using to avoid redundancy, 1

attribute fields

defining using rules files, 1

position in rules file, 1

attribute parent field type

example, 1

in header records, 1

in rules files, 1

nulls and, 1, 2

attribute values, 1, 2

@ATTRIBUTEBVAL function, 1, 2

attributes

advantages, 1

as values resulting from formulas, 1

associating

automatically, 1

in Outline Editor, 1

through dimension build, 1

associating aliases through dimension build, 1

Boolean type

changing default member names, 1

described, 1

duplicate values, 1

calculating

accessing calculated data, 1

Attribute Calculations dimension, 1

default calculation, 1

Essbase functions, 1

examples, 1

multiple calculations, 1

performance considerations, 1

process, 1

using attributes in formulas, 1

calculation functions, 1

date type, 1

changing the member name format, 1

duplicate values, 1

defined, 1

design considerations, 1

mapping, 1

member name format, 1

member names, 1

numeric type

defined, 1

defining ranges, 1

duplicate values, 1

ranges, 1

size of ranges, 1

process for defining in Outline Editor, 1

setting types, 1

shared member design approach, 1

standard dimension design approach, 1

text type, 1

time-dependent values, 1

types, 1

UDAs

alternative design approach, 1

feature comparison, 1

setting 1

user-defined attributes. See UDAs

using in partitions, 1

@ATTRIBUTESVAL function, 1, 2

@ATTRIBUTEVAL function, 1, 2, 3

ATTRPARENT. See attribute parent field type

ATTRPROD.RUL, 1

.ATX files, 1

audio clips, 1

audit log files, 1, 2

Autoconfigure Dense/Sparse option, 1

automating routine operations, 1

average time balance property, 1

average time balances specified in data sources, 1

averages

Attribute Calculations dimension, 1

determining with formulas, 1, 2

for time periods, 1, 2

reporting examples, 1, 2

setting time balances, 1

@AVG function, 1

Avg member, Attribute Calculations dimension, 1

@AVGRANGE function, 1, 2

B

B, time balance codes in data source, 1

background startup, 1

backing up databases, 1

backslashes (\)

in application and database names, 1

in dimension and member names, 1

in formulas, 1

in names in scripts and formulas, 1

backups

creating archive as, 1

creating by exporting, 1

restoring after system failures, 1

security, 1

.BAK file, 1

.BAK files, 1

balance sheet accounts, 1

bang command (!)

adding to report scripts, 1

terminating reports, 1

.BAS files, 1

base dimensions

associating with attribute dimensions in Outline Editor, 1

defined, 1, 2

member associations, 1

members

associating with attributes in Outline Editor, 1

attribute formulas, 1

attributes, 1

Basic databases. See Demo Basic database; Sample Basic database

BASIC directory, 1

basic equations, 1

basic reporting techniques, 1

creating simple reports, 1, 2

developing free-form reports, 1

editing report scripts, 1, 2, 3, 4

implementing security, 1

opening

report scripts, 1

opening report scripts, 1

running report scripts, 1, 2, 3

saving report scripts, 1

.BAT files, 1

batch files, 1

and ESSCMD scripts, 1

report scripts and, 1

running, 1

batch mode

command-line syntax for, 1

creating scripts for, 1

dimension building and, 1

dynamic calculations and, 1

error-handling, 1

examples

importing and calculating, 1

printing reports, 1

updating SQL scripts, 1

file-name extensions and, 1

MaxL, 1

overview, 1

shutting down server, 1

syntax, 1

updating outlines, 1

when to use, 1

batch processing time, 1

BEFORE command, 1

usage example, 1

BEGINARCHIVE command, 1, 2

partitioned applications and, 1

BIN directory

ESSCMD files, 1

files stored in, 1

bitmap compression, 1

described, 1

estimating block size, 1

overview, 1

specifying, 1

bitmap dimensions, 1

bitmap files, 1

bitmap, calculator cache, 1, 2

bitmaps, 1

black squares (Report Viewer), 1

blank fields

adding values to, 1

in data source, 1

in rules file, 1

blanks. See white space

block calculation mode, 1

block density (defined), 1

block offsets, 1

BLOCKHEADERS command, 1, 2

blocks. See data blocks

.BND files, 1

Boolean

attribute dimension type, 1, 2

attributes

changing default member names, 1

described, 1

duplicate values, 1

expressions in rules files

for select/reject criteria, 1, 2

functions, in formulas, 1, 2

Boolean expressions, 1

for select/reject criteria, 1

grouping, 1

usage example, 1

Boolean operators, 1, 2

BOTTOM command

entering in report scripts, 1, 2, 3

precedence, 1

restrictions, 1, 2

upper limits, 1

usage, 1

usage example, 1

bottom-up

partitioning, 1

bottom-up calculation, 1, 2

transparent partitions, 1

bottom-up ordering

calculations, 1

dynamic builds, 1, 2, 3

examples, 1, 2

bottom-up partitioning

defined, 1

braces ({})

in dimension and member names, 1

in names in scripts and formulas, 1, 2

in report scripts, 1, 2

brackets ([])

in application and database names, 1

in names in scripts and formulas, 1, 2

BRACKETS command, 1, 2

overriding, 1

branches

Calc Script Editor

aliases, 1

dimensions, 1

members, 1

data hierarchies, 1

Formula Editor

aliases, 1

dimensions, 1

members, 1

outlines, 1

sharing members, 1

browser for editing objects, 1, 2

budgets

allocating values, 1, 2

comparing actual to budgeted, 1, 2

example database for forecasting, 1

example for increasing, 1

generating and loading new, 1

getting variance, 1, 2

partitioned applications and, 1

variance reporting and, 1

buffer size

setting using MaxL, 1, 2

buffers, 1, 2

See also caches

extracted data row cells, 1

increasing size, 1

setting internal, 1

sorted data, 1

build methods

adding members

as children of specified parent, 1

as sibling with matching strings, 1

as siblings of lowest level, 1

bottom-up ordering, 1

creating

multiple roll-ups, 1, 2

creating shared members

at different generations, 1, 2

at same generation, 1, 2, 3

including branches, 1, 2

defined, 1

defining parent/child relationship, 1

description, 1

null processing, 1, 2

selecting, 1, 2

supported for associating attributes, 1

top-down ordering, 1

valid field types, 1

BUILDDIM command, 1, 2

building

See also adding; creating

applications, 1

calc scripts, 1, 2, 3

in Calc Script Editor, 1, 2, 3

restrictions, 1

syntax for, 1

with Application Manager, 1

databases, 1, 2, 3

development process for, 1

example for, 1

prerequisites for, 1

dimensions, 1, 2, 3, 4, 5

dynamically. See dynamic builds

example for, 1

guidelines for, 1, 2

prerequisites, 1, 2, 3

restructuring databases and, 1

with data sources, 1, 2, 3, 4, 5

with dynamically calculated members, 1

with rules files, 1, 2, 3, 4

dynamic calculations, 1, 2

restrictions, 1, 2, 3

formulas, 1, 2

with Formula Editor, 1, 2

multiple roll-ups, 1

reports, 1, 2, 3

basic techniques, 1, 2

free-form, 1

with API function calls, 1

shared members dynamically, 1, 2, 3, 4

builds. See dynamic builds

business models

checklist for creating, 1

creating as a part of database design, 1

C

Cache Memory Locking

enabling with Application Manager, 1

enabling with ESSCMD or MaxL, 1

updating, 1

caches

as storage units, 1

calculator, 1, 2, 3

determining size, 1

disabling, 1

getting information about, 1, 2

locking memory for, 1

managing, 1, 2

optimizing read/writes, 1, 2

setting size, 1, 2, 3, 4

with Application Manager, 1, 2

with ESSCMD or MaxL, 1, 2

with Hyperion Essbase kernel, 1, 2

updating, 1, 2, 3

CALC ALL command, 1

block ordering and, 1

currency conversions, 1

dynamic calculations and, 1

dynamically calculated members and, 1

Intelligent Calculation and, 1, 2, 3, 4

partitioned applications and, 1

usage overview, 1, 2, 3

CALC AVERAGE command, 1

CALC COL command. See CALCULATE COLUMN command

CALC command, 1

CALC DIM command, 1

dynamically calculated members and, 1

Intelligent Calculation and, 1, 2, 3, 4, 5

usage examples, 1, 2, 3

CALC FIRST command, 1

CALC LAST command, 1

CALC ROW command. See CALCULATE ROW command

Calc Script button (Application Manager), 1

calc script calculations, 1

Calc Script Editor

building calc scripts, 1, 2, 3

changing scripts, 1

checking syntax, 1, 2, 3

copying scripts, 1

expanding/contracting dimensions, 1

expanding/contracting member branches, 1

finding and replacing text, 1

opening, 1

printing calc scripts, 1

saving calc scripts, 1, 2

searching for members, 1

undoing last action, 1

calc script files, 1, 2

naming, 1, 2

opening, 1, 2

selecting, 1, 2

calc scripts, 1

adding

aliases, 1

comments, 1

equations, 1, 2

formulas, 1, 2, 3, 4

text, 1

aggregating missing values in, 1

applying conditions, 1

attaching to databases, 1

building in Calc Script Editor, 1, 2, 3, 4

calculation order, 1

changing, 1, 2, 3

checking syntax, 1

clearing databases after export, 1

copying, 1, 2

creating with Application Manager, 1

currency conversions, 1, 2

declaring variables in, 1, 2

defined, 1, 2

defining

as default, 1

execution access, 1

deleting, 1, 2

displaying completion notices with, 1

dynamic calculations and, 1, 2

examples, 1, 2, 3, 4

formulas in, 1

generating statistical information, 1

grouping formulas and dimensions, 1, 2, 3, 4

inserting

calculation commands, 1, 2, 3

variables, 1

Intelligent Calculation and, 1, 2, 3, 4

loading, 1, 2, 3

names with special characters, 1, 2

overriding default calculation order, 1

performing multiple calculation passes, 1

examples, 1, 2, 3, 4

printing, 1

restrictions, 1

running, 1

aborted transactions and, 1

calculating Sample Basic, 1

information messages after, 1

on partitioned applications, 1

with Application Manager, 1

with ESSCMD, 1

with MaxL, 1

saving, 1, 2, 3

on client workstations, 1, 2

syntax for

checking, 1, 2

guidelines, 1

troubleshooting, 1

two-pass calculations, 1, 2, 3, 4, 5

UDAs and, 1

undoing changes, 1

unlocking, 1

usage overview, 1, 2, 3

viewing log file contents, 1

CALC TWOPASS command, 1

usage examples, 1, 2, 3

CALCDEFAULT command, 1

CALCHASHTBLMEMORY setting, 1

CALCLINE command, 1

CALCLOCKBLOCK setting, 1

@CALCMODE function, 1

CALCOPTCALCHASHTBL setting, 1

CALCOPTFRMLBOTTOMUP setting, 1

CALCULATE COLUMN command, 1

usage examples, 1, 2

Calculate Database dialog box, 1

canceling operations, 1

running calc scripts, 1

calculate privilege, 1

defined, 1, 2

filters and, 1

CALCULATE ROW command, 1, 2

restrictions, 1

usage examples, 1, 2, 3

calculated columns

adding totals, 1

clearing values, 1, 2

creating, 1, 2, 3

calculated data, 1

filtering, 1

formatting, 1, 2

calculated values vs. input values, 1

calculation commands, 1, 2

computation, 1

control, 1

declaring temporary variables for, 1

functions, custom-defined, 1

iterating through, 1

macros, custom-defined, 1

specifying global settings, 1

calculation scripts. See calc scripts

calculations, 1, 2, 3

See also calc scripts; dynamic calculations

aborted transactions and, 1

account reporting values, 1

across multiple processors, 1

ad hoc, 1

adding formulas to, 1, 2, 3, 4

with Formula Editor, 1, 2

assigning constants, 1

associating with specific database, 1, 2, 3, 4

attributes

accessing calculated data, 1

Attribute Calculations dimension, 1

default calculation, 1

described, 1

examples, 1

multiple calculations, 1

performance considerations, 1

process, 1

using attributes in formulas, 1

basic concepts, 1

block mode, 1

blocks with dirty status, 1

bottom-up, 1, 2

calc scripts vs., 1

caution for changing outlines and, 1, 2

cell mode, 1

checklist for defining, 1

concurrent and memory usage, 1

controlling flow, 1, 2, 3

currency conversions, 1, 2, 3

links and, 1

dates, 1

default, 1

overriding, 1

setting, 1, 2, 3

defining global behavior, 1

defining order, 1

cells, 1, 2

data blocks, 1

dimensions, 1

forward references and, 1

members, 1, 2

designing for optimal, 1

difference between actual and budgeted, 1

displaying completion notices, 1

displaying settings, 1

entire database, 1

executing in MaxL, 1

extending capabilities, 1

failing, 1

first-time, 1

fixing unexpected results, 1, 2

getting current state, 1

getting information about, 1

handling missing and zero values, 1

members across multiple parents, 1

members in outlines, 1

members with different operators, 1

missing values and, 1, 2, 3

monitoring, 1

monthly assets, 1

multiple databases, 1

operator precedence, 1

optimizing, 1, 2

with attributes, 1

with bottom-up calculation, 1

with calc scripts, 1

with calculator cache, 1

with dynamic calculations, 1, 2

with Intelligent Calculation, 1

with interdependent values, 1

with two-pass calculations, 1

overview, 1, 2, 3

partial list of members, 1

partitioned applications

with replicated partitions, 1

with transparent partitions, 1, 2, 3, 4

performance and multi-users, 1

performance, with attributes, 1

performing multiple passes, 1, 2, 3, 4

examples, 1, 2, 3, 4

period-to-date values, 1, 2

preventing delays, 1

recovering, 1

relationships between members, 1

report scripts, 1, 2

examples, 1, 2, 3

rolling averages, 1

running, 1

default, 1

in batch mode, 1, 2, 3

setting the default calc using MaxL, 1

setting up two-pass, 1, 2, 3

shared members, 1

single-server applications, 1, 2, 3, 4, 5, 6

specified dimensions, 1

statistics, 1

stopping, 1

subsets of data, 1, 2, 3

example, 1

with Intelligent Calculation, 1

testing, 1

top-down, 1, 2

types described, 1, 2

using MaxL, 1

variance performance, 1

with a series of dimensions, 1

with a series of member formulas, 1

year-to-date values, 1

calculator cache

as storage unit, 1

bitmap, 1, 2

disabling, 1

maximum size, 1

optimizing, 1, 2

overview, 1

setting size, 1, 2, 3

calculator hash tables, 1, 2

canceling

archiving operations, 1

calculations, 1

changes to calc scripts, 1

ESSCMD operations, 1, 2

captures, 1, 2

carriage return as file delimiter, 1

case conversions, 1, 2

case sensitivity

field type designation in header record, 1

member names, 1

case-sensitive names

converting case, 1, 2

defining selection criteria for, 1, 2

report scripts, 1

setting for database, 1, 2

case-sensitive passwords, 1

case-sensitive searches

Calc Script Editor, 1

Field Properties dialog, 1

Formula Editor, 1, 2

Report Editor, 1

case-sensitivity in ESSCMD, 1

cash flow, 1, 2

catalogs, 1, 2, 3

category conversion property, 1

CCONV command, 1, 2

usage examples, 1, 2

usage overview, 1, 2

CCONV TOLOCALRATE command, 1

CCTRACK setting, 1

cell calculation mode, 1

cells, 1

accessing, 1

simultaneously in different databases, 1

annotating, 1

copying range of, 1

determining calculation order for, 1, 2

examples, 1, 2, 3, 4

empty, 1

caution for storing, 1

linking objects to, 1

mapping to targets, 1

ordering in blocks, 1

partitioning and, 1, 2, 3

removing linked objects, 1

returning unique values for, 1

shaded, 1

centering data, 1, 2

example, 1

centralized data repositories, 1

.CFG files, 1, 2

See also configurations

change log files, 1, 2

contents described, 1

enabling/disabling, 1

format example, 1

overview, 1

restructuring and, 1

setting size, 1

updating, 1

Change Password dialog box, 1

changes

affecting only outlines, 1

applying to outlines, 1, 2

discarding partition, 1

impacting restructures, 1, 2

overriding incremental restructuring, 1

overwritten, 1

relational storage manager and, 1

tracking outline, 1

unable to make, 1

undoing, 1

viewing outline, 1

changing

See also editing; altering

access privileges, 1, 2, 3, 4

alias table names, 1

aliases, 1

attribute associations, 1

calc scripts, 1, 2, 3

consolidations, 1

data, 1, 2, 3

prerequisite for, 1

data values, 1

default storage properties, 1

dimension names, 1

dimension properties, 1, 2, 3, 4

dimensions, 1, 2

default configurations, 1

for currency conversions, 1

formulas, 1, 2

headings in reports, 1

Hyperion Essbase kernel settings, 1, 2

scope and precedence, 1

with Application Manager, 1

with ESSCMD, 1, 2

linked partitions, 1

member combinations for linked objects, 1

member names, 1

members, 1

outlines, 1, 2, 3, 4

caution for, 1, 2, 3

dynamically, 1

for currency conversions, 1

with rules files, 1

passwords, 1

report layouts, 1

security settings, 1, 2

system password, 1, 2

character searches. See searches

character strings

in calculation formulas, 1

character strings. See strings

characters

calc scripts, 1

end-of-file markers and special, 1

forbidden at the beginning of a name, 1

formulas, 1

ignored in data sources, 1

ignored in report extraction, 1

in array and variable names, 1

maximum

in aliases, 1

in application and database names, 1

in application names, 1

in database names, 1

in dimension names, 1

in member names, 1, 2

in URLs, 1

numeric in member names, 1

quoting in scripts and formulas, 1, 2

valid in numeric data fields, 1

checking

disk space, 1

forward references, 1

syntax

Calc Script Editor, 1, 2, 3

Formula Editor, 1, 2

check-out facility, 1

.CHG files, 1, 2

updating, 1

child

See also parent/child relationships

adding as member of specified parent, 1

as only member (implied sharing), 1

calculation order for outlines, 1

checking for, 1

consolidation properties and, 1

currency conversions and, 1

defined, 1

dimension as, 1

member as, 1, 2

rolling up, 1

shared member as, 1

child field type

in header records, 1

in rules files, 1

sharing members, 1, 2, 3

child processes, 1

CHILD. See child field type

@CHILDREN function, 1

CHILDREN command, 1

entering in report scripts, 1

usage, 1

choosing

alias tables, 1, 2

applications for loading, 1

with ESSCMD, 1

build methods, 1, 2

calc script files, 1, 2

data sources, 1, 2, 3, 4, 5

using Windows, 1

data targets, 1

data to partition, 1, 2, 3

databases for loading, 1

with ESSCMD, 1

dimension type, 1, 2, 3, 4

guidelines for, 1

fields, 1

members

for dynamic calculations, 1

members for column groupings, 1

members for dynamic calculations, 1, 2

members for report scripts, 1, 2, 3

from Dynamic Time Series, 1

with ATTRIBUTE command, 1

with Boolean operators, 1

with conditions, 1

with substitution variables, 1

with TODATE command, 1

with UDAs, 1

with wildcards, 1

with WITHATTR command, 1

multiple dimensions and members, 1

multiple files, 1, 2

multiple members, 1

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, 1

values for dynamic calculations, 1, 2

guidelines for, 1, 2

clean status

caution for sparse dimensions, 1

clearing data and, 1

Intelligent Calculation and, 1

marking blocks with, 1, 2

partial calculations and, 1

Clear Alias Table dialog box, 1

Clear Data Combinations page (Data Load Settings), 1

CLEARALLROWCALC command, 1

CLEARBLOCK command, 1, 2

CLEARBLOCK DYNAMIC command, 1, 2, 3

CLEARDATA command, 1

partitioned applications and, 1

usage overview, 1, 2

clearing

See also deleting

alias tables, 1

data, 1, 2, 3, 4

caution, 1

in calculated columns, 1, 2

locks, 1

log file contents, 1, 2

member combinations, 1

values in transparent partitions, 1

CLEARLOGFILE setting, 1, 2

CLEARROWCALC command, 1

CLEARUPDATESTATUS command, 1

client

interfaces

accessing linked objects and, 1

workstations

as used in Hyperion Essbase, 1

caution for loading data from, 1

troubleshooting connections, 1

client interfaces, 1

client window, 1

client workstations

caution for improper shutdown, 1

deleting calc scripts, 1

recovering from improper shutdowns, 1

writing calc scripts to, 1, 2

clients, 1, 2, 3

communicating with server, 1

configuring, 1

types described, 1, 2

client-server applications

See also single-server applications

development guidelines, 1

overview, 1

client-server model, 1, 2, 3

Close dialog box

saving partition definitions, 1

closing

See also exiting; quitting; stopping

applications, 1, 2, 3, 4

archiving and, 1

multiple simultaneously, 1

with related database, 1

databases, 1, 2, 3

Log Viewer, 1

Partition Wizard, 1

.CNT files, 1

codes in data source

setting member properties, 1

COLCALC1.REP, 1

COLCALC2.REP, 1

COLCALC3.REP, 1

COLGROUP.REP, 1

COLHEADING command, 1

Collapse to Ancestor command, 1

collapsing

alias member lists, 1

Calc Script Editor lists, 1

Formula Editor lists, 1

outline hierarchies, 1

colons (:)

in application and database names, 1

in formulas, 1

in names in scripts and formulas, 1, 2

column calculation commands, 1

COLUMN command

entering in report scripts, 1

column formatting commands, 1, 2, 3, 4

column headings

adding to calculated columns, 1

adding to reports, 1, 2

changing, 1

defined, 1

displaying, 1

for loading asymmetric columns, 1

multi-line, 1

names truncated, 1

repeating, 1

SQL data sources, 1

suppressing, 1

column widths, 1

columns

See also fields

adjusting length, 1

calculating in reports, 1, 2

creating asymmetric, 1

creating calculated, 1, 2

defining as fields, 1

fixed-width, 1

formatting, 1

formatting for data load, 1, 2

mapping specific fields only, 1

nesting in reports, 1

numbering, 1

ordering in data sources, 1

overriding grouping in reports, 1

parent/child data sources, 1

replacing empty fields with text, 1

restricting number of, 1

setting as data field, 1

switching with rows, 1

symmetry in reports, 1

using attributes in, 1

combining fields. See joining fields

command prompt, 1

command syntax, 1

command-line interface

See also ESSCMD; server console

ESSCMD, 1

running batch files, 1

commands, 1

See also specific command

calculation types listed, 1

case sensitivity, 1

caution for processing, 1

computation, 1

control, 1

data extraction, 1, 2, 3

declaring temporary variables for, 1

displaying help for, 1

entering in ESSCMD scripts, 1

entering in report scripts, 1

ESSCMD syntax, 1

global calculation settings, 1

iterating through, 1

member selection, 1, 2

page layout, 1, 2

performance-related, 1

report formatting, 1, 2, 3, 4, 5

caution for usage, 1, 2

report output, 1

Server Agent, 1

sorting, 1, 2

startup in server console, 1

commas (,)

as file delimiter, 1

displaying in reports, 1

in application and database names, 1

in data fields, 1

in dimension and member names, 1

in formulas, 1

in header records, 1

in member combinations, 1

in names in scripts and formulas, 1, 2

suppressing in reports, 1, 2

COMMAS command, 1, 2

overriding, 1, 2

comment fields, 1

comments

See also annotating

adding to dimensions, 1

adding to members, 1

calc scripts, 1

display options, 1

report scripts, 1

storing, 1

viewing in Application Manager, 1

commission, 1, 2, 3

returning from calc scripts, 1

Commit Block setting, 1, 2

Commit Row setting, 1, 2, 3

commits, 1

data loads failing and, 1, 2

initiating, 1

managing, 1

rollbacks and, 1

setting isolation level, 1, 2

with ESSCMD, 1, 2

updating isolation level, 1

committed access

about, 1

caution for, 1

defined, 1

locks and, 1, 2, 3

rollbacks and, 1

setting, 1, 2, 3

common currency, 1

communications

client-server models, 1, 2, 3

communications protocols, 1

Company database

provided with Hyperion Essbase, 1

comparing

data values, 1, 2, 3

timestamps for outlines, 1

compilers, 1, 2

complete loads, 1

completion notices, 1

complex formulas, 1, 2, 3

@COMPOUND function, 1

compounded interest, 1

@COMPOUNDGROWTH function, 1

compression, 1

checking compression ratio, 1

enabling/disabling, 1

estimating block size, 1

fragmentation allowance, 1, 2

optimal configuration, 1

overview, 1

processes described, 1

ratio, 1

repetitive values, 1, 2, 3

specifying, 1, 2

types defined, 1

updating, 1

values (ESSCMD), 1

viewing settings information, 1

compression settings

changing using MaxL, 1

computing data relationships, 1

@CONCATENATE function, 1

concatenating fields, 1

concurrent calculations, 1, 2

overview, 1

conditional blocks, 1

conditional equations, 1

conditional operators, 1, 2

conditions

adding to report scripts, 1, 2

examples, 1, 2, 3

logical, 1, 2

setting for ESSCMD, 1

specifying

for data loads, 1, 2

in formulas, 1, 2

testing, 1, 2

configurable variables, 1

setting, 1

configuration files, 1, 2

configurations

activating change logs, 1

activating outline change log, 1, 2

changing, 1

checking, 1

clearing log files, 1, 2

clients, 1

controlling log file contents, 1

currency calculations, 1

database, 1

dimensions

automatic, 1, 2, 3

changing default setting, 1

determining optimal, 1, 2

enabling incremental restructuring, 1

Hyperion Essbase kernel settings and, 1

Intelligent Calculation, 1

logging spreadsheet updates, 1

resetting error log

files, 1

limits, 1

setting number of threads, 1

setting outline change file size, 1

viewing settings information, 1, 2

Confirm Delete dialog box, 1, 2

Confirm Password text box, 1, 2

Confirmation dialog box, 1

Connect page (Partition Wizard), 1

connection passwords, 1

connections

communications protocols, 1

databases with data cells, 1

losing, 1

multiple servers, 1

partitioned applications, 1, 2, 3

preventing system failures, 1, 2

terminating, 1

for specific user, 1, 2

troubleshooting, 1

Connections dialog box, 1

consecutive values, 1

consistency. See data integrity

console. See server console

consolidation, 1, 2

changing, 1

codes in data source, 1

default order, 1

defined, 1

defining for members, 1, 2

display options, 1

excluding members from, 1, 2

fixing unexpected results, 1, 2

operators listed, 1

performance considerations, 1

restrictions, 1

specifying requirements for, 1

consolidation paths

defining, 1, 2

checklist for, 1

consolidation properties

described, 1

setting, 1, 2

shared members and, 1

consolidations (in Hyperion MBA). See defaults, calculations

constants, 1, 2

contracting. See collapsing

control information, 1

conventions. See naming conventions

conversions, 1

See also currency conversions

case, 1, 2

positive/negative values, 1

white space

in data loads, 1

to underscores in data load, 1

converting

dates, 1

spaces to underscores, 1

coordinates (data values), 1

Copy Alias Table dialog box, 1

Copy Filter dialog box, 1

Copy Group dialog box, 1

Copy to Server Object dialog box, 1

Copy User dialog box, 1

COPYAPP command, 1

COPYDB command, 1, 2, 3

COPYFILTER command, 1

copying

See also duplicating; replicating

alias tables, 1

applications, 1, 2

base dimension members, 1

calc scripts, 1

data, 1, 2, 3, 4, 5

database outlines, 1

databases, 1, 2

filters, 1

from data targets, 1

objects, 1

outline files, 1, 2, 3

outlines

with Application Manager, 1

security profiles, 1, 2

text

in calc scripts, 1

in formulas, 1

in report scripts, 1

@CORRELATION function, 1

correlation coefficient, calculating, 1

corrupted data, 1, 2

operations causing, 1

cost of goods, 1

example for allocating, 1

@COUNT function, 1

Count member, Attribute Calculations dimension, 1

count, calculating, 1

country dimension

creating, 1

currency applications, 1

description, 1

specifying, 1

usage overview, 1

country-specific data. See locales,

.CPL files, 1

crashes

getting information about, 1

minimizing, 1, 2

recovering from, 1, 2, 3

suggested procedures, 1

restructuring and, 1

transaction rollbacks and, 1

Create Alias Table dialog box, 1

create application (MaxL), 1, 2

create blocks on equations

setting in MaxL, 1

Create Blocks on Equations option, 1

Create Currency Database dialog box, 1

create database (MaxL), 1, 2, 3, 4

Create Field Using Join dialog box, 1, 2

Create Field Using Text dialog box, 1

create group (MaxL), 1

create location alias (MaxL), 1

Create New Application dialog box, 1, 2

Create New Database dialog box, 1, 2

create user (MaxL), 1

Create/Delete Applications privilege type, 1

Create/Delete Users/Groups privilege type, 1

CREATEAPP command, 1

CREATEDB command, 1

CREATEGROUP command, 1

CREATELOCATION command, 1

CREATEUSER command, 1

CREATEVARIABLE command, 1

creating

See also adding; building

alias combinations, 1

alias tables, 1, 2

aliases, 1, 2

based on member combinations, 1

caution for, 1, 2, 3

guidelines for, 1

applications, 1, 2

for currency conversions, 1

for Personal Essbase servers, 1

prerequisites, 1

required privilege for, 1

with Application Manager, 1

backups, 1, 2

data blocks, 1

data load rules, 1

database outlines, 1, 2, 3, 4

example for, 1

from data sources, 1

guidelines for, 1

prerequisites for, 1

with Outline Editor, 1, 2

databases, 1, 2, 3

for Personal Essbase servers, 1

process summarized, 1

with Application Manager, 1

Dynamic Calc And Store members, 1

Dynamic Calc members, 1

ESSCMD script files, 1, 2

fields, 1, 2, 3

with joins, 1, 2

filters, 1, 2

for partitioned databases, 1, 2

formulas, 1, 2

examples, 1, 2, 3

syntax for, 1

with Formula Editor, 1, 2

writing equations, 1

header records, 1, 2

linked partitions, 1, 2

linked reporting objects, 1

member groups, 1, 2

multiple roll-ups, 1, 2

outline files, 1

outlines

for currency conversions, 1

outlines for currency conversions, 1

partition definition files, 1

partitions, 1, 2, 3, 4, 5

for currency conversions, 1, 2

process summarized, 1

queries, 1

replicated partitions, 1, 2, 3

report files, 1

report scripts, 1, 2

basic techniques, 1, 2

in ESSCMD, 1

in MaxL, 1

parts described, 1

with Application Manager, 1

rules files, 1, 2

process overview, 1

scripts for batch processing, 1

shared members, 1, 2, 3, 4

for different generations, 1, 2

for same generation, 1, 2, 3

guidelines for, 1, 2

with Outline Editor, 1

with rules files, 1

shared roll-ups, 1

substitution variables, 1

text files, 1, 2

trace files, 1, 2

transparent partitions, 1, 2

two-dimensional reports, 1, 2

UDAs, 1, 2

user groups, 1, 2, 3

cross-dimensional members

in formulas, 1, 2, 3, 4

cross-dimensional operator (->), 1, 2

inserting in calc scripts, 1

inserting in formulas, 1, 2

overview, 1, 2

usage examples, 1, 2

crosstab defined, 1

.CSC files, 1, 2, 3

cubes, 1, 2

CURCAT. See currency category field type

@CURGEN function, 1

CURHEADING command, 1

@CURLEV function, 1

curly braces ({ }). See braces ({ })

CURNAME. See currency name field type

currency

ad hoc report, 1

defining country-specific, 1

effects of adding new markets, 1

exchange rates, 1, 2, 3

calculation options, 1

formatting in reports, 1

currency applications

creating, 1

overview, 1, 2, 3

sample, 1

currency category, 1

dimension (example), 1

currency category field type

in header records, 1

in rules files, 1

nulls and, 1, 2

CURRENCY command, 1

overriding, 1

usage overview, 1

Currency Conversion

description of product, 1

currency conversions, 1

adding members, 1, 2

base to local exchange, 1

calculating in report scripts, 1

creating outlines for, 1, 2, 3

creating partitions for, 1, 2

defining, 1

dynamic calculations and, 1

getting information about, 1

Intelligent Calculation and, 1

keeping local and converted values, 1

links and calculating, 1

mathematical operations, 1

overview, 1

overwriting local values, 1

recovering from errors, 1

reporting, 1

running, 1, 2, 3

saving outline changes, 1, 2

suppressing in reports, 1

tagging dimensions for, 1

currency database (defined), 1

currency database types, 1

currency fields, 1

Currency Name dimension (example), 1

currency name field type

in header records, 1

in rules files, 1

nulls and, 1, 2

currency names, 1, 2, 3

defining, 1, 2

Currency page (Database Information), 1

Currency page (Database Settings), 1, 2

Currency Partition dimension, 1, 2, 3

creating, 1

usage overview, 1

currency partition dimension

description, 1

currency partitions, 1

caution for transparent, 1

creating, 1

currency sample databases, 1

linking, 1

currency symbols, 1

Currency Time dimension (example), 1

Currency Type dimension (example), 1

@CURRMBR function, 1

@CURRMBRRANGE function, 1

custom-defined functions, 1

function category, 1

using in formulas, 1

memory considerations, 1

performance considerations, 1

validating, 1

custom-defined macros, 1

customizing

applications, 1, 2

Data Prep Editor, 1

file delimiters, 1

Hyperion Essbase kernel, 1, 2

Outline Editor, 1, 2, 3, 4

page layouts, 1, 2

examples, 1, 2

user interface, 1

views, 1

cutting text

Calc Script Editor, 1

Formula Editor, 1

Report Editor, 1

D

dashes (-)

in dimension and member names, 1

in member names, 1

in names in scripts and formulas, 1

in report scripts, 1

data, 1, 2

accessing. See access

archiving, 1

calculated vs. input, 1

categorizing. See dimensions

centering in reports, 1, 2

example, 1

changing, 1, 2, 3

prerequisite for, 1

clearing, 1, 2, 3, 4, 5

in calculated columns, 1, 2

computing relationships, 1

controlling flow, 1

copying, 1, 2, 3, 4, 5

corrupted, 1, 2

operations causing, 1

derived, 1

developing logical structures for, 1

distribution characteristics, 1

entering in data sources, 1, 2

exporting, 1, 2, 3

for backups, 1

into other forms, 1

reporting example, 1

exporting using MaxL, 1

exporting using MaxL or ESSCMD, 1

importing, 1, 2

importing into databases using MaxL, 1

improving access to, 1, 2

in targets, 1

irrelevant, 1

loading, 1

aborted transactions and, 1

description, 1, 2

dynamic calculations and, 1

for testing purposes, 1

from external sources, 1, 2, 3, 4

from partitioned applications, 1, 2, 3

from rules files, 1

getting information about, 1

incrementally, 1

missing values and, 1

optimizing, 1, 2, 3, 4

overview, 1, 2, 3, 4, 5

prerequisites, 1, 2

restrictions, 1, 2, 3, 4

supported formats, 1

tips, 1, 2

troubleshooting problems with, 1

unauthorized users and, 1

managing, 1

manipulating remote, 1

missing, 1

not associated with members, 1

organizing, 1

partitioning guidelines, 1, 2, 3

pivoting, 1

protecting, 1, 2

recalculating, 1, 2

after exporting, 1

after member name changes, 1

after repositioning members, 1

Dynamic Calc And Store members, 1

examples, 1

for Personal Essbase servers, 1

in sparse dimensions, 1, 2

Intelligent Calculation and, 1, 2

two-pass calculations and, 1

referencing in dimensions, 1, 2, 3

refreshing, 1

reloading exported, 1

replicating, 1, 2

reporting combinations, 1, 2

retrieving, 1

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, 1

time-sensitive, 1

transactions and redundant, 1, 2

validating, 1

viewing, 1, 2, 3

in data targets, 1

with Data Prep Editor, 1, 2

data analysis, 1

defining objectives, 1

example, 1

getting started tips, 1

optimizing, 1

single-server applications, 1, 2

data blocks, 1, 2, 3

accessing locked, 1, 2

as multidimensional arrays, 1

calculating dirty, 1

calculating values in, 1, 2

caution for partial calculations, 1

defining calculation order, 1

calculations and, 1

categorizing, 1

checking characteristics of, 1

checking structural integrity, 1

clearing values, 1, 2

compressing, 1, 2, 3

creating from Intelligent Calculations, 1

defined, 1

exporting, 1

getting size, 1

locking, 1, 2, 3

with committed access, 1, 2

with uncommitted access, 1

managing, 1

marking as clean/dirty, 1, 2

ordering, 1

removing, 1

renumbering, 1

restructuring, 1, 2, 3

retrieving, 1, 2, 3

setting transactions for, 1, 2

size considerations, 1, 2, 3, 4

storing, 1

two-dimensional example, 1

updating, 1

viewing locks, 1

with no values, 1

data cache, 1

as storage unit, 1

defined, 1

determining size, 1

setting size, 1, 2

with Application Manager, 1

with ESSCMD or MaxL, 1

with Hyperion Essbase kernel, 1

updating, 1, 2

data cells. See cells

data compression, 1

changing using MaxL, 1

checking compression ratio, 1

enabling/disabling, 1

estimating block size, 1

fragmentation allowance, 1, 2

optimal configuration, 1

overview, 1

processes described, 1

ratio, 1

repetitive values, 1, 2, 3

specifying, 1, 2

types defined, 1

updating, 1

values (ESSCMD), 1

viewing settings information, 1

data consistency. See data integrity

data coordinates, 1

data extraction, 1, 2

characters ignored, 1

data extraction commands, 1, 2

defined, 1

data fields

defined in data source, 1

defining columns as, 1

entering data, 1

formatting, 1, 2

in data sources, 1, 2

invalid, 1

reversing values in, 1

with no values, 1, 2

data file cache

as storage unit, 1

defined, 1

setting size

with Application Manager, 1

with Hyperion Essbase kernel, 1

updating, 1

Data File Properties dialog box

defining header information, 1

mapping fields, 1

setting file delimiters, 1

undoing field operations, 1

data files

See also files

caution for recovery and, 1

cross-platform compatibility, 1

estimating size, 1, 2

opening, 1, 2, 3

replicating, 1

restructuring, 1, 2

spanning multiple volumes, 1

storage allocation and, 1

storing, 1

data filters, 1

assigning, 1

copying, 1

creating, 1, 2, 3, 4

defining in Application Manager, 1, 2

editing, 1

inheriting, 1, 2, 3

overlap conflicts, 1, 2

overriding, 1, 2

overview, 1, 2

removing, 1

renaming, 1

restrictions on applying, 1

saving, 1

viewing existing, 1

write access to database, 1

data hierarchies, 1

relationships defined, 1, 2

data integrity, 1, 2

checks failing, 1

committed access and, 1

maintaining, 1

retaining duplicate data, 1

uncommitted access and, 1

validating, 1

data load

fields, 1

free-form, 1

load rules in the source data, 1

mode, 1

parent members, 1

parents and missing values, 1

rules

creating, 1

defined, 1

described, 1

when to use, 1

Data Load Completed dialog box, 1, 2, 3

Data Load dialog box, 1, 2

building dimensions, 1

changing outlines, 1

selecting data sources, 1, 2, 3

Data Load Properties page

naming fields, 1

Data Load Rules button (Application Manager), 1

Data Load Settings dialog box

changing data values, 1

clearing existing values, 1

defining header information, 1

defining selection criteria, 1

flipping field values, 1

Data Manager, 1

overview, 1

data points. See cells

Data Prep Editor

building dimensions, 1, 2, 3, 4

creating rules files, 1, 2

customizing, 1

defining header information, 1

dimension building mode, 1

displaying

dimension building fields, 1

records, 1

enabling/disabling toolbar, 1

loading data sources, 1, 2, 3

opening, 1, 2

selecting data load or dimension build view, 1

validating rules files, 1, 2

viewing rules files, 1

window, 1

data redundancy overhead, 1, 2

Data Replication dialog box, 1

data repositories, 1

data sets, 1

copying portions, 1

distribution, 1

non-typical, 1

data sources

accessing data, 1

replicated partitions and, 1

adding headers, 1, 2, 3, 4

adding records, 1, 2, 3

altering to build dimensions, 1

appending information to, 1

associating with rules files, 1

building dimensions, 1, 2, 3, 4, 5

changing case, 1

changing outlines, 1

copying, 1

creating outlines with, 1

creating shared roll-ups from multiple, 1

debugging, 1

defined, 1

defining, 1

for multiple partitions, 1

for replicated partitions, 1

for transparent partitions, 1, 2

entering data, 1, 2

field types, 1

described, 1, 2

invalid, 1

fixing

no loads, 1

partial loads, 1

for dimension builds, 1

formatting, 1, 2, 3, 4, 5

overview, 1

free-form, 1, 2

optimizing, 1

identifying, 1

load failing, 1

loading, 1, 2, 3, 4

in Data Prep Editor, 1, 2, 3

prerequisites, 1

troubleshooting problems, 1, 2

logging into, 1

losing connections to, 1

mapping information, 1

mapping members, 1

linked partitions, 1, 2

replicated partitions, 1, 2

transparent partitions, 1, 2

member names differing from targets, 1

members with no ancestor specified, 1

missing members, 1, 2

numbering members, 1

opening, 1

opening in Data Prep Editor, 1

optimizing, 1, 2

ordering

columns, 1

fields, 1, 2

records, 1, 2, 3

overview, 1, 2, 3

partitioning information for, 1

propagating outline changes, 1, 2, 3

process summarized, 1, 2

remote data retrievals and, 1

removing members, 1

replicating derived data, 1

replicating members, 1

replicating partial sets, 1

selecting, 1, 2

how to, 1

SQL, 1

using Application Manager, 1

using Windows, 1

selecting text or spreadsheet, 1

setting member properties, 1

specifying

field type, 1

specifying shared areas, 1, 2, 3

supported, 1

unavailable, 1, 2

updating changes to, 1, 2

validating rules files from, 1

viewing, 1, 2

with different values, 1

with new member lists, 1

Data Storage dialog box, 1, 2

data storage property

setting, 1

data storage. See storage; Hyperion Essbase kernel

data subsets

calculating, 1, 2, 3

example, 1

with Intelligent Calculation, 1

clearing, 1

copying, 1

copying to Personal Essbase, 1

prerequisites, 1

loading, 1, 2

data targets

accessing data, 1, 2

archiving, 1

calculations and, 1, 2

changing data in, 1

changing outlines, 1

copying from, 1

defined, 1

defining

for multiple partitions, 1

for replicated partitions, 1

for transparent partitions, 1, 2

logging into, 1

losing connections to, 1

mapping information, 1

mapping members to data sources

linked partitions, 1, 2

replicated partitions, 1, 2

specifying specific areas, 1

transparent partitions, 1, 2

member names differing from source, 1

missing data, 1

partitioning information for, 1

propagating outline changes, 1, 2, 3

process summarized, 1, 2

selecting, 1

specifying shared areas, 1, 2, 3

updating changes to, 1, 2, 3

viewing data in linked partitions, 1

data values, 1, 2, 3, 4

See also missing values; range of values

accumulating, 1

assigning

to member combinations, 1

to variables, 1

averaging

for time periods, 1, 2, 3

non-zero values and, 1

reporting examples, 1, 2

with formulas, 1, 2

changing, 1

comparing, 1, 2, 3

compression and repetitive, 1, 2, 3

defined, 1

displaying specific, 1

distribution among dimensions, 1

duplicating, 1

dynamically calculating, 1, 2, 3

entering in empty fields, 1

filtering, 1

flipping, 1

formatting in reports, 1, 2

examples, 1

identical, 1

inconsistent, 1

incorrect, 1

interdependent, 1

iterating through, 1

looking up, 1

measuring, 1

member with no, 1

negative, 1

flipping, 1

variance as, 1

nulls, 1, 2

optimizing in sparse dimensions, 1

ordering in reports, 1, 2

example, 1

out of range, 1

overwriting, 1, 2, 3

for currency conversions, 1

placing retrieval restrictions, 1, 2

example, 1

reading multiple ranges, 1

referencing, 1, 2, 3, 4, 5

retrieving

dynamically calculated, 1, 2, 3, 4

from other databases, 1

from remote databases, 1, 2, 3

retrieving for reports, 1

setting maximum rows allowed, 1

with conditions, 1, 2, 3, 4

rolling up, 1

rounding, 1, 2

scaling, 1

setting maximum number of, 1

storing, 1, 2

temporary, 1, 2

truncating, 1

unable to change, 1

unexpected, 1

unique, 1

assigning #MISSING values to, 1

Intelligent Calculation and, 1

unknown, 1

variables as, 1

void, 1

Data Values page (Data Load Settings)

adding to or subtracting from existing values, 1

flipping field values, 1

Database Access dialog box, 1

Database Access options (Database Settings), 1

database administrators. See administrators

database cells, 1

accessing, 1

simultaneously in different databases, 1

annotating, 1

copying range of, 1

determining calculation order for, 1, 2

examples, 1, 2, 3, 4

empty, 1

caution for storing, 1

linking objects to, 1

mapping to targets, 1

ordering in blocks, 1

partitioning and, 1, 2, 3

removing linked objects, 1

returning unique values for, 1

shaded, 1

Database Copy dialog box, 1

database design

attribute dimensions, 1

Database Designer privilege. See DB Designer privilege

database directory, 1

database files, 1

Database Filter layer, 1, 2

Database Information dialog box, 1, 2, 3, 4

performance checks, 1

Database Locks dialog box, 1

database outlines. See outlines

Database Settings dialog box

aggregation of missing values, 1

calc options settings, 1

changing Hyperion Essbase kernel settings, 1, 2

global database access, 1

scope of storage settings, 1

setting

currency conversion links, 1

retrieval buffer size, 1, 2, 3

settings described, 1

two-pass calculations, 1

databases

See also data; partitioned databases

accessing, 1, 2, 3, 4

remote, 1

analytical vs. transaction processing, 1

annotating, 1

associating

with calc scripts, 1, 2, 3, 4

with reports, 1

associating index files with, 1

attaching to. See connections

backing up, 1

backing up using MaxL, 1

building, 1, 2, 3

development process for, 1

example for, 1

prerequisites for, 1

calculating multiple, 1

checking

operational status, 1

which databases are currently running, 1

checklist for analyzing, 1

closing related application simultaneously, 1

configuring, 1

contents for typical, 1

copying, 1, 2

copying using MaxL, 1, 2

creating, 1, 2, 3

for Personal Essbase, 1

process summarized, 1

with Application Manager, 1

creating accounts for, 1, 2, 3

creating using MaxL, 1

currency conversions and, 1

deleting, 1

deleting using MaxL, 1

determining scope, 1

displaying information in MaxL, 1

displaying statistical information, 1

distributing. See partitioning

fine tuning, 1

identifying data sources, 1

implementing global security, 1, 2, 3, 4

linking related, 1, 2

loading applications simultaneously, 1

minimizing downtime, 1

mission-critical, 1

multidimensional defined, 1

naming rules, 1

navigating between, 1, 2

non-contiguous portions in, 1

opening, 1, 2

optimizing access, 1, 2

to large, 1

optimizing retrieval, 1

partitioning, 1, 2

guidelines for, 1, 2

sample applications showing, 1

planning prerequisites, 1

processing requests, 1, 2

protecting data, 1, 2

rebuilding, 1

reducing size, 1

related information among, 1

reloading, 1

removing

partitions, 1

removing dimensions, 1

restructuring and, 1

renaming, 1

renaming using MaxL, 1

restructuring, 1, 2

changing outlines and, 1, 2

dynamic calculations and, 1

immediately, 1, 2

in partitioned applications, 1

Intelligent Calculation and, 1, 2

process described, 1, 2

sample, 1, 2

selecting, 1

with ESSCMD, 1

size determinations, 1, 2, 3, 4

slicing, 1

splitting, 1, 2

starting, 1

from Server Agent, 1

stopping, 1, 2, 3

testing design, 1

updating, 1, 2

viewing

in Application Manager, 1

information about, 1, 2

with differing dimensionality, 1

Databases list box, 1

DATACOPY command, 1, 2

currency conversions and, 1

partitioned applications and, 1

usage overview, 1, 2

DATAERRORLIMIT setting, 1, 2

DATALOAD.ERR

See also error log files

renaming, 1

setting, 1

using to debug data load problems, 1

DATALOAD.TXT, 1

date

attribute dimensions

changing the member name format, 1

tagging, 1

attributes

defined, 1

duplicate values, 1

date calculations, 1, 2

examples, 1

dates, in calculation formulas, 1

day-to-date calculations, 1

.DB files, 1

DB Designer privilege, 1, 2, 3

dBASE data files, 1

dBASE databases. See SQL databases

dBASE index files, 1

.DBB files, 1

.DBF files, 1

.DDB files, 1, 2, 3

.DDM files, 1

.DDN files, 1

deadlocks, 1

deallocation (storage), 1, 2

debugging data loads, 1

debugging tool, 1

DECIMAL command, 1, 2, 3

decimal points, 1

declaring

arrays, 1

variables, 1, 2, 3

@DECLINE function, 1

default calculation

setting in MaxL, 1

Default table (aliases), 1

updating during builds, 1

defaults

aggregating missing values, 1

application settings, 1

cache size, 1

calculations, 1

setting, 1, 2, 3

calculator cache, 1

change log file size, 1

compression, 1

changing, 1

currency type, 1

data storage, 1, 2, 3

dimension properties, 1

dynamic builds, 1

error log file locations, 1

for database settings, 1

Intelligent Calculation, 1

login information, 1

maximum lock time, 1

member selection for reports, 1

members names, 1

retrieval buffers, 1, 2

time balance tags, 1

variance reporting tags, 1

Define Attribute Dimensions dialog box, 1

define export filenames, 1

Define Filter dialog box, 1

Define SQL dialog box, 1

defining

See also adding; creating; setting

a single data value, 1

area-specific mappings, 1

calc script as default, 1

calculation order, 1

cells, 1, 2

data blocks, 1

dimensions, 1

dynamically calculated values, 1, 2

forward references and, 1

members, 1, 2

calculations (checklist for), 1

columns as fields, 1

consolidation paths, 1, 2

checklist for, 1

currency conversions, 1

currency names, 1

custom attributes, 1

data sources, 1

for multiple partitions, 1

for replicated partitions, 1

for transparent partitions, 1, 2

data storage properties, 1

data targets

for multiple partitions, 1

for replicated partitions, 1

for transparent partitions, 1, 2

dimension properties, 1, 2, 3, 4

caution for two-pass tags, 1

dimensions as flat, 1, 2

dynamic calc properties, 1

field type, 1, 2

filters in Application Manager, 1, 2

global access levels, 1, 2, 3

member properties, 1, 2, 3, 4

as label only, 1

members as label only, 1

multiple layout reports, 1

page layouts, 1, 2, 3

parent/child relationships, 1

partitioned areas

linked partitions, 1, 2

replicated partitions, 1, 2, 3

transparent partitions, 1, 2, 3

partitions, 1, 2, 3

linked, 1, 2

multiple, 1

replicated, 1, 2, 3

transparent, 1, 2, 3

with Partition Wizard, 1, 2, 3, 4

selection/rejection criteria, 1, 2

multiple for single field, 1, 2

on multiple fields, 1

shared member properties, 1, 2

sort order, 1

two-pass calculations, 1, 2

UDAs, 1

definition files. See partition definition files

delays, 1

Delete Alias Table dialog box, 1

DELETEAPP command, 1

Deleted Dimensions dialog box, 1

DELETEDB command, 1

DELETEGROUP command, 1

DELETELOCATION command, 1

DELETELOG command, 1, 2

DELETEUSER command, 1

DELETEVARIABLE command, 1

deleting

See also clearing

aliases, 1

applications, 1, 2

calc scripts, 1, 2

contents from alias tables, 1

data blocks, 1

databases, 1

dimensions, 1

restructuring and, 1

filters, 1

formulas, 1

items from outlines, 1, 2

linked objects, 1

locks, 1, 2, 3, 4

automatically, 1

log files, 1, 2

members from data sources, 1

objects, 1

partitions, 1

substitution variables, 1

temporary files, 1

text

in calc scripts, 1

in formulas, 1

in report scripts, 1

user groups, 1

users, 1, 2

white space in fields, 1

delimiters

See also file delimiters

commas in numbers, 1

exports/imports, 1, 2

member lists, 1

report script commands, 1, 2

Demo application, 1

Demo Basic database, 1

sample reports, 1

dense dimensions, 1

See also dimensions; sparse dimensions

attribute design approach, 1

calculating values in, 1, 2, 3

examples, 1, 2, 3

defined, 1

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, 1

partitioning, 1, 2

referencing values in, 1

reporting on, 1

selecting, 1

selection scenarios, 1, 2, 3, 4

setting, 1

storing, 1

viewing member combinations, 1, 2

density, 1

depreciation, 1, 2, 3

derived data, 1

DESC command

described, 1

usage example, 1

@DESCENDANTS function, 1, 2

descendants

checking for, 1

clearing, 1

currency conversions and, 1

defined, 1

moving, 1

DESCENDANTS command

entering in report scripts, 1

usage, 1

descending sort order, 1

applying to output, 1

members in outlines, 1

design checklists

analyzing database scope, 1

creating business models, 1

defining calculations, 1

defining consolidations, 1

defining dimension properties, 1

identifying data sources, 1

partitioning databases, 1, 2

selecting partition types, 1

design guidelines

attributes, 1

dimensions, 1

outlines, 1

designing

See also building; creating

for optimal calculations, 1, 2

partitioned applications, 1, 2, 3, 4, 5

scenarios for, 1, 2, 3

reports, 1, 2

simple applications, 1, 2, 3

single-server applications, 1, 2

Desktop window. See Application Desktop window

detail members, 1

developing applications, 1, 2

operations not supported, 1

process summarized, 1

diagnostic tools, 1

overview, 1

reference table, 1

dialog boxes

informational, 1

quick reference, 1

refreshing pages in, 1

differences

between attributes and UDAs, 1

between standard and attribute dimensions, 1

DIMBOTTOM command

entering in report scripts, 1

usage, 1

DIMBUILD.ERR, 1, 2

dimenion building rules

summary for attribute dimensions, 1

dimension build

See also dynamic builds

associating

aliases with attributes, 1

base dimension members with attributes, 1

defining

attribute dimensions, 1

standard dimensions, 1

fields, 1

mode, 1

options for members of attribute dimensions, 1

position of fields in rules file, 1

Dimension Build Completed dialog box, 1, 2

Dimension Build Settings dialog box, 1

adding members, 1, 2, 3

creating rules files, 1, 2

naming dimensions, 1

setting properties, 1

Dimension Build Settings page (Dimension Build Settings), 1

dimension building

field types, 1

rules, 1

setting mode in Data Prep Editor, 1

Dimension Building Properties page (Field Properties), 1

Dimension Definition page (Dimension Build Settings), 1

dimension fields

formatting, 1

in data source, defined, 1

dimension names

maximum length, 1

Dimension Properties dialog box, 1

Dimension Properties page (Dimension Properties), 1

Dimension Specification dialog box

adding comments, 1

applying time balance tags, 1

defining dimension type, 1, 2, 3, 4, 5, 6

dimension type

setting, 1

dimensions, 1, 2

See also dense dimensions; sparse dimensions; attribute dimensions; standard dimensions; base dimensions

adding comments to, 1

adding members, 1, 2, 3, 4, 5, 6

example for, 1, 2

for currency conversions, 1, 2

guidelines for, 1

partitioned applications, 1

restrictions, 1

adding to outlines, 1, 2, 3, 4, 5

performance considerations, 1, 2

restructuring and, 1

applicable to business models, 1

arranging in hierarchies, 1, 2

associating formulas with, 1

attribute

See also attribute dimensions

described, 1

auto-configuring, 1, 2, 3

base

See also base dimensions

defined, 1

building, 1, 2, 3, 4

dynamically See dynamic builds

example for, 1

guidelines for, 1, 2

prerequisites, 1, 2, 3

restructuring databases and, 1

with dynamically calculated members, 1

with rules files, 1

building using MaxL, 1, 2

calculating members in, 1, 2

calculating series of, 1

calculator cache and, 1

categorized, 1

changing, 1, 2

default configurations, 1

for currency conversions, 1

changing properties, 1, 2, 3, 4

clearing member combinations, 1

consolidation levels, 1

creating filters for, 1

databases with different, 1

defined, 1

defining as flat, 1, 2

defining properties, 1, 2, 3, 4

caution for two-pass tags, 1

deleting, 1

restructuring and, 1

determining optimal configuration, 1, 2

determining valid combinations, 1

displaying

in Calc Script Editor, 1

in Formula Editor, 1

in outlines, 1

displaying information about, 1

examples

time-balanced data, 1

fixing as constant, 1

getting member combinations, 1

getting started with setting up, 1

grouping in calc scripts, 1, 2, 3, 4

handling missing values in, 1

identified in data source, 1

inheritance characteristics, 1

irrelevance across, 1

mapping fields to, 1

missing, 1

missing members, 1

moving in outlines, 1

naming, 1, 2, 3

naming levels in current, 1

nesting, 1

non-specific, 1

optimum order in outline, 1

ordering, 1

ordering members, 1

predefined types described, 1

referencing data in, 1, 2, 3

relationship among members, 1, 2, 3

renaming, 1

selection guidelines, 1

sharing members, 1, 2

single-server models, 1

sorting, 1, 2

splitting, 1

standard

See also standard dimensions

alternative for attributes, 1

compared with attribute types, 1

described, 1

storage defaults, 1

tagging

as Currency Partition, 1

as specific type, 1

for currency conversion, 1

two-pass calculations and, 1

updating, 1

DIMTOP command

usage, 1

direct I/O, 1

directories

application, 1

database, 1

default

for calc scripts, 1

for error logs, 1

default for calc scripts, 1

dump, 1

error log files, 1

spreadsheets as data sources, 1

text files as data sources, 1

dirty status, 1

calculating blocks with, 1

clearing data and, 1

copying data and, 1

currency conversion and, 1

Intelligent Calculation and, 1

marking blocks with, 1, 2

Disabled Usernames dialog box, 1

disabling member sort, 1

discarding records, 1

disconnecting

from server, 1

other users, 1, 2

discontinuous field selection, 1

@DISCOUNT function, 1

discount, calculating, 1

disk drives

copying applications to, 1

copying databases to, 1

viewing information about, 1, 2

Disk Drives page (Server Information), 1

disk I/O, reducing, 1, 2

disk space

allocating, 1, 2

example, 1

availability for restructuring, 1

calculations for determining

compressed block size, 1

data file storage, 1

data redundancy overhead, 1

database overhead, 1

fragmentation allowance, 1

potential block size and number, 1, 2

checking, 1, 2

conserving, 1

estimating, 1, 2

for linked reporting objects, 1

for partitioned applications, 1

freeing, 1, 2, 3

general requirements, 1

optimizing restructures and, 1

out of, 1

partitioned databases, 1, 2

with replicated partitions, 1

with transparent partitions, 1

unused and fragmented, 1

Disk Swapping option, 1

disk volumes

allocation and, 1

caution for specifying name only, 1

data files and, 1

data storage and multiple, 1

deallocating, 1, 2

index files and, 1

setting using MaxL, 1

specifying

with Application Manager, 1

with ESSCMD, 1

with Hyperion Essbase kernel, 1

updating storage settings, 1

Disk Volumes setting, 1, 2, 3, 4

enabling, 1

display application (MaxL), 1

display database (MaxL), 1

display filter (MaxL), 1

display group (MaxL), 1

display location alias (MaxL), 1

display options

data in reports, 1, 2

formulas, 1

headings in reports, 1, 2

outlines, 1

reports, 1

display user (MaxL), 1, 2

display user in group (MaxL), 1

DISPLAYALIAS command, 1

displaying, 1

access settings, 1, 2

active filters, 1

active user groups, 1

aliases, 1, 2

in Calc Script Editor, 1

in Formula Editor, 1

application information, 1, 2, 3, 4

applications, 1

available ports, 1, 2

changes to outlines, 1

current users, 1, 2, 3

data, 1, 2, 3

in targets, 1

with Data Prep Editor, 1, 2

data sources, 1, 2

data targets, 1

database

information, 1, 2

statistics, 1

databases, 1

dimensions

in Calc Script Editor, 1

in Formula Editor, 1

in outlines, 1

dynamically calculated members, 1, 2

field operations, 1

formulas, 1, 2

inactive users, 1

informational messages, 1, 2

linked objects, 1, 2

locked data, 1

locks, 1

log files, 1, 2, 3, 4, 5

member combinations, 1, 2

member names in reports, 1

members in outlines, 1, 2

names for generations and levels, 1

partitions, 1, 2

records, 1

replace operations, 1

selection/rejection criteria, 1

Server Agent commands, 1

server information, 1

software version, 1, 2

specific values, 1

storage information, 1

text in Outline Editor, 1

unique values, 1

distributed client-server model, 1

distributed databases. See partitioning

distribution (multidimensional models), 1

dividing

databases, 1

fields, 1

dividing applications. See partitioned databases; partitions; splitting, databases

dividing databases, 1

division

consolidation codes in data source, 1

consolidation property, 1

modulus operations, 1

.DLL files, 1

Do Not Share option, 1

dynamic builds and, 1, 2, 3, 4

DOCS directory, 1, 2, 3

documentation, 1

additional resources, 1

suggested audience, 1

typographical conventions, 1

documents, linking external, 1

dollar signs ($)

in array and variable names, 1

dollar values, 1

converting to US$, 1

double quotation marks (")

enclosing member names, 1, 2

in application and database names, 1

in dimension and member names, 1

in ESSCMD commands, 1

in formulas, 1, 2, 3

in header information, 1

in report scripts, 1

terms in scripts and formulas, 1, 2

double slashes (//) in report scripts, 1

downtime, 1

drilling across, 1, 2, 3

facilitating, 1

drop application (MaxL), 1

drop database (MaxL), 1

drop group (MaxL), 1

drop location alias (MaxL), 1

drop user (MaxL), 1

D-T-D time series member, 1, 2

dummy

parents, 1

strings, 1

DUMP command, 1

usage overview, 1

DUMP directory, 1, 2

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, 1

generations, 1

members, 1

duplicate generation alias field type

arranging in rules files, 1

in header records, 1

in rules files, 1

nulls and, 1

duplicate generation field type

arranging in rules files, 1

creating shared members, 1

in header records, 1

in rules files, 1

nulls and, 1

duplicate level alias field type

arranging in rules files, 1

in header records, 1

in rules files, 1

nulls and, 1

duplicate level field type

arranging in rules files, 1

in header records, 1

in rules files, 1

nulls and, 1

sharing members, 1, 2

duplicate members

See also shared members

duplicating

See also copying; replicating

data, 1

data values, 1

outlines, 1

dynamic builds

See also dimension build

adding new members

as child of specified parent, 1

to dimensions with similar members, 1

to end of dimensions, 1

arranging fields, 1

batch processing, 1

bottom-up ordering, 1, 2, 3

creating shared members, 1, 2

for different generations, 1, 2

for same generation, 1, 2, 3

with rule files, 1

generation references and, 1

global options, 1

introduction, 1, 2

level references and, 1

members without specified ancestor, 1

parent/child references and, 1, 2

process summarized, 1

restrictions, 1

selecting build method, 1, 2

selecting field types for, 1

top-down ordering, 1, 2

validating rules files, 1

with Data Prep Editor, 1, 2, 3, 4

with data sources, 1, 2, 3, 4, 5, 6

with rules files, 1

Dynamic Calc And Store members, 1

adding to calculations, 1

adding to formulas, 1

clearing values, 1

creating, 1

currency conversions and, 1

dense dimensions and, 1

loading data into, 1

partitioning, 1, 2

replicating, 1

reporting on, 1

retrieving values, 1

selecting, 1, 2, 3

specifying in data source, 1

viewing, 1

Dynamic Calc And Store property

applying, 1, 2, 3

described, 1, 2

removing, 1

Dynamic Calc members, 1

adding to calculations, 1

adding to formulas, 1

Attribute Calculations dimension, 1

creating, 1

currency conversions and, 1

loading data into, 1

partitioning, 1, 2, 3

replicating, 1, 2

reporting on, 1

retrieving values, 1

selecting, 1, 2, 3

specifying in data source, 1

viewing, 1

Dynamic Calc property, 1

and sparse dimensions, 1, 2

applying, 1, 2, 3

in Application Manager, 1

description, 1

removing, 1

dynamic calculations, 1

asymmetric data, 1

Attribute Calculations dimension, 1

building, 1, 2

restrictions, 1, 2, 3

building dimensions with, 1

calc scripts and, 1, 2

choosing members, 1

guidelines for, 1, 2

choosing values, 1, 2

guidelines for, 1, 2

database design, 1

defined, 1

defining order, 1, 2

exporting data and, 1

formulas applied to members, 1

optimizing retrieval, 1

partitioned databases, 1

replicated partitions, 1

retrieving values, 1, 2, 3, 4

transparent partitions, 1

usage overview, 1, 2, 3

viewing log file contents, 1

dynamic calculator cache

sizing, 1

viewing usage information, 1

dynamic dimension building

adding members to outlines, 1, 2, 3

generation references, 1

level references, 1

Dynamic Dimensionality, 1

dynamic dimensions

level references, 1

dynamic references

defining header information, 1

description, 1

record numbers in, 1

Dynamic Time Series Member Information dialog box

defining aliases, 1

enabling/disabling members, 1, 2

Dynamic Time Series members, 1, 2

enabling/disabling, 1, 2

generation names for, 1

in shared areas, 1

inserting in report scripts, 1

listed, 1

reporting on, 1

selecting, 1

specifying aliases for, 1

E

E, expense property code in data source, 1

East database

partitioning, 1

provided with Hyperion Essbase, 1

Edit Alias dialog box, 1

Edit User dialog box, 1, 2

modifying access settings, 1

editing

See also changing

aliases, 1

filters, 1

linked files, 1

partitions, 1

report scripts, 1, 2, 3, 4

security profiles, 1

user groups, 1

editors

calc scripts and, 1

ESSCMD commands and, 1

formulas and, 1

report scripts and, 1

electronic mailboxes, 1

ELSE operator

usage examples, 1, 2

ELSE statement, 1

ELSEIF statements

calc scripts, 1

formulas, 1, 2

empty database cells, 1

caution for storing, 1

empty fields

adding values to, 1

blank fields in rules file, 1

in data source, 1

emptying. See clearing

ENDARCHIVE command, 1, 2, 3

partitioned applications and, 1

ENDFIX command, 1, 2, 3

allocating costs, 1, 2

allocating values, 1

calculating product/market shares, 1

calculating range of values, 1

calculating subsets of values, 1

clearing data blocks, 1

clearing subsets of values, 1

copying subsets of values, 1

currency conversions and, 1

Intelligent Calculation and, 1, 2, 3

optimizing calculations with, 1, 2

ENDHEADING command

entering in report scripts, 1

modifying headings, 1

usage example, 1

ENDIF statement

calc scripts

interdependent formulas in, 1

member formulas in, 1

semicolons with, 1

syntax, 1

formulas

purpose of, 1

semicolons with, 1

syntax, 1

usage examples, 1, 2

ENDLOOP command, 1, 2

end-of-file markers, 1

end-of-line character, 1, 2

ESSCMD commands, 1

inserting in calc scripts, 1, 2, 3

inserting in formulas, 1

enterprise analysis applications, 1

Environment Variables list box, 1

environments, 1

See also UNIX platforms; Windows platforms

equal signs (=)

in application and database names, 1

in calc scripts, 1

in dimension and member names, 1

in formulas, 1

in names in scripts and formulas, 1

in report scripts, 1

equations, 1, 2

See also formulas

cross-dimensional operator and, 1, 2

inserting in calc scripts, 1, 2

report scripts, 1

.ERR files. See error log files

error codes and numbers, 1

error handling (Hyperion Essbase kernel), 1

error log files, 1

default directory for, 1

empty, 1

from partial loads, 1

loading, 1

maximum number of records in, 1, 2

missing, 1

names and locations, 1

renaming, 1

resetting

record count, 1

setting, 1

error message categories, 1

error-handling commands, 1

errors

calc scripts

checking for, 1

currency conversions, 1

ESSCMD, 1, 2

fixing for dynamic builds, 1

formulas and dynamically calculated members, 1

formulas,checking for, 1

handling fatal, 1

loading data, 1, 2

locking, 1, 2

matching member omitted, 1

mismatches, 1

partition validation, 1

pinpointing, 1

Report Extractor, 1

restructuring and, 1

storage allocation, 1

time-out, 1, 2

unknown member, 1

ESBBEGINREPORT function, 1

ESBENDREPORT function, 1

ESBREPORT function, 1

ESBREPORTFILE function, 1

.ESM files, 1, 2, 3, 4

.ESN files, 1, 2

.ESR files, 1

ESSBASE, 1, 2

Essbase

architecture, 1, 2

development features described, 1

displaying software version number, 1, 2

guide prerequisites, 1

products summarized, 1

program files, 1

quick reference to menus and dialog boxes, 1

quitting, 1, 2

terms described, 1

Essbase client. See clients

ESSBASE command, 1

Essbase Config page (Server Information), 1

Essbase Server Agent. See Server Agent

Essbase server. See server

Essbase System Login dialog box, 1

ESSBASE.BAK, 1

ESSBASE.CFG, 1, 2

dynamic calculator cache settings, 1

ESSBASE.LOG, 1, 2, 3

ESSBASE.SEC, 1

and filters, 1

backup of, 1

ESSBEGINREPORT function, 1

ESSCMD, 1

See also specific command

canceling operations, 1, 2

caution for processing commands, 1

changing Hyperion Essbase kernel settings, 1, 2

checking structural integrity, 1

command reference, 1

commands and case-sensitivity, 1

creating report scripts, 1

defined, 1

enabling Cache Memory Locking, 1

entering commands, 1

error-handling, 1, 2

loading update log files, 1

operational modes, 1

performance-related commands, 1

referencing files, 1

replicating data, 1

running, 1, 2

calc scripts, 1, 2, 3

caution for pausing systems and, 1

in interactive mode, 1

reports, 1, 2

setting

cache size, 1, 2

index page size, 1

isolation levels, 1

substitution variables, 1

transaction isolation levels, 1

shutting down server, 1

specifying

data compression, 1

disk volumes, 1

starting, 1

prerequisites, 1

syntax, 1

updating replicated partitions, 1

viewing dynamic calculator cache activity, 1

ESSCMD script files

creating, 1, 2

naming, 1

quotation marks in, 1

running, 1

sample, 1

within operating system batch files, 1

ESSCMD.EXE, 1

ESSENDREPORT function, 1

ESSGBEGINREPORT function, 1

ESSGREPORTFILE function, 1

Essnet library, 1

ESSREPORT function, 1

ESSREPORTFILE function, 1

ESSSVR (application server), 1, 2

estimating disk space, 1, 2

linked reporting objects, 1

partitioned applications, 1

Euro currency symbol, 1

EUROPEAN command

overriding, 1

usage, 1

event log files, 1, 2

calc scripts and, 1

deleting, 1, 2

server-specific, 1

viewing contents, 1, 2, 3

event logs

clearing using MaxL, 1, 2

events, 1

Excel spreadsheets. See Spreadsheet Add-in

exception error logs, 1

names and locations, 1

Exception Handler, 1

location of writes, 1

ExceptionLogOverwrite parameter, 1

exchange rates, 1, 2

calculating options, 1

defining, 1

sample database, 1

exclamation points (!)

See also bang command

in names in scripts and formulas, 1

excluding members from consolidations, 1, 2

exclusive locks. See Write locks

.EXE files, 1

Execute Calc Scripts dialog box, 1

execute calculation (MaxL), 1, 2, 3

Existing Members options in dimension build, 1

EXIT command, 1, 2, 3

usage overview, 1

exiting

See also closing; quitting; stopping

Essbase, 1, 2

Partition Wizard, 1

@EXP function, 1

expanded blocks, 1

expanding

alias member lists, 1

Calc Script Editor lists, 1, 2, 3

Formula Editor lists, 1, 2, 3

outline hierarchies, 1

expense property, 1, 2

specifying in data source, 1

expense vs. non-expense items, 1

exponents

calculating, 1

exponents, calculating, 1

export

parallel, 1

export (MaxL), 1, 2, 3

EXPORT command

columnar format, 1

partitioned applications and, 1

EXPORT command (ESSCMD), 1

export files, 1

 

EXPORT utility, 1

exported data reloads, 1

exporting

alias tables, 1, 2

data, 1, 2, 3

for backups, 1

in parallel, 1

into other forms, 1

reporting example, 1

data in parallel, 1

EXPORTTHREADS,1

external data sources

for loading data, 1, 2, 3, 4

linking to cells, 1

prerequisites for loading, 1

supported, 1

extraction

characters ignored, 1

commands, 1, 2

data, 1, 2

extraction commands

defined, 1

F

F, first time balance code in data source, 1

@FACTORIAL function, 1

factorials, 1

failures

calculations, 1

getting information about, 1

preventing, 1, 2

recovering from, 1, 2, 3

suggested procedures, 1

restructuring and, 1

transaction rollbacks and, 1

fatal errors, 1

FEEDON command, 1

fetches, 1

Field Edits page (Data File Properties), 1

field names

adding prefixes or suffixes to, 1

assigning to data fields, 1

changing case, 1

SQL data sources, 1

validating, 1

field operations, 1

Field Properties dialog box

adding members, 1, 2, 3

adding prefixes and suffixes, 1

applying case conversions, 1

converting white space to underscores, 1

defining columns as fields, 1

mapping fields, 1

naming fields, 1

removing white space, 1

replacing text strings, 1

scaling data values, 1

setting field types, 1

field types

data sources, 1, 2, 3

invalid, 1

dimension building properties, 1

dynamically referencing, 1

restrictions for rules files, 1

setting for record selection, 1, 2

setting member properties, 1, 2

shared members, 1, 2, 3, 4, 5, 6

caution for creating, 1

specifying, 1, 2

valid build methods, 1

fields

See also columns

adding prefixes or suffixes to values, 1

arranging, 1, 2, 3

building dynamically, 1, 2

changing case, 1

clearing existing values, 1

concatenating multiple, 1

copying, in rules files, 1

creating, 1, 2

by splitting, 1

with joins, 1, 2

defined, 1

defining columns as, 1

defining operations for rules files, 1

delimiters/separators. See file delimiters

displaying in Data Prep Editor, 1

empty

adding values to, 1

in data source, 1

in rules file, 1

replacing with text, 1

entering data, 1, 2

excluding specific from data loads, 1

formatting rules, 1, 2, 3

invalid, 1

manipulating in rules files, 1

mapping

changing case, 1

inserting text in empty fields, 1

replacing text strings, 1

specific only, 1, 2, 3

to member names, 1

moving, 1

naming, 1

position in rules file, 1, 2

processing nulls in, 1, 2

removing white space in, 1

reversing values in, 1

select/reject criteria, 1

selecting, 1

setting retrieval specifications, 1, 2, 3

size and optimal loads, 1

undoing operations on, 1

File Delimiter page (Data File Properties), 1

file delimiters

customizing, 1

formatting rules, 1

in header information, 1

mapping files, 1

setting, 1, 2

file locks, 1, 2

file system types, 1

file-name extensions

batch files, 1

calc scripts, 1

error log files, 1

ESSCMD script files, 1

in ESSCMD, 1

index files, 1

listed, 1

live reporting object files, 1

outline change files, 1, 2

outline files, 1

report files, 1

report scripts, 1

restructuring and, 1

rules files, 1

temporary files, 1

text files, 1

trace files, 1

files, 1

See also data files; rules files; text files

attaching external to cells, 1, 2

backing up, 1, 2

caution for recovery and, 1

compatibility across platforms, 1

creating trace, 1, 2

editing linked, 1

estimating size, 1

implementing security for, 1

importing, 1, 2, 3

loading, 1

locating end-of-file markers, 1

location of sample report scripts, 1

logging data load errors, 1

logging dimension builds, 1

logging outline changes, 1

opening, 1, 2, 3

program, 1

referencing in ESSCMD, 1

renaming with FTP, 1

restrictions for linking, 1

restructuring, 1

running multiple report scripts, 1

selecting multiple for loading, 1, 2

sending report output to, 1

setting maximum size, 1

specifying size for linked, 1

storing, 1

temporary for full restructures, 1

transferring compatible, 1

types defined, 1

types described, 1

updating log, 1

with long names, 1

Files page (Database Information), 1

Filter Access privilege, 1

Filter privilege, 1

filters, 1

and attribute functions, 1

AND relationship, 1

assigning, 1

copying, 1

creating, 1, 2, 3

for partitioned databases, 1

defined on seperate rows, 1

defining in Application Manager, 1, 2

deleting, 1

displaying in MaxL, 1

editing, 1

enclosing member names in quotation marks, 1

in the security (.SEC) file, 1

inheriting, 1, 2, 3

on entire members, 1

on member combinations, 1

OR relationship, 1

overlap conflicts, 1, 2

overriding, 1, 2

overview, 1, 2

removing, 1

renaming, 1

restrictions on applying, 1

saving, 1

using member set functions, 1

viewing existing, 1

write access to database, 1

Filters dialog box, 1

financial applications, 1

allocating costs, 1

allocating values, 1, 2

calculating product and market share, 1

comparing actual to budgeted expense, 1, 2

containing time-sensitive data, 1

estimating sales and profits, 1

example for building, 1

forecasting values, 1

getting budgeted data values, 1

getting variance for actual to budgeted, 1, 2

loading new budget values, 1

financial functions, 1, 2

formulas and, 1, 2, 3

Intelligent Calculation and, 1

Find dialog box

Calc Script Editor, 1, 2

Formula Editor, 1, 2

Report Editor, 1

finding

end-of-file markers, 1

members in Calc Script Editor, 1

members in Formula Editor, 1

specific values, 1, 2

text in formulas, 1

text in report scripts, 1, 2

first time balance property, 1

specifying in data source, 1

first-time calculations, 1

first-time users, 1

FIX/ENDFIX command, 1, 2, 3

allocating costs, 1

allocating values, 1, 2

calculating product/market shares, 1

calculating range of values, 1

calculating subsets of values, 1

clearing data blocks, 1

clearing subsets of values, 1

copying subsets of values, 1

currency conversions and, 1

Intelligent Calculation and, 1, 2, 3

optimizing calculations with, 1, 2

FIXCOLUMNS command, 1

fixed-size overhead, 1, 2

fixed-width columns, 1

flags (partitions), 1

flat dimensions, 1, 2

flat files, 1

loading, 1

FLAT2SQL.REP, 1

flipping data values, 1

Font dialog box, 1, 2

fonts, 1, 2

forecasting values

examples, 1

functions, 1, 2

foreground startup, 1

formats

See also formatting commands

alias tables, 1

calculated data, 1, 2

columns for data load, 1, 2

comments, 1

data sources, 1, 2, 3, 4, 5

overview, 1

export, 1

free-form data sources, 1, 2

header information, 1

import specifications and, 1

linked object restrictions, 1

member mappings, 1

report output, 1

sample report, 1, 2, 3, 4

suppressing in reports, 1, 2

tab-delimited, 1

formatting commands, 1, 2

calculations, 1, 2

caution for usage, 1, 2

defined, 1

display options, 1, 2

listed, 1

nesting, 1

output, 1

report headings, 1, 2, 3, 4

formatting styles (documentation), 1

Formula Editor

building formulas, 1, 2, 3, 4

checking syntax, 1, 2

deleting formulas, 1, 2

expanding/contracting dimensions, 1

expanding/contracting member branches, 1

finding and replacing text, 1

opening, 1, 2

saving formulas, 1

searching for members, 1

undoing last action, 1

formula field type

in header records, 1

in rules files, 1

nulls and, 1, 2

FORMULA. See formula field type

formulas, 1, 2, 3

adding aliases, 1

adding text to, 1

adding to calc scripts, 1, 2, 3, 4

adding to report scripts, 1

allowing changes, 1

applied to members, 1, 2, 3, 4, 5, 6

applying to data subsets, 1

associating with dimensions or members, 1

calculating twice, 1, 2, 3

with Intelligent Calculation, 1, 2

calculation mode used, 1

caution for sparse dimensions, 1

changing, 1

complex, 1, 2

creating, 1

examples, 1, 2, 3, 4

syntax for, 1

with Formula Editor, 1

writing equations, 1

cross-dimensional references in, 1, 2

defined, 1

deleting, 1

displaying, 1, 2

dynamic calculations and, 1, 2

errors in, 1

examples, 1

finding and replacing text in, 1

grouping in calc scripts, 1, 2, 3, 4

in partitioned applications, 1, 2

in time and accounts dimensions, 1

inserting operators, 1

inserting variables, 1

Intelligent Calculation and, 1

names with special characters, 1, 2

nesting, 1, 2

optimizing, 1

partitions and, 1

performance considerations, 1, 2

printing, 1

saving, 1

setting conditions for, 1, 2

shared members and, 1

simple, 1, 2

top-down, 1

troubleshooting, 1

types described, 1

forward calculation references, 1

FoxPro databases. See SQL databases

fragmentation (defined), 1

fragmentation allowance, 1

free-form

data load, 1

data sources, 1

formatting, 1, 2

optimizing, 1

reports, 1

freeing memory, 1

FTP file transfers, 1

full restructure, 1

temporary files created, 1

function syntax, 1

Function Templates dialog box, 1

functions, 1, 2, 3

See also specific @function

allocation, 1

API, 1

applying in filter definitions, 1

applying to subsets, 1

Boolean, 1

calc scripts and, 1

calculation mode, 1

date and time, 1

defining multiple members and, 1

defining partitioned areas with, 1, 2, 3

financial calculations with, 1

forecasting, 1

formulas and, 1, 2, 3, 4

generating member lists, 1, 2

Intelligent Calculation and, 1

mathematical, 1

member set, 1

range, 1

relationship, 1

report generation, 1

returning specific values, 1

statistical, 1

functions, custom-defined, 1

fundamentals, 1

future values, calculating, 1

G

@GEN function, 1

GEN field type. See generation field type<

GEN numbers. See generation reference numbers

General page (Database Information), 1

General page (Database Settings), 1

Generate Currency Outline button, 1

Generate Currency Outline dialog box, 1

generating

account reporting values, 1

member lists, 1, 2, 3

reports, 1, 2, 3

basic techniques, 1, 2

free-form, 1

from the command line, 1

with API function calls, 1

Generation and Level Names dialog box, 1

generation field type

arranging in rules files, 1

in header records, 1

in rules files, 1

null values and, 1

generation names, 1

adding to report scripts, 1, 2

creating, 1, 2

displaying, 1

for Dynamic Time Series members, 1

static, 1

generation reference numbers

associating attributes dynamically, 1

building shared members, 1

defined, 1

Dynamic Time Series members, 1, 2

entering in rules files, 1

generating, 1

generation references build method

creating shared members, 1

discussion, 1

guidelines for using, 1

null processing, 1

sample rules file, 1, 2

shared members, 1

valid build types, 1

generation references defined, 1

Generation/Level Names page (Dimension Properties), 1

generations

checking for, 1

defined, 1, 2

duplicate, 1

Dynamic Time Series members and, 1, 2, 3

levels vs., 1

naming, 1, 2, 3

reversing numerical ordering, 1

sharing members, 1, 2

at multiple, 1

sorting on, 1

generic passwords, 1

@GENMBRS function, 1

GENREF.RUL, 1

GENREF.TXT, 1

GETALLREPLCELLS command, 1

GETAPPINFO command, 1

GETAPPSTATE command, 1

GETATTRIBUTESPECS command, 1

GETATTRINFO command, 1

GETCRDBINFO command, 1

GETDBINFO command, 1, 2

GETDBSTATE command, 1

GETDBSTATS command, 1, 2

GETMBRCALC command, 1

GETPARTITIONOTLCHANGES command, 1

GETPERFSTATS, 1

GETPERFSTATS command, 1

getting started with Hyperion Essbase, 1, 2

GETUPDATEDREPLCELLS command, 1

GETVERSION command, 1

global

formatting commands, 1, 2

Global Access layer (security and privileges), 1

global access settings

defining, 1, 2, 3

minimum database access, 1

overriding, 1

types listed, 1

global calculation commands, 1

Global ESSBASE.CFG Settings list box, 1

global options (dynamic builds), 1

global placeholders, 1

Global Properties page (Field Properties)

adding prefixes and suffixes, 1

applying case conversions, 1

converting white space to underscores, 1

defining columns as fields, 1

removing white space, 1

replacing text strings, 1

scaling data values, 1

setting ignored values, 1

global replacement

data load, 1

Global Setting page (Dimension Build Settings), 1

goal seeking calculations, 1

GOTO command, 1

granularity, 1

graphs, 1

greater than signs (>)

in application and database names, 1

in names in scripts and formulas, 1

gridlines (Data Prep Editor), 1

Group Membership dialog box, 1

groups

assigning filters to, 1

assigning privileges to, 1

assigning users to, 1, 2

copying security profiles, 1

creating member, 1, 2

creating or copying using MaxL, 1

creating user, 1, 2, 3

defined, 1, 2

defining security, 1, 2, 3

deleting, 1

deleting users, 1

deleting using MaxL, 1

displaying in MaxL, 1

displaying membership using MaxL, 1

editing user information, 1

formulas and dimensions in calc scripts, 1, 2, 3, 4

getting list of, 1

modifying access settings, 1, 2, 3, 4

overriding column, 1

renaming, 1

returning valid users, 1, 2

security settings, 1

security types, 1

selecting members for report, 1

viewing current settings, 1, 2

@GROWTH function, 1

guest accounts, 1

guidelines

analyzing database design, 1

H

.H files, 1

handles, 1

handling missing values, 1

reporting example, 1

handling zero values, 1

hardware platforms, 1

hash tables, 1, 2

Header Definition page (Data Load Settings), 1

header information

adding, 1, 2, 3, 4

dynamic references, 1

formatting, 1

header records

creating, 1, 2

defined, 1

defining load rules, 1

identifying missing dimensions with, 1

skipping, 1, 2

specifying location of, 1

Header Records page (Data File Properties), 1

headers. See header information; header records

HEADING command, 1

HEADING1.REP, 1

HEADING2.REP, 1

headings

See also column headings; field names; row headings

adding to complex reports, 1, 2

adding to free-form reports, 1

currency conversion, 1

customizing, 1, 2

display options, 1, 2

forcing immediate display, 1

formatting, 1, 2, 3, 4

multiple layout reports, 1

page, 1

suppressing display, 1

using attributes in, 1

help

API functions, 1

calc scripts, 1

configuration variables, 1

configurations, 1

files, 1

loading sample applications, 1

Report Writer commands and definitions, 1

Server Agent, 1

Help button (Application Desktop), 1

HELP command, 1

hierarchies

Calc Script Editor

aliases, 1

dimensions, 1

members, 1

calculation order and, 1

data, 1

relationships defined, 1, 2

dynamic builds, 1

Formula Editor

aliases, 1

dimensions, 1

members, 1

outlines, 1

expanding/contracting, 1

unbalanced in outlines, 1

history-to-date calculations, 1

.HLP files, 1

hosts, 1

HP-UX servers. See UNIX platforms<

H-T-D time series member, 1, 2

HTML files, 1

Hyperion Essbase

fundamentals, 1

getting started tips, 1, 2

Hyperion Essbase kernel

active transactions and failures, 1

allocating storage, 1

changing settings, 1, 2

scope and precedence, 1

with Application Manager, 1

with ESSCMD, 1, 2

components, 1

compressing data, 1, 2, 3

cross-platform compatibility, 1

customizing, 1, 2

error handling, 1

linked reporting objects and, 1

locking procedure, 1

overview, 1, 2

setting cache size, 1, 2

setting index page size, 1, 2

setting isolation levels, 1, 2

specifying data compression, 1, 2

specifying disk volumes, 1, 2

starting, 1

hyphens (-)

in dimension and member names, 1

in member names, 1

in names in scripts and formulas, 1

in report scripts, 1

I

@IALLANCESTORS function, 1

@IANCESTORS function, 1

IANCESTORS command

usage, 1

IBM DB2 relational storage manager, 1

@ICHILDREN function, 1

ICHILDREN command

usage, 1

usage example, 1

.ICO files, 1

identical values, 1

identifying data sources, 1

@IDESCENDANTS function, 1, 2

IDESCENDANTS command

usage, 1

usage example, 1

IF/ELSEIF... statements

calc scripts

nested statements, 1

formulas

nested statements, 1

purpose of, 1

IF/ENDIF statements

calc scripts

interdependent formulas in, 1

member formulas in, 1

semicolons with, 1

syntax, 1

formulas

purpose of, 1

semicolons with, 1

syntax, 1

usage examples, 1, 2

IFERROR command, 1

Ignore Conflicts option, 1

Ignore Tokens page (Data File Properties), 1

ignoring

#MISSING and zero values, 1, 2

end-of-file markers, 1

fields when mapping, 1, 2, 3

lines in rules files, 1, 2

multiple fields in data load, 1

specific fields in data load, 1

specific records in data load, 1

@ILSIBLINGS function, 1

immediate restructuring, 1, 2

IMMHEADING command, 1

implementing security measures, 1

for users and groups, 1, 2, 3, 4

globally, 1, 2, 3, 4

guidelines for, 1

partitioned databases, 1, 2, 3

planning, 1

system server, 1, 2

implied shared relationships, 1, 2, 3

import (MaxL), 1

import database (MaxL), 1, 2

Import Member Mappings dialog box, 1

Import Server Alias Table Object dialog box, 1

importing

alias tables, 1

data, 1, 2

files, 1, 2, 3

member mappings, 1

importing database files. See reloading database files

improper shutdown, 1

improving performance, 1, 2, 3

See also optimizing

inaccessible applications, 1

inactive users, 1

INCBUILDDIM command, 1

INCEMPTYROWS command

overriding, 1

usage, 1

INCFORMATS command, 1

INCMASK command, 1

INCMISSINGROWS command, overriding, 1

inconsistent values, 1

incorrect data values, 1

incremental data load, 1

incremental restructuring, 1

disabled, 1

files, 1

INCRESTRUC parameter, 1

linked reporting objects and, 1

INCZEROROWS command, 1

overriding, 1

.IND files, 1, 2

INDENT command, 1

indentation

turning off, 1

usage, 1

INDENTGEN command

usage, 1

usage example, 1

index

advantage of small, 1

checking structural integrity, 1

defined, 1

determining optimal size, 1, 2, 3, 4

disadvantage of large, 1

dynamic calculations and, 1

managing, 1, 2

optimizing, 1, 2

process for retrieval, 1

rebuilding. See restructuring

removing references to linked files, 1

restructuring, 1

retrieving linked reporting objects, 1

spanning multiple pages, 1

updating, 1

usage described, 1

index cache

as storage unit, 1

determining size, 1

managing, 1

optimizing read/writes, 1

setting size, 1, 2

with Application Manager, 1

with ESSCMD or MaxL, 1

with Hyperion Essbase kernel, 1

updating, 1

index entries, 1, 2

managing, 1

index files, 1

associated with current application, 1

caution for recovery and, 1

creating, 1

cross-platform compatibility, 1

defined, 1

size considerations, 1

storing, 1, 2

Index Manager, 1

overview, 1

index page

linked reporting objects and, 1

managing, 1

setting size, 1, 2

updating, 1

index page files, 1

index searches, 1

viewing information about, 1

information dialog boxes, 1

information flow, 1

informational messages, 1, 2

inheritance

currency categories, 1

filters, 1, 2, 3

privileges, 1, 2

properties, 1

initialization process (Hyperion Essbase kernel), 1

initializing rules files, 1

.INM files, 1, 2

.INN files, 1, 2

input blocks, 1, 2

input data, 1, 2, 3

restructuring and, 1, 2

input/output (I/O), 1

Insert Arguments option, 1, 2

inserting. See adding

installation information, 1

installer

security level of, 1

installing OLAP Server, 1

installing Personal Essbase, 1

insufficient privileges, 1

@INT function, 1

integers. See numbers; values

integrity. See data integrity

Intelligent Calculation

block size and efficiency, 1

controlling with calc scripts, 1

currency conversions and, 1, 2

default calculations and, 1

enabling/disabling, 1, 2

large indexes and, 1

limitations, 1, 2

overview, 1, 2

partial calculations and, 1

recalculating data and, 1

restructuring and, 1

setting as default, 1

time balance properties and, 1

turning on/turning off, 1

two-pass calculations and, 1, 2, 3

Intelligent Calculation option, 1

interactive mode (ESSCMD)

canceling operations, 1

command-line syntax for, 1

defined, 1

entering commands, 1

file-name extensions and, 1

overview, 1

running ESSCMD from, 1

interdependent values, 1, 2

interdimensional irrelevance, 1

@INTEREST function, 1

interest, calculating, 1

interfaces, 1, 2

accessing linked objects and client, 1

customizing, 1

international applications. See locales

international formats, 1, 2

Interntl database, 1, 2

changing Scenario dimension in, 1

contents described, 1

linking, 1

opening outline, 1

provided with Hyperion Essbase, 1

saving outline changes, 1

interpolation, with spline, 1

invalid fields in data sources, 1

inventory, 1

calculating first/last values, 1, 2

calculating period-to-date values, 1

currency categories and, 1

getting averages, 1

tracking, 1, 2

investments, 1

IPARENT command

usage, 1

@IRDESCENDANTS function, 1

@IRR function, 1

irrelevant data, 1

@IRSIBLINGS function, 1

@ISACCTYPE function, 1

@ISANCEST function, 1

@ISCHILD function, 1

@ISDESC function, 1

@ISDESCENDANTS function, 1

@ISGEN function, 1

@ISIANCEST function, 1

@ISIBLINGS function, 1

@ISICHILD function, 1

@ISIDESC function, 1

@ISIPARENT function, 1

@ISISIBLING function, 1

@ISLEV function, 1

@ISMBR function, 1, 2

isolation levels, 1, 2

calculations and, 1

canceling calculations and, 1

caution for data loads, 1

committed and uncommitted access, 1

locks and, 1, 2, 3, 4

rollbacks and, 1, 2

setting

with Application Manager, 1

with ESSCMD, 1, 2

with Hyperion Essbase kernel, 1

updating, 1

@ISPARENT function, 1

@ISSAMEGEN function, 1

@ISSAMELEV function, 1

@ISSIBLING function, 1

@ISUDA function, 1

J

Java

Archives, creating, 1

using for custom-defined functions, 1

Join Fields dialog box, 1

joining fields, 1, 2

K

kernel settings, options, 1

L

L, last time balance code in data source, 1

label members

See also label only property

dynamically calculating, 1

storing, 1

label only property, 1

defining, 1

description, 1

specifying in data source, 1

usage example, 1

labels

defining, 1

replacing missing values with, 1, 2

language support (programming), 1, 2

languages

country-specific dimensions, 1, 2

requirements for partitioning, 1

large databases, 1, 2, 3

large-scale reports, 1, 2

last time balance property, 1

example, 1

specifying in data source, 1

LATEST command, 1

latest time period, 1

layout commands, 1, 2

layouts. See page layouts

.LCK files, 1

leading spaces, 1

leaf members

defined, 1

restructuring, 1

leaf nodes, 1

less than signs (<)

in application and database names, 1

in dimension and member names, 1

in names in scripts and formulas, 1, 2

in report scripts, 1

@LEV function, 1

level 0 blocks, 1, 2

exporting, 1

restructuring, 1, 2

level 0 members, 1

See also leaf members

calculations on, 1, 2, 3

in two-dimensional reports, 1

required in source data, 1

storing, 1

level field type

arranging in rules files, 1

in header records, 1

in rules files, 1

null values in, 1

sharing members, 1

level names, 1

adding to report scripts, 1, 2

creating, 1, 2

displaying, 1

static, 1

level numbers

determining for shared members, 1, 2

generating, 1

level reference numbers

associating attributes dynamically, 1

entering in rules files, 1

level references

described, 1

sample rules file for, 1

level references build method, 1

creating multiple roll-ups, 1

creating shared members, 1, 2, 3

example rules file, 1, 2

guidelines for, 1

null processing, 1

sample rules file for, 1

shared members, 1, 2, 3

valid field types, 1

LEVEL.RUL, 1

LEVEL.TXT, 1

LEVELMUL.RUL, 1

levels

checking for, 1

defined, 1

naming, 1, 2, 3

period-to-date reporting, 1

sorting on, 1

@LEVMBRS function, 1

.LIB files, 1

libraries, 1

.LIC files, 1

License Info page (Server Information), 1

licensing, 1, 2, 3, 4

getting information for, 1, 2

partitioning product suite, 1

line formatting, 1

linear regression, with @TREND function, 1

lines, skipping in rules files, 1, 2

LINK command

usage, 1

usage example, 1

Link Properties dialog box, 1

LINK.REP, 1

linked databases. See linked partitions

linked files

displaying contents, 1

editing, 1

LRO object type, 1

restrictions, 1

specifying size, 1

storing, 1

valid objects as LROs, 1

linked object catalogs, 1, 2

Linked Objects Browser

changing linked partitions, 1

editing objects, 1, 2

linked objects. See linked reporting objects (LRO)

linked partitions

attaching to cells, 1

changing, 1

creating, 1, 2, 3, 4, 5, 6

defined, 1

described, 1

disadvantages, 1

guidelines for selecting, 1, 2

implementing security measures, 1

mapping members, 1, 2

port usage, 1

testing, 1

linked reporting objects

setting maximum size using MaxL, 1

linked reporting objects (LRO)

assigning access levels, 1

changing member combinations, 1

checking structural integrity, 1

creating, 1

defined, 1

estimating disk space for, 1

format restrictions, 1

limiting size, 1

overview, 1, 2

removing from cells, 1

restructuring and, 1

retrieving, 1

storage management, 1

types supported, 1

viewing, 1, 2

Linked Reporting Objects dialog box, 1

links

currency conversions, 1

linked reporting objects, 1

missing, 1

partitioned databases, 1

related databases, 1, 2

supported types, 1

@LIST function, 1

list of members, generating, 1

LISTALIASES command, 1

LISTFILTERS command, 1

LISTGROUPS command, 1

LISTGROUPUSERS command, 1

LISTLINKEDOBJECTS command, 1, 2

LISTLOCATIONS command, 1

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, 1

referencing, 1, 2

LISTUSERS command, 1, 2

LISUSERS command, 1

LMARGIN command, 1

@LN function, 1

LOADALIAS command, 1

LOADAPP command, 1, 2

LOADDATA command

loading data without rules file, 1

loading free form data, 1

locating files, 1

LOADDB command, 1, 2, 3

loading

alias tables, 1

applications

with related database, 1

calc scripts, 1, 2, 3

data, 1, 2, 3

aborted transactions and, 1

dynamic calculations and, 1

for testing purposes, 1

from external sources, 1, 2, 3, 4

from partitioned applications, 1, 2, 3

from rules files, 1

getting information about, 1

incrementally, 1

missing values and, 1

optimizing, 1, 2, 3, 4

overview, 1, 2, 3, 4, 5

prerequisites, 1, 2

restrictions, 1, 2, 3, 4

supported formats, 1

tips, 1, 2

troubleshooting problems with, 1

unauthorized users and, 1

data files, 1

data sources, 1, 2, 3, 4

in Data Prep Editor, 1, 2, 3

prerequisites, 1

troubleshooting problems, 1, 2

error log files, 1

failed records only, 1

output files, 1

report scripts, 1, 2

rules files, 1, 2

prerequisites, 1

sample applications (problems with), 1

specific fields only, 1

specific records, 1

spreadsheets, 1, 2, 3

multiple, 1

SQL data sources, 1, 2

troubleshooting problems with, 1

subsets of data, 1, 2

text files, 1, 2

multiple, 1

update log files, 1

local access, 1

local currency, 1

locales

See also currency conversions

dimensions defining, 1, 2

partitioned applications and, 1

locating

end-of-file markers, 1

members in Calc Script Editor, 1

members in Formula Editor, 1

specific values, 1, 2

text

in report scripts, 1

text in formulas, 1

text in report scripts, 1

location aliases

advantages, 1

creating using MaxL, 1

displaying using MaxL, 1

editing or deleting, 1

Location Aliases dialog box, 1

locationi aliases

deleting using MaxL, 1

lock files, 1

Lock Manager, 1

overview, 1

Lock Partition Definition Files option, 1

locking caches into memory, 1

locking errors, 1, 2

locks, 1

applying, 1, 2, 3, 4, 5

committed access and, 1, 2

contention, 1

displaying, 1

generating reports and, 1

loading data, 1

managing, 1

maximum time to hold, 1

partition definition files, 1

removing, 1, 2, 3, 4

automatically, 1

setting for new users, 1, 2, 3

time-out settings, 1

types described, 1

uncommitted access and, 1

wait intervals, 1, 2

.LOG files, 1

@LOG function, 1

log files

application events, 1

calc scripts, 1

captures failing, 1

clearing contents, 1, 2

clearing using MaxL, 1, 2

controlling contents, 1

data load errors, 1

deleting, 1, 2

dimension builds, 1

dynamically calculated members, 1

maintaining, 1

moving through, 1, 2

outline changes, 1, 2

enabling/disabling, 1

overview, 1

restructuring and, 1

updating, 1

Server Agent activity, 1, 2

server events, 1

spreadsheet changes, 1

system errors, 1, 2

updating, 1

viewing contents, 1, 2, 3, 4, 5

viewing retrieval factor, 1

Log Viewer

checking calculations, 1

displaying

dynamically calculated members, 1

retrieval factor, 1

displaying server events, 1

opening, 1

@LOG10 function, 1

logarithms

calculating, 1, 2

calculating exponents, 1

logical conditions, 1, 2

See also Boolean expressions

LOGIN command, 1, 2, 3

login scripts (ESSCMD), 1

logins, 1

entering user name and password, 1, 2

limiting attempts, 1

partitioned applications, 1

process overview, 1

setting up, 1

logouts

from Application Manager, 1, 2

from Server Agent, 1, 2

LOGOUTUSER command, 1, 2

long file names, 1

LOOP/ENDLOOP command, 1, 2

loops, 1

losing connections, 1

loss, tracking, 1

Lotus 1-2-3 spreadsheets. See Spreadsheet Add-in

LRO catalog, 1

.LRO files, 1, 2, 3

LRO Manager, 1

overview, 1

LRO. See linked reporting objects (LRO)

@LSIBLINGS function, 1

.LST files, 1

.LWP files, 1

M

M, time balance codes in data source, 1

macros, custom-defined, 1

Main Database (defined), 1

main window (Application Manager), 1

maintaining applications, 1

maintaining data integrity, 1

maintenance tasks, 1, 2

management privileges, 1

mapping

area-specific partitions, 1, 2

in Partition Wizard, 1

attributes, 1

cells, 1

columns with no members, 1

data source/data target members

linked partitions, 1, 2

replicated partitions, 1, 2

transparent partitions, 1, 2

databases with location aliases, 1

fields to dimensions, 1

files (.TXT), 1

member fields to outlines, 1

members, 1

members to member fields, 1, 2, 3

members with different names, 1

partitioned members, 1

partitions

defining manually, 1, 2

replicated partitions, 1

specific fields only, 1, 2, 3

transparent partitions, 1

Mappings page (Partition Wizard)

defining linked mappings, 1

defining replicated mappings, 1

defining transparent mappings, 1

margin (profit), 1

margins, 1

market share (calculation example), 1

marketing sample reports, 1

marking blocks as clean and dirty, 1, 2

markup, 1

MASK command

entering in report scripts, 1, 2

overriding, 1

usage, 1

masks, 1, 2

@MATCH function, 1

Match Whole Word option

Formula Editor, 1

matching case, 1, 2, 3, 4, 5

matching members, 1, 2

mathematical calculations, 1

mathematical functions, 1, 2

mathematical operations

currency conversions, 1

formulas and, 1

missing values and, 1

performing on fields, 1

performing on members, 1

prerequisite for, 1

report scripts, 1, 2

specifying in data source, 1

mathematical operators, 1, 2

inserting in calc scripts, 1

inserting in formulas, 1

matrix-style access, 1

@MAX function, 1

Max member, Attribute Calculations dimension, 1

MaxL

building dimensions, 1, 2

creating report scripts, 1

running

calculations, 1

setting maxiumum attachment size, 1

specifying

data compression, 1

starting/stopping applications, 1

updating replicated partitions, 1

Maxl, 1

@MAXRANGE function, 1

@MAXS function, 1

@MAXSRANGE function, 1

@MDALLOCATE function, 1

@MDANCESTVAL function, 1

.MDB files, 1

@MDPARENTVAL function, 1

@MDSHIFT function, 1

.MDX files, 1

Measures dimension (example)

calculating period-to-date values, 1

changing for currency conversions, 1

media failure, 1

@MEDIAN function, 1

median, calculating, 1

member codes

property tags, 1

specifying, 1

member consolidation properties

described, 1

setting, 1, 2

member descriptions (in Hyperion MBA). See alias tables

member fields

defined in data source, 1

duplicate members and, 1

entering data, 1

formatting, 1

formatting rules, 1

in data source, 1

invalid, 1

mapping requirements, 1, 2, 3

member lists

calculating subset of, 1

generating, 1, 2, 3

referencing, 1, 2

member names

case sensitivity, 1

maximum length, 1

Member Properties dialog box

creating aliases, 1, 2

creating UDAs, 1

defining data storage properties, 1

renaming members, 1

setting consolidation properties, 1

setting two-pass calculations, 1

setting variance reporting tags, 1

tagging for Dynamic Calculations, 1

tagging members as label only, 1

member properties display option, 1

member selection

commands, 1

sorting members and, 1

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, 1

described, 1

generating lists, 1

in filter definitions, 1

inserting in formulas, 1

Member Specification dialog box

creating dynamically calculated members, 1

members, 1, 2

See also shared members

adding, 1, 2

as children of specified parent, 1

as siblings, 1, 2

example for, 1, 2

for currency conversions, 1, 2

guidelines for, 1

restrictions for, 1

through header information in the data source, 1

to dimensions, 1, 2, 3, 4, 5

to member fields, 1, 2

to outlines, 1, 2

adding comments about, 1

adding to report scripts, 1, 2

in precise combinations, 1

with common attributes, 1

applying skip properties, 1

assigning

alias combinations, 1

aliases to, 1, 2

properties to, 1, 2

values to combinations, 1

assigning aliases to, 1

associating base dimension members with attributes

in Outline Editor, 1

associating formulas with, 1

associating with report scripts, 1

Attribute Calculations dimension, 1

attribute dimensions, 1

naming, 1

prefixes and suffixes, 1

preventing creation, 1

resulting from formulas, 1

avoiding naming conflicts, 1

calculating across multiple parents, 1

calculating relationships between, 1

caution for sorting with shared, 1

changing, 1

changing combinations for linked objects, 1

changing properties, 1

clearing, 1

containing no data, 1

creating dynamic for time series, 1, 2

data distribution among, 1

default operator, 1

defined, 1

defining calculation order for, 1, 2

defining consolidations for, 1, 2

deleting from attribute dimensions, 1

dependent on others, 1

displaying

combinations, 1, 2

in outlines, 1, 2

in reports, 1

duplicate, 1

dynamically building, 1, 2, 3, 4, 5

dynamically calculating, 1, 2

restrictions, 1

excluding from consolidation, 1, 2

getting values for specific combinations, 1

grouping, 1, 2

inserting in calc scripts, 1, 2

inserting in formulas, 1

irrelevant across dimensions, 1

leaving unsorted, 1

mapping names to dimensions, 1

matching specified, 1, 2

missing in data sources, 1, 2

moving in outlines, 1

moving to new parents, 1

names as range of values, 1, 2, 3, 4

naming, 1, 2, 3

maximum character length, 1

nesting in reports, 1

numbering in data sources, 1

of attribute dimensions

sorting, 1

ordering in dense dimensions, 1

partitioning, 1

relationships described, 1, 2

removing from data sources, 1

renaming, 1

replicating, 1, 2

report example for missing, 1

searching in the Calc Script Editor, 1

searching in the Formula Editor, 1

selecting for dynamic calculations, guidelines for, 1, 2

selecting multiple, 1

sharing identical values, 1

sorting, 1, 2

sorting in reports, 1

specifying as case-sensitive, 1

storing, 1

testing for, 1

unique combinations for, 1

unspecified, 1

with no data values, 1

with non-changing names, 1

member-specific formatting commands, 1

memory, 1, 2

checking available, 1

clearing, 1, 2, 3

dynamically calculated values and, 1, 2

estimating requirements, 1

index cache size and, 1

index size and, 1, 2, 3

setting cache size, 1, 2, 3, 4

first-time calculations, 1

shortage, 1

storing data, 1

swapping, 1

memory buffers, 1, 2

memory, locking caches into memory, 1

menus

quick reference to commands, 1

@MERGE function, 1

merging member lists, 1

messages

displaying for calculations, 1, 2

example for displaying, 1

metadata, 1

metadata (in Hyperion MBA). See outlines

MIDDLE.REP, 1

migration, 1, 2

@MIN function, 1

Min member, Attribute Calculations dimension, 1

minimizing resources, 1

Minimum Database Access options (Application Settings), 1

@MINRANGE function, 1

@MINS function, 1

@MINSRANGE function, 1

minus signs (-)

as codes in data source, 1

in data fields, 1

in dimension and member names, 1

in member names, 1

in names in scripts and formulas, 1

in report scripts, 1

miscellaneous text, 1

mismatches, 1

MISS_LBL.REP, 1

MISSING displayed in cells, 1

missing links, 1

missing members, 1, 2

missing values, 1, 2

adding place holder for, 1

aggregating, 1

effects on calculation order, 1, 2, 3, 4

averages and, 1

calculating, 1, 2, 3

caution for data loads and, 1

caution for dimension fields, 1

formatting in reports, 1

handling, 1, 2, 3

identifying in data fields, 1

in calculations, 1

inserting into empty fields, 1

loading to parents, 1

optimal entry for, 1

overriding default for, 1

replacing with labels, 1

reporting samples, 1, 2

skipping, 1, 2

sorting data with, 1

testing for, 1

viewing with Personal Essbase, 1

MISSINGTEXT command

usage, 1

usage example, 1

mission-critical databases, 1

@MOD function, 1

@MODE function, 1

mode, calculating, 1

Modifications page (Database Information), 1

Modify Outline option

caution for disabling, 1

modifying

See also editing

access privileges, 1, 2, 3, 4

alias table names, 1

aliases, 1

calc scripts, 1, 2, 3

consolidations, 1

data, 1, 2, 3

prerequisite for, 1

data values, 1

default storage properties, 1

dimension names, 1

dimension properties, 1, 2, 3, 4

dimensions, 1, 2

default configurations, 1

for currency conversions, 1

formulas, 1, 2

headings in reports, 1

Hyperion Essbase kernel settings, 1, 2

scope and precedence, 1

with Application Manager, 1

with ESSCMD, 1, 2

linked partitions, 1

member combinations for linked objects, 1

member names, 1

members, 1

outlines, 1, 2, 3, 4

caution for, 1, 2, 3

dynamically, 1

for currency conversions, 1

with rules files, 1

passwords, 1

report layouts, 1

security settings, 1, 2

system password, 1, 2

modules, 1

modulus, calculating, 1

monitoring

applications, 1, 2

calculations, 1

month-to-date calculations, 1

@MOVAVG function, 1

Move Field dialog box, 1

moving

fields, 1

members and dimensions, 1

members to new parents, 1

moving average, calculating, 1

moving between databases, 1, 2

moving maximum, calculating, 1

moving median, calculating, 1

moving minimum, calculating, 1

moving through log files, 1, 2

@MOVMAX function, 1

@MOVMED function, 1

@MOVMIN function, 1

MS Access databases.See SQL databases

M-T-D time series member, 1, 2

multidimensional arrays, 1

multidimensional models, 1

conceptual overview, 1

data distribution in, 1

storage requirements, 1

multi-line column headings, 1

multiple

layout report, 1

partitions, 1

transactions, 1

multiple-pass calculations, 1, 2, 3

examples, 1, 2, 3, 4

usage overview, 1

multiplication

setting data consolidation properties, 1

multiplication operators, 1

multithreading, 1, 2, 3

setting number of threads, 1

multi-user environments, 1

performance considerations, 1

running ESSCMD in, 1

N

N, never allow data sharing code in data source, 1

Named Pipes connections, 1

names

See also column headings; field names; aliases

NAMESCOL command, 1

NAMESON command, 1

NAMEWIDTH command, 1

naming

arrays and variables, 1

batch files, 1

calc script files, 1, 2

dimensions, 1, 2, 3

ESSCMD script files, 1

fields, 1

filters, 1

generations, 1, 2, 3

levels, 1, 2, 3

members, 1, 2, 3, 4

members of attribute dimensions, 1

rules files, 1

shared members, 1

naming conflicts, 1, 2

naming conventions

aliases, 1, 2

applications, 1, 2

case sensitivity, 1, 2

databases, 1, 2

dimensions, 1

fields, 1

generations and levels, 1

members, 1, 2

passwords, 1

report files, 1

rules files, 1

UNIX files, 1

natural logarithms

calculating, 1

calculating exponents, 1

navigating between databases, 1, 2

negative numbers, formatting in reports, 1, 2

negative values

flipping, 1

in data fields, 1

variance as, 1

nesting

column headings, 1

columns in reports, 1

dimensions, 1

formatting commands, 1

formulas, 1, 2

IF statements, 1, 2

members in reports, 1

quotation marks in ESSCMD commands, 1

net present values, 1

network administrators. See administrators

networks, 1, 2

optimizing resources, 1, 2

reducing traffic during data load, 1

securing, 1

transferring data via, 1, 2

never share property, 1

description, 1

setting in data source, 1

Never Share tag, 1

New button (Application Manager), 1

New Group dialog box, 1

new line

as command separator, 1

as file delimiter, 1

New User dialog box, 1, 2

new users, 1

NEWPAGE command, 1

@NEXT function, 1

No Conversion property, 1

currency conversions and, 1

no loads, 1

#NOACCESS value, 1

node, 1

See also branches; trees

NOINDENTGEN command

usage, 1

usage example, 1

non expense property, 1, 2

None access level, 1, 2, 3, 4

None Currency Conversion property, 1

none time balance property, 1

non-typical data sets, 1

NOROWREPEAT command, 1

NOSKIPONDIMENSION command, 1

NOT operator, 1, 2

Note dialog box, 1, 2, 3

notes

adding to databases, 1

adding to partitions, 1, 2, 3

annotating to data cells, 1

display options, 1

storing, 1

viewing in Application Manager, 1

no-wait I/O, 1

.NP files, 1

@NPV function, 1

null values, 1

level references build method

null processing, 1

numbering

columns in reports, 1

members in data sources, 1

report pages, 1

numbers

calc scripts and, 1

calculated columns, 1

formatting, 1, 2

formulas and, 1

in array and variable names, 1

in member names, 1

in source data fields, 1

options for loading, 1, 2

rounding, 1, 2

truncating, 1

numeric

attribute dimensions

sorting members in outline, 1

tagging, 1

attributes

defined, 1

defining member names in ranges, 1

duplicate values, 1

size of ranges, 1

fields

with commas, 1

fields in data source, 1

parameters, 1

entering in ESSCMD scripts, 1

numeric parameters, 1

Numeric Range Rules dialog box, 1

numerical ordering (generations), 1

NUMERICPRECISION setting, 1

O

O, label only code in data source, 1

object handles, 1

object references, 1

objects, 1

See also linked reporting objects

copying, 1

creating filters for, 1

deleting, 1

linking to cells, 1

locking, 1, 2

renaming, 1

unlocking, 1

.OCL files, 1

clearing, 1

.OCN files, 1

.OCO files, 1

ODBC drivers, 1

ODBC files, 1

OFFCOLCALCS command, 1

OFFROWCALCS command, 1

OFSAMEGEN command

usage, 1

OLAP, 1

defined, 1

fundamentals, 1

getting started tips, 1

OLAP Server, 1

installing, 1

OLAP-aware modules, 1

.OLB files, 1, 2

.OLG files, 1, 2

OLTP, 1

ONCOLCALCS command, 1

Online Analytical Processing. See OLAP

Online Transaction Processing. See OLTP

ONROWCALCS command, 1

ONSAMELEVELAS command

usage, 1

Open button (Application Manager), 1

Open Client Data Files dialog box

opening data sources, 1

opening spreadsheets, 1, 2

opening text files, 1

updating dimensions, 1

Open Client Object dialog box

selecting calc script files, 1

Open Server Data File Object dialog box

opening data sources, 1

opening spreadsheets, 1, 2

opening text files, 1

updating dimensions, 1

Open Server Object dialog box

opening report scripts, 1

selecting calc script files, 1

open tasks, 1

opening

applications, 1, 2

Calc Script Editor, 1

calc script files, 1, 2

Data Prep Editor, 1, 2

data sources, 1

databases, 1, 2

Formula Editor, 1, 2

Log Viewer, 1

outlines, 1

caution for, 1

Partition Manager, 1

Report Editor, 1

report script files, 1, 2

rules files, 1, 2

sample applications (problems with), 1

spreadsheets, 1, 2

SQL data sources, 1, 2

text files, 1

operating system

information, 1, 2

recovery, 1

operations, 1

See also transactions

aborted transactions and, 1

automating routine, 1

canceling

archiving, 1

calculations, 1

canceling ESSCMD, 1, 2

causing corruption, 1

displaying field, 1

displaying replace, 1

failed, 1

maintaining data integrity for, 1

missing values and mathematical, 1

not supported, 1

privileges and routine, 1

restructure types defined, 1

undoing, 1, 2

viewing information about, 1, 2

operators

See also specific operator

calc scripts and, 1, 2

consolidation listed, 1

creating Boolean expressions with, 1

cross-dimensional, 1, 2

inserting in calc scripts, 1

inserting in formulas, 1, 2

overview, 1, 2

usage examples, 1, 2

default for members, 1

display options, 1

formulas and, 1, 2, 3, 4

inserting in formulas, 1

mathematical, 1, 2

calc scripts, 1

formulas, 1

order of precedence, 1

resetting in report scripts, 1

unary, 1, 2

usage overview, 1, 2

optimizing

access, 1, 2

cache, 1, 2

calculations, 1, 2, 3

with bottom-up calcs, 1

with calc scripts, 1

with calculator cache, 1

with dynamic calculations, 1, 2

with Intelligent Calculation, 1

with interdependent values, 1

with two-pass calculations, 1

data analysis, 1

data loading, 1, 2, 3, 4, 5

data manipulation, 1

data sources, 1, 2

disk read/writes, 1, 2

indexes, 1, 2

network resources, 1, 2

outlines, 1, 2

performance, 1, 2, 3, 4, 5, 6

queries, 1, 2

readability, 1

replication, 1

reports, 1, 2, 3

restructures, 1, 2

retrieval, 1, 2

sparse dimensions, 1, 2

storage, 1

transparent partitions, 1

optional parameters, 1

options

See also display options

application access, 1

calculations, 1, 2

dimension builds, 1

dimension updates, 1

dynamic builds, 1, 2

generating currency outlines, 1

global access, 1, 2, 3

Hyperion Essbase kernel, 1, 2, 3

isolation levels, 1

level and generation numbering, 1

password management, 1

restructuring outlines, 1

saving partition definitions, 1

setting up rules files, 1

viewing

currently set installation, 1

linked reporting objects, 1

OR operator, 1

select/reject criteria, 1, 2

Oracle databases. See SQL databases

ORDER command

usage example, 1, 2

ORDERBY command

entering in report scripts, 1, 2, 3

precedence, 1

usage, 1

usage example, 1

ORDERBY.REP, 1

ordering

cells in blocks, 1

data blocks, 1

data values, 1, 2

example, 1

dimensions in outlines, 1

fields, 1, 2

members in dense dimensions, 1

members in outlines, 1, 2

output values, 1

ordinary user privileges, 1

organizational databases, 1

organizing data (tutorial), 1

.OTL files, 1, 2, 3

.OTM files, 1

.OTN files, 1, 2

.OTO files, 1

OUTALT command, 1

OUTALTMBR command

entering in report scripts, 1

usage, 1

OUTALTNAMES command

entering in report scripts, 1

usage, 1

usage example, 1

OUTALTSELECT command

usage, 1

outline

attribute prefixes and suffixes, 1

Outline button (Application Manager), 1

outline calculation, 1

outline change log files, 1

contents described, 1, 2

enabling/disabling, 1

format example, 1

overview, 1

restructuring and, 1

setting size, 1

updating, 1

outline design

attribute dimensions, 1

performance considerations, 1, 2

Outline Editor, 1, 2

adding comments, 1

adding dimensions, 1

applying time balance tags, 1

associating attribute dimensions with base dimensions, 1

associating base dimension members with attributes, 1

Attribute Calculations dimension, 1

changes and restructuring impact, 1

components, 1

enabling/disabling, 1

creating

aliases, 1

aliases for member combinations, 1

dynamically calculated members, 1

outlines, 1

shared members, 1

UDAs, 1

creating dynamically calculated members, 1

customizing, 1, 2, 3, 4

defining

accounts dimension type, 1

attribute dimension type, 1

attributes, 1

country dimension type, 1

data storage properties, 1

dimension type, 1

time dimension type, 1

defining dimension type

Currency Partition, 1

removing dynamically calculated members, 1

renaming dimensions and members, 1

selecting multiple members, 1

setting consolidation properties, 1

setting two-pass calculations, 1

setting variance reporting tags, 1

starting, 1

tagging members as label only, 1

updating dimensions, 1

viewing outline members, 1

outline files, 1

copying, 1, 2, 3

creating, 1

cross-platform compatibility, 1

saving, 1

outline synchronization

described, 1

shared members, 1

Outline Synchronization Editor, 1

Outline Update dialog box, 1

OUTLINECHANGELOG parameter, 1, 2, 3

OUTLINECHANGELOGFILESIZE parameter, 1

outline-only restructure, 1

outlines, 1, 2

accessing, 1

adding alias tables, 1, 2

adding dimensions, 1, 2, 3, 4, 5

performance considerations, 1, 2

restructuring and, 1

adding members, 1, 2

applying changes, 1, 2

associating

calc scripts with, 1

member fields with, 1

rules files with, 1, 2, 3, 4

associating filters with, 1

bottom-up ordering, 1

changes impacting restructuring, 1, 2

changing, 1, 2, 3, 4

caution for, 1, 2, 3

dynamically, 1

with rules files, 1

components of, 1

controlling location of, 1

copying, 1, 2

with Application Manager, 1

creating, 1, 2, 3, 4

example for, 1

for currency conversions, 1, 2, 3

from data sources, 1

guidelines for, 1

prerequisites for, 1

with Outline Editor, 1, 2

creating formulas for, 1

customizing view, 1

defined, 1, 2

drafting for single-server databases, 1

expanding/contracting, 1

 

improving readability, 1

member relationships described, 1, 2

modifying for currency conversions, 1

naming

dimensions and members, 1

generations and levels, 1

opening existing, 1

caution for, 1

optimizing, 1, 2

optimum order of dimensions, 1

ordering dimensions, 1

ordering members, 1, 2

rearranging members and dimensions, 1

removing, 1

removing items, 1, 2

renaming, 1

repeating elements, 1

restructuring, 1

prerequisites for, 1

rules, 1

saving, 1, 2, 3

caution for, 1

description, 1

instructions, 1

sharing members, 1, 2, 3

caution for placing, 1

synchronizing, 1, 2

process summarized, 1, 2

warning for not applying changes, 1

with Application Manager, 1

with Partition Wizard, 1

with report scripts, 1

top-down ordering, 1

tracking changes, 1

updating, 1, 2

verifying, 1, 2

viewing

changes to, 1

dimensions in, 1

dynamically calculated members, 1

update information, 1

with unbalanced hierarchies, 1

OUTMBRALT command, 1

OUTMBRNAMES command, 1

output

displaying in columns, 1

formatting, 1

options, 1

ordering, 1

reporting example, 1

security information, 1

selecting specific values for, 1

sorting, 1

OUTPUT command, 1

output files, 1

See also log files

loading, 1

saving, 1

overhead, 1, 2, 3

checking compression ratio, 1

partitioned applications, 1

overlapping partitions, 1

overriding

column groupings in reports, 1

data filters, 1, 2

default calculation order, 1

default calculations, 1

file locks, 1

incremental restructuring, 1

security and access levels, 1

overwriting error log files, 1

overwriting existing values, 1

for currency conversions, 1

with values in data source, 1, 2

ownership, 1

P

.PAG files, 1, 2

page breaks

in report scripts, 1

suppressing, 1, 2

PAGE command

entering in report scripts, 1

in page layout, 1

usage example, 1

page files, 1

See also data files

page headings

adding to complex reports, 1

adding to free-form reports, 1

customizing, 1, 2

defined, 1

display options, 1

forcing immediate display, 1

suppressing, 1

using attributes in, 1

page layout commands, 1, 2

page layouts

See also reports

adding titles, 1

centering data, 1, 2

example, 1

changing, 1

customizing, 1, 2

examples, 1, 2

formatting, 1, 2, 3, 4

problems with, 1

formatting samples, 1, 2, 3, 4

inserting page breaks, 1, 2

numbering pages, 1

switching row/column display, 1

PAGEHEADING command, 1

PAGELENGTH command

overriding, 1

usage, 1

PAGEONDIMENSION command

usage, 1

usage example, 1

.PAN files, 1, 2

parallel export, 1

parameters

enclosure in quotation marks (ESSCMD), 1

entering in ESSCMD scripts, 1

referencing files, 1

PARCHIL.RUL, 1

PARCHIL.TXT, 1

@PARENT function, 1

PARENT command

usage, 1

parent field type

in header records, 1

in rules files, 1

sharing members, 1, 2, 3

PARENT. See parent field type

parent/child references build method

creating multiple roll-ups, 1

creating shared members, 1, 2, 3

creating shared roll-ups from multiple data sources, 1

described, 1

example rules file, 1

guidelines for using, 1

sharing members, 1, 2, 3

valid field types, 1

parent/child relationships, 1

data sources, 1

defining, 1

dynamic calculations and, 1, 2, 3

parentheses

in calc scripts, 1

in dimension and member names, 1

in formulas, 1

in names in scripts and formulas, 1, 2

in report scripts, 1, 2

indicating negative numeric values in fields, 1

parents

as shared members, 1

assigning children to, 1, 2, 3

associating members with, 1

calculation order for outlines, 1

calculations with multiple, 1

checking for, 1

defined, 1

getting, 1, 2

in time dimensions, 1

loading data into, 1

loading data to, 1

rolling up, 1, 2

setting values as average, 1

sharing members, 1

specifying for existing members, 1

with only one child, 1

@PARENTVAL function, 1, 2

PAREXPORT, 1

partial loads, 1

invalid members, 1

value out of range, 1

partition areas

changing shared, 1

defined, 1

defining, 1, 2, 3

Dynamic Time Series members in, 1

mapping to specific, 1, 2

in Partition Wizard, 1

partition definition files, 1

creating, 1

locking, 1

partition definitions

enclosing member names in quotation marks, 1

Partition Information dialog box, 1

Partition Manager, 1

changing links, 1

creating partitions, 1, 2, 3, 4

defining partitioned areas

replicated partitions, 1, 2

transparent partitions, 1, 2

editing partitions, 1

opening, 1

partition size, 1

Partition Wizard

closing, 1

defining area-specific mappings, 1

defining partitioned areas, 1, 2, 3

described, 1

editing partitions, 1

mapping linked members, 1, 2

mapping partitioned members, 1

mapping replicated members, 1, 2, 3

mapping transparent members, 1, 2

saving partition definition, 1

validating partitions, 1

partitioned applications

accessing data, 1

adding members, 1

calculating, 1

transparent, 1

connecting to, 1, 2, 3

creating, process summarized, 1

described, 1

designing, 1, 2, 3

scenarios for, 1, 2, 3

disadvantages of, 1

estimating disk space for, 1

examples of, 1

language requirements, 1

loading data, 1, 2, 3

performing calculations on, 1

replicated partitions and, 1

transparent partitions and, 1, 2, 3, 4

retrieving data, 1

running calc scripts, 1

single-server vs., 1

troubleshooting access to, 1

types of, 1

updating, 1, 2, 3, 4

guidelines, 1

remote data and, 1

viewing current state, 1

partitioned databases

accessing, 1, 2, 3

adding partitions for currency conversions, 1, 2

calculating, 1

transparent, 1

creating accounts for, 1, 2, 3

described, 1

dynamically calculating values, 1

filtering, 1, 2

implementing security measures, 1, 2, 3

linking data values, 1

maintaining, 1

restructuring, 1, 2

sample applications showing, 1

sharing data, 1, 2, 3

size and storage considerations, 1

storing data, 1, 2

sparse member combinations and, 1

with replicated partitions, 1

with transparent partitions, 1

synchronizing data across partitions, 1

synchronizing outlines, 1, 2

with Partition Wizard, 1

testing, 1, 2

time series reporting, 1

troubleshooting connections, 1

workflow, 1

partitioning

mapping attributes, 1

using attributes in, 1, 2

partitioning product suite, 1

licensing, 1

partitions

See also partitioned applications; partitioned databases, areas

advantages, 1

annotating, 1, 2, 3

calculating, 1

transparent, 1

controlling updates to, 1

creating, 1, 2, 3, 4, 5

for currency conversions, 1, 2

process summarized, 1

defined, 1

defining, 1, 2, 3

linked, 1, 2

multiple, 1

replicated, 1, 2, 3

transparent, 1, 2, 3

with Partition Wizard, 1, 2, 3, 4

deleting, 1

discarding changes to, 1

dynamic calculations and, 1, 2

editing, 1

getting type, 1

mapping guidelines, 1, 2

mapping members, 1

overlapping, 1

parts described, 1

performance

improving, 1

port usage, 1, 2, 3

primary/secondary sites defined, 1

restructuring performance and, 1

saving definitions, 1

selecting type, 1, 2, 3, 4, 5

in Partition Wizard, 1, 2, 3, 4

top-down vs. bottom-up, 1

troubleshooting, 1

usage examples, 1

replicated partitions, 1

transparent partitions, 1

using attributes in, 1

validating, 1

viewing currently defined, 1, 2

PASSWORD command, 1

usage overview, 1

Password Management options (Server Settings), 1

passwords

assigning generic, 1

changing, 1

changing others' using MaxL, 1

connections, 1

entering in logins, 1, 2

forcing users to change, 1, 2, 3

in partitions, 1

masking, 1, 2

setting, 1

new users, 1, 2

partitioned databases, 1

system, 1, 2

pasting

calc scripts into Calc Script Editor, 1

formulas into Formula Editor, 1

text into calc scripts, 1

text into formulas, 1

text into report scripts, 1

path information, 1

pattern matching, 1, 2

payroll, 1

percent signs (%)

as codes in data source, 1

in names in scripts and formulas, 1

in report scripts, 1

percentages

allocating, 1

calculating, 1, 2

displaying in reports, 1, 2

returning variance, 1, 2, 3

setting consolidation properties, 1

specifying in data source, 1

performance, 1, 2

calculation, 1, 2, 3

checking, 1, 2

getting information about, 1, 2

linked partitions and, 1, 2

log files and, 1

multi-user considerations, 1

optimizing, 1, 2, 3, 4, 5, 6, 7

recommended settings, 1

replicated partitions and, 1

restructure operations and, 1, 2

transparent partitions and, 1

performance statistics, 1

performance-related storage settings, 1, 2

scope, 1

periodic year to date (in Hyperion MBA). See dynamic time series members

periods (.)

in application and database names, 1

in dimension and member names, 1

in names in scripts and formulas, 1

period-to-date calculations, 1

period-to-date values, 1

calculating, 1, 2

retrieving, 1

Personal Essbase, 1

copying data to, 1

prerequisites, 1

copying outlines to, 1, 2, 3

creating applications and databases, 1

installing, 1

loading data, 1

loading output files, 1

viewing data, 1

PIDs, finding for Hyperion Essbase applications, 1

pivoting, 1

platforms, 1

complete listing, 1

porting applications across, 1, 2

creating backups for, 1

redefining information for, 1

porting applications to UNIX servers, 1

plus signs (+)

as codes in data source, 1

in application and database names, 1

in dimension and member names, 1

in member names, 1

in names in scripts and formulas, 1, 2

pointers

data blocks, 1

member combinations, 1

shared data values, 1, 2

populating replicated partitions, 1

porting applications, 1, 2

creating backups for, 1

redefining server information, 1

to UNIX platforms, 1

ports

and linked partitions, 1

and replicated partitions, 1

and transparent partitions, 1

displaying available, 1, 2

displaying installed, 1, 2

displaying list of available, 1

freeing, 1, 2

licensed and multithreading, 1

protocol-specific assignments, 1

reserved, 1

running out of, 1

PORTS command, 1

usage overview, 1

positive values, 1

variance as, 1

poundt signs (#)

in array and variable names, 1

@POWER function, 1

power down (caution), 1

power failures. See failures; recovery

power loss, 1

precedence

calculations, 1

precision, 1

predefined Dynamic Time Series members, 1

enabling/disabling, 1, 2

generation names for, 1

in shared areas, 1

listed, 1

specifying aliases for, 1

predefined routines, 1, 2

prefixes

adding to fields, 1

assignment sequence in data build, 1

attribute member names, 1, 2, 3

member and alias names, 1

Pre-image Access option, 1, 2

locks and, 1

preventing calculation delays, 1

preventing system failures, 1, 2

primary roll-ups, 1, 2, 3

Print Calc Script dialog box, 1

printed documentation, 1

additional resources, 1

suggested audience, 1

typographical conventions, 1

printing

calc scripts, 1

formulas, 1

reports, 1, 2

PRINTPARTITIONDEFFILE command, 1

PRINTROW command, 1

@PRIOR function, 1, 2

privileges, 1

Application Designer, 1

applying to groups, 1

assigning

global, 1, 2, 3, 4

to users and groups, 1

assignment examples, 1, 2, 3, 4, 5

changing, 1, 2, 3, 4

global security settings and, 1

global types, 1

inheritance from group, 1

inheriting, 1, 2

insufficient, 1

layers defined, 1

levels defined, 1

linked reporting objects, 1

overriding, 1

planning for user access, 1

replicating, 1

required, 1

routine operations and, 1

setting filters and, 1, 2

transactions and, 1

types listed, 1, 2

user types, 1

procedural commands, 1

process IDs, finding for Hyperion Essbase applications, 1

processes, 1, 2

monitoring, 1

processing requests, 1, 2

processors, 1

calculations across multiple, 1

supported as clients, 1

product and market shares, 1

Product dimension (example), 1

product version, 1, 2

profit and loss, 1, 2

example for tracking, 1

profit margins, 1

dynamically calculating, 1

program files, 1

programming interface. See API (Application Programming Interface)

programming languages (supported), 1

programming objects, 1

programming-specific files, 1

propagating outline changes. See synchronizing

properties, 1

changing dynamically, 1, 2, 3, 4

consolidation, 1, 2, 3

currency conversion, 1

data storage, 1, 2

defining

caution for two-pass tags, 1

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, 1

dimension building

field types, 1

dynamic calculations, 1

setting dynamically, 1

shared member, 1, 2

time balance, 1

Time Series, 1

two-pass calculations, 1

variance reporting, 1, 2

properties bar (Outline Editor), 1

properties in outlines, 1

property field type

in header records, 1

in rules files, 1

nulls and, 1, 2

specifying in data source, 1

PROPERTY. See property field type

protecting data, 1, 2

See also security

@PTD function, 1, 2, 3

P-T-D time series member, 1, 2

PURGELINKEDOBJECTS command, 1, 2

PURGEOTLCHANGEFILE command, 1

purging log files, 1

PUTALLREPLCELLS command, 1

PUTUPDATEDREPLCELLS command, 1

PYRAMIDHEADERS command, 1, 2

Q

Q-T-D time series member, 1, 2

quarterly values, 1

quarter-to-date calculations, 1

example, 1

queries, 1

optimizing performance, 1

question marks (?)

in application and database names, 1

used as wildcard, 1

QUIT command, 1, 2

usage overview, 1

quitting

See also closing; exiting; stopping

Essbase, 1, 2

Partition Wizard, 1

quotation marks, double (")

and ESSCMD commands, 1

enclosing member names, 1, 2, 3

in application and database names, 1

in calc scripts, 1

in dimension and member names, 1

in formulas, 1, 2

in report scripts, 1

in scripts and formulas, 1, 2

quotation marks, single (')

in application and database names, 1

in dimension and member names, 1

QUOTEMBRNAMES command, 1

R

@RANGE function, 1

range functions, 1, 2, 3, 4

formulas and, 1

range of values

See also ranges

calculating, 1

copying, 1

data exceeding, 1

duplicate members in, 1

getting next member, 1

iterating through, 1

member names as, 1, 2, 3, 4

optimizing data loads with, 1

reading multiple, 1

report member selection, 1, 2

setting automatically, 1

ranges

numeric

caution regarding inserting new values, 1

dimension building summary, 1

numeric attributes, 1, 2

automatic building, 1

building multilevel (example), 1

different sizes, 1

@RANK function, 1

ranking values, 1

ratios, 1

raw data sources, 1

viewing, 1

@RDESCENDANTS function, 1

Read locks, 1

described, 1

with committed access, 1, 2

with uncommitted access, 1

Read Only privilege, 1

Read privilege, 1, 2

Read/Write privilege, 1

reads, 1

getting number of, 1

optimizing, 1

rearranging fields, 1, 2

reboot (caution), 1

rebuilding databases, 1

recalculating data, 1, 2, 3, 4

after exporting, 1

Dynamic Calc And Store members, 1

examples, 1

for Personal Essbase servers, 1

in sparse dimensions, 1, 2

Intelligent Calculation and, 1, 2

two-pass calculations and, 1

reconfiguring dimensions, 1

Record View Count dialog box, 1

records

See also rows

adding to data sources, 1, 2, 3

as headers in rules files, 1, 2

bottom-up ordering and, 1

defined, 1

defining operations for rules files, 1

defining roll-ups for, 1, 2, 3

in data source, 1

loading specific range, 1

missing from error logs, 1

rejecting for loads, 1

reloading failed, 1

selecting, 1, 2, 3

setting parent/child relationships, 1

sorting to optimize data loading, 1

top-down ordering and, 1

types in data sources, 1

viewing, 1, 2

with extra fields, 1

recovery, 1, 2

calculations not completing, 1

caution for loading data and, 1

failed operations, 1

improper shutdowns, 1

managing, 1

procedures, 1

redundant data and, 1

restructuring databases, 1

server crashing, 1, 2, 3

suggested procedures, 1

redefining server information, 1

reducing database size, 1

reducing network traffic, 1

redundant data, 1, 2

references

caution for, 1

data values, 1, 2, 3, 4

dynamic, 1, 2

record numbers in, 1

dynamically calculated members, 1

filters and updating, 1

forward calculation, 1

generation, 1

null processing, 1

sample rules file, 1, 2

shared members, 1

level, 1

example rules file, 1, 2

null processing, 1

sample rules file, 1

shared members, 1, 2, 3

linked files, 1

lists, 1, 2

objects, 1

parent/child, 1

example rules file, 1

sharing members, 1, 2, 3

specific values, 1

refresh replicated partition (MaxL), 1

refreshes

data, 1

dialog boxes, 1

Region dimension (example), 1

registration

of custom-defined functions, 1

of custom-defined macros, 1

Reject Record dialog box, 1

rejection criteria

defining multiple for single field, 1

defining on multiple fields, 1

example, 1

locating end-of-file markers with, 1

specifying in rules file, 1, 2

relational databases. See databases

relational storage manager, 1

relationship among members, 1, 2, 3

report example for missing, 1

relationship functions, 1

formulas and, 1, 2

Intelligent Calculation and, 1

@RELATIVE function, 1

reloading database files, 1

reloading exported data, 1

@REMAINDER function, 1

remainders, 1

remote locations

accessing, 1

manipulating data, 1

retrieving data, 1, 2, 3

remote partitions. See transparent partitions

@REMOVE function, 1

Remove Unspecified option, 1

REMOVECOLCALCS command

entering in report scripts, 1

usage, 1

REMOVELOCKS command, 1

REMOVEUSER command, 1

removing

See also clearing

aliases, 1

applications, 1, 2

calc scripts, 1, 2

contents from alias tables, 1

data blocks, 1

databases, 1

dimensions, 1

restructuring and, 1

filters, 1

formulas, 1

items from outlines, 1, 2

linked objects, 1

locks, 1, 2, 3, 4

automatically, 1

log files, 1, 2

members from data sources, 1

members from member lists, 1

objects, 1

partitions, 1

substitution variables, 1

temporary files, 1

text in calc scripts, 1

text in formulas, 1

text in report scripts, 1

user groups, 1

users, 1, 2

white space in fields, 1

Rename Alias Table dialog box, 1

Rename Application dialog box, 1

RENAME command, 1

Rename Database dialog box, 1

Rename Filter dialog box, 1

Rename Group dialog box, 1

Rename Object dialog box, 1

Rename User dialog box, 1

RENAMEAPP command, 1

RENAMEDB command, 1

RENAMEFILTER command, 1

RENAMEUSER command, 1

renaming

alias tables, 1

applications, 1

databases, 1

dimensions, 1

error log files, 1

files with FTP, 1

filters, 1

members, 1

objects, 1

users and groups, 1

renumbering data blocks, 1

.REP files, 1, 2

Replace dialog box, 1

replace operations, 1

replacing

empty fields with values, 1

missing values with text, 1, 2

text in formulas, 1

text in report scripts, 1

text strings, 1

replicated partitions

creating, 1, 2, 3, 4, 5, 6, 7

defined, 1

disadvantages, 1

dynamically calculated values in, 1

example of, 1

guidelines for selecting, 1, 2

implementing security measures, 1

improving performance, 1

mapping members, 1, 2

by importing, 1

port usage, 1

storage considerations, 1

updating data, 1, 2, 3

guidelines, 1

usage restrictions, 1

replicating

See also copying; duplicating

data files, 1

partial data sets, 1

problems with, 1

Replication Properties dialog box, 1

REPORT command, 1, 2

Report Editor

creating scripts, 1

described, 1

editing scripts, 1, 2, 3

opening, 1

running report scripts, 1

specifying output destinations, 1, 2, 3

text editing commands, 1

Report Extractor

associating members with dimensions, 1

described, 1

errors, 1

extracting data, 1

extraction order, 1

generating free-form reports, 1

ignored characters, 1

internal numerical comparisons, 1

report files

creating, 1

naming, 1

report formatting

commands, 1, 2

report formatting commands

calculations, 1, 2

caution for usage, 1, 2

defined, 1

display options, 1, 2

listed, 1

nesting, 1

output, 1

report headings, 1, 2, 3, 4

types described, 1

report generation functions, 1

report output commands, 1

Report Output Options dialog box

described, 1

opening, 1

Report Script button (Application Manager), 1

report script examples, 1

adding aliases, 1, 2

calculations, 1, 2, 3

changing data combinations, 1

creating asymmetric columns, 1

customizing page layouts, 1, 2

formatting layouts, 1, 2, 3, 4

grouping rows, 1

handling missing values, 1

narrowing member selection, 1

nesting columns, 1

ordering data, 1

restricting data retrieval, 1

sorting data values, 1, 2, 3

report script files

adding scripts, 1

default location, 1

location of sample, 1

naming, 1

opening, 1, 2

report scripts

See also reports

adding comments, 1

adding conditions, 1, 2

examples, 1, 2, 3

adding members, 1, 2

adding variables, 1, 2, 3, 4

associating members with, 1

batch files and, 1

caution for aliases in, 1

caution for non-changing names in, 1

copying, 1

creating, 1, 2

basic techniques, 1, 2

in ESSCMD, 1

in MaxL, 1

parts described, 1

creating with Application Manager, 1

currency conversions and, 1

defined, 1

defining page layouts, 1, 2, 3

editing, 1, 2, 3, 4

exporting data with, 1

finding and replacing text in, 1, 2

formatting

calculated values, 1, 2

report layouts, 1, 2, 3

reports, 1

formatting calculated values, 1

inserting

equations in, 1

formulas in, 1

inserting UDAs, 1

loading, 1, 2

names with special characters, 1, 2

naming restrictions, 1

ordering data values, 1, 2, 3

resetting operators, 1

running

basic techniques, 1, 2, 3

examples, 1

in ESSCMD, 1

single line only, 1

with Application Manager, 1

running with Application Manager, 1

saving, 1

selecting members

with common attributes, 1

selecting members for column groups, 1

selecting precise member combinations, 1

sorting members, 1

suppressing shared member selection, 1

synchronizing outlines with, 1

unlocking, 1

using members of attribute dimensions, 1

wildcards in, 1

Report Viewer, 1

Report Writer

See also report scripts

commands described, 1

creating text files, 1, 2

main components, 1

online help, 1

optimizing retrieval, 1, 2

reporting objects (linked)

assigning access levels, 1

changing member combinations, 1

checking structural integrity, 1

creating, 1

defined, 1

estimating disk space for, 1

format restrictions, 1

limiting size, 1

overview, 1, 2

removing from cells, 1

restructuring and, 1

retrieving, 1

storage management, 1

types supported, 1

viewing, 1, 2

REPORTLINE command, 1, 2

reports

See also time series reporting

ad hoc currency, 1

adding blank spaces, 1

adding calculated columns, 1, 2

adding headings, 1, 2, 3, 4

adding page breaks, 1, 2

adding titles, 1

adjusting column length, 1

associating with databases, 1

basic techniques, 1

building, 1, 2, 3

basic techniques, 1, 2

with API function calls, 1

calculating currency conversions, 1

changing

headings in columns, 1

layouts, 1

clearing values in calculated columns, 1, 2

creating two-dimensional, 1, 2

customizing page layouts, 1, 2

examples, 1, 2

defining multiple layouts, 1

designing, 1, 2, 3

developing free-form, 1

displaying member names, 1

dynamically calculated values and, 1

eliminating data duplication, 1

improving readability, 1

numbering columns, 1

optimizing, 1, 2, 3

ordering output values, 1

printing, 1, 2

problems with formatting, 1

repeating column/row headings, 1, 2

replacing missing values, 1

restricting data retrieval, 1, 2

example, 1

retrieving data values, 1

setting maximum rows allowed, 1

with conditions, 1, 2

saving, 1

setting up output destinations, 1, 2, 3

suppressing formatting in, 1, 2

terminating, 1

updating, 1

variance reporting examples, 1

repositories, 1

REPTKBYTESORTBUF setting, 1

requests, 1, 2, 3

Dynamic Calculations and, 1

partitioned applications, 1

processing, 1, 2

reserved names, 1

reserved words, 1, 2

RESETOTLCHANGETIME command, 1

RESETSTATUS command, 1

resources

checking usage, 1

minimizing, 1

optimizing network, 1, 2

partitioning databases and, 1, 2

restarting system, 1

restoring security settings, 1

RESTRICT command

entering in report scripts, 1, 2

NUMERICPRECISION parameter, 1

usage, 1

usage example, 1

RESTRICT.REP, 1

Restructure Database dialog box, 1, 2

restructure operations, 1

improving performance, 1, 2

incremental, 1, 2

optimizing, 1, 2

outline changes impacting, 1, 2

restructuring

attribute dimensions, 1

data blocks, 1, 2, 3

data files, 1, 2

databases, 1, 2

changing outlines and, 1, 2

dynamic calculations and, 1

immediately, 1, 2

Intelligent Calculation and, 1, 2

process described, 1, 2

indexes, 1

linked reporting objects and, 1

outlines, 1

prerequisites for, 1

partitioned databases, 1, 2

recovery and, 1, 2

restructuring conflicts, 1

retrieval buffer

sizing with MaxL, 1

retrieval buffer size

setting using MaxL, 1

Retrieval Buffer Size option, 1

retrieval buffers, 1, 2, 3

retrieval factor, 1

displaying, 1

retrieval sort buffer size

setting using MaxL, 1

Retrieval Sort Buffer Size option, 1

Retrieval Wizard, 1

retrieving

cross-database values, 1

data, 1

data blocks, 1, 2, 3

size and density, 1

data values for reports, 1

placing restrictions on, 1, 2, 3

setting maximum rows allowed, 1

with conditions, 1, 2, 3, 4

data values from remote databases, 1, 2, 3

Dynamic Time Series members, 1

dynamically calculated values, 1, 2, 3, 4

linked reporting objects, 1

member combinations, 1

partition type, 1

period-to-date values, 1

specific values, 1, 2

unique values, 1

values for sparse dimensions, 1

reversing data values, 1

RLE data compression, 1, 2, 3

overview, 1

specifying, 1

rollbacks, 1, 2, 3

outlines, 1

rolling average values, 1

rolling back transactions. See recovery

roll-ups

See also consolidation

building multiple, 1

examples, 1, 2, 3

implementing, 1

maximum number in records, 1, 2

member consolidation and, 1

multiple data sources, 1

optimizing, 1

ordering in rules files, 1

setting for time balance properties, 1, 2

shared members, 1, 2

root member (defined), 1

@ROUND function, 1

rounding, 1, 2

routine operations, 1

privileges and, 1

routines, 1, 2

row calculation commands, 1

ROW command

entering in report scripts, 1

usage example, 1

row headings, 1

adding to reports, 1

defined, 1

names truncated, 1

repeating, 1

suppressing, 1

ROWAVG.REP, 1

ROWCALC1.REP, 1

ROWCALC2.REP, 1

ROWGROUP.REP, 1

ROWREPEAT command

entering in report scripts, 1

usage, 1

usage examples, 1

rows

See also records

attributes in report scripts, 1

calculating totals, 1

calculation sample reports, 1, 2, 3

formatting

empty values in, 1

missing values in, 1

with different member names, 1

grouping in reports, 1

in data sources, 1

restrictions on retrieval, 1

setting qualifications for retrieval, 1, 2, 3

setting transactions levels, 1

switching with columns, 1

.RPT files, 1

@RSIBLINGS function, 1

.RUL files, 1

See also rules files

rules

creating aliases, 1

creating shared members, 1

data entry in member fields, 1

data load

creating, 1

when to use, 1

data loads, 1

defining attribute dimensions, 1

defining attributes, 1

defining dimension type, 1, 2

dimension builds, 1

formatting data sources, 1, 2, 3, 4, 5

formatting free-form data sources, 1, 2

replicated partitions, 1

replicating

data, 1

transparent partitions, 1, 2

UDAs, 1

rules files

adding members with, 1, 2

associating

with data sources, 1

with outlines, 1, 2, 3, 4

associating aliases with attributes, 1

attribute associations, 1

bottom-up ordering, 1, 2

building dimensions, 1, 2, 3, 4

building shared members, 1

different generation, 1, 2

same generation, 1, 2, 3

with branches, 1, 2

changing field names, 1

copying, 1

creating, 1, 2

process overview, 1

creating new fields, 1

cross-platform compatibility, 1

for dimension builds, 1

generation references and, 1, 2, 3

header records and, 1, 2

initializing, 1

invalid, 1

level references and, 1, 2, 3, 4

loading, 1, 2

prerequisites, 1

logging load errors, 1

manipulating fields in, 1

naming, 1

opening, 1

optimizing usage, 1

options for setting up, 1

parent/child builds, 1, 2, 3, 4

position of fields, 1, 2

replacing text strings, 1

restrictions for entering field types, 1

saving, 1, 2

setting global options, 1

specifying field types, 1

SQL data sources and, 1, 2

top-down ordering, 1

usage overview, 1, 2, 3, 4

validating, 1, 2, 3

troubleshooting problems with, 1

with blank fields, 1

Run button (Application Manager), 1

RUNCALC command, 1

Run-Length Encoding. See RLE data compression

running

batch files, 1, 2

calc scripts, 1, 2, 3, 4

aborted transactions and, 1

on partitioned applications, 1

calc scripts with Application Manager, 1

currency conversions, 1, 2, 3

ESSCMD, 1, 2

caution for pausing systems while, 1

in interactive mode, 1

multiple report script files, 1

report scripts

basic techniques, 1, 2, 3

examples, 1

in ESSCMD, 1

single line only, 1

with Application Manager, 1

report scripts with Application Manager, 1

RUNREPT command, 1

run-time information, 1

Run-time page (Database Information), 1, 2

S

salary databases, 1, 2

sales, 1

allocating percentages for, 1

estimating profits, 1

period-to-date values, 1

reporting

sample for market selection, 1

sample for percentages, 1

samples for actual, 1, 2

year-to-date and rolling averages, 1

Sampeast application, 1

partitioning examples, 1

replicated partitions in, 1, 2

transparent partitions in, 1

Sampeast East database

provided with Hyperion Essbase, 1

Sample application, 1

creating simple reports, 1

currency conversion databases, 1

Sample Basic database

batch mode processes, 1

consolidation example, 1

creating calc scripts, 1

creating formulas for outlines, 1

creating outlines for, 1

defining calculations for, 1, 2, 3

actual values, 1

allocating values, 1, 2

allocating values across one dimension, 1

data subsets, 1

forecasting future values, 1

forward references and, 1

increasing budgets, 1

percentage of variance, 1

product and market share, 1

sales and profit, 1

shared members in, 1

specific cells, 1, 2, 3, 4

dense dimensions in, 1, 2, 3

dynamically calculating data, 1

generating reports, 1

header and mapping information in, 1

Intelligent Calculations on, 1, 2, 3

loading new budget values, 1

optimal dimension configurations, 1

optimizing calculations in, 1, 2, 3

partitioning examples, 1, 2, 3, 4

provided with Hyperion Essbase, 1

report calculations in, 1

report formatting examples, 1, 2, 3

sample reports, 1

selecting members for reports, 1, 2

sorting example, 1

sparse dimensions in, 1, 2, 3

two-pass calculations in, 1

sample databases, 1

SAMPLE directory, 1

sample ESSCMD script files, 1

sample reports, 1

adding aliases, 1, 2

changing data combinations, 1

creating asymmetric columns, 1

customizing page layouts, 1, 2

formatting layouts, 1, 2, 3, 4

grouping rows, 1

handling missing values, 1

narrowing member selection, 1

nesting columns, 1

ordering data, 1

restricting data retrieval, 1

sorting data values, 1, 2, 3

using attributes, 1, 2

using attributes in member selection, 1

sample script files, 1

Samppart application, 1

partitioning examples, 1

replicated partitions in, 1, 2

transparent partitions in, 1

Samppart Company database

provided with Hyperion Essbase, 1

@SANCESTVAL function, 1

Save As command, 1

Save Client Object dialog box

saving calc scripts, 1, 2

Save Server Object dialog box

copying outlines, 1

saving calc scripts, 1, 2, 3

saving rules files, 1

SAVEANDOUTPUT command, 1

SAVEROW command

restrictions, 1

usage, 1

usage example, 1

saving

attachments, 1

calc scripts, 1, 2, 3

on client workstations, 1, 2

filters, 1

formulas, 1

outline files, 1

outlines, 1, 2, 3, 4, 5

caution for, 1

output files, 1

partition definitions, 1

report scripts, 1

reports, 1

rules files, 1, 2

security profiles, 1, 2, 3

scalability, 1

scaling data values, 1

scope

checklist for analyzing, 1

determining, 1

Hyperion Essbase kernel settings, 1

.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, 1

members in Calc Script Editor, 1

members in Formula Editor, 1

returning specific values, 1, 2

sequential, 1

text

in calc scripts, 1

in formulas, 1

in report scripts, 1, 2

viewing information about index, 1

season-to-date calculations, 1

.SEC files, 1, 2

secondary fields, 1, 2

secondary roll-ups, 1, 2, 3

security, 1, 2

See also access; filters; privileges

access levels listed, 1, 2, 3

backup files, 1

changing for users and groups, 1, 2

checking information about, 1

implementing, 1, 2

for users and groups, 1, 2, 3, 4

globally, 1, 2, 3, 4

guidelines for, 1

system server, 1, 2

information file, 1

layers defined, 1

linked reporting objects, 1

maintaining information for, 1

managing, 1, 2, 3, 4

for large number of users, 1

modifying user access settings, 1

overriding, 1

planning for, 1

profiles

copying, 1, 2

creating, 1

deleting users and groups, 1

editing, 1

saving, 1, 2, 3

sample solutions, 1, 2, 3, 4, 5

saving information to ASCII files, 1, 2

setting up for partitioned databases, 1, 2, 3

security file

backup of, 1

contents of, 1

cross-platform compatibility, 1

filter storage, 1

restoring, 1

Security System, 1

See also security

security types

Create/Delete Users/Groups, 1

defined, 1

ordinary, 1

Supervisor, 1

.SEL files, 1

SELECT command, 1, 2, 3

select criteria. See selection criteria

Select Database dialog box, 1

Select Record dialog box, 1

Select Server, Application and Database dialog box, 1

select statements. See SQL databases

selecting

alias tables, 1, 2

applications for loading, 1

with ESSCMD, 1

build methods, 1, 2

calc script files, 1, 2

data sources, 1, 2, 3, 4, 5

using Windows, 1

data targets, 1

data to partition, 1, 2, 3

databases for loading, 1

with ESSCMD, 1

dimension type, 1, 2, 3, 4

guidelines for, 1

fields, 1

members for dynamic calculations, 1

guidelines for, 1, 2

members for report scripts, 1, 2, 3

from Dynamic Time Series, 1

with ATTRIBUTE command, 1

with Boolean operators, 1

with conditions, 1

with substitution variables, 1

with TODATE command, 1

with UDAs, 1

with wildcards, 1

with WITHATTR command, 1

members, for column groupings, 1

multiple dimensions and members, 1

multiple files, 1, 2

multiple members, 1

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, 1

values for dynamic calculations, 1, 2

guidelines for, 1, 2

selection criteria, 1

defining multiple for single field, 1

defining on multiple fields, 1

specifying in rules file, 1

semantic errors, 1, 2

semicolons (;)

in application and database names, 1

in calc scripts, 1, 2, 3, 4

in ESSCMD syntax, 1

in formulas, 1, 2, 3

in names in scripts and formulas, 1, 2

separators

See also file delimiters

commas in numbers, 1

member lists, 1

report script commands, 1, 2

sequential searches, 1

server, 1, 2

application startup, 1

caution for improper shutdown, 1

caution for rebooting, 1

changing system password for, 1, 2

client requests and, 1, 2, 3

client/server model described, 1

client-server model described, 1, 2

communicating with clients, 1

connecting to. See connections

crashes, recovering from, 1, 2, 3

suggested procedures, 1

cross-platform compatibility, 1

disconnecting users, 1, 2

displaying

access settings, 1, 2

active groups, 1

current users, 1, 2, 3

displaying version number, 1, 2

functionality described, 1

getting information about, 1, 2

installing, 1

interruptions, 1

loading data from, 1

logging errors, 1

logging out of, 1, 2, 3, 4

moving data sources to, 1

partitioning databases across multiple, 1

redefining information, 1

restrictions, 1

securing, 1, 2

setting internal buffer, 1

shutting down, 1, 2

starting, 1

system supervisor defined, 1

unavailable, 1, 2

viewing log file, 1

writing calc scripts to, 1

Server Agent, 1, 2

See also server console

accessing, 1

activity recording, 1, 2

commands listed, 1

displaying available commands, 1

handling requests, 1

monitoring applications, 1

overview client-server communications, 1, 2

setting number of threads, 1

server applications. See client-server applications

server console, 1

exception occurred messages in, 1

overview, 1

shutting down server, 1, 2

starting applications, 1

starting databases, 1

starting Essbase server, 1

stopping applications, 1, 2

multiple simultaneously, 1

stopping databases, 1, 2

server errors, 1

server event log files, 1

deleting, 1

viewing contents, 1

Server Information dialog box, 1

server interface, 1

Server Settings dialog box

auto logoff, 1

password management, 1

SERVERTHREADS setting, 1

SET AGGMISSG command

and allocating costs, 1

and member combinations, 1

described, 1, 2

SET CACHE command, 1

SET CALCHASHTBL command, 1, 2

performance considerations and, 1

SET CLEARUPDATESTATUS command, 1

calculating subsets with, 1

concurrent calculations and, 1

Intelligent Calculation and, 1, 2, 3, 4, 5, 6

multi-pass calculations, 1, 2, 3

parameters listed, 1

two-pass calculations, 1, 2

Set Current Alias Table dialog box, 1

Set Database Note dialog box, 1

Set Default Calc dialog box, 1

SET FRMLBOTTOMUP command, 1, 2

SET LOCKBLOCK command, 1, 2

SET MSG command, 1, 2

SET MSG DETAIL command, 1

SET MSG SUMMARY command, 1, 2

usage example, 1

SET NOTICE command, 1, 2, 3

set number of export threads, 1

SET UPDATECALC command, 1, 2

usage example, 1

SET UPDATECALC OFF command, 1

SET UPTOLOCAL command, 1

SETALIAS command, 1

SETAPPSTATE command, 1

SETCENTER command, 1

SETDBSTATE command, 1, 2, 3

allocating storage, 1

changing data compression, 1

creating blocks on equations, 1

enabling two-pass calc, 1

precedence, 1

setting cache size, 1, 2

setting index page size, 1

specifying data compression, 1

SETDBSTATEITEM command, 1, 2

aggregating missing values, 1, 2, 3

allocating storage, 1

changing data compression, 1

increasing retrieval buffer, 1

precedence, 1

scope of storage settings, 1

setting

cache size, 1, 2

index page size, 1

retrieval buffer size, 1

retrieval sort buffer, 1

transaction isolation levels, 1

specifying

data compression, 1

disk volumes, 1, 2

viewing database information, 1

SETDEFAULTCALC command, 1

SETDEFAULTCALCFILE command, 1

SETPASSWORD command, 1, 2

SETROWOP command

entering in report scripts, 1

usage, 1

setting

See also assigning; defining; applying

aggregate missing values, 1

attribute types, 1

cache size, 1, 2, 3, 4

first-time calculations, 1

with Application Manager, 1, 2

with ESSCMD or MaxL, 1, 2

with Hyperion Essbase kernel, 1, 2

conditions in formulas, 1, 2

configurable variables, 1

consolidation properties, 1, 2

default calculations, 1, 2, 3, 4

dimension and member properties, 1

file delimiters, 1, 2, 3

fonts and typefaces, 1

global options, 1, 2

index page size, 1, 2

internal server buffer, 1

member consolidation properties, 1

passwords and user names

new users, 1, 2

overview, 1

partitioned databases, 1

properties dynamically, 1

report output destinations, 1, 2, 3

retrieval buffer size, 1, 2

for data sorts, 1

transaction isolation levels, 1, 2, 3

with ESSCMD, 1, 2

shaded cells, 1

shared areas. See partition areas

shared library files, 1

shared locks. See Read locks

shared member property, 1, 2

shared members

adding to outlines, 1, 2, 3

caution for placing, 1

affect on consolidation paths, 1

at different generations

building dynamically, 1, 2, 3

at same generation, 1, 2

building dynamically, 1, 2

building dynamically, 1, 2, 3, 4

calculating, 1, 2

caution for sorting, 1

creating, 1, 2, 3, 4

for different generations, 1, 2

for same generation, 1, 2, 3

guidelines for, 1, 2

with Outline Editor, 1

with rules files, 1

described, 1

design approach for attributes, 1

different generations, 1

getting, 1

guidelines, 1, 2

implicit, 1, 2, 3

linked reporting objects and, 1

parent/child

most versatile build method, 1

partitioned applications and, 1, 2

properties, 1

relationship implied, 1

reorganizing, 1

rolling up, 1

same generation, 1

sample rules files

generation references, 1

level references, 1, 2, 3

parent/child references, 1, 2, 3

storing, 1

suppressing for report generation, 1

with branches

building dynamically, 1, 2, 3

with outline synchcronization, 1

shared partition areas, 1

shared roll-ups, 1

sharing data, 1, 2

across multiple sites, 1, 2

in partitioned databases, 1, 2, 3

never allow property, 1, 2, 3

not allowing, 1

sharing members. See shared members

sheets. See Spreadsheet Add-in; spreadsheets

shell scripts (UNIX), 1

SHGENREF.RUL, 1

SHGENREF.TXT, 1

@SHIFT function, 1

SHLEV.RUL, 1

SHLEV.TXT, 1

Show Warnings option, 1, 2

shutdown (caution for improper), 1

SHUTDOWNSERVER command, 1

shutting down server, 1, 2

@SIBLINGS function, 1

siblings

adding as members, 1, 2

calculation order in outlines, 1

checking for, 1

consolidation properties and, 1

defined, 1

dimensions as, 1

getting, 1

members as, 1, 2

rolling up, 1

SIBLOW.RUL, 1

SIBLOW.TXT, 1

SIBPAR.TXT, 1

SIBSTR.RUL, 1

SIBSTR.TXT, 1

Sign Flip option, 1

Simple application, 1

changing makeup, 1, 2, 3

organizing data, 1

simple formulas, 1, 2

simple interest, 1

single quotation marks (')

in application and database names, 1

in dimension and member names, 1

single-server applications

adding dimensions, 1, 2

analyzing data, 1, 2

analyzing database scope, 1, 2

creating outlines, 1

defining calculations, 1, 2, 3, 4, 5, 6

designing, 1, 2

identifying data sources, 1

implementing security, 1

partitioned vs., 1

planning process, 1, 2

size

array variables, 1

change log files, 1

data blocks, 1, 2, 3, 4

controlling, 1

determining cache, 1, 2

estimating database, 1, 2, 3, 4

factors determining database, 1

field and optimal loads, 1

getting information on cache, 1

index page, 1, 2

linked files, 1

minimizing for linked objects, 1

optimizing index, 1, 2, 3

partitioned databases, 1

planning for optimal, 1

reducing database, 1

setting cache, 1, 2, 3, 4

first-time calculations, 1

with Application Manager, 1, 2

with ESSCMD or MaxL, 1, 2

with Hyperion Essbase kernel, 1, 2

setting limits for linked objects, 1

setting maximum file, 1

setting retrieval buffer, 1, 2

for data sorts, 1

SKIP command

usage, 1

usage example, 1

Skip Missing property, 1

skip properties, 1

Skip Zeros property, 1

SKIPONDIMENSION command, 1

skipping

#MISSING and zero values, 1, 2

fields when mapping, 1, 2, 3

lines in rules files, 1, 2

multiple fields in data load, 1

records in data load, 1

specific fields in data load, 1

.SL files, 1

slashes (/)

as codes in data source, 1

in names in scripts and formulas, 1, 2

slicing, 1

@SLN function, 1

smoothing data, 1

SMP (symmetric multiprocessing), 1, 2

.SO files, 1

software version, 1, 2

Solaris servers. See UNIX platforms

Sort Descending command, 1

sort order

defining, 1

members in outline, 1

output, 1

SORTALTNAMES command, 1

SORTASC command, 1

SORTDESC command, 1

SORTGEN command, 1

sorting

data for reports, 1, 2, 3

examples, 1, 2, 3

data with missing values, 1

dimensions and members, 1, 2

members in reports, 1

records to optimize data loading, 1

sorting commands, 1, 2

SORTLEVEL command

usage, 1

usage example, 1

SORTMBRNAMES command

precedence in sorts, 1

usage, 1

SORTNONE command, 1

source data. Seedata sources

source outline (defined), 1

space. See white space

spaces

in application and database names, 1

in dimension and member names, 1

@SPARENTVAL function, 1

SPARSE command, 1

sparse dimensions, 1

See also dense dimensions; dimensions

calculating values in, 1, 2, 3, 4

defined, 1

defining member combinations for, 1, 2

Dynamic Calc, 1, 2

dynamically calculating, 1, 2, 3, 4, 5

formulas and, 1

grouping member combinations, 1

implications for restructuring and, 1, 2

Intelligent Calculation and, 1

location in outline, 1, 2

marked as clean, 1

optimizing, 1, 2, 3

partitioning, 1

recalculating values in, 1, 2

reporting on, 1

returning values for, 1

selecting, 1

selection scenarios, 1, 2, 3

setting, 1

storing, 1

storing member combinations, 1

unique member combinations, 1

sparse restructure, 1

speed up. See optimizing

@SPLINE function, 1

spline, calculating, 1

split dimensions, 1

Split Field dialog box, 1

splitting

databases, 1, 2

fields, 1

Spreadsheet Add-in, 1, 2

ad hoc currency reporting, 1

as client interface, 1

getting Dynamic Time Series members, 1

linked partitions and, 1, 2

linked reporting objects and, 1, 2

maintaining data integrity, 1

optimizing retrieval, 1, 2

running calc scripts, 1

specifying latest time period, 1

viewing database information, 1

spreadsheet audit information, 1

spreadsheet files, 1, 2

spreadsheets

data source, 1

default locations, 1

loading, 1, 2, 3

multiple, 1

logging updates, 1

opening, 1, 2

supported for data loading, 1

SQL databases

batch mode example, 1

data source, 1

field names in, 1

loading, 1, 2

troubleshooting problems with, 1

opening, 1, 2

troubleshooting connections, 1

SQL select statements, 1

SSAUDIT parameter, 1

SSAUDITR parameter, 1

standard deviation, calculating, 1

standard dimensions

attribute formulas on, 1

comparison with attribute dimensions, 1

defining in dimension build, 1

described, 1

START command, 1, 2

start value

ranges in numeric attributes, 1

STARTHEADING command

entering in report scripts, 1

usage, 1

usage example, 1

starting

applications, 1, 2, 3

from Server Agent, 1

databases, 1

from Server Agent, 1

ESSCMD, 1

prerequisites, 1

Hyperion Essbase kernel, 1

Outline Editor, 1

server, 1

startup commands, 1

startup information, 1, 2

startup settings

restoring, 1

statement terminator, 1, 2

ESSCMD commands, 1

in report scripts, 1

inserting in calc scripts, 1, 2, 3

inserting in formulas, 1

statements

calc scripts and, 1, 2, 3, 4

formulas and, 1, 2

static member names, 1

statistical calculations

generating with calc scripts, 1

statistical functions, 1

statistical variance, calculating, 1

statistics, 1

performance, 1

Statistics page (Database Information), 1

Statistics tab (Database Information), 1

status

current calculation state, 1

data loads, 1, 2, 3

partitioned applications, 1

viewing database information, 1

viewing server information, 1, 2

S-T-D time series member, 1, 2

@STDEV function, 1

@STDEVP function, 1

@STDEVRANGE function, 1

STOP command, 1, 2, 3

stopping

See also closing; exiting; quitting

applications, 1, 2, 3, 4

archiving and, 1

multiple simultaneously, 1

with related database, 1

calculations, 1

data loads, 1

databases, 1, 2, 3

server, 1, 2

storage, 1, 2

See also Hyperion Essbase kernel, 1

allocating disk space, 1, 2

example, 1

bitmap compression and, 1

checking disk space, 1

data blocks and, 1, 2, 3, 4, 5

data files, 1

data values, 1, 2

deallocation and, 1, 2

default properties, 1

dimensions, 1

dynamically calculated values, 1, 2

with attributes, 1

fine-tuning, 1

index files, 1, 2

inefficient, 1

internal structures optimizing, 1

linked reporting objects, 1, 2, 3

local, 1

multiple applications, 1

optimizing, 1

partitioned databases, 1, 2, 3

sparse member combinations and, 1

with replicated partitions, 1

with transparent partitions, 1

planning for, 1

restructuring and, 1

server configurations, 1

shared members, 1

temporary variables, 1

trace files, 1

using MaxL to set disk volumes, 1

viewing information about, 1

Storage page (Database Information), 1

Storage page (Database Settings), 1

setting

cache size, 1, 2, 3

index page size, 1

specifying

data compression, 1

disk volume, 1

storage settings, 1, 2

scope, 1

store data property, 1

store property

description, 1

Stores, 1

.STR files, 1

strings

See also characters

adding fields by matching, 1

adding members by matching, 1

as tokens, 1

calc scripts as, 1

dummy, 1

options for loading, 1, 2

preceded by &, 1

replacing for data loads, 1

strings, in calculation formulas, 1

subexpressions, 1

subsets of data

calculating, 1, 2, 3

example, 1

with Intelligent Calculation, 1

clearing, 1

copying, 1

copying to Personal Essbase, 1

prerequisites, 1

loading, 1, 2

substitution variables, 1

adding to report scripts, 1, 2, 3

creating, 1

guidelines for, 1

creating using MaxL, 1

deleting, 1

deleting using MaxL, 1

formulas and, 1

free-form reports and, 1

inserting in calc scripts, 1, 2

setting using MaxL, 1

updating, 1

usage overview, 1

Substitution Variables dialog box, 1, 2

@SUBSTRING function, 1

subtotals, 1, 2

subtracting

values from existing values, 1

subtraction

consolidation codes in data source, 1

prerequisite for, 1

setting member consolidation properties, 1

suffixes

adding to fields, 1

assignment sequence in data build, 1

attribute member names, 1, 2, 3

member names, 1

@SUM function, 1

Sum member, Attribute Calculations dimension, 1, 2

summaries, 1

reporting example, 1

summary information, 1

Summary page (Partition Wizard), 1

@SUMRANGE function, 1

sums, 1, 2

SUPALL command, 1

SUPBRACKETS command, 1

overriding, 1

usage example, 1

SUPCOLHEADING command, 1

SUPCOMMAS command, 1

SUPCURHEADING command, 1

SUPEMPTYROWS command

entering in report scripts, 1

usage, 1

Supervisor privilege, 1

SUPEUROPEAN command, 1

SUPFEED command

usage, 1

usage example, 1

SUPFORMATS command, 1

SUPHEADING command, 1

SUPMASK command, 1

SUPMISSINGROWS command

usage, 1

usage example, 1

SUPNAMES command, 1

SUPOUTPUT command, 1

SUPPAGEHEADING command

usage, 1

usage example, 1

SUPPMISSING command, 1

supported platforms, 1

suppressing report formatting, 1, 2

SUPPRESSMISSING command, 1

SUPSHARE command, 1

SUPSHAREOFF command, 1

SUPZEROROWS command, 1

SUPZEROS command, 1

swap space, 1

swapping devices, 1

Sybase SQL Server. See SQL databases

@SYD function, 1

SYM command

entering in report scripts, 1

usage, 1

usage example, 1

symmetric columns, 1

symmetric multiprocessing (SMP), 1, 2

symmetric reports

asymmetric reports vs., 1

calculated columns in, 1

changing column headings, 1

creating, 1, 2

defined, 1

formatting, 1

outputting column groups, 1

overriding column groupings, 1

Synchronize Outline dialog box, 1

synchronizing

data, 1, 2, 3

partitioning and, 1

outlines, 1, 2

process summarized, 1, 2

warning for not applying changes, 1

with Application Manager, 1

with Partition Wizard, 1

outlines with report scripts, 1

syntax

See also formats

calc scripts, 1, 2

calculation commands, 1

checking in Calc Script Editor, 1, 2, 3

checking in Formula Editor, 1, 2

commands and functions, 1

comments, 1

ESSCMD, 1

formulas, guidelines for, 1

report scripts, 1

member selection, 1, 2

substitution variables, 1

UDAs, 1

with wildcards, 1

verifying for filters, 1

syntax errors

finding in calc scripts, 1

finding in formulas, 1

formulas and dynamically calculated members, 1

stepping through, 1

system administrators. See administrators

system errors, 1, 2

log file locations and names, 1

system failures. See failures; recovery

System Info page (Server Information), 1

system information, 1, 2

system password, 1

changing, 1

system security. See security

System Supervisor, 1

T

T, two-pass calc code in data source, 1

tab

as column separator, 1

as command separator, 1

as file delimiter, 1

in names, 1

TABDELIMIT command

entering in report scripts, 1

usage, 1

tab-delimited formats, 1

tables.See alias tables; databases

tags

See also properties

assigning to members, 1

display options, 1

usage examples, 1

target outline, 1

See also targets

targets

accessing data, 1, 2

calculations and, 1, 2

changing data in, 1

changing outlines, 1

copying from, 1

defined, 1

defining

for multiple partitions, 1

for replicated partitions, 1

for transparent partitions, 1, 2

displaying, 1

logging into, 1

losing connections to, 1

mapping information, 1

mapping members to data sources

linked partitions, 1, 2

replicated partitions, 1, 2

specifying specific areas, 1

transparent partitions, 1, 2

member names differing from source, 1

missing data, 1

partitioning information for, 1

propagating outline changes, 1, 2, 3

process summarized, 1, 2

selecting, 1

specifying shared areas, 1, 2, 3

updating changes to, 1, 2, 3

viewing data in linked partitions, 1

.TCP files, 1

TCP/IP connections, 1

.TCT files, 1, 2, 3

.TCU files, 1, 2

technical support, 1

temporary files, 1

deleting, 1

temporary values, 1, 2

terminating server connections

caution, 1

for specific user, 1, 2

terminology, 1

testing

calculations, 1

database design, 1

for missing values, 1

partitions, 1, 2

text

See also annotating; comments

adding to calc scripts, 1

adding to empty fields, 1

attribute dimension type, 1

attribute type, 1

case conversions, 1, 2

copying and pasting, 1, 2, 3

cutting, 1, 2, 3

defining as labels, 1

displaying in Outline Editor, 1

fields, 1

finding and replacing

in formulas, 1

in report scripts, 1, 2

in data sources, 1

inserting in formulas, 1

linked reporting object, 1, 2

replacing missing values with, 1, 2

storing, 1

strings

replacing in rules file, 1

TEXT command

usage, 1, 2

usage example, 1

text editors

calc scripts and, 1

ESSCMD commands and, 1

formulas and, 1

report scripts and, 1

text files, 1

calc scripts in, 1

creating, 1, 2

cross-platform compatibility, 1

data sources, 1

default locations, 1

dumping security information to, 1, 2

loading, 1, 2

multiple, 1

opening, 1

text masks, 1, 2

text strings. See strings

The Beverage Company (TBC), 1, 2

third-party backup utility, 1, 2

threshold (transactions), 1

tildes (~)

as codes in data source, 1

in headings, 1

tildes (~)

in names in scripts and formulas, 1

time balance first/last properties

described, 1, 2

in combination with skip property, 1

setting, 1

time balance properties

described, 1

examples for usage, 1

time balance tags, 1

calculating accounts data, 1

time balanced data

calculating averages, 1

missing and zero values, 1

specifying in data sources, 1

Time dimension

currency applications, 1

time series members and, 1, 2, 3

usage example, 1

time dimension

calculating values, 1, 2

defining formulas for, 1

description, 1

setting, 1

specifying, 1, 2, 3

time balance members and, 1

two-pass calculations and, 1

usage example, 1, 2

time-out errors, 1, 2

time-out settings

locks, 1

transactions, 1

time periods, 1

budgeting expenses for, 1

determining first value for, 1, 2

determining last value for, 1, 2

getting average for, 1, 2

time-sensitive data, 1

time series reporting, 1

calculating averages, 1

calculating period-to-date values, 1

creating dynamic members for, 1, 2

getting first/last values, 1, 2, 3

partitioned databases, 1

retrieving period-to-date values, 1

skipping missing or zero values, 1

Time Series tags

Intelligent Calculation and, 1

listed, 1

time tags, 1

time zones, 1

time-out settings

locks, 1, 2

transactions, 1

timestamps, comparing, 1

TIMINGMESSAGES parameter, 1

titles, 1, 2

@TODATE function, 1, 2

TODATE command, 1

usage, 1

tokens, 1

toolbar

Data Prep Editor, 1

Formula Editor, 1

Outline Editor, 1, 2

enabling/disabling, 1

Script Editor, 1

tools, 1

TOP command

caution for usage, 1

entering in report scripts, 1, 2, 3

precedence, 1

restrictions, 1

upper limits, 1

usage, 1

usage example, 1

TOP.REP, 1

top-down calculation, 1, 2

top-down ordering

calculations, 1

dynamic builds, 1, 2, 3, 4

top-down partitioning, 1

defined, 1

totals, 1, 2

trace files, 1

creating, 1, 2

tracing calculations, 1

traffic coordinator, 1

trailing spaces, 1

transaction control files, 1

Transaction Control Table (TCT), 1, 2

Transaction Manager, 1

overview, 1

Transaction page (Database Settings), 1, 2

accessing locked blocks, 1

transactions

actions triggering, 1

canceling calculations and, 1

caution for committed access, 1

caution for data loads, 1

committing, 1, 2

defined, 1

forcing at load completion, 1

initiating commits, 1

locks and, 1, 2, 3

managing, 1

multiple, 1

not completing, 1

predictability, 1

processing, 1

required privileges, 1

rolling back, 1, 2, 3

server crashes and active, 1

setting isolation levels

with Application Manager, 1

with ESSCMD, 1, 2

with Hyperion Essbase kernel, 1

tracking, 1

updating isolation levels, 1

wait intervals, 1, 2

transparent members, 1

transparent partitions

advantages, 1

calculating, 1

clearing values in, 1

creating, 1, 2, 3, 4, 5, 6

currency conversions and, 1, 2, 3

data loading and, 1

defined, 1

described, 1

disadvantages, 1

dynamically calculated values in, 1

example of, 1

formulas and, 1, 2

guidelines for selecting, 1, 2

implementing security measures, 1

improving performance, 1, 2, 3, 4

mapping members, 1, 2

port usage, 1

usage restrictions, 1

using attributes in, 1

.TRC files, 1, 2, 3

tree icon, 1

trees

See also branches

data hierarchies, 1

moving members in, 1

outlines, 1

@TREND function, 1

trend analysis, 1

trends, calculating, 1

troubleshooting, 1, 2

calc scripts, 1

connections, 1

data loading, 1

formulas, 1

partitions, 1

@TRUNCATE function, 1

truncated names, 1

truncating values, 1

two-dimensional

data blocks, 1

two-dimensional reports, 1, 2

two-pass, 1

two-pass calculation property, 1

usage example, 1

two-pass calculations, 1, 2

as default, 1

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, 1

two-pass-calc

enabling using MaxL or ESSCMD, 1

.TXT files. See text files

typefaces, 1

types

See also dimension types; field types

setting attribute, 1

tagging dimensions, 1

typographical conventions, 1

U

UCHARACTERS command, 1

UCOLUMNS command, 1

@UDA function, 1

UDA command

selecting members with, 1

usage example, 1

UDA field type

in header records, 1

in rules files, 1

nulls and, 1, 2

UDAs

adding to report scripts, 1

allowing changes, 1

calc script example, 1

checking for, 1

compared with attributes, 1

creating, 1

described, 1

design approach for attributes, 1

flipping values in data load, 1

rules for creating, 1

shared members and, 1

UDATA command, 1

usage example, 1

UNAME command, 1

UNAMEONDIMENSION command, 1

unary operators, 1, 2

usage overview, 1, 2

unauthorized users, 1, 2

unavailable server or data sources, 1, 2

uncommitted access

about, 1

commits and, 1

defined, 1

handling transactions with, 1

locks and, 1, 2

rollbacks and, 1

setting, 1, 2, 3

UNDERLINECHAR command

usage, 1

usage example, 1

underlining, 1

UNDERSCORECHAR command, 1

underscores ( _ )

converting spaces to, 1, 2

in dimension and member names, 1

in report scripts, 1

underscores (_)

in array and variable names, 1

undoing

calc scripts builds, 1

database operations, 1

unexpected values, 1

Uniform Resource Locators. See URLs

unique data values, 1

assigning #MISSING values to, 1

Intelligent Calculation and, 1

UNIX platforms, 1

basic memory requirements, 1

file naming conventions, 1

freeing memory, 1

monitoring applications, 1, 2

running batch files, 1

specifying disk volumes, 1

starting Essbase server, 1

storing trace files, 1

unknown member errors, 1

unknown values, 1

UNLOADALIAS command, 1

UNLOADAPP command, 1, 2

UNLOADDB command, 1, 2

usage overview, 1

unlocking databases, 1

after allotted maximum lock time, 1

with Application Designer privilege, 1

unlocking objects, 1, 2

UNLOCKOBJECT command, 1

unspecified members, 1

Untitled report script, 1

update log files, 1

UPDATECALC setting, 1

system failures and, 1

UPDATEFILE command, 1

updates, 1, 2

getting information about outline, 1

troubleshooting, 1

updating

alias tables, 1

cache, 1, 2, 3

Cache Memory Locking, 1

cache size, 1

changed blocks only, 1

data compression, 1

data sources, 1, 2

data targets, 1, 2, 3

databases, 1, 2

dimensions, 1

index page size, 1

indexes, 1

log files, 1

outlines, 1

partitioned applications, 1, 2, 3, 4

guidelines, 1

with remote data, 1

references, 1

reports, 1

requests. See transactions

spreadsheets, 1

substitution variables, 1

transaction isolation settings, 1

volumn settings, 1

upgrades, 1, 2

upper level blocks, 1, 2

dynamically calculating, 1, 2, 3, 4

recalculating values in, 1

restructuring and, 1

URLs

linking to cells, 1, 2

manipulating with Application Manager, 1

maximum character length, 1

storing, 1

Use Aliases option, 1, 2

Use Dimension Property Settings option, 1

User Database Access dialog box, 1

user groups

assigning filters to, 1

assigning privileges, 1

creating, 1, 2, 3

defined, 1, 2

defining security settings, 1, 2, 3

deleting, 1

editing, 1

modifying access settings, 1, 2, 3, 4

removing members, 1

renaming, 1

returning members, 1, 2

viewing current settings, 1, 2

user interface, 1, 2

See also Application Manager

accessing linked objects and clients, 1

customizing, 1

user-management tasks, 1, 2, 3

user names

disabling, 1, 2, 3, 4

entering, 1, 2, 3

user types

Create/Delete Users/Groups, 1

defined, 1

ordinary, 1

Supervisor, 1

User/Group Application Access dialog box, 1

User/Group Security dialog box

copying security profiles, 1, 2

creating new users, 1, 2

deleting users and groups, 1, 2

editing existing groups, 1

editing user profiles, 1

managing users and groups, 1

renaming users and groups, 1

updating users, 1

user-defined attributes See UDAs

users, 1

accessing locked blocks, 1, 2

activating disabled, 1

adding to or removing from groups using MaxL, 1

assigning

application access, 1, 2, 3, 4

filters, 1

privileges, 1

to groups, 1, 2

changing access privileges, 1, 2, 3

changing passwords, 1

changing passwords using MaxL, 1

creating accounts for, 1, 2

creating in MaxL, 1

creating new, 1

defining security, 1, 2, 3

deleting using MaxL, 1

disconnecting from servers, 1, 2

displaying

access settings, 1, 2

defined users, 1

inactive users, 1

displaying current, 1, 2

displaying in MaxL, 1

editing security settings, 1

limiting login attempts, 1

logging out, 1, 2, 3, 4

logging out using MaxL, 1

login procedure, 1

maintaining information for, 1

removing, 1, 2

renaming, 1

renaming using MaxL, 1

replicating privileges, 1

security settings, 1

security types, 1

setting global access levels, 1

unauthorized, 1, 2

USERS command, 1

usage overview, 1

Users/Groups list box, 1, 2

V

V, Dynamic Calc and Store code in data source, 1

VALIDATE command, 1, 2

partitioned applications and, 1

Validate page (Partition Wizard), 1

Validate Rules dialog box, 1, 2

VALIDATEPARTITIONDEFFILE command, 1

validating

data integrity, 1

field names, 1

partitions, 1

rules files, 1, 2, 3

troubleshooting problems, 1

validity checking, 1

values, 1, 2

See also missing values; range of values

accumulation, 1

assigning to member combinations, 1

assigning to variables, 1

averaging, 1

for time periods, 1, 2

non-zero values and, 1

reporting examples, 1, 2

with formulas, 1, 2

changing, 1

comparing, 1, 2, 3

compression and repetitive, 1, 2, 3

defined, 1

displaying specific, 1

distribution among dimensions, 1

duplicating, 1

dynamically calculating, 1, 2, 3

entering in empty fields, 1

filtering, 1

flipping, 1

formatting in reports, 1, 2

examples, 1

identical, 1

in a database, 1, 2

inconsistent, 1

incorrect, 1

interdependent, 1

iterating through, 1

looking up, 1

measuring, 1

member with no, 1

negative, 1

flipping, 1

variance as, 1

nulls, 1, 2

of attributes, 1, 2

optimizing in sparse dimensions, 1

ordering in reports, 1, 2

example, 1

out of range, 1

overwriting, 1, 2, 3

for currency conversions, 1

placing retrieval restrictions, 1, 2

example, 1

reading multiple ranges, 1

referencing, 1, 2, 3, 4, 5

retrieving dynamically calculated, 1, 2, 3, 4

retrieving for reports, 1

setting maximum rows allowed, 1

with conditions, 1, 2, 3, 4

retrieving from remote databases, 1, 2, 3

rolling up, 1

rounding, 1, 2

scaling, 1

setting maximum number of, 1

storing, 1, 2

temporary, 1, 2

truncating, 1

unable to change, 1

unexpected, 1

unique, 1

assigning #MISSING values to, 1

Intelligent Calculation and, 1

unknown, 1

variables as, 1

void, 1

@VAR function, 1, 2, 3

VAR command, 1

variables, 1

adding to report scripts, 1, 2, 3, 4

assigning values, 1

creating substitution, 1

creating using MaxL, 1

declaring, 1, 2, 3

deleting, 1

deleting using MaxL, 1

free-form reports and, 1

inserting in calc scripts, 1, 2

naming, 1

setting configurable variables, 1

updating, 1

@VARIANCE function, 1

variance, 1, 2

See also statistical variance, calculating

dynamically calculating, 1

returning, 1, 2

usage examples, 1, 2, 3, 4

variance percentages

calculating, 1

returning, 1, 2

variance reporting properties, 1, 2

setting, 1

@VARIANCEP function, 1

@VARPER function, 1, 2, 3, 4

Verify dialog box, 1

verifying

See also validating

outline content on save, 1

outlines, 1

path information, 1

values retrieved in loads, 1

VERSION command, 1

usage overview, 1

version compatibility, 1, 2

version numbers, 1, 2

vertical bars (|)

in application and database names, 1

in dimension and member names, 1

View Log File dialog box, 1, 2, 3, 4

View menu, 1, 2

viewing

access settings, 1, 2

active filters, 1

active user groups, 1

aliases, 1, 2

in Calc Script Editor, 1

in Formula Editor, 1

application event log, 1

application information, 1, 2, 3, 4

applications, 1

available ports, 1, 2

changes to outlines, 1

current users, 1, 2, 3

data, 1, 2, 3

in targets, 1

with Data Prep Editor, 1, 2

data sources, 1, 2

data targets, 1

database information, 1, 2

database statistics, 1

databases, 1

dimensions

in Calc Script Editor, 1

in Formula Editor, 1

in outlines, 1

dynamically calculated members, 1, 2

field operations, 1

formulas, 1, 2

inactive users, 1

informational messages, 1, 2

linked objects, 1, 2

locked data, 1

locks, 1

log files, 1, 2, 3, 4, 5

member combinations, 1, 2

member names in reports, 1

members in outlines, 1, 2

names for generations and levels, 1

partitions, 1, 2

records, 1

replace operations, 1

selection/rejection criteria, 1

Server Agent commands, 1

server information, 1

software version, 1, 2

specific values, 1

storage information, 1

text in Outline Editor, 1

unique values, 1

views, 1

customizing, 1

virtual cubes (in Hyperion MBA). See transparent partitions

virtual memory, 1

Visual Basic programming objects, 1

void mappings, 1

volume names, 1

volumes

allocation and, 1

data files and, 1

data storage and multiple, 1

deallocating, 1, 2

index files and, 1

specifying

with Application Manager, 1

with ESSCMD, 1

with Hyperion Essbase kernel, 1

updating storage settings, 1

W

.W95 files, 1

Wait settings

locks, 1, 2

transactions, 1, 2

warnings

partition validation, 1

report processing, 1, 2

week-to-date calculations, 1

white space

as file delimiter, 1

converting to underscores, 1, 2

cross-dimensional operator and, 1

data entry, 1

dropping, 1, 2

formulas, 1

in dimension and member names, 1

in member names, 1

in report layouts, 1

report scripts, 1

WIDTH command, 1

wildcard matches, 1

wildcards in report scripts, 1

window (application), 1

Windows Explorer, 1

Windows File Manager, 1

Windows platforms, 1

freeing memory, 1

monitoring applications, 1, 2

prerequisite user understanding, 1

storing trace files, 1

@WITHATTR function, 1, 2

WITHATTR command, 1, 2, 3

usage, 1

wizards, 1

.WK4 files, 1

workstations, 1

Write access, 1

write access, 1

Write locks, 1

described, 1

with committed access, 1, 2

with uncommitted access, 1, 2

Write privilege, 1, 2

writes, 1

data compression and, 1, 2

error log files, 1

getting number of, 1

optimizing, 1

W-T-D time series member, 1, 2

X

X member code, 1

X operator, 1, 2

X, Dynamic Calc code in data source, 1

XCHGRATE database, 1, 2

adding members, 1

contents described, 1

displaying outlines, 1

linking, 1

Xchgrate database

provided with Hyperion Essbase, 1

.XCP files, 1, 2

.XLL files, 1

.XLS files, 1

@XREF function, 1

Y

year-to-date calculations, 1, 2

Y-T-D time series member, 1, 2

Z

Z, time balance codes in data source, 1

zero values, 1

excluding in time balances, 1

formatting in reports, 1, 2

including in time balances, 1

replacing with labels, 1

skipping, 1, 2

ZEROTEXT command, 1

zoom, 1