Hyperion(r) Database Administrators Guide Help

 

Index


Symbols Numbers A B C D E F G H I J K L M N O P Q R S T U V W X Y Z


Symbols

! (bang) command

  adding to report scripts

  terminating reports

! (exclamation points)

  in names in scripts and formulas

" (double quotation marks)

  enclosing member names, (1), (2), (3)

  in application and database names

  in dimension and member names

  in ESSCMD commands

  in formulas, (1), (2), (3)

  in header information

  in report scripts

  terms in scripts and formulas, (1), (2)

# (pound sign) in array and variable names

#MI values

  inserting into empty fields, (1), (2), (3)

  instead of #MISSING

#MISSING values, (1), (2), (3)

  aggregating

  defaults for

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

  setting behavior for

  averages and

  calculations and

  CLEARDATA command

  disabling

  during calculations

  formatting in reports

  in calculations

  inserting into empty fields, (1), (2)

  parents and

  replacing with text

  reporting samples, (1), (2)

  skipping, (1), (2)

  sorting data with

  specifying in data source

  testing for

  viewing with Personal Essbase

#NOACCESS value

$ (dollar signs) in array and variable names

$ fields

$ALT_NAME setting

% (percent signs)

  as codes in data source

  in names in scripts and formulas

  in report scripts

% operators

  defining member consolidations

  in calc scripts

  in mathematical operations

  in unary operations, (1), (2), (3)

& (ampersands)

  as delimiters in logs

  in calc scripts, (1), (2)

  in names

  in names in scripts and formulas

  in report scripts

& commands, (1), (2)

( ) (parentheses)

  in calc scripts

  in dimension and member names

  in formulas

  indicating negative numeric values in fields

  report scripts, (1), (2)

* (asterisks)

  as codes in data source

  as delimiters in logs

  in application and database names

  in names in scripts and formulas, (1), (2)

  options in reports

  used as wildcard

* operators, (1), (2), (3), (4)

+ (plus signs)

  as codes in data source

  in application and database names

  in dimension and member names

  in member names

  in names in scripts and formulas, (1), (2)

+ operators

  defining member consolidations

  in mathematical operations

  in unary operations, (1), (2), (3)

  member consolidation

, (commas)

  as file delimiter

  displaying in reports

  in application and database names

  in data fields

  in dimension and member names

  in formulas

  in header records

  in member combinations

  in names in scripts and formulas, (1), (2)

  suppressing in reports, (1), (2)

. (periods)

  in application and database names

.EQD files(EQD)

/ (slashes)

  as codes in data source

  in application and database names

  in names in scripts and formulas, (1), (2)

/ operators

  defining member consolidations

  in calc scripts

  in mathematical operations

  in unary operations, (1), (2), (3)

/* */ character pairs, (1), (2)

// (double slashes) in report scripts

: (colons)

  as delimiters in logs

  in application and database names

  in formulas

  in names in scripts and formulas, (1), (2)

:: (double colons) in formulas

; (semicolons)

  end a calc script

  end ENDIF statement

  in application and database names

  in calc scripts, (1), (2)

  in ESSCMD syntax

  in formulas, (1), (2), (3)

  in names in scripts and formulas, (1), (2)

  insert formulaend-of-line

< (less than signs)

  in application and database names

  in dimension and member names

  in names in scripts and formulas, (1), (2)

  in report scripts

= (equal signs)

  in application and database names

  in calc scripts

  in dimension and member names

  in formulas

  in names in scripts and formulas

  in report scripts

> (greater than signs)

  in application and database names

  in names in scripts and formulas

-> operator

-> operators

  in formulas, (1), (2)

  inserting in calc scripts

  inserting in formulas, (1), (2)

  overview, (1), (2)

  usage examples, (1), (2)

? (question marks)

  in application and database names

  used as wildcard

@ (at signs)

  in dimension and member names

  in names in scripts and formulas, (1), (2)

@ABS function

@ACCUM function, (1), (2)

@ALLANCESTORS function

@ALLOCATE function, (1), (2)

@ANCEST function

@ANCESTORS function

@ANCESTVAL function

@ATTRIBUTE function, (1), (2)

@ATTRIBUTEBVAL function

@ATTRIBUTESVAL function

@ATTRIBUTEVAL function, (1), (2), (3)

@AVG function

@AVGRANGE function, (1), (2)

@CALCMODE function

@CHILDREN function

@COMPOUND function

@COMPOUNDGROWTH function

@CONCATENATE function

@CORRELATION function

@COUNT function

@CURGEN function

@CURLEV function

@CURRMBR function

@CURRMBRRANGE function

@DECLINE function

@DESCENDANTS function, (1), (2)

@DISCOUNT function

@EXP function

@FACTORIAL function

@GEN function

@GENMBRS function

@GROWTH function

@IALLANCESTORS function

@IANCESTORS function

@ICHILDREN function

@IDESCENDANTS function, (1), (2)

@ILSIBLINGS function

@INT function

@INTEREST function

@IRDESCENDANTS function

@IRR function

@IRSIBLINGS function

@ISACCTYPE function

@ISANCEST function

@ISCHILD function

@ISDESC function

@ISDESCENDANTS function

@ISGEN function

@ISIANCEST function

@ISIBLINGS function

@ISICHILD function

@ISIDESC function

@ISIPARENT function

@ISISIBLING function

@ISLEV function

@ISMBR function, (1), (2)

@ISPARENT function

@ISSAMEGEN function

@ISSAMELEV function

@ISSIBLING function

@ISUDA function

@LEV function

@LEVMBRS function

@LIST function

@LN function

@LOG function

@LOG10 function

@LSIBLINGS function

@MATCH function

@MAX function

@MAXRANGE function

@MAXS function

@MAXSRANGE function

@MDALLOCATE function, (1), (2)

@MDANCESTVAL function

@MDPARENTVAL function

@MDSHIFT function

@MEDIAN function

@MEMBER function

@MERGE function

@MIN function

@MINRANGE function

@MINS function

@MINSRANGE function

@MOD function

@MODE function

@MOVAVG function

@MOVMAX function

@MOVMED function

@MOVMIN function

@NAME function

@NAME function to return member name as a string

@NEXT function

@NEXTS function

@NPV function

@PARENT function

@PARENTVAL function, (1), (2)

@POWER function

@PRIOR function, (1), (2)

@PRIORS function

@PTD function, (1), (2), (3)

@RANGE function

@RANK function

@RDESCENDANTS function

@RELATIVE function

@REMAINDER function

@REMOVE function

@ROUND function

@RSIBLINGS function

@SANCESTVAL function

@SHIFT function

@SHIFTMINUS function

@SHIFTPLUS function

@SIBLINGS function

@SLN function

@SPARENTVAL function

@SPLINE function

@STDEV function

@STDEVP function

@STDEVRANGE function

@SUBSTRING function

@SUM function

@SUMRANGE function

@SYD function

@TODATE function, (1), (2)

@TREND function, (1), (2)

@TRUNCATE function

@UDA function

@VAR function, (1), (2), (3)

@VARIANCE function

@VARIANCEP function

@VARPER function, (1), (2), (3), (4)

@WITHATTR function, (1), (2)

@XREF function, (1), (2)

[ ] (brackets)

  in application and database names

  in names in scripts and formulas, (1), (2)

\ (backslashes)

  in application and database names

  in dimension and member names

  in formulas

  in names in scripts and formulas

^ (carets)

  as delimiters in logs

_ (underscores)

  converting spaces to, (1), (2)

  in array and variable names

  in report scripts

{ } (braces)

  in dimension and member names

  in names in scripts and formulas, (1), (2)

  in report scripts, (1), (2)

| (vertical bars)

  in dimension and member names

~ (tildes)

  as character in headings

  as codes in data source

  as delimiters in logs

~ operators, (1), (2), (3), (4)

- (hyphens, dashes, minus signs)

  as codes in data source

  in data fields

  in dimension and member names

  in member names

  in names in scripts and formulas

  in report scripts

- operators

  defining member consolidations

  in mathematical operations

  in unary operations, (1), (2), (3)

' (single quotation marks)

  in application and database names

  in dimension and member names

(tildes)

  in names in scripts and formulas


Numbers

0 (zero) values

  calculating

  excluding in time balances

  formatting in reports, (1), (2)

  including in time balances

  replacing with labels

  skipping, (1), (2)

.123 files

.A files


A

A, average time balance codes in data source

abnormal shutdown. See exception logs.

aborting data loads

@ABS function

absolute values

access

  application-level settings

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

  cells in blocks, (1), (2)

  checking information about

  concurrent

  controlling, (1), (2), (3), (4), (5)

  data sources

  replicated partitions and

  data targets, (1), (2)

  database permissions for users

  defining global levels

  getting started tips

  global levels

  internal structures optimizing

  levels defined in filters

  linked objects

  local

  locked data blocks, (1), (2)

  maintaining data integrity

  matrix-style

  modifying, (1), (2), (3)

  multi-user

  optimizing, (1), (2)

  outlines

  partitioned databases, (1), (2), (3)

  troubleshooting

  remote databases

  restricting, (1), (2)

  Server Agent

  setting database

  simultaneous, (1), (2)

  transactions and, (1), (2)

  unspecified members

Access databases. See SQL databases

Access DBs setting, (1), (2)

access levels

Account Dimension Properties page (Dimension Properties)

account reporting values

accounts

  administrators, (1), (2)

  users, (1), (2)

Accounts dimension

  usage examples

accounts dimension

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

  calculating time period averages

  calculating variance for

  calculation passes for

  calculations on, (1), (2), (3)

  creating

  currency applications

  description

  flipping values in

  setting

  setting member properties in data source

  time balance members in

  two-pass calculations and

  unary operations in

  usage examples

  usage overview

accounts tags

  checking for

@ACCUM function, (1), (2)

accumulation of values

actual expense vs. budgeted

  getting variance, (1), (2), (3)

  setting properties

actual sales reporting samples, (1), (2)

ad hoc calculations

ad hoc currency reporting

add as sibling build method

  attribute associations

adding

  See also building; creating; defining

  alias tables to outlines, (1), (2)

  aliases to calc scripts

  aliases to formulas

  comments to calc scripts

  comments to dimensions

  comments to report scripts

  dimensions to outlines, (1), (2), (3), (4)

  performance considerations, (1), (2)

  restructuring and

  dynamically calculated members to calculations

  equations to calc scripts, (1), (2)

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

  formulas to oulines

  formulas to report scripts

  header information

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

  headings to reports, (1), (2), (3), (4)

  members

  as children of specified parent

  as siblings of lowest level

  as siblings with matching strings

  build methods

  example for, (1), (2)

  for currency conversions, (1), (2)

  guidelines for

  restrictions

  through header information in the data source

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

  to member fields, (1), (2)

  to outlines, (1), (2)

  members to report scripts, (1), (2)

  in precise combinations

  with common attributes

  operators to formulas

  page breaks to reports, (1), (2)

  prefixes or suffixes to fields

  records to data sources, (1), (2), (3)

  shared members to outlines, (1), (2), (3)

  caution for placing

  text to calc scripts

  text to formulas

  titles to reports

  values to empty fields

  values to existing values

  variables to formulas

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

Adding Dimensions dialog box

addition

  consolidation codes in data source

  prerequisite for

  setting member consolidation properties

addition operator (+)

  unary operations

addition operators (+)

  defining member consolidations

  in unary operations, (1), (2)

  mathematical operations

  member consolidation

adjusting buffer size

  Application Manager

adjusting column length

adjusting retrieval buffer size

  Administration Services

adjusting retrieval sort buffer size

  Administration Services

Admin page (Partition Wizard)

Adminiatration Servicesr

  setting index cache size

Administration Services

  adding users to groups

  adjust retrieval buffer size

  adjust retrieval sort buffer size

  annotating databases

  application

  copy

  delete

  build calc script

  changing data cache size

  changing Essbase kernel settings

  copying

  outlines

  creating

  applications

  databases with Administration Services

  new users

  database

  copy

  delete

  defining calculations

  as default

  deleting

  logs, (1), (2), (3)

  deleting a substitution variable

  deleting logs

  display used and unused ports

  enable memory cache locking

  execute a calculation script

  open existing calc script

  rename application

  rename database

  review application log

  run a calc script

  run calculations

  set retrieval buffer size

  setting

  current alias table

  setting index cache size

  setting substitution variables

  start database

  starting/stopping applications

  starting/stopping databases

  updating a substitution variable

  view average clustering ratio

  view current data compression settings

  view data block size

  view logs

  viewing logs

  viewing the application log

administrative accounts

  setting up

administrative requests

administrators

  controlling partitioned updates

  getting started with Essbase

  getting started with Hyperion Essbase

  maintenance routines

  maintenance tasks

  minimizing downtime

  usage prerequisites

  user-management tasks, (1), (2), (3)

Admnistration Services

  view user and group lists

.ADW files

AFTER command

  usage examples, (1), (2)

agent event logs. See OLAP Server logs.

Agent log

agent logs. See OLAP Server logs.

Agent. See Server Agent

AGENTLOGMSGLEVEL setting

AGENTPORT

AGENTTHREADS setting

aggregation

  See also consolidation

  formulas vs.

  missing values

  calculations and, (1), (2)

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

  in calculations

AGTSVRCONNECTIONS

  control the maximum number of threads to OLAP Server

AGTSVRCONNECTIONS setting in essbase.cfg

AIX servers. See UNIX platforms

.ALG files

alias combinations

  creating

  defined

Alias Combinations page (Member Properties)

alias field type

  in header records

  in rules files

  nulls and, (1), (2)

alias tables

  clearing contents

  copying

  creating, (1), (2)

  described

  importing/exporting, (1), (2), (3)

  including in report scripts

  introducing, (1), (2)

  loading

  maximum per outline

  removing from outlines

  renaming

  reserved generation names in

  selecting, (1), (2)

  setting as current with Administration Services

  setting as current with Application Manager, (1), (2)

  updating

ALIAS. See alias field type

aliases

  adding to calc scripts

  adding to formulas

  adding to report scripts, (1), (2), (3)

  caution for

  allowing changes

  build methods and

  creating, (1), (2)

  attribute dimension build example

  based on member combinations

  caution for, (1), (2), (3)

  guidelines for

  parent/child dimension build example

  defined

  displaying, (1), (2)

  in Calc Script Editor

  in Formula Editor

  displaying in reports, (1), (2)

  duplicate generation fields and

  editing names

  entering in fields

  expanding/contracting member list

  introducing

  maximum characters in names

  multiple

  shared members and

  sorting members by

  specifying for Dynamic Time Series members

  with embedded blanks

@ALLANCESTORS function

ALLINSAMEDIM command

  usage

@ALLOCATE function

allocation

  calculation examples, (1), (2), (3), (4)

  calculation functions

  storage, (1), (2)

  example

Allocation Manager, (1), (2)

Allow Application to Start option

Allow Association Chgs option

Allow Commands option

Allow Connects option

Allow Formula Changes option

Allow Moves option

Allow Property Changes option

Allow Updates option

ALLSIBLINGS command

  usage

alphabetizing members

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

alter database

  MaxL statement

  alter database

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

  changing database storage settings

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

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

altering. See changing; editing

alternate hierarchies (in Hyperion MBA). See shared members

alternate names. See aliases

ampersands (&)

  in calc scripts, (1), (2)

  in names

  in names in scripts and formulas

  in report scripts

analysis

  defining objectives

  example

  getting started tips

  optimizing

  single-server applications, (1), (2)

analytical functions, key

  allocations

  ratios

  trend analysis

analyze logs

  Log Analyzer

analyzing database design

  guidelines

@ANCEST function

ancestor/descendant relationships

  defining calculation order for

ancestor-descendant relationships

@ANCESTORS function

ancestors

  checking for

  currency conversions and

  defined

  getting, (1), (2)

  new members with no

ANCESTORS command

  usage

@ANCESTVAL function

anchoring dimensions

AND operator

  select/reject criteria, (1), (2)

annotate database

  Administration Services

annotating

  See also comments

  data cells

  databases

  partitions, (1), (2), (3)

.APB files

API directory

API function calls

API functions

  location

  using VBA functions

.APP files

App Access button, (1), (2), (3)

APP directory

  security file information

application

  migrating using Administration Services

  parallel calculation level

  rename

Application Copy dialog box

Application Designer permission

Application designer permission

Application Desktop window

application directory, (1), (2)

application event logs. See application logs.

application files

Application Information dialog box

application log

  calculation time

  dimensions calculated

Application Log Viewer. See Log Viewer

application logs

  contents described

  deleting in Application Manager

  deleting on restart

  delimiters

  disk space and

  dynamic calculator cache usage

  dynamically calculated members

  example

  last row committed

  message categories

  overview

  setting messages logged

  viewing

  viewing contents, (1), (2)

Application Manager

  adding calc scripts

  adding dimensions

  adding members

  annotating databases

  build calc script

  caution for clearing data

  changing data cache size

  changing Essbase kernel settings

  clearing alias tables

  copying

  alias tables

  applications

  databases

  outlines, (1), (2)

  copying objects

  create calculation script

  creating

  alias tables

  applications

  databases with Application Manager

  rules files

  substitution variables

  creating calc scripts, (1), (2)

  creating reports, (1), (2)

  creating text files

  defined

  defining calculations

  as default

  deleting

  alias tables

  applications

  databases

  logs

  objects

  substitution variables

  deleting users

  described

  importing/exporting alias tables, (1), (2)

  loading data

  moving members

  naming generations and levels

  opening

  outlines, (1), (2)

  report scripts

  overview

  registering custom-defined functions

  removing linked objects

  renaming

  alias tables

  applications

  databases

  objects

  replicating data

  restructuring partitioned databases

  running calc scripts, (1), (2), (3)

  saving outlines

  selecting

  applications

  data sources, (1), (2)

  databases

  set retrieval sort buffer size

  setting

  current alias table

  default calculation

  index cache size

  isolation levels

  setting data compression

  setting index cache size

  sorting members

  specifying disk volumes

  specifying file size

  starting/stopping applications, (1), (2)

  starting/stopping databases, (1), (2)

  synchronizing outlines

  transferring files from client to server

  updating substitution variables

  verifying outlines

  view average clustering ratio

  view data block size

  viewing

  and changing user access

  applications and databases

  linked objects

  logs

  viewing storage information

  viewing the application log

Application Programming Interface. See API

application server, (1), (2)

Application Services window

Application Settings dialog box

  global application access

  minimum database access settings

  options

  specifying application file size

application startup, results of

Application Tools

  defined

Applications

  monitoring

applications

  See also partitioned applications

  analytical vs transaction processing

  associating index files with

  associating with calc scripts, (1), (2), (3)

  building

  components

  copying, (1), (2)

  copying using MaxL

  creating, (1), (2)

  for currency conversions

  for Personal Essbase

  on client

  prerequisites

  with Administration Services

  with Application Manager

  creating using MaxL

  creating with ESSCMD

  creating with MaxL

  currency conversions and

  customizing

  data distribution characteristics

  deleting

  deleting using MaxL

  designing partitioned

  deciding which type

  scenarios for, (1), (2), (3)

  designing simple, (1), (2)

  designing single-server, (1), (2)

  developing

  process summarized

  implementing global security

  inaccessible

  interruptions

  loading

  automatically

  with related database

  logging errors

  maintaining

  modifying database outlines

  monitoring, (1), (2)

  naming rule

  opening

  overview

  partitioned

  benefits of, (1), (2)

  choosing when not to use

  choosing when to use

  porting, (1), (2)

  creating backups for

  redefining information for

  to UNIX platforms

  renaming

  renaming using MaxL

  sample, (1), (2)

  selecting

  simultaneous access

  size considerations

  starting

  starting using MaxL

  stopping, (1), (2)

  all opened

  before backup

  when transactions are running

  with Administration Services

  with Application Manager

  stopping using MaxL

  storing

  terminating requests

  viewing

  information about, (1), (2), (3)

  log contents

Applications list box

Applications page (Server Information)

Apply Outline Changes dialog box

applying

  See also setting

  changes to outlines, (1), (2)

  locks, (1), (2), (3), (4)

  privileges to groups

  skip properties

APPLYOTLCHANGEFILE command

ARBORPATH

.ARC files

archive files

  restoring from

ARCHIVE.LST file

archiving

  data

  data targets

Area Definition dialog box

  defining linked areas, (1), (2)

  defining replicated areas

  defining transparent areas, (1), (2)

Area Specific Member Mapping dialog box

areas

  See also partitions

  changing shared

  defined

  Dynamic Time Series members in

  linked partitions

  mapping to specific, (1), (2), (3)

  in Partition Wizard

  replicated partitions

  transparent partitions

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

arithmetic operations

  currency conversions

  formulas and, (1), (2)

  missing values and

  performing on fields

  performing on members

  prerequisite for

  report scripts

  specifying in data source

arranging

  cells in blocks

  data blocks

  dimension build

  position of fields in rules file

  dimensions in outlines

  fields, (1), (2)

  members in dense dimensions

  members in outlines, (1), (2)

ARRAY command

  declare data variables

  usage example

arrays

  as variables, (1), (2)

  declaring

  naming

ASC command

  usage example

ascending sort order

  applying to output

  members in outlines

ASCII characters ignored in data loads

ASCII files

  calc scripts in

  creating, (1), (2)

  cross-platform compatibility

  data sources

  dumping security information to

  loading, (1), (2)

  multiple

  opening

ASCII text, (1), (2)

assets

Assign Filters dialog box

assigning

  See also defining; setting

  access levels to linked objects

  aliases to members, (1), (2)

  based on combinations

  attributes to dimensions

  filters to users and groups

  generic passwords

  privileges

  global access

  to users and groups

  properties to dimensions, (1), (2), (3), (4)

  overview, (1), (2), (3)

  properties to members, (1), (2)

  values to member combinations

  values to variables

  variance reporting properties

Associate Client Outline dialog box

Associate Server Outline dialog box, (1), (2)

associating

  applications with calc scripts, (1), (2)

  attributes

  automatically

  example rules file

  in Outline Editor

  through dimension build

  calc scripts with outlines

  databases with calc scripts, (1), (2), (3)

  databases with reports

  filters with outlines

  members with report scripts

  multilevel attribute dimensions

  new applications with calc scripts

  new databases with calc scripts

  parents with members

  rules files

  with data sources

  with outlines, (1), (2), (3)

asterisks (*)

  as codes in data source

  in application and database names

  in names in scripts and formulas, (1), (2)

  used as wildcard

ASYM command

  entering in report scripts

  usage

asymmetric columns

  changing headings

  creating

  dynamically calculating values

  in reports

  in source data, (1), (2)

  overriding groupings

asymmetric reports

  creating, (1), (2)

  defined

  formatting

  symmetric reports vs.

at signs (@)

  in dimension and member names

  in names in scripts and formulas, (1), (2)

attaching to databases. See connections

attachments

  See also linked reporting objects

  limiting size

  removing

  saving

  viewing in Application Manager

@ATTRIBUTE function, (1), (2)

attribute associations

  allowing changes

  base dimensions, (1), (2)

  field type

  lost in cut or copy and paste

  requirements

Attribute Calculations dimension

  accessing members from

  changing member names

  default member names

  described

  instead of consolidation symbols

  instead of member formulas

  members, default

  properties of

  retrieving multiple members from

ATTRIBUTE command, (1), (2)

  usage

attribute dimensions

  associating with base dimensions in Outline Editor

  comparison with standard dimensions

  creating in Outline Editor

  defining in dimension build

  deleting members

  described, (1), (2)

  generation or level reference numbers

  members

  overview

  prefixes and suffixes

  preventing creation, (1), (2), (3)

  multilevel

  building and associating

  names as field types, (1), (2)

  outline design

  restructuring

  summary of dimension building rules

  tagging

  type

  using to avoid redundancy

attribute fields

  defining using rules files

  position in rules file

attribute members

  options in dimension build

  using in report scripts

attribute parent field type

  example

  in header records

  in rules files

  nulls and, (1), (2)

attribute values, (1), (2), (3)

@ATTRIBUTEBVAL function

attributes

  advantages

  as values resulting from formulas

  associating

  automatically

  in Outline Editor

  through dimension build

  associating aliases through dimension build

  Boolean type

  changing default member names

  described

  duplicate values

  calculating

  accessing calculated data

  Attribute Calculations dimension

  default calculation

  Essbase functions

  examples

  multiple calculations

  performance considerations

  process

  using attributes in formulas

  calculation functions

  date type

  changing the member name format

  duplicate values

  defined

  design considerations

  mapping

  member name format

  member names

  numeric type

  defined

  defining ranges

  duplicate values

  ranges

  size of ranges

  process for defining in Outline Editor

  setting types

  shared member design approach

  standard dimension design approach

  text type

  time-dependent values

  types

  UDAs

  alternative design approach

  feature comparison

  setting

  user-defined

  See also UDAs

  using in partitions

@ATTRIBUTESVAL function

@ATTRIBUTEVAL function, (1), (2), (3)

ATTRPROD.RUL

.ATX files

audit log files

audit logs

Autoconfigure Dense/Sparse option

automating routine operations

average clustering ratio

  viewing in Administration Services

  viewing size in Application Manager

average time balance property

average time balances specified in data sources

averages

  Attribute Calculations dimension

  determining with formulas, (1), (2)

  for time periods, (1), (2)

  reporting examples, (1), (2)

  setting time balances

@AVG function

Avg member, Attribute Calculations dimension

@AVGRANGE function, (1), (2)


B

B, time balance codes in data source

background process

  detecting

  running Essbase as

backing up databases

  by exporting

  files to back up

  overview

  preparing

backslashes (\)

  in application and database names

  in dimension and member names

  in formulas

  in names in scripts and formulas

backups

  export method

  file list

  file system method

  restoring after system failures

  restoring from

  security

.BAK file

.BAK files

balance sheet accounts

bang command (!)

  adding to report scripts

  terminating reports

.BAS files

base dimensions

  associating with attribute dimensions in Outline Editor

  defined, (1), (2)

  member associations

  members

  associating with attributes in Outline Editor

  attribute formulas

  attributes

Basic databases. See Demo Basic database; Sample Basic database

BASIC directory

basic equations

basic reporting techniques

  creating simple reports, (1), (2)

  developing free-form reports

  editing report scripts, (1), (2), (3), (4)

  implementing security

  opening

  report scripts

  opening report scripts

  running report scripts, (1), (2), (3)

  saving report scripts

.BAT files

batch files

  and ESSCMD scripts

  report scripts and

  running

batch mode

  command-line syntax for

  creating scripts for

  dynamic calculations and

  error-handling

  examples

  importing and calculating

  printing reports

  updating SQL scripts

  file-name extensions and

  MaxL

  overview

  shutting down server

  syntax

  updating outlines

  when to use

batch processing time

BEFORE command

  usage example

BEGINARCHIVE command, (1), (2)

  partitioned applications and

benefits of Essbase

BIN directory

  ESSCMD files

Bitmap cache

  effects from parallel calculation

bitmap compression

  described

  estimating block size

  specifying

bitmap dimensions

bitmap, calculator cache

black squares (Report Viewer)

blank fields

  adding values to

  in data source

  in rules file

blanks. See white space

block calculation mode

block density (defined)

BLOCKHEADERS command, (1), (2)

blocks. See data blocks

.BND files

Boolean

  attribute dimension type, (1), (2)

  attributes

  changing default member names

  described

  duplicate values

  expressions in rules files

  for select/reject criteria, (1), (2)

  functions, in formulas, (1), (2)

Boolean expressions

  for select/reject criteria

  grouping

  usage example

Boolean operators, (1), (2)

BOTTOM command

  entering in report scripts, (1), (2), (3)

  precedence

  restrictions, (1), (2)

  upper limits

  usage

  usage example

bottom-up

  partitioning

bottom-up calculation

  transparent partitions

bottom-up ordering

  calculations

  dynamic builds, (1), (2), (3)

  examples, (1), (2)

bottom-up partitioning

  defined

braces ({ })

  in dimension and member names

  in names in scripts and formulas, (1), (2)

  in report scripts, (1), (2)

brackets ([ ])

  in application and database names

  in names in scripts and formulas, (1), (2)

BRACKETS command, (1), (2)

  overriding

branches

  Calc Script Editor

  aliases

  dimensions

  members

  data hierarchies, (1), (2)

  Formula Editor

  aliases

  dimensions

  members

  outlines

  sharing members

browser for editing objects, (1), (2)

budgets

  allocating values, (1), (2)

  comparing actual to budgeted, (1), (2)

  example database for forecasting

  example for increasing

  generating and loading new

  getting variance, (1), (2)

  partitioned applications and

  variance reporting and

buffered I/O as default

buffers, (1), (2)

  See also caches

  extracted data row cells

  increasing size

  setting internal

  sorted data

build methods

  adding members

  as children of specified parent

  as sibling with matching strings

  as siblings of lowest level

  bottom-up ordering

  creating

  multiple roll-ups, (1), (2)

  creating shared members

  at different generations, (1), (2)

  at same generation, (1), (2)

  including branches, (1), (2)

  defined

  defining parent/child relationship

  description

  null processing, (1), (2)

  selecting, (1), (2)

  supported for associating attributes

  top-down ordering

  valid field types

BUILDDIM command, (1), (2)

building

  See also adding; creating

  applications

  calc script in Calc Script Editor

  calc scripts

  in Calc Script Editor, (1), (2)

  restrictions

  syntax for

  with Application Manager

  database outline

  databases

  development process for

  example for

  prerequisites for

  dimensions, (1), (2), (3), (4), (5)

  dynamically. See dynamic builds

  guidelines for, (1), (2)

  prerequisites, (1), (2), (3)

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

  with dynamically calculated members

  with rules files, (1), (2), (3), (4)

  dynamic calculations, (1), (2)

  restrictions, (1), (2), (3)

  formulas, (1), (2)

  with Formula Editor

  multiple roll-ups

  new calc script

  reports, (1), (2), (3)

  basic techniques, (1), (2)

  free-form

  with API function calls

  shared members dynamically, (1), (2), (3), (4)

Building and designing a security system

building dimensions

  example for

builds. See dynamic builds

business models

  checklist for creating

  creating as a part of database design

Cache Memory Locking

  described


C

caches

  as storage units

  calculator, (1), (2), (3)

  described

  disabling

  getting information about, (1), (2)

  locking memory for

  managing, (1), (2)

  optimizing read/writes

  setting size, (1), (2)

  sizing

  data cache

  data file cache

  fine-tuning

  index cache

  overview

  viewing statistics

  when changes take effect

CALC ALL command

  block ordering and

  currency conversions

  dynamic calculations and

  dynamically calculated members and

  for database calculation

  Intelligent Calculation and, (1), (2), (3)

  partitioned applications and

  usage overview, (1), (2), (3)

CALC AVERAGE command

CALC COL command. See CALCULATE COLUMN command

CALC command

CALC DIM command

  dynamically calculated members and

  for database calculation

  Intelligent Calculation and, (1), (2), (3), (4)

  usage examples, (1), (2), (3)

CALC FIRST command

CALC LAST command

CALC ROW command. See CALCULATE ROW command

Calc Script button (Application Manager)

calc script calculations

Calc Script Editor

  building calc scripts, (1), (2), (3)

  changing scripts

  checking syntax, (1), (2), (3)

  copying scripts

  expanding/contracting dimensions

  expanding/contracting member branches

  finding and replacing text

  opening

  saving calc scripts, (1), (2)

  searching for members

  undoing last action

calc script files, (1), (2)

  naming, (1), (2)

  opening, (1), (2)

  selecting, (1), (2)

calc scripts

  adding

  aliases

  comments

  equations, (1), (2)

  formulas, (1), (2)

  text

  aggregating missing values in

  applying conditions

  attaching to databases

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

  calculating member formulas

  calculation order

  changing, (1), (2)

  checking syntax

  copying, (1), (2)

  in file system

  creating with Application Manager

  currency conversions, (1), (2)

  declaring variables in, (1), (2)

  defined, (1), (2)

  defining

  as default

  execution access

  defining equations

  deleting, (1), (2)

  displaying completion notices with

  dynamic calculations and, (1), (2)

  examples, (1), (2), (3), (4)

  formulas in

  generating statistical information

  grouping formulas and dimensions, (1), (2), (3)

  inserting

  calculation commands, (1), (2)

  variables

  Intelligent Calculation and, (1), (2), (3), (4)

  loading, (1), (2), (3)

  names with special characters, (1), (2)

  overriding default calculation order

  performing multiple calculation passes

  examples, (1), (2)

  printing

  restrictions

  running

  calculating Sample Basic

  information messages after

  on partitioned applications

  with Application Manager

  with ESSCMD, (1), (2)

  with MaxL, (1), (2)

  saving, (1), (2), (3)

  on client workstations, (1), (2)

  syntax for

  checking, (1), (2)

  guidelines

  troubleshooting

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

  UDAs and

  undoing changes

  unlocking

  usage overview, (1), (2), (3)

  using formulas

  viewing application log contents

CALC TWOPASS command

  usage examples, (1), (2), (3)

CALCDEFAULT command

CALCHASHTBLMEMORY

  and parallel calculation

CALCHASHTBLMEMORY setting

CALCLINE command

CALCLOCKBLOCK setting

@CALCMODE function

CALCMODE configuration setting

CALCOPTCALCHASHTBL

  and parallel calculation

CALCOPTCALCHASHTBL setting

CALCOPTFRMLBOTTOMUP setting

CALCPARALLEL

  checking parallel calculation status

CALCULATE COLUMN command

  usage examples, (1), (2)

Calculate Database dialog box

  canceling operations

  running calc scripts

Calculate permission

calculate privilege

  defined, (1), (2)

  filters and

CALCULATE ROW command, (1), (2)

  restrictions

  usage examples, (1), (2), (3)

calculated columns

  adding totals

  clearing values, (1), (2)

  creating, (1), (2), (3)

calculated data

  filtering

  formatting, (1), (2)

calculated values vs. input values

Calculation

  locking blocks

  parallel vs. serial

calculation

  permission required to run

calculation commands, (1), (2)

  computation

  control

  declaring temporary variables for

  functions, custom-defined

  iterating through

  macros, custom-defined

  specifying global settings

calculation script commands

  SET MSG

calculation scripts

  clearing databases after export

calculation scripts. See calc scripts

calculations, (1), (2)

  See also calc scripts; dynamic calculations

  account reporting values

  across multiple processors

  ad hoc

  adding formulas to, (1), (2), (3), (4)

  with Formula Editor

  assigning constants

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

  attributes

  accessing calculated data

  Attribute Calculations dimension

  default calculation

  described

  examples

  multiple calculations

  performance considerations

  process

  using attributes in formulas

  basic concepts

  block mode

  blocks with dirty status

  bottom-up

  calc scripts vs.

  caution for changing outlines and, (1), (2)

  cell mode

  checklist for defining

  concurrent and memory usage

  controlling flow, (1), (2), (3)

  currency conversions, (1), (2), (3)

  links and

  dates

  default

  overriding

  setting, (1), (2), (3)

  defining global behavior

  defining order

  cells, (1), (2)

  data blocks

  dimensions

  forward references and

  members, (1), (2)

  designing for optimal

  difference between actual and budgeted

  displaying completion notices

  displaying settings

  entire database

  executing in ESSCMD

  executing in MaxL

  extending capabilities

  failing

  first-time

  fixing unexpected results, (1), (2)

  getting current state

  getting information about

  handling missing and zero values

  members across multiple parents

  members in outlines

  members with different operators

  missing values and, (1), (2), (3)

  monitoring, (1), (2)

  monthly assets

  multiple databases

  operator precedence

  optimizing, (1), (2)

  with attributes

  with bottom-up calculation

  with calc scripts

  with dynamic calculations, (1), (2)

  with Intelligent Calculation

  with interdependent values

  with two-pass calculations

  optimizing with search

  overview, (1), (2), (3)

  partial list of members

  partitioned applications

  with replicated partitions

  with transparent partitions, (1), (2), (3), (4)

  performance and multi-users

  performance, with attributes

  performing multiple passes, (1), (2), (3), (4)

  examples, (1), (2)

  period-to-date values, (1), (2)

  preventing delays

  recovering

  relationships between members

  report scripts, (1), (2)

  examples, (1), (2), (3)

  rolling averages

  running

  default

  in batch mode, (1), (2), (3)

  setting up two-pass, (1), (2), (3)

  shared members

  simulating

  single-server applications, (1), (2), (3)

  specified dimensions

  statistics

  stopping

  subsets of data, (1), (2), (3)

  example

  with Intelligent Calculation

  testing

  top-down

  types described, (1), (2)

  using MaxL

  variance performance

  with a series of dimensions

  with a series of member formulas

  year-to-date values

calculator cache

  and parallel calculation

  as storage unit

  bitmap

  disabling

  maximum size

  optimizing, (1), (2)

  overview

  setting size, (1), (2)

  sizing

calculator hash tables, (1), (2)

  and parallel calculation

canceling

  archiving operations

  calculations

  changes to calc scripts

  ESSCMD operations, (1), (2)

captures

carriage return as file delimiter

case conversions, (1), (2)

case sensitivity

  field type designation in header record

  member names

case-sensitive names

  converting case, (1), (2)

  defining selection criteria for, (1), (2)

  for databases

  improved for applications

  report scripts

  setting for database, (1), (2)

case-sensitive passwords

case-sensitive searches

  Calc Script Editor

  Field Properties dialog

  Formula Editor, (1), (2)

  Report Editor

cash flow, (1), (2)

catalogs, (1), (2), (3)

category conversion property

CCONV command, (1), (2)

  usage examples, (1), (2)

  usage overview, (1), (2)

CCONV TOLOCALRATE command

CCTRACK setting

cell calculation mode

cells

  accessing

  simultaneously in different databases

  annotating

  contents

  copying range of

  determining calculation order for, (1), (2)

  examples, (1), (2), (3), (4)

  empty

  caution for storing

  linking objects to

  mapping to targets

  ordering in blocks

  partitioning and, (1), (2), (3)

  removing linked objects

  returning unique values for

centering data, (1), (2)

  example

centralized data repositories

.CFG files, (1), (2)

  See also configurations

change data cache size

  Administration Services

  Application Manager

change logs, (1), (2)

  restructuring and

  updating

change logs. See outline change logs., (1), (2)

Change Password dialog box

changes

  affecting only outlines

  applying to outlines, (1), (2)

  discarding partition

  impacting restructures

  overriding incremental restructuring

  overwritten

  relational storage manager and

  tracking outline

  unable to make

  undoing

  viewing outline

changing

  See also editing; altering

  access privileges, (1), (2), (3)

  alias table names

  aliases

  attribute associations

  calc scripts, (1), (2)

  consolidations

  data, (1), (2), (3)

  prerequisite for

  data values

  default storage properties

  dimension names

  dimension properties, (1), (2), (3), (4)

  dimensions

  default configurations

  for currency conversions

  Essbase kernel settings

  with Administration Services

  formulas, (1), (2)

  headings in reports

  Hyperion Essbase kernel settings

  scope and precedence

  with Application Manager

  linked partitions

  member combinations for linked objects

  member names

  members

  outlines, (1), (2), (3)

  caution for, (1), (2), (3)

  dynamically

  for currency conversions

  with rules files

  passwords with Administration Services

  passwords with Application Manager

  report layouts

  security settings

  security settings with Administration Services

  security settings with Application Manager

  system password

character searches. See searches

character strings

  in calculation formulas

character strings. See strings

characters

  calc scripts

  end-of-file markers and special

  forbidden at the beginning of a name

  formulas

  ignored in data sources

  ignored in report extraction

  in array and variable names

  log delimiters

  maximum

  in aliases

  in application and database names

  in application names

  in database names

  in dimension names

  in member names, (1), (2)

  in URLs

  numeric in member names

  quoting in scripts and formulas, (1), (2)

  valid in numeric data fields

checking

  disk space

  forward references

  syntax

  Calc Script Editor, (1), (2), (3)

  Formula Editor, (1), (2)

check-out facility

.CHG files, (1), (2)

  updating

child

  See also parent/child relationships

  adding as member of specified parent

  as only member (implied sharing)

  calculation order for outlines

  checking for

  consolidation properties and

  currency conversions and

  defined

  dimension as

  member as, (1), (2)

  rolling up

  shared member as

child field type

  in header records

  in rules files

  sharing members, (1), (2), (3)

child processes

@CHILDREN function

CHILDREN command

  entering in report scripts

  usage

choosing

  alias tables, (1), (2)

  applications for loading

  with ESSCMD

  build methods, (1), (2)

  calc script files, (1), (2)

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

  using Windows

  data targets

  data to partition, (1), (2), (3)

  databases for loading

  with ESSCMD

  dimension storage type, (1), (2), (3)

  dimension type

  guidelines for

  fields

  members

  for dynamic calculations

  members for column groupings

  members for dynamic calculations, (1), (2)

  members for report scripts, (1), (2), (3)

  from Dynamic Time Series

  with ATTRIBUTE command

  with Boolean operators

  with conditions

  with substitution variables

  with TODATE command

  with user-defined attributes

  with wildcards

  with WITHATTR command

  multiple dimensions and members

  multiple files, (1), (2)

  multiple members

  partition type, (1), (2), (3), (4), (5)

  in Partition Wizard, (1), (2), (3), (4)

  records, (1), (2), (3)

  report script files, (1), (2)

  SQL data sources

  values for dynamic calculations, (1), (2)

  guidelines for, (1), (2)

clean status

  caution for sparse dimensions

  clearing data and

  Intelligent Calculation and

  marking blocks with, (1), (2)

  partial calculations and

Clear Alias Table dialog box

Clear Data Combinations page (Data Load Settings)

CLEARALLROWCALC command

CLEARBLOCK command, (1), (2)

CLEARBLOCK DYNAMIC command, (1), (2), (3)

CLEARDATA command

  partitioned applications and

  usage overview, (1), (2)

clearing

  See also deleting

  alias tables

  application and OLAP Server log contents

  data, (1), (2), (3), (4)

  caution

  in calculated columns, (1), (2)

  locks

  log contents

  member combinations

  values in transparent partitions

CLEARLOGFILE setting

CLEARROWCALC command

CLEARUPDATESTATUS command

client

  interfaces

  accessing linked objects and

  workstations

  as used in Hyperion Essbase

  caution for loading data from

  troubleshooting connections

client window

client workstations

  caution for improper shutdown

  deleting calc scripts

  limitations

  recovering from improper shutdowns

  writing calc scripts to, (1), (2)

clients, (1), (2)

  communicating with server

  types described

client-server applications

  See also single-server applications

client-server model, (1), (2)

  typical configuration

Close dialog box

  saving partition definitions

closing

  See also exiting; quitting; stopping

  applications, (1), (2)

  all opened

  before backup

  applications in Administration Services

  with related database

  applications in Application Manager

  with related database

  databases, (1), (2)

  Partition Wizard

.CNT files

codes in data source

  setting member properties

COLCALC1.REP

COLCALC2.REP

COLCALC3.REP

COLGROUP.REP

COLHEADING command

Collapse to Ancestor command

collapsing

  alias member lists

  Calc Script Editor lists

  Formula Editor lists

  outline hierarchies

colons (:)

  in application and database names

  in formulas

  in names in scripts and formulas, (1), (2)

column calculation commands

COLUMN command

  entering in report scripts

column formatting commands, (1), (2), (3)

column headings

  adding to calculated columns

  adding to reports, (1), (2)

  changing

  defined

  displaying

  for loading asymmetric columns

  multi-line

  names truncated

  repeating

  SQL data sources

  suppressing

column widths

columns

  See also fields

  adjusting length

  calculating in reports, (1), (2)

  creating asymmetric

  creating calculated, (1), (2)

  defining as fields

  fixed-width

  formatting

  formatting for data load, (1), (2)

  mapping specific fields only

  nesting in reports

  numbering

  ordering in data sources

  overriding grouping in reports

  parent/child data sources

  replacing empty fields with text

  restricting number of

  setting as data field

  switching with rows

  symmetry in reports

  using attributes in

combining fields. See joining fields, (1), (2), (3)

command prompt

command-line interface

  See also ESSCMD; server console

  ESSCMD

  running batch files

commands

  See also specific command

  calculation types listed

  caution for processing

  computation

  control

  data extraction, (1), (2), (3)

  declaring temporary variables for

  entering in ESSCMD scripts

  entering in report scripts

  ESSCMD syntax

  global calculation settings

  iterating through

  member selection, (1), (2)

  page layout, (1), (2)

  performance-related

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

  caution for usage, (1), (2)

  report output

  Server Agent

  sorting, (1), (2)

commas ( , )

  as file delimiter

  displaying in reports

  in application and database names

  in data fields

  in dimension and member names

  in formulas

  in header records

  in member combinations

  in names in scripts and formulas, (1), (2)

  suppressing in reports, (1), (2)

COMMAS command, (1), (2)

  overriding, (1), (2)

comment fields

comments

  See also annotating

  adding to dimensions

  adding to members

  calc scripts

  display options

  report scripts

  storing

  viewing in Application Manager

commission, (1), (2), (3)

  returning from calc scripts

commit

  threshold adjustments with parallel calculation

Commit Block setting, (1), (2)

Commit Row setting, (1), (2), (3)

commit threshold adjustments and parallel calculation

commits

  data loads failing and, (1), (2), (3)

  initiating, (1), (2)

  managing

  rollbacks and

  setting isolation level

  with ESSCMD, (1), (2)

  updating isolation level

committed access

  about

  caution for

  locks and, (1), (2), (3)

  rollbacks and

  setting, (1), (2), (3)

common currency

communications

  client-server models, (1), (2), (3)

communications protocols

Company database

  provided with Hyperion Essbase

comparing

  data values, (1), (2), (3)

  timestamps for outlines

complete loads

completion notices

Complex Formula

  performance example

complex formulas, (1), (2), (3)

@COMPOUND function

compounded interest

@COMPOUNDGROWTH function

compression

  as default

  checking compression ratio in Administration Mservicesr

  checking compression ratio in Application Manager

  enabling/disabling, (1), (2)

  estimating block size

  fragmentation allowance, (1), (2)

  optimal configuration

  overview

  ratio

  repetitive values, (1), (2)

  specifying/changing

  viewing settings information

compression ratio, checking in Administration Services

compression ratio, checking in Application Manager

compression settings, changing with MaxL

computing data relationships

@CONCATENATE function

concatenating fields

concurrency, data

concurrent calculations, (1), (2)

  overview

conditional blocks

conditional equations

conditional operators, (1), (2)

conditions

  adding to report scripts, (1), (2)

  examples, (1), (2), (3)

  logical, (1), (2)

  setting for ESSCMD

  specifying

  for data loads, (1), (2)

  in formulas, (1), (2)

  testing, (1), (2)

Confignuration parameter

  CALCPARALLEL

configurable variables

  setting

configuration files, (1), (2)

configurations

  activating change logs

  changing

  checking

  clearing logs

  creating multiple exception logs

  creating outline change logs

  currency calculations

  database

  delimiting logs

  determining optimal

  dimensions

  automatic

  changing default setting

  determining optimal

  manual

  enabling incremental restructuring

  Hyperion Essbase kernel settings and

  Intelligent Calculation

  logging spreadsheet updates

  resetting error log

  limits

  resetting error logs

  files

  limits

  setting dimensions automatic vs manual

  setting number of threads

  setting outline change file size

  viewing settings information, (1), (2)

configuring multiple agents on a single server

Confirm Delete dialog box, (1), (2)

Confirm Password text box, (1), (2)

Confirmation dialog box

Connect page (Partition Wizard)

connection passwords

connections

  communications protocols

  databases with data cells

  losing

  multiple servers

  partitioned applications, (1), (2), (3)

  preventing system failures, (1), (2)

  terminating

  for specific user

  troubleshooting

Connections dialog box

consecutive values

consistency, data

consistency. See data integrity

console. See server console

consolidation

  changing

  codes in data source

  default order

  defined

  defining for members, (1), (2)

  display options

  excluding members from, (1), (2)

  fixing unexpected results, (1), (2)

  levels within a dimension

  operators listed

  performance considerations

  restrictions

  specifying requirements for

consolidation paths

  defining, (1), (2)

  checklist for

consolidation properties

  described

  setting, (1), (2)

consolidations (in Hyperion MBA). See defaults, calculations

constants, (1), (2)

contracting. See collapsing

control information

conventions. See naming conventions

conversions

  See also currency conversions

  case, (1), (2)

  positive/negative values

  white space

  in data loads

  to underscores in data load

converting

  dates

  spaces to underscores

coordinates (data values)

Copy Alias Table dialog box

copy application

  Administration Services

copy database

  Administration Services

Copy Filter dialog box

Copy Group dialog box

Copy to Server Object dialog box

Copy User dialog box

COPYAPP command

COPYDB command, (1), (2), (3)

COPYFILTER command

copying

  See also duplicating; replicating

  alias tables

  applications, (1), (2)

  base dimension members

  calc scripts

  data, (1), (2), (3), (4), (5)

  database outlines

  databases, (1), (2)

  filters

  from data targets

  objects

  outline files, (1), (2), (3)

  outlines

  with Application Manager

  security profiles, (1), (2)

  text

  in calc scripts

  in formulas

  in report scripts

@CORRELATION function

correlation coefficient, calculating

corrupted data, (1), (2)

  operations causing, (1), (2)

  restoring and

cost of goods

  example for allocating

@COUNT function

Count member, Attribute Calculations dimension

count, calculating

country dimension

  creating

  currency applications

  description

  specifying

  usage overview

country-specific data. See locales

.CPL files

crashes

  exception logs for

  getting information about

  minimizing, (1), (2)

  recovering from, (1), (2), (3)

  suggested procedures

  restructuring and

  transaction rollbacks and

Create Alias Table dialog box

create application (MaxL)

create application as (MaxL)

Create Blocks on Equations option, (1), (2)

Create Currency Database dialog box

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

Create Field Using Join dialog box, (1), (2)

Create Field Using Text dialog box

create group (MaxL)

create location alias (MaxL)

Create New Application dialog box, (1), (2)

Create New Database dialog box, (1), (2)

Create/Delete Applications permission

Create/Delete Applications privilege type

Create/Delete Users/Groups permission

Create/Delete Users/Groups privilege type

CREATEAPP command

CREATEDB command

CREATEGROUP command

CREATELOCATION command

CREATEVARIABLE command

creating

  See also adding; building

  alias combinations

  alias tables, (1), (2)

  aliases, (1), (2)

  based on member combinations

  caution for, (1), (2), (3)

  guidelines for

  applications, (1), (2)

  for currency conversions

  for Personal Essbase servers

  on client

  prerequisites

  with Application Manager

  backups

  data blocks

  data load rules

  database outlines, (1), (2)

  example for

  from data sources

  guidelines for

  prerequisites for

  with Outline Editor, (1), (2)

  databases, (1), (2)

  for Personal Essbase servers

  on client

  process summarized

  with Administration Services

  with Application Manager

  Dynamic Calc And Store members

  Dynamic Calc members

  ESSCMD script files, (1), (2)

  fields, (1), (2)

  with joins

  filters, (1), (2)

  for partitioned databases, (1), (2)

  formulas, (1), (2)

  examples, (1), (2), (3)

  syntax for

  with Formula Editor

  writing equations

  header records, (1), (2)

  linked partitions, (1), (2)

  linked reporting objects

  member groups, (1), (2)

  multiple roll-ups, (1), (2)

  outline change logs

  outline files

  outlines

  for currency conversions

  outlines for currency conversions

  partition definition files

  partitions, (1), (2), (3), (4), (5)

  for currency conversions, (1), (2)

  process summarized

  replicated partitions, (1), (2)

  report files

  report scripts, (1), (2)

  basic techniques, (1), (2)

  parts described

  with Application Manager

  rules files, (1), (2)

  process overview

  scripts for batch processing

  shared members, (1), (2), (3), (4)

  for different generations, (1), (2)

  for same generation, (1), (2)

  guidelines for, (1), (2)

  with Outline Editor

  with rules files

  shared roll-ups

  substitution variables

  text files, (1), (2)

  transparent partitions

  two-dimensional reports, (1), (2)

  UDAs, (1), (2)

  user groups, (1), (2)

  user groups with Administration Services

  user groups with Application Manager

creating applications

  with Administration Services

  with MaxL

creating databases

  as optimized

  ESSCMD

  MaxL

creating new users

  with Administration Services

  with Application Manager

creating queries

cross-dimensional members

  in formulas, (1), (2), (3), (4)

Cross-dimensional operator

  replacing on the left side of an equation for performance

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

  inserting in calc scripts

  inserting in formulas, (1), (2)

  overview, (1), (2)

  usage examples, (1), (2)

crosstab defined

.CSC files

cubes

CURCAT. See currency category field type

@CURGEN function

CURHEADING command

@CURLEV function

CURNAME. See currency name field type

currency

  ad hoc report

  defining country-specific

  effects of adding new markets

  exchange rates, (1), (2), (3)

  calculation options

  formatting in reports

currency applications

  creating

  overview, (1), (2), (3)

  sample

currency category

  dimension (example)

currency category field type

  in header records

  in rules files

  nulls and, (1), (2)

CURRENCY command

  overriding

  usage overview

Currency Conversion

  description of product

currency conversions

  adding members, (1), (2)

  base to local exchange

  calculating in report scripts

  creating outlines for, (1), (2), (3)

  creating partitions for, (1), (2)

  defining

  dynamic calculations and

  getting information about

  Intelligent Calculation and

  keeping local and converted values

  links and calculating

  mathematical operations

  overview

  overwriting local values

  recovering from errors

  reporting

  running, (1), (2), (3)

  saving outline changes, (1), (2)

  suppressing in reports

  tagging dimensions for

currency database (defined)

currency database types

currency fields

Currency Name dimension (example)

currency name field type

  in header records

  in rules files

  nulls and, (1), (2)

currency names, (1), (2), (3)

  defining

Currency page (Database Information)

Currency page (Database Settings), (1), (2)

Currency Partition dimension, (1), (2), (3)

  creating

  usage overview

currency partition dimension

  description

currency partitions

  caution for transparent

  creating

currency sample databases

  linking

currency symbols

Currency Time dimension (example)

Currency Type dimension (example)

@CURRMBR function

@CURRMBRRANGE function

custom-defined function

  creating a Java class

  registering using Application Manager

custom-defined functions

  function category

  using in formulas

  drop using MaxL

  input parameters

  memory considerations

  performance considerations

  registering

  security required

custom-defined macros

customizing

  applications

  Data Prep Editor

  Essbase kernel

  file delimiters

  Hyperion Essbase kernel

  Outline Editor, (1), (2)

  page layouts, (1), (2)

  examples, (1), (2)

  views

cutting text

  Calc Script Editor

  Formula Editor

  Report Editor


D

dashes (-)

  in dimension and member names

  in member names

  in names in scripts and formulas

  in report scripts

data

  accessing. See access

  backing up

  calculated vs. input

  categorizing. See dimensions

  centering in reports, (1), (2)

  example

  changing, (1), (2), (3)

  prerequisite for

  clearing, (1), (2), (3), (4), (5)

  in calculated columns, (1), (2)

  computing relationships

  concurrency

  consistency

  controlling flow

  copying, (1), (2), (3), (4), (5)

  corrupted, (1), (2), (3)

  operations causing, (1), (2)

  derived

  developing logical structures for

  distribution characteristics

  entering in data sources, (1), (2)

  exporting, (1), (2), (3)

  for backups

  into other forms

  reporting example

  exporting using MaxL or ESSCMD, (1), (2)

  importing, (1), (2)

  improving access to, (1), (2)

  in targets

  irrelevant

  loading

  description, (1), (2)

  dynamic calculations and

  for testing purposes

  from external sources, (1), (2), (3), (4)

  from partitioned applications, (1), (2), (3)

  from rules files

  getting information about

  incrementally

  optimizing, (1), (2), (3), (4)

  overview, (1), (2), (3), (4)

  prerequisites, (1), (2)

  restrictions, (1), (2), (3), (4)

  supported formats

  tips, (1), (2)

  troubleshooting problems with

  unauthorized users and

  managing

  manipulating remote

  missing

  not associated with members

  organizing

  partitioning guidelines, (1), (2), (3)

  pivoting

  protecting

  recalculating, (1), (2)

  after exporting

  after member name changes

  after repositioning members

  Dynamic Calc And Store members

  examples

  for Personal Essbase servers

  in sparse dimensions, (1), (2)

  Intelligent Calculation and, (1), (2)

  two-pass calculations and

  referencing in dimensions, (1), (2)

  refreshing

  reloading exported, (1), (2)

  replicating, (1), (2)

  reporting combinations, (1), (2)

  restoring from backups

  sharing, (1), (2)

  across multiple sites, (1), (2)

  disabling, (1), (2), (3), (4)

  in partitioned databases, (1), (2), (3)

  sorting for reports, (1), (2), (3), (4)

  examples, (1), (2), (3)

  storing. See storage

  synchronizing, (1), (2), (3)

  partitioning and

  time-sensitive

  transactions and redundant, (1), (2)

  validating

  viewing, (1), (2)

  in data targets

  with Data Prep Editor, (1), (2)

  viewing in different perspectives

data analysis

  defining objectives

  example

  getting started tips

  optimizing

  single-server applications, (1), (2)

data block size

  viewing in Administration Services

  viewing size in Application Manager

data blocks

  accessing locked, (1), (2)

  and index system

  as multidimensional arrays

  calculating dirty

  calculating values in, (1), (2)

  caution for partial calculations

  defining calculation order

  calculations and

  categorizing

  checking characteristics of

  checking structural integrity

  clearing values, (1), (2)

  compressing

  creating from Intelligent Calculations

  defined

  exporting

  locking, (1), (2)

  with committed access, (1), (2)

  with uncommitted access

  managing

  marking as clean/dirty, (1), (2)

  ordering

  removing

  renumbering

  restructuring, (1), (2)

  retrieving, (1), (2), (3)

  setting transactions for, (1), (2)

  size considerations, (1), (2)

  storing

  two-dimensional example

  updating

  viewing locks

  with no values

data cache

  as storage unit

  defined

  described

  fine-tuning

  setting size, (1), (2)

data cache size

  changing with Administration Services

  changing with Application Manager

data cells. See cells

data compression

  as default

  changing using MaxL

  checking compression ratio in Administration Services

  checking compression ratio in Application Manager

  enabling/disabling, (1), (2)

  estimating block size

  fragmentation allowance, (1), (2)

  optimal configuration

  overview

  ratio

  repetitive values, (1), (2)

  specifying/changing

  viewing settings information

data concurrency

data consistency

data consistency. See data integrity

data coordinates

data extraction, (1), (2)

  characters ignored

data extraction commands, (1), (2)

  defined

data fields

  defined in data source

  defining columns as

  entering data

  formatting, (1), (2)

  in data sources, (1), (2)

  invalid

  reversing values in

  with no values, (1), (2)

data file cache

  as storage unit

  defined

  described

  fine-tuning

  setting size

Data File Properties dialog box

  defining header information

  mapping fields

  setting file delimiters

  undoing field operations

data files

  See also files

  allocating storage for

  backing up

  caution for recovery and

  cross-platform compatibility

  definition

  estimating size

  list to backup

  opening, (1), (2)

  restructuring, (1), (2)

  size

  setting maximum

  viewing

  spanning multiple volumes

data filters

  assigning

  copying

  creating, (1), (2), (3), (4)

  defining in Application Manager, (1), (2)

  editing

  inheriting, (1), (2), (3)

  overlap conflicts, (1), (2)

  overriding, (1), (2)

  overview, (1), (2)

  removing

  renaming

  restrictions on applying

  saving

  viewing existing

  write access to database

data hierarchies

  relationships defined, (1), (2)

data integrity, (1), (2)

  checks failing

  committed access and

  maintaining

  retaining duplicate data

  uncommitted access and

  validating

data load

  error logs. See DATALOAD.ERR.

  fields

  free-form

  load rules in the source data

  mode

  parallel processing, (1), (2), (3)

  parent members

  rules

  creating

  defined

  described

  when to use

  use of threads, (1), (2)

Data Load Completed dialog box, (1), (2), (3)

Data Load dialog box, (1), (2)

  building dimensions

  changing outlines

  selecting data sources, (1), (2)

Data Load Properties page

  naming fields

Data Load Rules button (Application Manager)

Data Load Settings dialog box

  changing data values

  clearing existing values

  defining header information

  defining selection criteria

  flipping field values

data loading

  stages

Data Manager

  overview

data points. See cells

Data Prep Editor

  building dimensions, (1), (2), (3), (4)

  creating rules files, (1), (2)

  customizing

  defining header information

  dimension building mode

  displaying

  dimension building fields

  records

  enabling/disabling toolbar

  loading data sources, (1), (2)

  opening, (1), (2)

  selecting data load or dimension build view

  validating rules files, (1), (2)

  viewing rules files

  window

data redundancy overhead

Data Replication dialog box

data repositories

  location

data sets

  copying portions

  distribution

  non-typical

  typical nature of data

data sources

  accessing data

  replicated partitions and

  adding headers, (1), (2), (3), (4)

  adding records, (1), (2), (3)

  altering to build dimensions

  appending information to

  associating with rules files

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

  changing outlines

  copying

  creating outlines with

  creating shared roll-ups from multiple

  debugging

  defined

  defining

  for multiple partitions

  for replicated partitions

  for transparent partitions, (1), (2)

  entering data, (1), (2)

  field types

  described, (1), (2)

  invalid

  fixing

  partial loads, (1), (2)

  for dimension builds

  formatting, (1), (2), (3), (4)

  overview

  free-form, (1), (2), (3)

  identifying

  load failing

  loading, (1), (2), (3), (4)

  in Data Prep Editor, (1), (2)

  prerequisites

  troubleshooting problems, (1), (2)

  logging into

  losing connections to

  mapping information

  mapping members

  linked partitions, (1), (2)

  replicated partitions, (1), (2), (3)

  transparent partitions, (1), (2)

  member names differing from targets

  members with no ancestor specified

  missing members, (1), (2)

  numbering members

  opening

  opening in Data Prep Editor

  optimizing, (1), (2)

  ordering

  columns

  fields, (1), (2)

  records, (1), (2), (3)

  overview, (1), (2), (3)

  partitioning information for

  propagating outline changes, (1), (2), (3)

  process summarized, (1), (2)

  remote data retrievals and

  removing members

  replicating derived data

  replicating members

  replicating partial sets

  selecting, (1), (2)

  how to

  SQL

  using Application Manager

  using Windows

  selecting text or spreadsheet

  setting member properties

  specifying

  field type

  specifying shared areas, (1), (2), (3)

  supported

  unavailable, (1), (2)

  updating changes to, (1), (2)

  validating rules files from

  viewing, (1), (2)

  with different values

  with new member lists

Data Storage dialog box, (1), (2)

data storage property

  setting

data storage. See storage; Hyperion Essbase kernel

data subsets

  calculating, (1), (2), (3)

  example

  with Intelligent Calculation

  clearing

  copying

  copying to Personal Essbase

  prerequisites

  loading, (1), (2)

data targets

  accessing data, (1), (2)

  archiving

  calculations and, (1), (2)

  changing data in

  changing outlines

  copying from

  defined

  defining

  for multiple partitions

  for replicated partitions

  for transparent partitions, (1), (2)

  logging into

  losing connections to

  mapping information

  mapping members to data sources

  linked partitions, (1), (2)

  replicated partitions, (1), (2), (3)

  specifying specific areas

  transparent partitions, (1), (2)

  member names differing from source

  missing data

  partitioning information for

  propagating outline changes, (1), (2), (3)

  process summarized, (1), (2)

  selecting

  specifying shared areas, (1), (2), (3)

  updating changes to, (1), (2), (3)

  viewing data in linked partitions

data values, (1), (2), (3)

  See also missing values; range of values

  accumulating

  assigning

  to member combinations

  to variables

  averaging

  for time periods, (1), (2), (3)

  non-zero values and

  reporting examples, (1), (2)

  with formulas, (1), (2)

  changing

  comparing, (1), (2)

  comparing example

  compression and repetitive, (1), (2)

  defined

  displaying specific

  distribution among dimensions

  duplicating

  dynamically calculating, (1), (2), (3)

  entering in empty fields

  filtering

  flipping

  formatting in reports, (1), (2)

  examples

  identical

  inconsistent

  incorrect

  interdependent

  location

  looking up

  measuring

  member with no

  negative

  flipping

  variance as

  nulls, (1), (2)

  optimizing in sparse dimensions

  ordering in reports, (1), (2)

  example

  out of range

  overwriting, (1), (2), (3)

  for currency conversions

  placing retrieval restrictions, (1), (2)

  example

  reading multiple ranges

  referencing, (1), (2), (3), (4)

  retrieving

  dynamically calculated, (1), (2), (3), (4)

  from other databases

  from remote databases, (1), (2), (3)

  retrieving for reports

  setting maximum rows allowed

  with conditions, (1), (2), (3), (4)

  rolling up

  rounding, (1), (2)

  scaling

  setting maximum number of

  storing, (1), (2)

  temporary, (1), (2)

  truncating

  unable to change

  unexpected

  unique

  assigning #MISSING values to

  Intelligent Calculation and

  unknown

  variables as

  void

Data Values page (Data Load Settings)

  adding to or subtracting from existing values

  flipping field values

database

  exporting methods

  larger than 2 GB, exporting

  parallel calculation level

  rename, (1), (2)

Database Access options (Database Settings)

database administrators. See administrators

database cells

  accessing

  simultaneously in different databases

  annotating

  copying range of

  determining calculation order for, (1), (2)

  examples, (1), (2), (3), (4)

  empty

  caution for storing

  linking objects to

  mapping to targets

  ordering in blocks

  partitioning and, (1), (2), (3)

  removing linked objects

  returning unique values for

Database Copy dialog box

database design

  attribute dimensions

Database Designer permission

Database designer permission

Database Designer privilege. See DB Designer privilege

database directory

database files

  backing up

  corruption and

  essential files

  on different operating systems

Database Filter layer, (1), (2)

Database Information dialog box, (1), (2), (3)

  cache hit ratios

  performance checks

Database Locks dialog box

database objects

  calc scripts

  data sources

  linked reporting objects

  member select definitions

  outlines

  report scripts

  rules files

  security definitions

  spreadsheet queries

database outlines. See outlines, (1), (2)

database processing as server function

Database Properties

  adjust retrieval buffer size

  adjust retrieval sort buffer size

  run a calc script

Database Properties dialog box

  changing Essbase kernel settings

Database Properties window

  check index and data file sizes

  check performance

  viewing latest database settings

database restructuring

  using incremental

Database Settings dialog box

  calc options settings

  changing Essbase kernel settings

  changing Hyperion Essbase kernel settings

  global database access

  setting

  currency conversion links

  retrieval buffer size, (1), (2), (3)

  settings described

databases

  See also data; partitioned databases

  accessing, (1), (2)

  remote

  analytical vs transaction processing

  annotating

  annotating with Administration Services

  associating

  with calc scripts, (1), (2), (3), (4)

  with reports

  associating index files with

  attaching to. See connections

  backing up

  building

  development process for

  example for

  prerequisites for

  building an outline

  calculating multiple

  checking

  operational status

  which databases are currently running

  checklist for analyzing

  closing related application in Administration Services

  closing related application in Application Manager

  configuring

  copying, (1), (2)

  copying using MaxL

  creating, (1), (2), (3)

  for Personal Essbase

  on client

  process summarized

  with Administration Services

  with Application Manager

  creating accounts for, (1), (2), (3)

  creating using MaxL

  currency conversions and

  deleting

  deleting using MaxL

  determining scope

  distributing. See partitioning

  fine tuning

  identifying data sources

  implementing common security

  implementing global security

  linking related, (1), (2)

  loading applications with

  minimizing downtime

  mission-critical

  multidimensional defined

  naming rules

  navigating between, (1), (2)

  non-contiguous portions in

  objects

  opening

  optimizing access, (1), (2)

  to large

  optimizing retrieval

  overview

  partitioning, (1), (2)

  guidelines for, (1), (2)

  sample applications showing

  permission

  planning prerequisites

  processing requests

  protecting data

  putting in archive or read-only mode

  rebuilding

  reducing size

  related information among

  reloading after porting

  removing

  partitions

  removing dimensions

  restructuring and

  renaming

  renaming using MaxL

  restoring from backups

  restructuring, (1), (2)

  changing outlines and, (1), (2)

  dynamic calculations and

  immediately, (1), (2)

  in partitioned applications

  Intelligent Calculation and, (1), (2)

  process described

  sample

  selecting

  with ESSCMD

  size determinations, (1), (2), (3)

  slicing

  splitting, (1), (2)

  starting

  automatically

  automatically using Administration Services

  stopping, (1), (2)

  taking out of archive or read-only mode

  terminating requests

  testing design

  typical contents

  updating, (1), (2)

  viewing

  in Application Manager

  information about, (1), (2)

  viewing statistical information

  with differing dimensionality

Databases list box

DATACOPY command, (1), (2), (3)

  currency conversions and

  partitioned applications and

  usage overview, (1), (2)

DATAERRORLIMIT setting, (1), (2), (3)

DATALOAD.ERR

  See also error log files

  example

  loading

  maximum errors logged

  overview

  renaming

  setting

  using to debug data load problems

  viewing

DATALOAD.TXT

date

  attribute dimensions

  changing the member name format

  tagging

  attributes

  defined, (1), (2)

  duplicate values

date calculations, (1), (2)

  examples

dates, in calculation formulas

day-to-date calculations

.DB files

DB Designer privilege

dBASE data files

dBASE databases. See SQL databases

dBASE index files

.DBB files

.DBF files

.DDB files, (1), (2), (3)

.DDM files

.DDN files

deadlocks

deallocation (storage), (1), (2)

debugging data loads

debugging tool

DECIMAL command, (1), (2), (3)

decimal points

declaring

  arrays

  variables, (1), (2), (3)

@DECLINE function

Default table (aliases)

  updating during builds

defaults

  aggregating missing values

  application settings

  cache size

  calculations

  setting, (1), (2), (3)

  calculator cache

  currency type

  data storage, (1), (2)

  dimension properties

  dynamic builds

  error log locations

  for database settings

  Intelligent Calculation

  login information

  maximum lock time

  member selection for reports

  members names

  outline change log size

  retrieval buffers, (1), (2)

  time balance tags

  variance reporting tags

Define Attribute Dimensions dialog box

Define Filter dialog box

Define SQL dialog box

defining

  See also adding; creating; setting

  a single data value

  area-specific mappings

  calc script as default

  calculation order

  cells, (1), (2)

  data blocks

  dimensions

  dynamically calculated values, (1), (2)

  forward references and

  members, (1), (2)

  calculations (checklist for)

  columns as fields

  consolidation paths, (1), (2)

  checklist for

  currency conversions

  custom attributes

  data sources

  for multiple partitions

  for replicated partitions

  for transparent partitions, (1), (2)

  data storage properties

  data targets

  for multiple partitions

  for replicated partitions

  for transparent partitions, (1), (2)

  dimension properties, (1), (2), (3), (4)

  caution for two-pass tags

  dimensions as flat, (1), (2)

  dynamic calc properties

  field type, (1), (2)

  filters in Application Manager, (1), (2)

  global access levels

  member properties, (1), (2), (3), (4)

  as label only

  members as label only

  multiple layout reports

  page layouts, (1), (2), (3)

  parent/child relationships

  partitioned areas

  linked partitions, (1), (2)

  replicated partitions, (1), (2)

  transparent partitions, (1), (2)

  partitions, (1), (2), (3)

  linked, (1), (2)

  multiple

  replicated, (1), (2)

  transparent, (1), (2)

  with Partition Wizard, (1), (2), (3), (4)

  selection/rejection criteria, (1), (2)

  multiple for single field, (1), (2)

  on multiple fields

  shared member properties, (1), (2)

  sort order

  two-pass calculations, (1), (2)

  UDAs

definition files. See partition definition files

delays

Delete Alias Table dialog box

delete application

  Administration Services

delete database

  Administration Services

delete logs

  OLAP Server and application in Application Manager

  OLAP Server logs and application logs in Administration Services

DELETEAPP command

Deleted Dimensions dialog box

DELETEDB command

DELETEGROUP command

DELETELOCATION command

DELETELOG command

DELETEUSER command

DELETEVARIABLE command

deleting

  See also clearing

  aliases

  applications

  calc scripts, (1), (2)

  contents from alias tables

  data blocks

  databases

  dimensions

  restructuring and

  filters

  formulas

  items from outlines

  linked objects

  locks, (1), (2), (3), (4)

  automatically

  logs, (1), (2)

  logs in Application Manager

  members from data sources

  objects

  partitions

  substitution variables

  temporary files

  text

  in calc scripts

  in formulas

  in report scripts

  user groups with Administration Services

  user groups with Application Manager

  users, (1), (2)

  users with Application Manager

  white space in fields

deleting dimensions from outlines

deleting users and groups

DELIMITEDMSG setting

DELIMITEDMSG to filter logs

DELIMITER setting

delimiters

  ~ (tildes) as default

  See also file delimiters

  application logs and

  commas in numbers

  exports/imports, (1), (2)

  member lists

  OLAP Server logs and

  report script commands, (1), (2)

Demo application

Demo Basic database

  sample reports

dense dimensions

  See also dimensions; sparse dimensions

  attribute design approach

  calculating values in, (1), (2), (3)

  examples, (1), (2), (3)

  defined

  dynamically calculating, (1), (2), (3), (4)

  implications for restructuring and, (1), (2)

  Intelligent Calculation and, (1), (2)

  location in outline, (1), (2)

  member order and

  partitioning, (1), (2)

  referencing values in, (1), (2)

  reporting on

  selecting

  selection scenarios, (1), (2)

  setting

  storing

  viewing member combinations, (1), (2)

  vs sparse dimensions

density

depreciation, (1), (2)

derived data

DESC command

  described

  usage example

@DESCENDANTS function, (1), (2)

descendants

  checking for

  clearing

  currency conversions and

  defined

  moving

DESCENDANTS command

  entering in report scripts

  usage

descending sort order

  applying to output

  members in outlines

desiging, building, and maintaining

design checklists

  analyzing database scope

  creating business models

  defining calculations

  defining consolidations

  defining dimension properties

  identifying data sources

  partitioning databases, (1), (2)

  selecting partition types

design guidelines

  attributes

  dimensions

  outlines

Designer permission

designer permissions

designing

  See also building; creating

  for optimal calculations, (1), (2)

  partitioned applications, (1), (2), (3), (4)

  scenarios for, (1), (2), (3)

  reports, (1), (2)

  simple applications, (1), (2), (3)

  single-server applications, (1), (2)

Designing and building a security system

Designing, building, and maintaining partitions

Desktop window. See Application Desktop window

detail members

developing applications

  process summarized

Diagnostic Information

diagnostic information

  quick reference table

diagnostic tools

  overview

dialog boxes

  informational

  refreshing pages in

differences

  between attributes and UDAs

  between standard and attribute dimensions

DIMBOTTOM command

  entering in report scripts

  usage

DIMBUILD.ERR

  example

  loading

  maximum errors logged

  overview

  renaming

  setting

  viewing

dimenion building rules

  summary for attribute dimensions

dimension

  as highest consolidation level

dimension build

  associating

  aliases with attributes

  base dimension members with attributes

  attribute members options

  defining

  attribute dimensions

  standard dimensions

  error logs. See DIMBUILD.ERR.

  fields

  mode

  position of fields in rules file

Dimension Build Completed dialog box, (1), (2)

Dimension Build Settings dialog box

  adding members, (1), (2)

  creating rules files, (1), (2)

  naming dimensions

  setting properties

Dimension Build Settings page (Dimension Build Settings)

dimension building

  field types

  rules

  setting mode in Data Prep Editor

Dimension Building Properties page (Field Properties)

Dimension Definition page (Dimension Build Settings)

dimension fields

  formatting

  in data source, defined

dimension names

  maximum length

Dimension Properties dialog box

Dimension Properties page (Dimension Properties)

Dimension Specification dialog box

  adding comments

  applying time balance tags

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

dimension type

  setting

DIMENSIONBUILD.TXT

dimensions

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

  adding and deleting

  adding comments to

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

  example for, (1), (2)

  for currency conversions, (1), (2)

  guidelines for

  partitioned applications

  restrictions

  adding to outlines, (1), (2), (3), (4)

  performance considerations, (1), (2)

  restructuring and

  applicable to business models

  arranging in hierarchies, (1), (2)

  associating formulas with

  attribute

  See also attribute dimensions

  described

  attribute vs standard

  auto-configuring, (1), (2)

  base

  See also base dimensions

  defined

  building, (1), (2), (3), (4)

  dynamically See dynamic builds

  example for

  guidelines for, (1), (2)

  prerequisites, (1), (2), (3)

  with dynamically calculated members

  with rules files

  calculating members in, (1), (2)

  calculating series of

  calculator cache and

  categorized

  changing

  default configurations

  for currency conversions

  changing properties, (1), (2), (3), (4)

  clearing member combinations

  consolidation levels

  creating filters for

  databases with different

  defined

  defining as flat, (1), (2)

  defining properties, (1), (2), (3), (4)

  caution for two-pass tags

  deleting

  restructuring and

  deleting from outline

  determining optimal configuration, (1), (2)

  determining valid combinations

  displaying

  in Calc Script Editor

  in Formula Editor

  in outlines

  displaying information about

  examples

  time-balanced data, (1), (2)

  fixing as constant

  getting member combinations

  getting started with setting up

  grouping in calc scripts, (1), (2), (3)

  handling missing values in

  identified in data source

  inheritance characteristics

  irrelevance across

  mapping fields to

  missing

  missing members

  moving in outlines

  naming, (1), (2), (3)

  naming levels in current

  nesting

  non-specific

  optimum order in outline

  ordering

  ordering members

  predefined types described

  referencing data in, (1), (2)

  relationship among members, (1), (2), (3), (4)

  renaming

  selection guidelines

  separating sparse and dense

  sharing members, (1), (2)

  single-server models

  sorting, (1), (2)

  sparse-dense recommendations

  splitting

  standard

  See also standard dimensions

  alternative for attributes

  compared with attribute types

  described

  standard vs dynamic

  tagging

  as Currency Partition

  as specific type

  for currency conversion

  two-pass calculations and

  types

  updating

DIMTOP command

  usage

direct I/O

direct I/O, adjusting cache sizes

direct I/O, using in place of buffered I/O

directories

  API

  application

  database

  default

  for calc scripts

  for error logs

  default for calc scripts

  error logs

  spreadsheets as data sources

  text files as data sources

dirty status

  calculating blocks with

  clearing data and

  copying data and

  currency conversion and

  Intelligent Calculation and

  marking blocks with, (1), (2)

  resulting from reloads

Disabled Usernames dialog box

disabling member sort

discarding records

disconnecting

  from server

  other users

  session or request

discontinuous field selection

@DISCOUNT function

discount, calculating

disk drives

  copying applications to

  copying databases to

  viewing information about, (1), (2)

Disk Drives page (Server Information)

disk I/O, reducing, (1), (2)

disk space

  allocating, (1), (2)

  example

  application logs and

  availability for restructuring

  calculations for determining

  compressed block size

  data file storage, (1), (2)

  data redundancy overhead

  database overhead

  fragmentation allowance

  checking, (1), (2)

  conserving

  estimating

  for linked reporting objects

  freeing, (1), (2), (3)

  OLAP Server logs and

  out of

  outline change logs and

  partitioned databases, (1), (2)

  with replicated partitions

  with transparent partitions

  unused and fragmented

Disk Swapping option

disk volumes

  allocation and

  backing up data on

  caution for specifying name only

  data files and

  data storage and multiple

  deallocating, (1), (2)

  index files and

  specifying

  with Application Manager

  with ESSCMD

  updating storage settings

Disk Volumes setting, (1), (2)

display filter (MaxL)

display group (MaxL), (1), (2), (3), (4), (5), (6)

display location alias (MaxL)

display options

  data in reports, (1), (2)

  formulas

  headings in reports, (1), (2)

  outlines

  reports

display port information

display system (MaxL) to show available unused ports

display user (MaxL), (1), (2), (3), (4), (5), (6), (7)

display user (MaxL) to show total number of installed ports

display user in group (MaxL)

DISPLAYALIAS command

displaying

  access settings

  active filters

  aliases, (1), (2)

  in Calc Script Editor

  in Formula Editor

  application information, (1), (2), (3)

  application logs

  applications

  available ports, (1), (2)

  changes to outlines

  current users, (1), (2), (3)

  data, (1), (2), (3)

  in targets

  with Data Prep Editor, (1), (2)

  data sources, (1), (2)

  data targets

  database

  information, (1), (2)

  databases

  dimensions

  in Calc Script Editor

  in Formula Editor

  in outlines

  dynamically calculated members, (1), (2)

  field operations

  formulas, (1), (2)

  inactive users

  informational messages, (1), (2), (3)

  linked objects, (1), (2)

  locked data

  locks

  logs, (1), (2), (3)

  member combinations, (1), (2)

  member names in reports

  members in outlines, (1), (2)

  names for generations and levels

  partitions, (1), (2)

  records

  replace operations

  selection/rejection criteria

  Server Agent commands

  server information

  software version

  specific values

  storage information

  text in Outline Editor

  unique values

distributed client-server model defined

distributed databases. See partitioning

distribution (multidimensional models)

dividing

  databases

  fields

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

dividing databases

division

  consolidation codes in data source

  consolidation property

  modulus operations

.DLL files

DLSINGLETHREADPERSTAGE setting

DLTHREADSPREPARE setting

DLTHREADSWRITE setting

Do Not Share option

  dynamic builds and, (1), (2), (3), (4)

DOCS directory, (1), (2), (3)

documentation

  suggested audience

  typographical conventions

documents, linking external

dollar signs ($)

  in array and variable names

dollar values

  converting to US$

double quotation marks (")

  enclosing member names, (1), (2)

  in application and database names

  in dimension and member names

  in ESSCMD commands

  in formulas, (1), (2), (3)

  in header information

  in report scripts

  terms in scripts and formulas, (1), (2)

double slashes (//) in report scripts

downtime

drill

  to display data

drilling across, (1), (2), (3)

  facilitating

drop application (MaxL)

drop database (MaxL)

drop function (MaxL)

drop group (MaxL)

drop location alias (MaxL)

drop user (MaxL)

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

dummy

  parents

  strings

DUMP command (Agent)

DUPGEN. See duplicate generation field type

DUPGENALIAS. See duplicate generation alias field type

DUPLEVEL. See duplicate level field type

DUPLEVELALIAS. See duplicate level alias field type

duplicate

  data

  generations

  members

duplicate generation alias field type

  arranging in rules files

  in header records

  in rules files

  nulls and

duplicate generation field type

  arranging in rules files

  creating shared members

  in header records

  in rules files

  nulls and

duplicate level alias field type

  arranging in rules files

  in header records

  in rules files

  nulls and

duplicate level field type

  arranging in rules files

  in header records

  in rules files

  nulls and

  sharing members

duplicate members

  See also shared members

duplicating

  See also copying; replicating

  data

  data values

  outlines

dynamic builds

  adding new members

  as child of specified parent

  to dimensions with similar members

  to end of dimensions

  arranging fields

  bottom-up ordering, (1), (2), (3)

  creating shared members, (1), (2)

  for different generations, (1), (2)

  for same generation, (1), (2)

  with rule files

  generation references and

  global options

  introduction, (1), (2)

  level references and

  members without specified ancestor

  parent/child references and, (1), (2)

  process summarized

  restrictions

  selecting build method, (1), (2)

  selecting field types for

  top-down ordering, (1), (2)

  validating rules files

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

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

  with rules files

Dynamic Calc And Store members

  adding to calculations

  adding to formulas

  clearing values

  creating

  currency conversions and

  dense dimensions and

  loading data into

  partitioning, (1), (2)

  replicating

  reporting on

  retrieving values

  selecting, (1), (2)

  specifying in data source

  viewing

Dynamic Calc And Store property

  applying, (1), (2), (3)

  described, (1), (2)

  removing

Dynamic Calc members

  adding to calculations

  adding to formulas

  Attribute Calculations dimension

  creating

  currency conversions and

  loading data into

  partitioning, (1), (2), (3)

  replicating, (1), (2)

  reporting on

  retrieving values

  selecting, (1), (2)

  specifying in data source

  viewing

Dynamic Calc property

  and sparse dimensions, (1), (2)

  and two-pass members

  applying, (1), (2), (3)

  in Application Manager

  description

  removing

dynamic calculations

  asymmetric data

  Attribute Calculations dimension

  building, (1), (2)

  restrictions, (1), (2), (3)

  building dimensions with

  calc scripts and, (1), (2)

  choosing members

  guidelines for, (1), (2)

  choosing values, (1), (2)

  guidelines for, (1), (2)

  database design

  defined

  defining order, (1), (2)

  exporting data and

  formulas applied to members

  optimizing retrieval

  partitioned databases

  replicated partitions

  retrieving values, (1), (2), (3), (4)

  transparent partitions

  usage overview, (1), (2), (3)

  viewing application

dynamic calculator cache

  configuration settings

  overview

  sizing, (1), (2), (3)

  summary of activity

  viewing usage information

dynamic dimension building

  adding members to outlines, (1), (2), (3)

  generation references

  level references

dynamic dimensionality

  for separating data into sparse and dense dimensions

  for storing and retrieving data

dynamic dimensions

  level references

dynamic references

  defining header information

  description

  record numbers in

Dynamic Time Series Member Information dialog box

  defining aliases

  enabling/disabling members, (1), (2)

Dynamic Time Series members, (1), (2)

  enabling/disabling, (1), (2)

  generation names for

  in shared areas

  inserting in report scripts

  listed

  reporting on

  selecting

  specifying aliases for


E

E, expense property code in data source

East database

  partitioning

  provided with Hyperion Essbase

Edit Alias dialog box

Edit User dialog box

  modifying access settings

editing

  See also changing

  aliases

  filters

  linked files

  partitions

  report scripts, (1), (2), (3), (4)

  security profiles

  user groups

editors

  calc scripts and

  ESSCMD commands and

  formulas and

  report scripts and

electronic mailboxes

ELSE operator

  usage examples, (1), (2)

ELSE statement

ELSEIF statements

  calc scripts

  formulas, (1), (2)

empty database cells

  caution for storing

empty fields

  adding values to

  blank fields in rules file

  in data source

emptying. See clearing

ENDARCHIVE command

  partitioned applications and

ENDFIX command, (1), (2), (3)

  allocating costs, (1), (2)

  allocating values

  calculating product/market shares

  calculating range of values

  calculating subsets of values

  clearing data blocks

  clearing subsets of values

  copying subsets of values

  currency conversions and

  Intelligent Calculation and, (1), (2), (3)

  optimizing calculations with, (1), (2), (3)

ENDHEADING command

  entering in report scripts

  modifying headings

  usage example

ENDIF statement

  calc scripts

  interdependent formulas in

  member formulas in

  semicolons with

  syntax

  formulas

  purpose of

  semicolons with

  syntax

  usage examples, (1), (2)

ENDLOOP command, (1), (2)

end-of-file markers

end-of-line character, (1), (2)

  ESSCMD commands

  inserting in calc scripts, (1), (2), (3)

  inserting in formulas

Environment Variables list box

environments

  See also UNIX platforms; Windows platforms

.EQD files

equal signs (=)

  in application and database names

  in calc scripts

  in dimension and member names

  in formulas

  in names in scripts and formulas

  in report scripts

equations, (1), (2)

  See also formulas

  cross-dimensional operator and, (1), (2), (3)

  inserting in calc scripts, (1), (2)

  report scripts

.ERR files

.ERR files. See error log files

error codes and numbers

error handling (Hyperion Essbase kernel)

error logs, (1), (2)

  default directory for

  empty

  loading

  maximum number of records in, (1), (2), (3)

  missing

  names and locations

  renaming

  resetting

  record count, (1), (2)

  setting

error message categories

error messages. See application logs, exception logs, and OLAP Server logs.

error-handling commands

errors

  application logs and

  calc scripts

  checking for

  currency conversions

  ESSCMD, (1), (2)

  exception logs and

  fixing for dynamic builds

  formulas and

  formulas and dynamically calculated members

  formulas,checking for

  handling fatal

  loading data, (1), (2)

  locking, (1), (2)

  matching member omitted

  mismatches

  OLAP Server logs and

  partition validation

  pinpointing

  Report Extractor

  restructuring and

  storage allocation

  time-out, (1), (2)

  unknown member

ESBBEGINREPORT function

ESBENDREPORT function

ESBREPORT function

ESBREPORTFILE function

.ESM files, (1), (2), (3)

.ESN files, (1), (2)

.ESR files

Essbase

  architecture

  benefits

  development features described

  displaying software version number

  getting started tips

  guide prerequisites

  parallel login processing

  products summarized

  program files, (1), (2)

  quick reference to menus and dialog boxes

  quitting, (1), (2)

  starting

  starting with quicklogin

Essbase Administration Services

Essbase client. See clients

Essbase Config page (Server Information)

Essbase kernel

  changing settings

Essbase kernel settings

Essbase Server Agent. See Server Agent

Essbase server. See server

Essbase System Login dialog box

ESSBASE.BAK

ESSBASE.CFG, (1), (2), (3)

  dynamic calculator cache settings, (1), (2)

  setting messages added to application logs

  setting messages added to OLAP Server logs

ESSBASE.LOG, (1), (2)

ESSBASE.LOG files

ESSBASE.SEC

  and filters

  backup of

ESSBEGINREPORT function

ESSCMD

  See also specific command

  canceling operations, (1), (2)

  caution for processing commands

  checking structural integrity

  defined

  deleting logs

  entering commands

  error-handling, (1), (2)

  ESTIMATEFULLDBSIZE

  loading update log files

  operational modes

  performance-related commands

  referencing files

  replicating data

  running, (1), (2)

  calc scripts, (1), (2)

  caution for pausing systems and

  in interactive mode

  reports, (1), (2)

  setting

  isolation levels

  substitution variables

  transaction isolation levels

  shutting down server

  specifying

  data compression

  disk volumes

  starting

  prerequisites

  starting applications

  starting databases

  starting/stopping applications

  stopping applications

  stopping databases

  syntax

  updating replicated partitions

  viewing dynamic calculator cache activity

  writing script files

ESSCMD script files

  creating, (1), (2)

  naming

  quotation marks in

  running

  sample

  within operating system batch files

ESSCMD.EXE

ESSENDREPORT function

ESSGBEGINREPORT function

ESSGREPORTFILE function

Essnet library

  connection between Essbase and network

ESSREPORT function

ESSREPORTFILE function

ESSSVR (application server), (1), (2)

ESTIMATEFULLDBSIZE command

Estimating calculations

estimating disk space

  linked reporting objects

estimating time for a calculation

Euro currency symbol

EUROPEAN command

  overriding

  usage

event logs. See logs.

events

Excel spreadsheets. See Spreadsheet Add-in

exception error logs. See exception logs.

Exception Handler

  location of writes

exception logs

  contents described

  example

  names and locations

  overview

  overwriting

  saving

  viewing

EXCEPTIONLOGOVERWRITE setting

exchange rates, (1), (2)

  calculating options

  defining

  sample database

exclamation points (!)

  See also bang command

  in names in scripts and formulas

excluding members from consolidations, (1), (2)

exclusive locks. See Write locks

.EXE files

Execute Calc Scripts dialog box

execute calculation (MaxL), (1), (2)

Execute permission

Existing Members options in dimension build

EXIT command

EXIT command (Agent), (1), (2)

exiting

  See also closing; quitting; stopping

  Essbase

  Partition Wizard

@EXP function

expanding

  alias member lists

  Calc Script Editor lists, (1), (2), (3)

  Formula Editor lists, (1), (2), (3)

  outline hierarchies

expense property, (1), (2)

  specifying in data source

expense vs. non-expense items

exponentiation

exponents

  calculating

export (MaxL), (1), (2)

EXPORT command, (1), (2)

  columnar format

  partitioned applications and

export files

Export Server Alias Table Object dialog box

exported data reloads, (1), (2)

exporting

  alias tables, (1), (2)

  data, (1), (2), (3)

  for backups

  in parallel

  into other forms

  recalculating

  reporting example

  databases larger than 2 GB

  LROs

external data sources

  for loading data, (1), (2), (3), (4)

  linking to cells

  prerequisites for loading

  supported

extraction

  characters ignored

  commands, (1), (2)

  data, (1), (2)

extraction commands

  defined


F

F, first time balance code in data source

@FACTORIAL function

factorials

failures

  calculations

  getting information about

  preventing, (1), (2)

  recovering from, (1), (2), (3)

  suggested procedures

  restructuring and

  transaction rollbacks and

fatal errors

FEEDON command

fetches

Field Edits page (Data File Properties)

field names

  adding prefixes or suffixes to

  assigning to data fields

  changing case

  SQL data sources

  validating

field operations

field ordering for logs

Field Properties dialog box

  adding members, (1), (2)

  adding prefixes and suffixes

  applying case conversions

  converting white space to underscores

  defining columns as fields

  mapping fields

  naming fields

  removing white space

  replacing text strings

  scaling data values

  setting field types

field types

  data sources, (1), (2), (3)

  invalid

  dimension building properties

  dynamically referencing

  restrictions for rules files

  setting for record selection, (1), (2)

  setting member properties, (1), (2)

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

  caution for creating

  specifying, (1), (2)

  valid build methods

fields

  See also columns

  adding prefixes or suffixes to values

  arranging, (1), (2), (3)

  building dynamically, (1), (2)

  changing case

  clearing existing values

  concatenating multiple

  copying, in rules files

  creating

  by splitting

  with joins

  defined

  defining columns as

  defining operations for rules files

  delimiters/separators. See file delimiters

  displaying in Data Prep Editor

  empty

  adding values to

  in data source

  in rules file

  replacing with text

  entering data, (1), (2)

  excluding specific from data loads

  formatting rules, (1), (2), (3)

  in data sources

  invalid

  manipulating in rules files

  mapping

  changing case

  inserting text in empty fields

  replacing text strings

  specific only, (1), (2)

  to member names

  moving

  naming

  position in rules file, (1), (2)

  processing nulls in, (1), (2)

  removing white space in

  reversing values in

  select/reject criteria

  selecting

  setting retrieval specifications, (1), (2)

  size and optimal loads

  undoing operations on

File Delimiter page (Data File Properties)

file delimiters

  customizing

  formatting rules

  in header information

  mapping files

  setting, (1), (2)

file locks, (1), (2)

file system

  backing up databases with

  managing files with

  types on server

file-name extensions

  batch files

  calc scripts

  error logs

  ESSCMD script files

  in ESSCMD

  listed, (1), (2)

  live reporting object files

  outline change files

  report files

  report scripts

  rules files

  temporary files

  text files

files

  See also data files; rules files; text files

  attaching external to cells

  backing up, (1), (2)

  caution for recovery and

  compatibility across platforms

  copying across operating systems

  editing linked

  essential for Essbase

  estimating size

  implementing security for

  importing, (1), (2), (3)

  locating end-of-file markers

  location of sample report scripts

  logging data load errors

  logging dimension builds

  logging outline changes

  opening, (1), (2)

  program, (1), (2)

  referencing in ESSCMD

  referencing using ESSCMD

  renaming with FTP

  restrictions for linking

  restructuring

  running multiple report scripts

  selecting multiple for loading, (1), (2)

  sending report output to

  specifying size for linked, (1), (2)

  storing

  temporary for full restructures

  transferring compatible

  types

  compatibility across platforms

  types described, (1), (2)

  updating log

  with long names

Files page (Database Information)

Filter Access privilege

filters

  and attribute functions

  AND relationship

  assigning

  copying

  creating, (1), (2), (3)

  for partitioned databases

  defined on seperate rows

  defining in Application Manager, (1), (2)

  deleting

  displaying in MaxL

  editing

  in the security (.SEC) file

  inheriting, (1), (2), (3)

  insert into logs with DELIMITEDMSG

  on entire members

  on member combinations

  OR relationship

  overlap conflicts, (1), (2)

  overriding, (1), (2)

  overview, (1), (2)

  removing

  renaming

  restrictions on applying

  saving

  using member set functions

  viewing existing

  write access to database

Filters dialog box

financial applications

  allocating costs

  allocating values, (1), (2)

  calculating product and market share

  comparing actual to budgeted expense, (1), (2)

  containing time-sensitive data

  estimating sales and profits

  example for building

  forecasting values

  getting budgeted data values

  getting variance for actual to budgeted, (1), (2)

  load from different sources

  loading new budget values

financial functions, (1), (2)

  formulas and, (1), (2), (3)

  Intelligent Calculation and

Find dialog box

  Calc Script Editor, (1), (2)

  Formula Editor, (1), (2)

  Report Editor

finding

  end-of-file markers

  members in Calc Script Editor

  members in Formula Editor

  specific values, (1), (2)

  text in formulas

first time balance property

  specifying in data source

first-time calculations

first-time users

FIX/ENDFIX command, (1), (2), (3)

  allocating costs

  allocating values, (1), (2)

  calculating product/market shares

  calculating range of values

  calculating subsets of values

  clearing data blocks

  clearing subsets of values

  copying subsets of values

  currency conversions and

  Intelligent Calculation and, (1), (2), (3)

  optimizing calculations with, (1), (2), (3)

FIXCOLUMNS command

fixed-size overhead, (1), (2)

fixed-width columns

flags (partitions)

flat dimensions, (1), (2)

flat files

  loading

FLAT2SQL.REP

flipping data values

Font dialog box, (1), (2)

fonts, (1), (2)

forecasting values

  examples

  functions, (1), (2)

foreground startup

format

  database outlines

formats

  See also formatting commands

  alias tables

  calculated data, (1), (2)

  columns for data load, (1), (2)

  comments

  data sources, (1), (2), (3), (4)

  overview

  export

  free-form data sources, (1), (2), (3)

  header information

  import specifications and

  linked object restrictions

  member mappings

  report output

  sample report, (1), (2), (3), (4)

  suppressing in reports, (1), (2)

  tab-delimited

formatting commands, (1), (2)

  calculations, (1), (2)

  caution for usage, (1), (2)

  defined

  display options, (1), (2)

  listed

  nesting

  output

  report headings, (1), (2), (3)

formatting styles (documentation)

Formula Editor

  building formulas, (1), (2), (3)

  checking syntax, (1), (2)

  deleting formulas, (1), (2)

  expanding/contracting dimensions

  expanding/contracting member branches

  finding and replacing text

  opening, (1), (2)

  saving formulas

  searching for members

  undoing last action

formula field type

  in header records

  in rules files

  nulls and, (1), (2)

formula limitations and parallel calculation

formulas, (1), (2), (3)

  adding aliases

  adding series to calc scripts

  adding text to

  adding to calc scripts, (1), (2), (3)

  adding to report scripts

  allowing changes

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

  applying to data subsets

  associating with dimensions or members

  calculating twice, (1), (2), (3)

  with Intelligent Calculation, (1), (2)

  calculation mode used

  caution for sparse dimensions

  changing

  complex, (1), (2)

  creating

  examples, (1), (2), (3), (4)

  syntax for

  writing equations

  cross-dimensional operator and

  cross-dimensional references in, (1), (2)

  defined

  deleting

  displaying, (1), (2)

  dynamic calculations and, (1), (2)

  errors in, (1), (2)

  examples

  finding and replacing text in

  grouping in calc scripts, (1), (2), (3)

  in partitioned applications, (1), (2)

  in time and accounts dimensions

  inserting operators

  inserting variables

  Intelligent Calculation and

  names with special characters, (1), (2)

  nesting, (1), (2)

  optimizing

  partitions and

  performance considerations, (1), (2)

  printing

  saving

  setting conditions for, (1), (2)

  shared members and

  simple, (1), (2)

  top-down

  troubleshooting, (1), (2)

  types described

forward calculation references

FoxPro databases. See SQL databases

fragmentation (defined)

fragmentation allowance

free-form

  data load

  data sources

  formatting, (1), (2)

  reports

freeing memory

FTP file transfers

full restructure

  temporary files created

Function Templates dialog box

functions, (1), (2)

  See also specific @function

  allocation

  API

  applying in filter definitions

  applying to subsets

  Boolean

  calc scripts and

  calculation mode

  date and time

  defining multiple members and

  defining partitioned areas with, (1), (2), (3)

  financial calculations with

  forecasting

  formulas and, (1), (2), (3), (4)

  generating member lists, (1), (2)

  Intelligent Calculation and

  mathematical

  member set

  range

  relationship

  report generation

  returning specific values

  statistical

functions, custom-defined

fundamentals

future values, calculating

@GEN function


G

GEN field type. See generation field type

GEN numbers. See generation reference numbers

General page (Database Information)

General page (Database Settings)

Generate Currency Outline button

Generate Currency Outline dialog box

generating

  account reporting values

  member lists, (1), (2), (3)

  reports, (1), (2), (3)

  basic techniques, (1), (2)

  free-form

  with API function calls

Generation and Level Names dialog box

generation field type

  arranging in rules files

  in header records

  in rules files

  null values and

generation names

  adding to report scripts, (1), (2)

  creating, (1), (2)

  displaying

  for Dynamic Time Series members

  static

generation reference numbers

  associating attributes dynamically

  building shared members

  defined

  Dynamic Time Series members, (1), (2)

  entering in rules files

  generating

generation references build method

  creating shared members

  discussion

  guidelines for using

  null processing

  sample rules file, (1), (2)

  shared members

  valid build types

generation references defined

Generation/Level Names page (Dimension Properties)

generations

  checking for

  defined, (1), (2)

  duplicate

  Dynamic Time Series members and, (1), (2), (3)

  levels vs

  naming, (1), (2), (3)

  reversing numerical ordering

  sharing members, (1), (2)

  at multiple

  sorting on

generic passwords

@GENMBRS function

GENREF.RUL

GENREF.TXT

GETALLREPLCELLS command

GETAPPSTATE command

GETATTRIBUTESPECS command

GETATTRINFO command

GETCRDBINFO command

GETDBINFO command, (1), (2), (3)

GETDBSTATS command, (1), (2), (3), (4)

GETMBRCALC command

GETPARTITIONOTLCHANGES command

GETPERFSTATS command

getting started with Essbase

getting started with Hyperion Essbase

GETUPDATEDREPLCELLS command

global

  formatting commands, (1), (2)

global access settings

  applications

  defining

  types listed

global calculation commands

Global ESSBASE.CFG Settings list box

global options (dynamic builds)

global placeholders

Global Properties page (Field Properties)

  adding prefixes and suffixes

  applying case conversions

  converting white space to underscores

  defining columns as fields

  removing white space

  replacing text strings

  scaling data values

  setting ignored values

global replacement

  data load

Global Setting page (Dimension Build Settings)

goal seeking calculations

GOTO command

granularity

greater than signs (>)

  in application and database names

  in names in scripts and formulas

gridlines (Data Prep Editor)

Group Membership dialog box

groups

  assigning filters to

  assigning privileges to

  assigning users to, (1), (2)

  copying security profiles

  creating member, (1), (2)

  creating or copying using MaxL

  creating user, (1), (2)

  creating user with Administration Services

  creating user with Application Manager

  defined, (1), (2)

  defining security, (1), (2), (3)

  deleting

  deleting users

  deleting using MaxL

  deleting with Administration Services

  deleting with Application Manager

  displaying in MaxL, (1), (2), (3), (4), (5), (6)

  displaying membership using MaxL

  editing user information

  formulas and dimensions in calc scripts, (1), (2), (3)

  getting list of

  modifying access settings, (1), (2), (3)

  overriding column

  renaming

  returning valid users, (1), (2)

  security settings

  security types

  selecting members for report

  viewing current settings

@GROWTH function

guest accounts

guidelines

  analyzing database design

.H files


H

handles

handling missing values

  reporting example

handling zero values

hardware platforms

Hash tables

  effects from parallel calculation

hash tables, (1), (2)

Header Definition page (Data Load Settings)

header information

  adding, (1), (2), (3), (4)

  dynamic references

  formatting

header records

  creating, (1), (2)

  defined

  defining load rules

  identifying missing dimensions with

  skipping, (1), (2)

  specifying location of

Header Records page (Data File Properties)

headers. See header information; header records

HEADING command

HEADING1.REP

HEADING2.REP

headings

  See also column headings; field names; row headings

  adding to complex reports, (1), (2)

  adding to free-form reports

  currency conversion

  customizing, (1), (2)

  display options, (1), (2)

  forcing immediate display

  formatting, (1), (2), (3)

  multiple layout reports

  page

  suppressing display

  using attributes in

help

  API functions

  calc scripts

  configuration variables

  configurations

  files

  loading sample applications

  Report Writer commands and definitions

  Server Agent

Help button (Application Desktop)

HELP command (Agent)

hierarchies

  Calc Script Editor

  aliases

  dimensions

  members

  calculation order and

  data

  relationships defined, (1), (2)

  dynamic builds

  Formula Editor

  aliases

  dimensions

  members

  outlines

  expanding/contracting

  unbalanced in outlines

hierarchy

  members

history-to-date calculations

hit ratios, caches

.HLP files

hosts

HP-UX servers. See UNIX platforms

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

HTML files

Hyperion Essbase

  fundamentals

  getting started tips

Hyperion Essbase kernel

  active transactions and failures

  allocating storage

  caches used

  changing settings

  scope and precedence

  with Application Manager

  components

  compressing data

  cross-platform compatibility

  customizing, (1), (2)

  error handling

  linked reporting objects and

  locking procedure

  overview, (1), (2)

  setting isolation levels, (1), (2)

  specifying data compression

  starting

Hyperion Essbase Query Designer

hyphens (-)

  in dimension and member names

  in member names

  in names in scripts and formulas

  in report scripts

I/O access mode

@IALLANCESTORS function

@IANCESTORS function


I

IANCESTORS command

  usage

IBM DB2 relational storage manager

@ICHILDREN function

ICHILDREN command

  usage

  usage example

identical values

identifying data sources

@IDESCENDANTS function, (1), (2)

IDESCENDANTS command

  usage

  usage example

IF/ELSEIF... statements

  calc scripts

  nested statements

  formulas

  nested statements

  purpose of

IF/ENDIF statements

  calc scripts

  interdependent formulas in

  member formulas in

  semicolons with

  syntax

  formulas

  purpose of

  semicolons with

  syntax

  usage examples, (1), (2)

IFERROR command

Ignore Conflicts option

Ignore Tokens page (Data File Properties)

ignoring

  #MISSING and zero values, (1), (2)

  end-of-file markers

  fields when mapping, (1), (2)

  lines in rules files, (1), (2)

  multiple fields in data load

  specific fields in data load

  specific records in data load

@ILSIBLINGS function

immediate restructuring, (1), (2)

IMMHEADING command

implementing security measures

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

  globally

  guidelines for

  partitioned databases, (1), (2)

  planning

  system server, (1), (2), (3)

implied shared relationships, (1), (2), (3)

Import Member Mappings dialog box

Import Server Alias Table Object dialog box

importing

  alias tables, (1), (2)

  data, (1), (2)

  files, (1), (2), (3)

  LROs

  member mappings

improper shutdown

improving performance, (1), (2), (3)

  See also optimizing

  RESETDB

inaccessible applications

inactive users

INCBUILDDIM command

INCEMPTYROWS command

  overriding

  usage

INCFORMATS command

INCMASK command

INCMISSINGROWS command, overriding

inconsistent values

incorrect data values

increase number of threads

increasing performance

incremental data load

Incremental restructuring

  using

incremental restructuring

  disabled

  files

INCRESTRUC parameter

INCZEROROWS command

  overriding

.IND files, (1), (2), (3)

INDENT command

indentation

  turning off

  usage

INDENTGEN command

  usage

  usage example

index

  advantage of small

  checking structural integrity

  defined

  determining optimal size, (1), (2), (3)

  disadvantage of large

  dynamic calculations and

  managing, (1), (2)

  optimizing, (1), (2)

  rebuilding. See restructuring

  removing references to linked files

  restructuring

  retrieving linked reporting objects

  spanning multiple pages

  updating

  usage described

index cache

  as storage unit

  described

  fine-tuning

  managing

  optimizing read/writes

  setting size, (1), (2)

index cache size

  setting with Administration Services, (1), (2)

  setting with Application Manager

index entries

  as pointer to data block

  for data blocks

  managing

index files

  allocating storage for

  associated with current application

  caution for recovery and

  cross-platform compatibility

  defined

  size

  setting maximum

  view in Administration Services

  viewing in Application Manager

Index Manager

  overview

index page

  linked reporting objects and

  managing

index searches

  viewing information about

information dialog boxes

information flow

informational messages, (1), (2), (3)

  application logs and

  OLAP Server logs and

inheritance

  currency categories

  filters, (1), (2), (3)

  privileges, (1), (2)

  properties

initialization process (Hyperion Essbase kernel)

initializing rules files

.INM files, (1), (2)

.INN files, (1), (2)

input blocks

input data, (1), (2)

  reloading exported data

  restructuring and

input/output (I/O)

Insert Arguments option, (1), (2)

inserting text in Calc Script Editor

inserting. See adding

installation information

installer

  security level of

installing multiple agents on a single server

installing Personal Essbase

insufficient privileges

@INT function

integers. See numbers; values

integrity. See data integrity

Intelligent Calculation

  block size and efficiency

  controlling with calc scripts

  currency conversions and, (1), (2), (3)

  default calculations and

  enabling/disabling, (1), (2)

  large indexes and

  limitations, (1), (2)

  overview, (1), (2)

  partial calculations and

  recalculating data and

  restructuring and

  setting as default

  time balance properties and

  turning on/turning off

  two-pass calculations and, (1), (2), (3)

Intelligent Calculation option

interactive mode (ESSCMD)

  canceling operations

  command-line syntax for

  defined

  entering commands

  file-name extensions and

  overview

  running ESSCMD from

interdependent values, (1), (2)

interdimensional irrelevance

@INTEREST function

interest, calculating

interfaces

  accessing linked objects and client

international applications. See locales

international formats, (1), (2)

Interntl database

  changing Scenario dimension in

  contents described

  linking

  opening outline

  provided with Hyperion Essbase

  saving outline changes

INTERNTL sample database

interpolation, with spline

invalid fields in data sources

inventory

  calculating first/last values, (1), (2)

  calculating period-to-date values

  currency categories and

  getting averages

  tracking, (1), (2)

investments

IPARENT command

  usage

@IRDESCENDANTS function

@IRR function

irrelevant data

@IRSIBLINGS function

@ISACCTYPE function

@ISANCEST function

@ISCHILD function

@ISDESC function

@ISDESCENDANTS function

@ISGEN function

@ISIANCEST function

@ISIBLINGS function

@ISICHILD function

@ISIDESC function

@ISIPARENT function

@ISISIBLING function

@ISLEV function

@ISMBR function, (1), (2)

isolation level

  parallel calculation

isolation levels

  calculations and, (1), (2)

  canceling calculations and

  caution for data loads, (1), (2)

  committed and uncommitted access

  locks and, (1), (2), (3), (4)

  rollbacks and, (1), (2)

  setting

  with Application Manager

  with ESSCMD, (1), (2)

  with Hyperion Essbase kernel

  updating

@ISPARENT function

@ISSAMEGEN function

@ISSAMELEV function

@ISSIBLING function

@ISUDA function


J

Java

  Archives, creating

  creating a Java class for CDF

  using for custom-defined functions

Join Fields dialog box

joining fields, (1), (2)

JVM memoryh considerations


K

kernel settings, options


L

L, last time balance code in data source

label members

  See also label only property

  dynamically calculating

label only property

  defining

  description

  specifying in data source

  usage example

labels

  defining

  replacing missing values with, (1), (2)

language support (programming)

languages

  country-specific dimensions, (1), (2)

  requirements for partitioning

large databases, (1), (2), (3)

large-scale reports, (1), (2)

last time balance property

  example

  specifying in data source

LATEST command

latest time period

layout commands, (1), (2)

layouts. See page layouts

.LCK files

leading spaces

leaf members

  defined

  restructuring

leaf nodes

less than signs (<)

  in application and database names

  in dimension and member names

  in names in scripts and formulas, (1), (2)

  in report scripts

@LEV function

Level

  parallel calculation

  setting for parallel calculation

level 0 blocks, (1), (2)

  exporting

  restructuring

level 0 members

  See also leaf members

  calculations on, (1), (2), (3)

  in two-dimensional reports

  required in source data

  storing

level field type

  arranging in rules files

  in header records

  in rules files

  null values in

  sharing members

level names

  adding to report scripts, (1), (2)

  creating, (1), (2)

  displaying

  static

level numbers

  determining for shared members, (1), (2)

  generating

level reference numbers

  associating attributes dynamically

  entering in rules files

level references

  described

  sample rules file for

level references build method

  creating multiple roll-ups

  creating shared members, (1), (2), (3)

  example rules file, (1), (2)

  guidelines for

  null processing

  sample rules file for

  shared members, (1), (2), (3)

  valid field types

LEVEL.RUL

LEVEL.TXT

LEVELMUL.RUL

levels

  checking for

  defined

  naming, (1), (2), (3)

  period-to-date reporting

  sorting on

@LEVMBRS function

.LIB files

libraries

.LIC files

License Info page (Server Information)

licensing, (1), (2)

  getting information for, (1), (2)

  partitioning product suite

licensing ports

line formatting

linear regression, with @TREND function

lines, skipping in rules files, (1), (2)

LINK command

  usage

  usage example

Link Properties dialog box

LINK.REP

linked databases. See linked partitions

linked files

  displaying contents

  editing

  LRO object type

  restrictions

  specifying size, (1), (2)

  storing

linked object catalogs, (1), (2)

Linked Objects Browser

  changing linked partitions

  editing objects, (1), (2)

linked objects. See linked reporting objects (LRO)

linked partitions

  attaching to cells

  changing

  creating, (1), (2), (3), (4), (5)

  defined

  described

  disadvantages

  guidelines for selecting, (1), (2)

  implementing security measures

  mapping members, (1), (2)

  port usage

  testing

linked reporting objects (LRO)

  assigning access levels

  changing member combinations

  checking structural integrity

  creating

  estimating disk space for

  format restrictions

  limiting size using Administration Services

  limiting size using Application Manager

  overview

  removing from cells

  restructuring and

  retrieving

  storage management

  types supported

  viewing, (1), (2)

Linked Reporting Objects dialog box

links

  currency conversions

  linked reporting objects

  missing

  partitioned databases

  related databases, (1), (2)

  supported types

@LIST function

list of members, generating

LISTALIASES command

LISTGROUPS command, (1), (2)

LISTGROUPUSERS command

LISTLINKEDOBJECTS command, (1), (2)

LISTLOCATIONS command

lists

  expanding/contracting in Calc Script Editor, (1), (2), (3)

  expanding/contracting in Formula Editor, (1), (2), (3)

  generating member, (1), (2), (3)

  multiple, with @LIST

  referencing, (1), (2)

LISTUSERS command, (1), (2), (3), (4), (5), (6), (7)

LISUSERS command, (1), (2)

LMARGIN command

@LN function

LOADALIAS command

LOADAPP command

LOADDATA command

  loading data without rules file

  loading free form data

  locating files

LOADDB command, (1), (2)

loading

  alias tables

  applications

  automatically

  with related database

  calc scripts, (1), (2), (3)

  data, (1), (2), (3)

  dynamic calculations and

  for testing purposes

  from external sources, (1), (2), (3), (4)

  from partitioned applications, (1), (2), (3)

  from rules files

  getting information about

  incrementally

  optimizing, (1), (2), (3), (4)

  overview, (1), (2), (3), (4)

  prerequisites, (1), (2)

  restrictions, (1), (2), (3), (4)

  supported formats

  tips, (1), (2)

  troubleshooting problems with

  unauthorized users and

  data sources, (1), (2), (3), (4)

  in Data Prep Editor, (1), (2)

  prerequisites

  troubleshooting problems, (1), (2)

  databases

  automatically

  automatically using Administration Services

  error logs

  failed records only

  output files

  report scripts, (1), (2)

  rules files, (1), (2)

  prerequisites

  sample applications (problems with)

  specific fields only

  specific records

  spreadsheets, (1), (2), (3)

  multiple

  SQL data sources, (1), (2)

  troubleshooting problems with

  subsets of data, (1), (2)

  text files, (1), (2)

  multiple

  update log files

local access

local currency

locales

  See also currency conversions

  dimensions defining, (1), (2)

  partitioned applications and

locating

  end-of-file markers

  members in Calc Script Editor

  members in Formula Editor

  specific values, (1), (2)

  text in formulas

location aliases

  advantages

  creating using MaxL

  displaying using MaxL

  editing or deleting

Location Aliases dialog box

locationi aliases

  deleting using MaxL

lock files

Lock Manager

  overview

Lock Partition Definition Files option

Locking Blocks during calculation

locking caches into memory

locking errors, (1), (2)

locks

  applying, (1), (2), (3), (4)

  committed access and, (1), (2)

  contention

  displaying

  generating reports and

  loading data

  managing

  maximum time to hold

  partition definition files

  removing, (1), (2), (3), (4)

  automatically

  setting for new users, (1), (2), (3)

  time-out settings

  types described

  uncommitted access and

  wait intervals

.LOG files, (1), (2), (3)

@LOG function

log delimiter choices

log files

  spreadsheet changes

log files. See logs.

Log Viewer

  checking calculations

  displaying

  dynamically calculated members

  retrieval factor

@LOG10 function

logarithms

  calculating, (1), (2)

  calculating exponents

logical conditions, (1), (2)

  See also Boolean expressions

login

  parallel processing

LOGIN command, (1), (2)

login scripts (ESSCMD)

logins

  entering user name and password

  limiting attempts

  partitioned applications

  process overview

  setting up

LOGMESSAGELEVEL setting

logouts

  forced using MaxL statement

  from Application Manager, (1), (2)

  from Server Agent

LOGOUTUSER command (Agent)

logs

  calc scripts

  calc scripts and

  captures failing

  clearing contents

  creating multiple exception logs

  data load errors

  deleting

  deleting contents

  deleting in Application Manager

  dimension builds

  dynamically calculated members

  OLAP Server

  outline changes, (1), (2)

  overview

  restructuring and

  updating

  Server Agent activity

  server-specific

  system errors, (1), (2), (3)

  updating

  viewing

  viewing contents, (1), (2), (3)

  viewing retrieval factor

long file names

LOOP/ENDLOOP command, (1), (2)

loops

losing connections

loss, tracking

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

LRO catalog

.LRO files, (1), (2), (3)

LRO Manager

  overview

LRO. See linked reporting objects (LRO)

LROs

  exporting using MaxL

  importing using MaxL

@LSIBLINGS function

.LST files


M

M, time balance codes in data source

macros, custom-defined

Main Database (defined)

main window

  Application Manager

  Application Services

maintaining applications

maintaining data integrity

maintenance tasks

  backing up data

  managing applications and databases

  porting applications across platforms

  running Essbase

mapping

  area-specific partitions, (1), (2), (3)

  in Partition Wizard

  attributes

  cells

  columns with no members

  data source/data target members

  linked partitions, (1), (2)

  replicated partitions, (1), (2), (3)

  transparent partitions, (1), (2)

  databases with location aliases

  fields to dimensions

  files (.TXT)

  member fields to outlines

  members

  members to member fields, (1), (2), (3)

  members with different names

  partitioned members

  partitions

  defining manually, (1), (2)

  replicated partitions

  specific fields only, (1), (2)

  transparent partitions

Mappings page (Partition Wizard)

  defining linked mappings

  defining replicated mappings

  defining transparent mappings

margin (profit)

margins

market share (calculation example)

marketing sample reports

marking blocks as clean and dirty, (1), (2)

markup

MASK command

  entering in report scripts, (1), (2)

  overriding

  usage

masks, (1), (2)

@MATCH function

Match Whole Word option

  Formula Editor

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

matching members, (1), (2)

mathematical calculations

mathematical functions, (1), (2)

mathematical operations

  currency conversions

  formulas and

  missing values and

  performing on fields

  performing on members

  prerequisite for

  report scripts, (1), (2)

  specifying in data source

mathematical operators, (1), (2)

  inserting in calc scripts

  inserting in formulas

matrix-style access

@MAX function

Max member, Attribute Calculations dimension

maximum number of threads spawned by Agent

MaxL

  creating custom-defined macro

  deleting logs, (1), (2)

  drop function records

  error detection

  exporting LROs

  importing LROs

  register custom-defined function

  registering custom-defined functions

  running

  calculations

  running calc scripts

  shutting down server

  specifying isolation level settings

  starting a database

  starting a database automatically

  starting/stopping applications

  starting/stopping databases

  updating replicated partitions

Maxl

MAXLOGIN

  limit number of simultaneous user sessions

  limit number of user sessions

@MAXRANGE function

@MAXS function

@MAXSRANGE function

@MDALLOCATE function

@MDANCESTVAL function

.MDB files

@MDPARENTVAL function

@MDSHIFT function

.MDX files

Measures dimension (example)

  calculating period-to-date values

  changing for currency conversions

media failure

@MEDIAN function

median, calculating

@MEMBER function

member codes

  property tags

  specifying

member consolidation properties

  described

  setting, (1), (2)

member descriptions (in Hyperion MBA). See alias tables

member fields

  defined in data source

  duplicate members and

  entering data

  formatting

  formatting rules

  in data source

  invalid

  mapping requirements, (1), (2), (3)

member lists

  calculating subset of

  generating, (1), (2), (3)

  referencing, (1), (2)

member names

  case sensitivity

  maximum length

Member Properties dialog box

  creating aliases, (1), (2)

  creating UDAs

  defining data storage properties

  renaming members

  setting consolidation properties

  setting two-pass calculations

  setting variance reporting tags

  tagging for Dynamic Calculations

  tagging members as label only

member properties display option

member selection

  commands

  sorting members and

  in spreadsheets

Member Selection dialog box

  defining linked areas, (1), (2)

  defining replicated areas, (1), (2)

  defining transparent areas, (1), (2)

  mapping partitioned members, (1), (2), (3)

member set functions, (1), (2)

  applying to subsets of members

  described

  generating lists

  in filter definitions

  inserting in formulas

  withing FIX command

Member Specification dialog box

  creating dynamically calculated members, (1), (2)

members

  See also shared members

  adding, (1), (2)

  as children of specified parent

  as siblings, (1), (2)

  example for, (1), (2)

  for currency conversions, (1), (2)

  guidelines for

  restrictions for

  through header information in the data source

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

  to member fields, (1), (2)

  to outlines, (1), (2)

  adding comments about

  adding to report scripts, (1), (2)

  in precise combinations

  with common attributes

  applying skip properties

  assigning

  alias combinations

  aliases to, (1), (2)

  properties to, (1), (2)

  values to combinations

  assigning aliases to

  associating base dimension members with attributes

  in Outline Editor

  associating formulas with

  associating with report scripts

  Attribute Calculations dimension

  attribute dimensions

  naming

  prefixes and suffixes

  preventing creation

  resulting from formulas

  avoiding naming conflicts

  calculating across multiple parents

  calculating relationships between

  caution for sorting with shared

  changing

  changing combinations for linked objects

  changing properties

  clearing

  containing no data

  creating dynamic for time series, (1), (2)

  data distribution among

  default operator

  defined, (1), (2)

  defining calculation order for, (1), (2)

  defining consolidations for, (1), (2)

  deleting from attribute dimensions

  dependent on others

  displaying

  combinations, (1), (2)

  in outlines, (1), (2)

  in reports

  duplicate

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

  dynamically calculating, (1), (2)

  restrictions

  excluding from consolidation, (1), (2)

  getting values for specific combinations

  grouping, (1), (2)

  in data hierarchies

  inserting in calc scripts, (1), (2)

  inserting in formulas

  irrelevant across dimensions

  leaving unsorted

  mapping names to dimensions

  matching specified, (1), (2)

  missing in data sources, (1), (2)

  moving in outlines

  moving to new parents

  names as range of values, (1), (2), (3)

  naming, (1), (2), (3)

  maximum character length

  nesting in reports

  numbering in data sources

  of attribute dimensions

  sorting

  ordering in dense dimensions

  partitioning

  relationships described, (1), (2)

  removing from data sources

  renaming

  replicating, (1), (2)

  report example for missing

  searching in the Calc Script Editor

  searching in the Formula Editor

  selecting for dynamic calculations, guidelines for, (1), (2)

  selecting multiple

  sharing identical values

  sorting, (1), (2)

  sorting in reports

  specifying as case-sensitive

  storing

  testing for

  unique combinations for

  unspecified

  with no data values

  with non-changing names

member-specific formatting commands

memory, (1), (2)

  checking available

  clearing, (1), (2), (3)

  dynamically calculated values and, (1), (2)

  estimating requirements

  index cache size and

  index size and, (1), (2)

  locking caches into memory

  setting cache size, (1), (2)

  first-time calculations

  setting cache sizes

  shortage

  storing data

  swapping

memory buffers, (1), (2)

Memory Cache Locking

  with Administration Services

menus

  typographic conventions

@MERGE function

merging member lists

messages

  displaying for calculations, (1), (2), (3)

  example for displaying

metadata

metadata (in Hyperion MBA). See outlines

MIDDLE.REP

migrating

  applications across servers

  databases across servers

migration

@MIN function

Min member, Attribute Calculations dimension

minimizing resources

Minimum Database Access options (Application Settings)

Minimum Database Access options (Database Settings)

@MINRANGE function

@MINS function

@MINSRANGE function

minus signs (-)

  as codes in data source

  in data fields

  in dimension and member names

  in member names

  in names in scripts and formulas

  in report scripts

miscellaneous text

mismatches

MISS_LBL.REP

MISSING displayed in cells

missing links

missing members, (1), (2)

missing values

  adding place holder for

  aggregating

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

  averages and

  calculating, (1), (2), (3)

  caution for data loads and

  caution for dimension fields

  definition

  formatting in reports

  handling, (1), (2), (3)

  identifying in data fields

  in calculations

  inserting into empty fields

  optimal entry for

  overriding default for

  replacing with labels

  reporting samples, (1), (2)

  skipping, (1), (2)

  sorting data with

  testing for

  viewing with Personal Essbase

MISSINGTEXT command

  usage

  usage example

mission-critical databases

@MOD function

@MODE function

mode, calculating

Modifications page (Database Information)

Modify Outline option

  caution for disabling

modifying

  See also editing

  access privileges, (1), (2), (3)

  alias table names

  aliases

  calc scripts, (1), (2)

  consolidations

  data, (1), (2), (3)

  prerequisite for

  data values

  default storage properties

  dimension names

  dimension properties, (1), (2), (3), (4)

  dimensions

  default configurations

  for currency conversions

  formulas, (1), (2)

  headings in reports

  Hyperion Essbase kernel settings

  scope and precedence

  with Application Manager

  linked partitions

  member combinations for linked objects

  member names

  members

  outlines, (1), (2), (3)

  caution for, (1), (2), (3)

  dynamically

  for currency conversions

  with rules files

  passwords, (1), (2)

  report layouts

  security settings

  security settings with Administration Services

  security settings with Application Manager

  system password

modulus, calculating

monitoring

  applications, (1), (2)

  calculations, (1), (2)

Monitoring applications

Monitoring parallel calculation

month-to-date calculations. See M-T-D calculations.

@MOVAVG function

Move Field dialog box

moving

  fields

  members and dimensions

  members to new parents

moving average, calculating

moving between databases, (1), (2)

moving maximum, calculating

moving median, calculating

moving minimum, calculating

@MOVMAX function

@MOVMED function

@MOVMIN function

MS Access databases. See SQL databases

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

multidimensional arrays

multidimensional models

  conceptual overview

  data distribution in

  operations not supported

  storage requirements

multidimensional structure

  organizing

multi-line column headings

multiple

  layout report

  partitions

  transactions

multiple agents

  installing on a single server

multiple export files for databases

multiple-pass calculations, (1), (2), (3)

  examples, (1), (2)

  usage overview

multiplication

  setting data consolidation properties

multiplication operators

multithreading, (1), (2)

  setting number of threads

multi-user environments

  performance considerations

  running ESSCMD in


N

N, never allow data sharing code in data source

@NAME function

Named Pipes connections

names

  See also column headings; field names; aliases

NAMESCOL command

NAMESON command

NAMEWIDTH command

naming

  arrays and variables

  batch files

  calc script files, (1), (2)

  dimensions, (1), (2), (3)

  ESSCMD script files

  fields

  filters

  generations, (1), (2), (3)

  levels, (1), (2), (3)

  members, (1), (2), (3), (4)

  members of attribute dimensions

  rules files

  shared members

naming conflicts, (1), (2)

naming conventions

  aliases, (1), (2)

  applications, (1), (2)

  case sensitivity, (1), (2)

  databases, (1), (2)

  dimensions

  fields

  generations and levels

  members, (1), (2)

  passwords

  report files

  rules files

  UNIX files

natural logarithms

  calculating

  calculating exponents

navigating between databases, (1), (2)

negative numbers, formatting in reports, (1), (2)

negative values

  flipping

  in data fields

  variance as

nesting

  column headings

  columns in reports

  dimensions

  formatting commands

  formulas, (1), (2)

  IF statements, (1), (2)

  members in reports

  quotation marks in ESSCMD commands

net present values

network administrators. See administrators

networks

  optimizing resources, (1), (2)

  reducing traffic during data load

  securing

  transferring data via, (1), (2)

never share property

  description

  setting in data source

Never Share tag

New button (Application Manager)

New Group dialog box

new line

  as command separator

  as file delimiter

New User dialog box

new users

NEWPAGE command

@NEXT function

@NEXTS function

no access

No Conversion property

  currency conversions and

no loads

#NOACCESS value

node

  See also branches; trees

NOINDENTGEN command

  usage

  usage example

non expense property, (1), (2)

non-attribute dimension

  See standard dimension

None access level, (1), (2), (3)

None Currency Conversion property

none time balance property

non-typical data sets

NOROWREPEAT command

NOSKIPONDIMENSION command

NOT operator, (1), (2)

Note dialog box, (1), (2), (3)

notes

  adding to databases

  adding to partitions, (1), (2), (3)

  annotating to data cells

  display options

  storing

  viewing in Application Manager

no-wait I/O

.NP files

@NPV function

null values

  level references build method

  null processing

numbering

  columns in reports

  members in data sources

  report pages

numbers

  calc scripts and

  calculated columns

  formatting, (1), (2)

  formulas and

  in array and variable names

  in names

  in source data fields

  options for loading, (1), (2)

  rounding, (1), (2)

  truncating

numeric

  attribute dimensions

  sorting members in outline

  tagging

  attributes

  defined

  defining member names in ranges

  duplicate values

  size of ranges

  fields

  with commas

  fields in data source

  parameters

  entering in ESSCMD scripts

numeric parameters

Numeric Range Rules dialog box

numerical ordering (generations)

NUMERICPRECISION setting


O

O, label only code in data source

object handles

object references

objects

  See also linked reporting objects

  copying

  creating filters for

  deleting

  linking to cells

  locking, (1), (2)

  overview

  renaming

  unlocking

.OCL files

  clearing

.OCN files

.OCO files

ODBC drivers

ODBC files

OFFCOLCALCS command

OFFROWCALCS command

OFSAMEGEN command

  usage

OLAP

  fundamentals

  getting started tips

  history

OLAP Server

  defined

  deleting logs

  viewing logs

OLAP Server logs

  contents described

  deleting

  deleting on restart

  delimiters

  disk space and

  example

  message categories

  overview

  setting messages logged

  viewing

.OLB files, (1), (2)

.OLG files, (1), (2)

OLTP vs OLAP

ONCOLCALCS command

Online Analytical Processing. See OLAP

Online Transaction Processing. See OLTP

ONLY parameter for SET MSG

ONROWCALCS command

ONSAMELEVELAS command

  usage

Open button (Application Manager)

Open Client Data Files dialog box

  opening data sources

  opening spreadsheets, (1), (2)

  opening text files

  updating dimensions

Open Client Object dialog box

  selecting calc script files

Open Server Data File Object dialog box

  opening data sources

  opening spreadsheets, (1), (2)

  opening text files

  updating dimensions

Open Server Object dialog box

  opening report scripts

  selecting calc script files

open tasks

opening

  applications

  Calc Script Editor

  calc script files, (1), (2)

  Data Prep Editor, (1), (2)

  data sources

  databases

  Formula Editor, (1), (2)

  outlines

  caution for

  Partition Manager

  Report Editor

  report script files, (1), (2)

  rules files, (1), (2)

  sample applications (problems with)

  spreadsheets, (1), (2)

  SQL data sources, (1), (2)

  text files

operating system

  information, (1), (2)

  multithreaded

  recovery

operations

  See also transactions

  automating routine

  canceling

  archiving

  calculations

  canceling ESSCMD, (1), (2)

  causing corruption, (1), (2)

  displaying field

  displaying replace

  failed

  maintaining data integrity for

  missing values and mathematical

  restructure types defined

  undoing, (1), (2)

  viewing information about, (1), (2)

operators

  See also specific operator

  calc scripts and, (1), (2)

  consolidation listed

  creating Boolean expressions with

  cross-dimensional, (1), (2), (3)

  inserting in calc scripts

  inserting in formulas, (1), (2)

  overview, (1), (2)

  usage examples, (1), (2)

  default for members

  display options

  formulas and, (1), (2), (3), (4)

  inserting in formulas

  mathematical, (1), (2)

  calc scripts

  formulas

  order of precedence

  resetting in report scripts

  unary, (1), (2)

  usage overview, (1), (2)

optimization

  basic tasks

  RESETDB

optimizing

  access, (1), (2)

  caches

  calculator cache, (1), (2)

  calculations, (1), (2), (3)

  with bottom-up calcs

  with calc scripts

  with dynamic calculations, (1), (2)

  with Intelligent Calculation

  with interdependent values

  with two-pass calculations

  data analysis

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

  data manipulation

  data sources, (1), (2)

  disk read/writes, (1), (2)

  indexes, (1), (2)

  loading of sparse dimensions

  network resources, (1), (2)

  outlines, (1), (2)

  performance, (1), (2), (3), (4), (5)

  queries, (1), (2)

  readability

  replication

  reports, (1), (2), (3)

  restructures, (1), (2)

  retrieval, (1), (2)

  sparse dimensions

  storage

  transparent partitions

Optimizing Hyperion Essbase

optimizing performance

  cross-dimensional operator

optional parameters

options

  See also display options

  application access

  application security settings

  calculations, (1), (2)

  dimension builds

  dimension updates

  dynamic builds, (1), (2)

  Essbase kernel

  generating currency outlines

  global access, (1), (2)

  Hyperion Essbase kernel, (1), (2)

  isolation levels

  level and generation numbering

  password management

  restructuring outlines

  saving partition definitions

  setting up rules files

  viewing

  currently set installation

  linked reporting objects

OR operator

  select/reject criteria, (1), (2)

Oracle databases. See SQL databases

ORDER command

  usage example, (1), (2)

ORDERBY command

  entering in report scripts, (1), (2)

  precedence

  usage

  usage example

ORDERBY.REP

ordering

  cells in blocks

  data blocks

  data values, (1), (2)

  example

  dimensions in outlines

  fields, (1), (2)

  members in dense dimensions

  members in outlines, (1), (2)

  output values

ordinary user permission, (1), (2)

organizational databases

organizing data (tutorial)

.OTL files, (1), (2)

.OTM files

.OTN files, (1), (2)

.OTO files

OUTALT command

OUTALTMBR command

  entering in report scripts

  usage

OUTALTNAMES command

  entering in report scripts

  usage

  usage example

OUTALTSELECT command

  usage

outline

  attribute prefixes and suffixes

Outline button (Application Manager)

outline calculation

outline change logs

  contents described

  example

  overview

  restructuring and

  setting size

  updating

  viewing

outline design

  attribute dimensions

  performance considerations, (1), (2)

Outline Editor

  adding comments

  adding dimensions

  applying time balance tags

  associating attribute dimensions with base dimensions

  associating base dimension members with attributes

  Attribute Calculations dimension

  changes and restructuring impact

  components

  enabling/disabling

  creating

  aliases

  aliases for member combinations

  dynamically calculated members

  shared members

  UDAs

  creating dynamically calculated members

  creating outlines

  customizing, (1), (2)

  defining

  accounts dimension type

  attribute dimension type

  attributes

  country dimension type

  data storage properties

  dimension type

  time dimension type

  defining dimension type

  Currency Partition

  removing dynamically calculated members

  renaming dimensions and members

  selecting multiple members

  setting consolidation properties

  setting two-pass calculations

  setting variance reporting tags

  starting

  tagging members as label only

  updating dimensions

  viewing outline members

outline files

  copying, (1), (2), (3)

  creating

  cross-platform compatibility

  saving

outline synchronization

  described

  shared members

Outline Synchronization Editor

Outline Update dialog box

OUTLINECHANGELOG parameter

OUTLINECHANGELOG setting

OUTLINECHANGELOGFILESIZE setting

outline-only restructure

outlines

  accessing

  adding alias tables, (1), (2)

  adding dimensions, (1), (2), (3), (4)

  performance considerations, (1), (2)

  restructuring and

  adding members, (1), (2)

  applying changes, (1), (2)

  associating

  calc scripts with

  member fields with

  rules files with, (1), (2), (3), (4)

  associating filters with

  bottom-up ordering

  changes impacting restructuring

  changing, (1), (2), (3)

  caution for, (1), (2), (3)

  dynamically

  with rules files

  controlling location of

  copying

  with Application Manager

  copying in file system

  copying with Administration Services

  copying with Application Manager

  creating, (1), (2)

  example for

  for currency conversions, (1), (2), (3)

  from data sources

  guidelines for

  prerequisites for

  with Outline Editor, (1), (2)

  creating formulas for

  customizing view

  defined, (1), (2), (3)

  drafting for single-server databases

  expanding/contracting

  format

  hierarchical arrangement

  improving readability

  member relationships described, (1), (2)

  modifying for currency conversions

  naming

  dimensions and members

  generations and levels

  opening existing

  caution for

  optimizing, (1), (2)

  optimum order of dimensions

  ordering dimensions

  ordering members, (1), (2)

  purpose

  rearranging members and dimensions

  removing

  removing items, (1), (2)

  renaming

  repeating elements

  restructuring

  prerequisites for

  rules

  saving, (1), (2)

  caution for

  description

  instructions

  sharing members, (1), (2), (3)

  caution for placing

  sparse-dense recommendations

  synchronizing, (1), (2)

  process summarized, (1), (2)

  warning for not applying changes

  with Application Manager

  with Partition Wizard

  with report scripts

  top-down ordering

  tracking changes

  updating, (1), (2)

  verifying, (1), (2)

  viewing

  changes to

  dimensions in

  dynamically calculated members

  update information

  with unbalanced hierarchies

OUTMBRALT command

OUTMBRNAMES command

output

  displaying in columns

  formatting

  options

  ordering

  reporting example

  security information

  selecting specific values for

  sorting

OUTPUT command

output files

  See also log files

  loading

  saving

overhead, (1), (2), (3)

  checking compression ratio

overlapping partitions

overriding

  column groupings in reports

  data filters, (1), (2)

  default calculation order

  default calculations

  file locks

  incremental restructuring

  security and permissions

overwriting error logs

overwriting existing values

  for currency conversions

  with values in data source, (1), (2)

ownership

.PAG files, (1), (2), (3)


P

page breaks

  in report scripts

  suppressing, (1), (2)

PAGE command

  entering in report scripts

  in page layout

  usage example

page files

  See also data files

page headings

  adding to complex reports

  adding to free-form reports

  customizing, (1), (2)

  defined

  display options

  forcing immediate display

  suppressing

  using attributes in

page layout commands, (1), (2)

page layouts

  See also reports

  adding titles

  centering data, (1), (2)

  example

  changing

  customizing, (1), (2)

  examples, (1), (2)

  formatting, (1), (2), (3), (4)

  problems with

  formatting samples, (1), (2), (3), (4)

  inserting page breaks, (1), (2)

  numbering pages

  switching row/column display

PAGEHEADING command

PAGELENGTH command

  overriding

  usage

PAGEONDIMENSION command

  usage

  usage example

.PAN files, (1), (2)

Paraellel calculation

  effect on hash tables

paralle calculation

  enabling in calculation script

Parallel calculation

  analysis of feasibility

  and UNCOMMITTED requirement

  checking status

  commit threshold adjustments

  effect on bitmpa cache

  enabling

  feasibility analysis

  increased speed

  introduction

  levels

  monitoring performance

  partition limitations

  procedure for enabling

  requirements for use

  serial vs. parallel

  setting levels

parallel calculation

  and calculator cache

  and other Essbase fetaures

  calculator hash tables

  checking current settings

  commit threshold adjustments

  definition

  enabling

  formula limitations

  identifying additional tasks

  identifying tasks.

  isolation level

  monitoring

  overview

  requirements

  restructuring limitations

  retrieval performance

  transparent partition limitations

  uncommitted mode

parallel processing

  data load

  login

parameters

  enclosure in quotation marks (ESSCMD)

  entering in ESSCMD scripts

  referencing files

PARCHIL.RUL

PARCHIL.TXT

@PARENT function

parent

  defined

PARENT command

  usage

parent field type

  in header records

  in rules files

  sharing members, (1), (2), (3)

parent/child references build method

  creating multiple roll-ups

  creating shared members, (1), (2), (3)

  creating shared roll-ups from multiple data sources

  described

  example rules file

  guidelines for using

  sharing members, (1), (2), (3)

  valid field types

parent/child relationships

  data sources

  defining

  dynamic calculations and, (1), (2), (3)

parent-child relationships

parentheses

  in calc scripts

  in dimension and member names

  in formulas

  in report scripts, (1), (2)

  indicating negative numeric values in fields

parents

  as shared members

  assigning children to, (1), (2), (3)

  associating members with

  calculation order for outlines

  calculations with multiple

  checking for

  getting, (1), (2)

  in time dimensions

  loading data into

  rolling up, (1), (2)

  setting values as average

  sharing members

  specifying for existing members

  with only one child

@PARENTVAL function, (1), (2)

PAREXPORT command, (1), (2)

partial loads

  invalid members

  value out of range

Partition

  limitiations with parallel calculation

partition areas

  changing shared

  defined

  defining, (1), (2), (3)

  Dynamic Time Series members in

  mapping to specific, (1), (2), (3)

  in Partition Wizard

partition definition files

  creating

  locking

Partition Information dialog box

Partition Manager

  changing links

  creating partitions, (1), (2), (3), (4)

  defining partitioned areas

  replicated partitions, (1), (2)

  transparent partitions, (1), (2)

  editing partitions

  opening

partition size, disk volumes

Partition Wizard

  closing

  defining area-specific mappings

  defining partitioned areas, (1), (2), (3)

  described

  editing partitions

  mapping linked members, (1), (2)

  mapping partitioned members

  mapping replicated members, (1), (2), (3)

  mapping transparent members, (1), (2)

  saving partition definition

  validating partitions

partitioned applications

  accessing data

  adding members

  calculating

  transparent

  connecting to, (1), (2), (3)

  creating, process summarized

  described

  designing, (1), (2), (3)

  scenarios for, (1), (2), (3)

  disadvantages of

  examples of

  language requirements

  loading data, (1), (2), (3)

  performing calculations on

  replicated partitions and

  transparent partitions and, (1), (2), (3), (4)

  retrieving data

  running calc scripts

  single-server vs.

  troubleshooting access to

  types of

  updating, (1), (2), (3), (4)

  guidelines

  remote data and

  viewing current state

partitioned databases

  accessing, (1), (2), (3)

  adding partitions for currency conversions, (1), (2)

  calculating

  transparent

  creating accounts for, (1), (2), (3)

  described

  dynamically calculating values

  filtering, (1), (2)

  implementing security measures, (1), (2)

  linking data values

  maintaining

  restructuring, (1), (2)

  sample applications showing

  sharing data, (1), (2), (3)

  storing data, (1), (2)

  sparse member combinations and

  with replicated partitions

  with transparent partitions

  synchronizing data across partitions

  synchronizing outlines, (1), (2)

  with Partition Wizard

  testing, (1), (2)

  time series reporting

  troubleshooting connections

  workflow

partitioning

  mapping attributes

  using attributes in, (1), (2)

partitioning product suite

  licensing

Partitions

partitions

  See also partitioned applications; partitioned databases, areas

  advantages

  annotating, (1), (2), (3)

  calculating

  transparent

  controlling updates to

  creating, (1), (2), (3), (4), (5)

  for currency conversions, (1), (2)

  process summarized

  defined

  defining, (1), (2), (3)

  linked, (1), (2)

  multiple

  replicated, (1), (2)

  transparent, (1), (2)

  with Partition Wizard, (1), (2), (3), (4)

  deleting

  discarding changes to

  dynamic calculations and, (1), (2)

  editing

  getting type

  mapping guidelines, (1), (2)

  mapping members

  overlapping

  parts described

  performance

  improving

  port usage, (1), (2), (3)

  primary/secondary sites defined

  restructuring performance and

  saving definitions

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

  in Partition Wizard, (1), (2), (3), (4)

  top-down vs. bottom-up

  troubleshooting

  usage examples

  replicated partitions

  transparent partitions

  using attributes in

  validating

  viewing currently defined, (1), (2)

PASSWORD command

Password Management options (Server Settings)

passwords

  assigning generic

  changing system

  changing with Administration Services

  changing with Application Manager

  connections

  entering in logins

  forcing users to change, (1), (2), (3)

  in partitions

  masking, (1), (2)

  setting

  new users, (1), (2)

  partitioned databases

pasting

  calc scripts into Calc Script Editor

  formulas into Formula Editor

  text into calc scripts

  text into formulas

path information

pattern matching, (1), (2)

payroll

percent signs (%)

  as codes in data source

  in names in scripts and formulas

  in report scripts

percentages

  allocating

  calculating, (1), (2)

  displaying in reports, (1), (2)

  returning variance, (1), (2), (3)

  setting consolidation properties

  specifying in data source

Performance

  example of complex formula effects

  increase with periodic tasks

  monitoring parallel calculation

  replacing cross-dimensional operator on left side of equation

performance

  calculation

  checking, (1), (2)

  getting information about, (1), (2)

  improvement techniques

  linked partitions and, (1), (2)

  multi-user considerations, (1), (2)

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

  recommended settings

  replicated partitions and

  transparent partitions and

performance statistics

  caches

performance-related storage settings, (1), (2)

  scope

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

periods (.)

  in application and database names

period-to-date calculations

period-to-date values

  calculating, (1), (2)

  retrieving

permission

  assigning/reassigning user

  setting database

  Supervisor

permissions

  Application Designer

  Application or Database designer

  application-level settings

  Calculate (or execute)

  Create/Delete Applications

  Create/Delete Users/Groups

  database

  Database Designer

  designer

  linked reporting objects

  ordinary user (no access)

  Read

  routine operations and

  scope of

  Supervisor

  user types

  Write

Personal Essbase

  copying data to

  prerequisites

  copying outlines to, (1), (2)

  creating applications and databases

  installing

  loading data

  loading output files

  viewing data

PIDs, finding for Hyperion Essbase applications

pivoting

.PL files

platforms

  porting applications across, (1), (2)

  creating backups for

  redefining information for

  porting applications to UNIX servers

plus signs (+)

  as codes in data source

  in application and database names

  in dimension and member names

  in member names

  in names in scripts and formulas, (1), (2)

.PM files

pointers

  data blocks

  member combinations

  shared data values, (1), (2)

populating replicated partitions

porting applications, (1), (2)

  creating backups for

  redefining server information

  to UNIX platforms

ports

  and linked partitions

  and replicated partitions

  and transparent partitions

  changing default values used by Agent

  displaying available

  displaying installed

  displaying list of available, (1), (2)

  freeing

  licensed and multithreading

  protocol-specific assignments

  reserved

  running out of

PORTS command

  usage overview

PORTS command (Agent)

positive values

  variance as

pound sign (#) in array and variable names

@POWER function

power down (caution)

power failures. See failures; recovery

power loss

precedence

  calculations

Precendence

  parallel calculation setting

precision

predefined Dynamic Time Series members

  enabling/disabling, (1), (2)

  generation names for

  in shared areas

  listed

  specifying aliases for

predefined routines, (1), (2)

prefixes

  adding to fields

  assignment sequence in data build

  attribute member names, (1), (2), (3)

  member and alias names

Pre-image Access option

preventing calculation delays

preventing system failures, (1), (2)

primary roll-ups, (1), (2), (3)

Print Calc Script dialog box

printed documentation

  suggested audience

  typographical conventions

printing

  calc scripts

  formulas

  reports, (1), (2)

PRINTPARTITIONDEFFILE command

PRINTROW command

@PRIOR function, (1), (2)

@PRIORS function

privileges

  applying to groups

  assigning

  global

  to users and groups

  assignment examples, (1), (2)

  changing, (1), (2), (3)

  inheritance from group

  inheriting, (1), (2)

  insufficient

  layers defined

  linked reporting objects

  planning for user access

  replicating

  setting filters and, (1), (2)

  transactions and, (1), (2)

  types listed, (1), (2)

procedural commands

Procedure

  parallel calculation

process IDs, finding for Hyperion Essbase applications

processes

  monitoring

processing requests

processors

  calculations across multiple

  running multiple concurrently

product and market shares

Product dimension example

product version

profit and loss, (1), (2)

  example for tracking

profit margins

  dynamically calculating

program files, (1), (2)

programming interface. See API (Application Programming Interface)

programming-specific files

propagating outline changes. See synchronizing

properties

  changing dynamically, (1), (2), (3), (4)

  consolidation, (1), (2), (3)

  currency conversion

  data storage, (1), (2)

  defining

  caution for two-pass tags

  for dimensions, (1), (2)

  for members, (1), (2)

  defining for dimensions, (1), (2)

  defining for members, (1), (2)

  as label only, (1), (2)

  design checklist for

  dimension building

  field types

  dynamic calculations

  setting dynamically

  shared member, (1), (2)

  time balance

  Time Series

  two-pass calculations

  variance reporting, (1), (2)

properties bar (Outline Editor)

properties in outlines

property field type

  in header records

  in rules files

  nulls and, (1), (2)

  specifying in data source

protecting data

  See also security

@PTD function, (1), (2), (3)

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

PURGELINKEDOBJECTS command, (1), (2)

PURGEOTLCHANGEFILE command

purging logs

PUTALLREPLCELLS command

PUTUPDATEDREPLCELLS command

PYRAMIDHEADERS command, (1), (2)


Q

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

quarterly values

quarter-to-date calculations

  example

queries

  optimizing performance

  saving

query

  as client function

query governors

query limits

question marks (?)

  in application and database names

  used as wildcard

quicklogin

QUIT command (Agent), (1), (2)

quitting

  See also closing; exiting; stopping

  Essbase, (1), (2)

  Partition Wizard

quotation marks, double (")

  and ESSCMD commands

  enclosing member names, (1), (2), (3)

  in application and database names

  in calc scripts

  in dimension and member names

  in formulas, (1), (2)

  in report scripts

  in scripts and formulas, (1), (2)

quotation marks, single (')

  in application and database names

  in dimension and member names

QUOTEMBRNAMES command

@RANGE function


R

range functions, (1), (2), (3), (4)

  formulas and

range of values

  calculating

  copying

  data exceeding

  duplicate members in

  member names as, (1), (2), (3)

  optimizing data loads with

  reading multiple

  report member selection, (1), (2)

  setting automatically

ranges

  numeric

  caution regarding inserting new values

  dimension building summary

  numeric attributes, (1), (2)

  automatic building

  building multilevel (example)

  different sizes

@RANK function

ranking values

raw data sources

  viewing

@RDESCENDANTS function

Read locks

  described

  with committed access

  with uncommitted access

Read Only privilege

Read permission

Read privilege, (1), (2)

Read/Write privilege

read-only mode

  backups and

reads

  getting number of

  optimizing

read-write mode

  backups and

rearranging fields, (1), (2)

reboot (caution)

rebuilding databases

recalculating data, (1), (2), (3), (4)

  after exporting

  Dynamic Calc And Store members

  examples

  for Personal Essbase servers

  in sparse dimensions, (1), (2)

  Intelligent Calculation and, (1), (2)

  two-pass calculations and

reconfiguring dimensions

Record View Count dialog box

records

  See also rows

  adding to data sources, (1), (2), (3)

  as headers in rules files, (1), (2)

  bottom-up ordering and

  defined

  defining operations for rules files

  defining roll-ups for, (1), (2), (3)

  in data source

  loading specific range

  maximum logged, setting

  missing from error logs, (1), (2)

  rejecting for loads

  reloading failed

  selecting, (1), (2), (3)

  setting parent/child relationships

  sorting to optimize data loading

  top-down ordering and

  types in data sources

  viewing, (1), (2)

  with extra fields

recovery

  calculations not completing

  caution for loading data and

  failed operations

  improper shutdowns

  managing

  procedures

  redundant data and

  restructuring databases

  server crashing, (1), (2), (3)

  suggested procedures

redefining server information

reducing database size

reducing network traffic

redundant data, (1), (2)

references

  caution for

  data values, (1), (2), (3)

  dynamic, (1), (2)

  record numbers in

  dynamically calculated members

  filters and updating

  forward calculation

  generation

  null processing

  sample rules file, (1), (2)

  shared members

  level

  example rules file, (1), (2)

  null processing

  sample rules file

  shared members, (1), (2), (3)

  linked files

  lists, (1), (2)

  objects

  parent/child

  example rules file

  sharing members, (1), (2), (3)

  specific values

referencing files with ESSCMD

refresh replicated partition (MaxL)

refreshes

  data

  dialog boxes

Region dimension example

registration

  of custom-defined functions

Reject Record dialog box

rejection criteria

  defining multiple for single field

  defining on multiple fields

  example

  locating end-of-file markers with

  specifying in rules file, (1), (2)

relational databases. See databases

relational storage manager

relationship among members, (1), (2), (3), (4)

  report example for missing

relationship functions

  formulas and, (1), (2)

  Intelligent Calculation and

@RELATIVE function

reloading database files

reloading exported data, (1), (2)

@REMAINDER function

remainders

remote locations

  accessing

  manipulating data

  retrieving data, (1), (2), (3)

remote partitions. See transparent partitions

remote shutdowns

@REMOVE function

Remove Unspecified option

REMOVECOLCALCS command

  entering in report scripts

  usage

REMOVELOCKS command

removing

  See also clearing

  aliases

  applications

  calc scripts, (1), (2)

  contents from alias tables

  data blocks

  databases

  dimensions

  restructuring and

  filters

  formulas

  items from outlines, (1), (2)

  linked objects

  locks, (1), (2), (3), (4)

  automatically

  logs

  logs in Application Manager

  members from data sources

  members from member lists

  objects

  partitions

  substitution variables

  temporary files

  text in calc scripts

  text in formulas

  text in report scripts

  user groups with Administration Services

  user groups with Application Manager

  user locks

  users, (1), (2)

  white space in fields

Rename Alias Table dialog box

rename application

  Administration Services

Rename Application dialog box, (1), (2)

RENAME command

rename database

  Administration Services

Rename Database dialog box

Rename Filter dialog box

Rename Group dialog box

Rename Object dialog box

Rename User dialog box

RENAMEDB command

RENAMEFILTER command

RENAMEUSER command

renaming

  alias tables

  applications

  databases

  dimensions

  error logs

  files with FTP

  filters

  members

  objects

  users and groups

renumbering data blocks

.REP files, (1), (2)

Replace dialog box

replace operations

replacing

  empty fields with values

  files from backups

  missing values with text, (1), (2)

  text in formulas

  text strings

replicated partitions

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

  defined

  disadvantages

  dynamically calculated values in

  example of

  guidelines for selecting, (1), (2)

  implementing security measures

  improving performance

  mapping members, (1), (2), (3)

  by importing

  port usage

  updating data, (1), (2), (3)

  guidelines

  usage restrictions

replicating

  partial data sets

  problems with

Replication Properties dialog box

REPORT command

Report Editor

  creating scripts

  described

  editing scripts, (1), (2), (3)

  opening

  running report scripts

  specifying output destinations, (1), (2)

  text editing commands

Report Extractor

  associating members with dimensions

  described

  errors

  extracting data

  extraction order

  generating free-form reports

  ignored characters

  internal numerical comparisons

report files

  creating

  naming

report formatting

  commands, (1), (2)

report formatting commands

  calculations, (1), (2)

  caution for usage, (1), (2)

  defined

  display options, (1), (2)

  listed

  nesting

  output

  report headings, (1), (2), (3)

  types described

report generation functions

report output commands

Report Output Options dialog box

  described

  opening

Report Script button (Application Manager)

report script examples

  adding aliases, (1), (2)

  calculations, (1), (2), (3)

  changing data combinations

  creating asymmetric columns

  customizing page layouts, (1), (2)

  formatting layouts, (1), (2), (3), (4)

  grouping rows

  handling missing values

  narrowing member selection

  nesting columns

  ordering data

  restricting data retrieval

  sorting data values, (1), (2), (3)

report script files

  adding scripts

  default location

  location of sample

  naming

  opening, (1), (2)

report scripts

  See also reports

  adding comments

  adding conditions, (1), (2)

  examples, (1), (2), (3)

  adding members, (1), (2)

  adding variables, (1), (2), (3), (4)

  associating members with

  batch files and

  caution for aliases in

  caution for non-changing names in

  copying

  in file system

  creating, (1), (2)

  basic techniques, (1), (2)

  parts described

  creating with Application Manager

  currency conversions and

  defined

  defining page layouts, (1), (2), (3)

  editing, (1), (2), (3), (4)

  exporting data with

  formatting

  calculated values, (1), (2)

  report layouts, (1), (2), (3)

  reports

  formatting calculated values

  inserting

  equations in

  formulas in

  inserting UDAs

  loading, (1), (2)

  names with special characters, (1), (2)

  naming restrictions

  ordering data values, (1), (2), (3)

  resetting operators

  run in batch mode

  running

  basic techniques, (1), (2), (3)

  examples

  in ESSCMD

  single line only

  with Application Manager

  running with Application Manager

  saving

  selecting members

  with common attributes

  selecting members for column groups

  selecting precise member combinations

  sorting members

  suppressing shared member selection

  synchronizing outlines with

  unlocking

  using attribute members

  wildcards in

Report Viewer

Report Writer

  See also report scripts

  commands described

  creating text files, (1), (2)

  main components

  online help

  optimizing retrieval, (1), (2)

reporting objects (linked)

  assigning access levels

  changing member combinations

  checking structural integrity

  creating

  estimating disk space for

  format restrictions

  limiting size

  overview

  removing from cells

  restructuring and

  retrieving

  storage management

  types supported

  viewing, (1), (2)

REPORTLINE command

reports

  See also time series reporting

  ad hoc currency

  adding blank spaces

  adding calculated columns, (1), (2)

  adding headings, (1), (2), (3)

  adding page breaks, (1), (2)

  adding titles

  adjusting column length

  associating with databases

  basic techniques

  building, (1), (2), (3)

  basic techniques, (1), (2)

  with API function calls

  calculating currency conversions

  changing

  headings in columns

  layouts

  clearing values in calculated columns, (1), (2)

  creating two-dimensional, (1), (2)

  customizing page layouts, (1), (2)

  examples, (1), (2)

  defining multiple layouts

  designing, (1), (2), (3)

  designing headings

  developing free-form

  displaying member names

  dynamically calculated values and

  eliminating data duplication

  improving readability

  numbering columns

  optimizing, (1), (2), (3)

  ordering output values

  printing, (1), (2)

  problems with formatting

  repeating column/row headings, (1), (2)

  replacing missing values

  restricting data retrieval, (1), (2)

  example

  retrieving data values

  setting maximum rows allowed

  with conditions, (1), (2)

  saving, (1), (2)

  setting up output destinations, (1), (2)

  suppressing formatting in, (1), (2)

  terminating

  updating

  variance reporting examples

repositories

REPTKBYTESORTBUF setting

requests, (1), (2)

  Dynamic Calculations and

  partitioned applications

  processing

  processing as server function

  terminate specific requests using MaxL

  terminating using Application Manager

Requirements

  parallel calculation use

reserved names

reserved words, (1), (2)

RESETDB to improve performance

RESETOTLCHANGETIME command

RESETSTATUS command

resources

  checking usage

  minimizing

  optimizing network, (1), (2)

  partitioning databases and, (1), (2)

restarting system

restoring databases from backups

restoring security settings

RESTRICT command

  entering in report scripts, (1), (2)

  NUMERICPRECISION parameter

  usage

  usage example

RESTRICT.REP

Restructure Database dialog box, (1), (2)

restructure operations

  incremental

  optimizing, (1), (2)

  outline changes impacting

restructuring

  attribute dimensions

  data blocks, (1), (2)

  data files, (1), (2)

  databases, (1), (2)

  changing outlines and, (1), (2)

  dynamic calculations and

  immediately, (1), (2)

  Intelligent Calculation and, (1), (2)

  process described

  indexes

  linked reporting objects and

  outlines

  prerequisites for

  partitioned databases, (1), (2)

  recovery and, (1), (2)

restructuring conflicts

restructuring limitations with parallel calculation

retrieval buffer

  sizing with MaxL

Retrieval Buffer Size option

retrieval buffers, (1), (2), (3)

retrieval factor

  displaying

retrieval performance and parallel calculation

Retrieval Sort Buffer Size option

  Administration Services

  in Application Manager

retrieval time

  reducing

Retrieval Wizard

retrieving

  cross-database values

  data blocks, (1), (2), (3)

  data values for reports

  placing restrictions on, (1), (2), (3)

  setting maximum rows allowed

  with conditions, (1), (2), (3), (4)

  data values from remote databases, (1), (2), (3)

  Dynamic Time Series members

  dynamically calculated values, (1), (2), (3), (4)

  linked reporting objects

  member combinations

  partition type

  period-to-date values

  specific values, (1), (2)

  unique values

  values for sparse dimensions

reversing data values

RLE data compression

  described

  specifying

rollbacks

  after application shutdown

  after database shutdown

  after server shutdown

  outlines

rolling average values

rolling back transactions. See recovery

roll-ups

  See also consolidation

  building multiple

  examples, (1), (2), (3)

  implementing

  maximum number in records, (1), (2)

  member consolidation and

  multiple data sources

  optimizing

  ordering in rules files

  setting for time balance properties

  shared members, (1), (2)

root member, defined

@ROUND function

rounding, (1), (2)

routine operations

routines, (1), (2)

row calculation commands

ROW command

  entering in report scripts

  usage example

row headings

  adding to reports

  defined

  names truncated

  repeating

  suppressing

ROWAVG.REP

ROWCALC1.REP

ROWCALC2.REP

ROWGROUP.REP

ROWREPEAT command

  entering in report scripts

  usage

  usage examples

rows

  See also records

  attributes in report scripts

  calculating totals

  calculation sample reports, (1), (2), (3)

  formatting

  empty values in

  missing values in

  with different member names

  grouping in reports

  in data sources

  restrictions on retrieval

  setting qualifications for retrieval, (1), (2), (3)

  setting transactions levels

  switching with columns

.RPT files

@RSIBLINGS function

.RUL files

  See also rules files

rules

  creating aliases

  creating shared members

  data entry in member fields

  data load

  creating

  when to use

  data loads

  defining attribute dimensions

  defining attributes

  defining dimension type, (1), (2)

  dimension builds

  formatting data sources, (1), (2), (3), (4)

  formatting free-form data sources, (1), (2)

  replicated partitions

  replicating

  data

  transparent partitions, (1), (2)

  UDAs

rules files

  adding members with, (1), (2)

  associating

  with data sources

  with outlines, (1), (2), (3), (4)

  associating aliases with attributes

  attribute associations

  bottom-up ordering, (1), (2)

  building dimensions, (1), (2), (3), (4)

  building shared members

  different generation, (1), (2)

  same generation, (1), (2)

  with branches, (1), (2)

  changing field names

  copying

  copying in file system

  creating, (1), (2)

  process overview

  creating new fields

  cross-platform compatibility

  for dimension builds

  generation references and, (1), (2), (3)

  header records and, (1), (2)

  initializing

  invalid

  level references and, (1), (2), (3), (4)

  loading, (1), (2)

  prerequisites

  logging load errors

  manipulating fields in

  naming

  opening

  optimizing usage

  options for setting up

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

  position of fields, (1), (2)

  replacing text strings

  restrictions for entering field types

  saving, (1), (2), (3)

  setting global options

  specifying field types

  SQL data sources and, (1), (2)

  top-down ordering

  usage overview, (1), (2), (3), (4)

  validating, (1), (2), (3)

  troubleshooting problems with

  with blank fields

Run button (Application Manager)

RUNCALC command

Run-Length Encoding. See RLE data compression

running

  batch files, (1), (2)

  calc scripts, (1), (2), (3), (4)

  on partitioned applications

  calc scripts with Application Manager

  currency conversions, (1), (2), (3)

  ESSCMD, (1), (2)

  caution for pausing systems while

  in interactive mode

  multiple report script files

  report scripts

  basic techniques, (1), (2), (3)

  examples

  in ESSCMD

  single line only

  with Application Manager

  report scripts with Application Manager

RUNREPT command

run-time information

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


S

salary databases, (1), (2)

sales

  allocating percentages for

  estimating profits

  period-to-date values

  reporting

  sample for market selection

  sample for percentages

  samples for actual, (1), (2)

  year-to-date and rolling averages

Sampeast application

  partitioning examples

  replicated partitions in, (1), (2)

  transparent partitions in

Sampeast East database

  provided with Hyperion Essbase

Sample application

  creating simple reports

  currency conversion databases

Sample Basic database

  batch mode processes

  consolidation example

  creating calc scripts

  creating formulas for outlines

  creating outlines for

  defining calculations for, (1), (2)

  actual values

  allocating values, (1), (2)

  allocating values across one dimension

  data subsets

  forecasting future values

  forward references and

  increasing budgets

  percentage of variance

  product and market share

  sales and profit

  shared members in

  specific cells, (1), (2), (3), (4)

  dense dimensions in, (1), (2), (3)

  dynamically calculating data

  generating reports

  header and mapping information in

  Intelligent Calculations on, (1), (2), (3)

  loading new budget values

  optimal dimension configurations

  optimizing calculations in, (1), (2), (3), (4)

  partitioning examples, (1), (2), (3), (4)

  provided with Hyperion Essbase

  report calculations in

  report formatting examples, (1), (2), (3)

  sample reports

  selecting members for reports, (1), (2)

  sorting example

  sparse dimensions in, (1), (2), (3)

  two-pass calculations in

Sample database

  INTERNTL

  XCHGRATE

sample databases

SAMPLE directory

sample ESSCMD script files

sample questions

sample reports

  adding aliases, (1), (2)

  changing data combinations

  creating asymmetric columns

  customizing page layouts, (1), (2)

  formatting layouts, (1), (2), (3), (4)

  grouping rows

  handling missing values

  narrowing member selection

  nesting columns

  ordering data

  restricting data retrieval

  sorting data values, (1), (2), (3)

  using attributes, (1), (2)

  using attributes in member selection

sample script files

Samppart application

  partitioning examples

  replicated partitions in, (1), (2)

  transparent partitions in

Samppart Company database

  provided with Hyperion Essbase

@SANCESTVAL function

Save As command

Save Client Object dialog box

  saving calc scripts, (1), (2)

Save Server Object dialog box

  copying outlines

  saving calc scripts, (1), (2), (3)

  saving rules files, (1), (2)

SAVEANDOUTPUT command

SAVEROW command

  restrictions

  usage

  usage example

saving

  attachments

  calc scripts, (1), (2), (3)

  on client workstations, (1), (2)

  filters

  formulas

  outline files

  outlines, (1), (2), (3), (4)

  caution for

  output files

  partition definitions

  report scripts

  reports, (1), (2)

  rules files, (1), (2), (3)

  security profiles, (1), (2), (3)

scalability

scaling data values

schedule report scripts to run in batch mode

scope

  checklist for analyzing

  determining

scopeEssbase kernel settings

.SCR files, (1), (2)

script files. See ESSCMD script files

scripts. See calc scripts; report scripts

searches

  case-sensitive, (1), (2), (3), (4), (5)

  large indexes and

  members in Calc Script Editor

  members in Formula Editor

  returning specific values, (1), (2)

  sequential

  text

  in calc scripts

  in formulas

  viewing information about index

season-to-date calculations

.SEC files, (1), (2), (3)

secondary fields, (1), (2)

secondary roll-ups, (1), (2), (3)

Security

  designing and building a system

security, (1), (2)

  See also access; filters; privileges

  access levels listed, (1), (2), (3)

  application-level settings

  backup files

  changing for users and groups

  changing for users and groups with Administration Services

  changing for users and groups with Application Manager

  checking information about

  custom-defined functions

  disconnect session or request

  for applications and databases

  implementing, (1), (2)

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

  globally

  guidelines for

  system server, (1), (2), (3)

  information file

  layers defined

  linked reporting objects

  managing, (1), (2), (3)

  for large number of users

  modifying user access settings

  planning for

  profiles

  copying, (1), (2)

  creating

  deleting users and groups

  editing

  saving, (1), (2), (3)

  sample solutions, (1), (2)

  saving information to ASCII files

  setting up for partitioned databases, (1), (2)

security definitions

security file

  backup of

  contents of

  cross-platform compatibility

  filter storage

  restoring

Security System

  See also security

security types

  Create/Delete Users/Groups

  defined

  ordinary

.SEL files, (1), (2)

SELECT command, (1), (2), (3)

select criteria. See selection criteria

Select Database dialog box

Select Record dialog box

Select Server, Application and Database dialog box

select statements. See SQL databases

selecting

  alias tables, (1), (2)

  applications for loading

  with ESSCMD

  build methods, (1), (2)

  calc script files, (1), (2)

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

  using Windows

  data targets

  data to partition, (1), (2), (3)

  databases for loading

  with ESSCMD

  dimension storage type, (1), (2), (3)

  dimension type

  guidelines for

  fields

  members for dynamic calculations

  guidelines for, (1), (2)

  members for report scripts, (1), (2), (3)

  from Dynamic Time Series

  with ATTRIBUTE command

  with Boolean operators

  with conditions

  with substitution variables

  with TODATE command

  with user-defined attributes

  with wildcards

  with WITHATTR command

  members, for column groupings

  multiple dimensions and members

  multiple files, (1), (2)

  multiple members

  partition type, (1), (2), (3), (4), (5)

  in Partition Wizard, (1), (2), (3), (4)

  records, (1), (2), (3)

  report script files, (1), (2)

  SQL data sources

  values for dynamic calculations, (1), (2)

  guidelines for, (1), (2)

selection criteria

  defining multiple for single field

  defining on multiple fields

  specifying in rules file

semantic errors, (1), (2)

semicolons (;)

  in application and database names

  in calc scripts, (1), (2), (3), (4)

  in ESSCMD syntax

  in formulas, (1), (2), (3)

  in names in scripts and formulas, (1), (2)

separators

  See also file delimiters

  commas in numbers

  member lists

  report script commands, (1), (2)

sequential searches

Serial calculation

  introduction

server

  AGTSVRCONNECTIONS

  application startup

  caution for improper shutdown

  caution for rebooting

  changing system password for

  client requests and, (1), (2), (3)

  client/server model described

  communicating with clients

  connecting to. See connections

  crashes, recovering from, (1), (2), (3)

  suggested procedures

  cross-platform compatibility

  disconnecting users

  displaying

  access settings

  current users, (1), (2), (3)

  ports

  displaying version number

  Essbase components

  functionality described, (1), (2)

  getting information about, (1), (2)

  initial connection and disconnection

  interruptions

  loading data from

  logging errors

  logging out of, (1), (2)

  logging out users

  moving data sources to

  parallel calculation level

  partitioning databases across multiple

  redefining information

  restrictions

  securing, (1), (2), (3)

  SERVERTHREADS

  setting internal buffer

  shutting down, (1), (2)

  simultaneous access by multiple users

  simultaneous updates by multiple users

  starting

  system supervisor defined

  terminating requests

  unavailable, (1), (2)

  writing calc scripts to

Server Agent

  See also server console

  accessing

  activity recording

  as traffic coordinator

  defined

  displaying available commands

  handling requests

  monitoring applications

  multiple installations on a single server

  overview client-server communications, (1), (2)

  running as background process

  setting number of threads

server applications. See client-server applications

server console

  remote shutdowns

  shutting down server, (1), (2)

  starting applications

  starting databases

  starting Essbase server

  stopping applications, (1), (2)

  multiple simultaneously

  stopping databases

server errors

server event logs. See OLAP Server logs.

Server Information dialog box

server interface

server logs. See OLAP Server logs.

server requirements

  multithreaded operating system

Server Settings dialog box

  auto logoff

  password management

SERVERTHREADS setting

sessions

  terminate user's session using MaxL

  terminating using Application Manager

SET AGGMISSG command

  and allocating costs

  and member combinations

  described, (1), (2)

SET CACHE command

SET CALCHASHTBL

  and parallel calculation

SET CALCHASHTBL command, (1), (2)

  performance considerations and

set calcparallel

SET CALCTASKDIMS

SET CLEARUPDATESTATUS command

  calculating subsets with

  concurrent calculations and

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

  multi-pass calculations, (1), (2)

  parameters listed

  two-pass calculations

Set Current Alias Table dialog box

Set Database Note dialog box

Set Default Calc dialog box

SET FRMLBOTTOMUP command, (1), (2)

Set isolation level to uncommitted

set isolation level to uncommitted

  Administration Services

SET LOCKBLOCK command, (1), (2)

SET MSG calculation script command

SET MSG command

SET MSG DETAIL command

SET MSG ONLY

SET MSG SUMMARY command

  usage example

SET NOTICE command, (1), (2), (3)

SET UPDATECALC command, (1), (2)

SET UPDATECALC OFF command

SET UPTOLOCAL command

SETALIAS command

SETAPPSTATE command

SETCENTER command

SETDBSTATE command

  changing data compression

  precedence, (1), (2)

  running in batch mode

  setting

  index page size, (1), (2)

  specifying data compression

SETDBSTATEITEM command

  aggregating missing values, (1), (2), (3)

  changing data compression

  increasing retrieval buffer

  precedence, (1), (2)

  running in batch mode

  scope of storage settings

  setting

  retrieval buffer size, (1), (2)

  transaction isolation levels, (1), (2), (3)

  specifying

  data compression

  disk volumes, (1), (2)

SETDEFAULTCALCFILE command

SETPASSWORD command

SETROWOP command

  entering in report scripts

  usage

setting

  See also assigning; defining; applying

  attribute types

  cache size, (1), (2)

  first-time calculations

  cache sizes

  conditions in formulas, (1), (2)

  configurable variables

  consolidation properties, (1), (2)

  data cache size

  data file cache size

  default calculations, (1), (2), (3), (4)

  delimiters

  dimension and member properties

  file delimiters, (1), (2), (3)

  fonts and typefaces

  global options, (1), (2)

  index cache size

  internal server buffer

  maximum records logged

  member consolidation properties

  messages in application logs

  messages in OLAP Server logs

  outline change log size

  passwords and user names

  new users, (1), (2)

  overview

  partitioned databases

  properties dynamically

  report output destinations, (1), (2)

  retrieval buffer size, (1), (2)

  for data sorts

  transaction isolation levels

  with ESSCMD, (1), (2)

setting the number of threads for server

shared areas. See partition areas

shared library files

shared locks. See Read locks

shared member property, (1), (2)

shared members

  adding to outlines, (1), (2), (3)

  caution for placing

  affect on consolidation paths

  at different generations

  building dynamically, (1), (2)

  at same generation, (1), (2)

  building dynamically, (1), (2)

  building dynamically, (1), (2), (3), (4)

  calculating, (1), (2)

  caution for sorting

  creating, (1), (2), (3), (4)

  for different generations, (1), (2)

  for same generation, (1), (2)

  guidelines for, (1), (2)

  with Outline Editor

  with rules files

  described

  design approach for attributes

  different generations

  getting

  guidelines, (1), (2)

  implicit, (1), (2), (3)

  linked reporting objects and

  parent/child

  most versatile build method

  partitioned applications and, (1), (2)

  properties

  relationship implied

  reorganizing

  rolling up

  same generation

  sample rules files

  generation references

  level references, (1), (2), (3)

  parent/child references, (1), (2), (3)

  suppressing for report generation

  with branches

  building dynamically, (1), (2)

  with outline synchcronization

shared partition areas

shared roll-ups

sharing data, (1), (2)

  across multiple sites, (1), (2)

  in partitioned databases, (1), (2), (3)

  never allow property, (1), (2), (3)

  not allowing

sharing members. See shared members

sheets. See Spreadsheet Add-in; spreadsheets

shell scripts (UNIX)

SHGENREF.RUL

SHGENREF.TXT

@SHIFT function

@SHIFTMINUS function

@SHIFTPLUS function

SHLEV.RUL

SHLEV.TXT

Show Warnings option, (1), (2)

shutdown (caution for improper)

SHUTDOWNSERVER command

shutting down server

  from ESSCMD

  from MaxL

  from Server Agent

sibling

  defined

@SIBLINGS function

siblings

  adding as members, (1), (2)

  calculation order in outlines

  checking for

  consolidation properties and

  dimensions as

  getting

  members as, (1), (2)

  rolling up

SIBLOW.RUL

SIBLOW.TXT

SIBPAR.TXT

SIBSTR.RUL

SIBSTR.TXT

Sign Flip option

Simple application

  adding standard dimension to outline

  adding stored members to outline

  changing outline

  creating

  organizing data

  removing a dimension from outline

simple formulas, (1), (2)

simple interest

simulated calculation

simulating calculations

single quotation marks (')

  in application and database names

  in dimension and member names

single-server applications

  adding dimensions, (1), (2)

  analyzing data, (1), (2)

  analyzing database scope, (1), (2)

  creating outlines

  defining calculations, (1), (2), (3)

  designing, (1), (2)

  identifying data sources

  implementing security

  partitioned vs.

  planning process, (1), (2)

size

  array variables

  data blocks

  controlling

  data files, setting maximum size

  determining cache

  estimating database, (1), (2), (3)

  factors determining for database

  field and optimal loads

  getting information on cache

  index files, setting maximum size

  linked files, (1), (2)

  minimizing for linked objects

  optimizing index, (1), (2)

  outline change logs

  planning for optimal

  reducing database

  setting cache, (1), (2)

  first-time calculations

  setting data cache

  setting data file cache

  setting index cache

  setting limits for linked objects

  setting retrieval buffer, (1), (2)

  for data sorts

sizing

  dynamic calculator cache

skip #MISSING and/or zero values in a range

SKIP command

  usage

  usage example

Skip Missing property

skip next #MISSING and/or zero values

skip properties

Skip Zeros property

SKIPONDIMENSION command

skipping

  #MISSING and zero values, (1), (2)

  fields when mapping, (1), (2)

  lines in rules files, (1), (2)

  multiple fields in data load

  records in data load

  specific fields in data load

.SL files

slashes (/)

  as codes in data source

  in application and database names

  in names in scripts and formulas, (1), (2)

slicing

  defined

  for different perspectives

@SLN function

smoothing data

SMP (symmetric multiprocessing), (1), (2)

.SO files

software version

Solaris servers. See UNIX platforms

Sort Descending command

sort order

  defining

  members in outline

  output

SORTALTNAMES command

SORTASC command

SORTDESC command

SORTGEN command

sorting

  data for reports, (1), (2), (3)

  examples, (1), (2), (3)

  data with missing values

  dimensions and members, (1), (2)

  members in reports

  records to optimize data loading

sorting commands, (1), (2)

SORTLEVEL command

  usage

  usage example

SORTMBRNAMES command

  precedence in sorts

  usage

SORTNONE command

source data

  changing case

source outline (defined)

space. See white space

spaces

  in application and database names

  in dimension and member names

@SPARENTVAL function

SPARSE command

sparse dimensions

  See also dense dimensions; dimensions

  calculating values in, (1), (2), (3), (4)

  defined

  defining member combinations for, (1), (2)

  Dynamic Calc, (1), (2)

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

  formulas and

  grouping member combinations

  implications for restructuring and, (1), (2)

  Intelligent Calculation and

  location in outline, (1), (2)

  marked as clean

  optimizing, (1), (2)

  optimizing loading

  partitioning

  recalculating values in, (1), (2)

  reporting on

  returning values for

  selecting

  selection scenarios, (1), (2)

  setting

  storing

  storing member combinations

  unique member combinations

  vs dense dimensions

sparse restructure

specifying port increment with PORTINC

specifying port values

  AGENTPORT

  SERVERPORTBEGIN and SERVERPORTEND

Specifying settings

  isolation levels with MaxL

speed up. See optimizing

@SPLINE function

spline, calculating

split dimensions

Split Field dialog box

splitting

  databases, (1), (2)

  fields

Spreadsheet Add-in

  ad hoc currency reporting

  as Essbase client

  defined

  getting Dynamic Time Series members

  linked partitions and, (1), (2)

  linked reporting objects and, (1), (2)

  maintaining data integrity

  optimizing retrieval, (1), (2)

  running calc scripts

  specifying latest time period

  viewing database information

spreadsheet files

spreadsheets

  data source

  default locations

  loading, (1), (2), (3)

  multiple

  logging updates

  opening, (1), (2)

  supported for data loading

SQL databases

  batch mode example

  data source

  field names in

  loading, (1), (2)

  troubleshooting problems with

  opening, (1), (2)

  troubleshooting connections

SQL select statements

SSAUDIT parameter

SSAUDITR parameter

SSLUNKNOWN setting

stages of data loading

standard deviation, calculating

standard dimensions

  attribute formulas on

  comparison with attribute dimensions

  defining in dimension build

  described

START command (Agent), (1), (2)

start database

  Administration Services

start value

  ranges in numeric attributes

STARTHEADING command

  entering in report scripts

  usage

  usage example

starting

  application server

  applications

  databases

  ESSCMD

  prerequisites

  Hyperion Essbase kernel

  Outline Editor

  server

startup commands

startup information, (1), (2)

startup settings

  restoring

statement terminator, (1), (2)

  ESSCMD commands

  in report scripts

  inserting in calc scripts, (1), (2), (3)

  inserting in formulas

statements

  calc scripts and, (1), (2), (3), (4)

  formulas and, (1), (2)

static member names

statistical calculations

  generating with calc scripts

statistical functions

statistical variance, calculating

statistics

  checking cache

Statistics page (Database Information)

Statistics tab (Database Information)

Status

  checking parallel calculation

status

  current calculation state

  data loads, (1), (2)

  partitioned applications

  viewing database information

  viewing server information, (1), (2)

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

@STDEV function

@STDEVP function

@STDEVRANGE function

STOP command (Agent), (1), (2), (3)

stopping

  See also closing; exiting; quitting

  applications, (1), (2)

  before backup

  with related database in Administration Services

  with related database in Application Manager

  calculations

  data loads

  databases, (1), (2)

  server, (1), (2)

stopping applications (MaxL)

storage

  See also Hyperion Essbase kernel

  allocating disk space, (1), (2)

  example

  bitmap compression option

  checking disk space

  data blocks and, (1), (2), (3)

  data compression

  data files

  data values, (1), (2)

  deallocation and, (1), (2)

  default properties

  dynamically calculated values, (1), (2)

  with attributes

  fine-tuning

  index files

  inefficient data blocks

  internal structures optimizing

  linked reporting objects, (1), (2), (3)

  local

  multiple applications

  optimizing

  partitioned databases, (1), (2)

  sparse member combinations and

  with replicated partitions

  with transparent partitions

  planning for

  restructuring and

  RLE compression method

  server configurations

  temporary variables

  viewing information about

Storage page (Database Information)

Storage page (Database Settings)

  setting

  data file cache size, (1), (2)

  index cache size, (1), (2), (3)

  index page size, (1), (2), (3)

  specifying

  data compression

  disk volumes

storage settings, (1), (2)

  scope

store data property

store property

  description

stored members

  adding and deleting

strings

  See also characters

  adding fields by matching

  adding members by matching

  as tokens

  calc scripts as

  dummy

  options for loading, (1), (2)

  preceded by &

  replacing for data loads

strings, in calculation formulas

subexpressions

subsets of data

  calculating, (1), (2), (3)

  example

  with Intelligent Calculation

  clearing

  copying

  copying to Personal Essbase

  prerequisites

  loading, (1), (2)

substitution variables

  adding to report scripts, (1), (2), (3)

  creating

  guidelines for

  creating using MaxL

  deleting

  deleting using MaxL

  formulas and

  free-form reports and

  inserting in calc scripts, (1), (2)

  updating

  updating using MaxL

  usage overview

Substitution Variables dialog box, (1), (2)

@SUBSTRING function

subtotals, (1), (2)

subtracting

  values from existing values

subtraction

  consolidation codes in data source

  prerequisite for

  setting member consolidation properties

suffixes

  adding to fields

  assignment sequence in data build

  attribute member names, (1), (2), (3)

  member names

@SUM function

Sum member, Attribute Calculations dimension, (1), (2)

summaries

  reporting example

summary information

Summary page (Partition Wizard)

@SUMRANGE function

sums, (1), (2)

SUPALL command

SUPBRACKETS command

  overriding

  usage example

SUPCOLHEADING command

SUPCOMMAS command

SUPCURHEADING command

SUPEMPTYROWS command

  entering in report scripts

  usage

Supervisor permission, (1), (2)

SUPEUROPEAN command

SUPFEED command

  usage

  usage example

SUPFORMATS command

SUPHEADING command

SUPMASK command

SUPMISSINGROWS command

  usage

  usage example

SUPNAMES command

SUPOUTPUT command

SUPPAGEHEADING command

  usage

  usage example

SUPPMISSING command

suppressing report formatting, (1), (2)

SUPPRESSMISSING command

SUPSHARE command

SUPSHAREOFF command

SUPZEROROWS command

SUPZEROS command

swap space

swapping devices

Sybase SQL Server. See SQL databases

@SYD function

SYM command

  entering in report scripts

  usage

  usage example

symmetric columns

symmetric multiprocessing (SMP), (1), (2)

symmetric reports

  asymmetric reports vs.

  calculated columns in

  changing column headings

  creating, (1), (2)

  defined

  formatting

  outputting column groups

  overriding column groupings

Synchronize Outline dialog box

synchronizing

  data, (1), (2), (3)

  partitioning and

  outlines, (1), (2)

  process summarized, (1), (2)

  warning for not applying changes

  with Application Manager

  with Partition Wizard

  outlines with report scripts

syntax

  See also formats

  calc scripts

  calculation commands

  checking in Calc Script Editor, (1), (2), (3)

  checking in Formula Editor, (1), (2)

  comments

  ESSCMD

  formulas, guidelines for

  report scripts

  member selection

  substitution variables

  user-defined attributes

  with wildcards

  verifying for filters

syntax errors

  finding in calc scripts

  finding in formulas

  formulas and dynamically calculated members

  stepping through

system administrators. See administrators

system errors, (1), (2), (3)

  logs locations and names

system failures. See failures; recovery

System Info page (Server Information)

system information, (1), (2)

system password

  changing

system security. See security

System Supervisor


T

T, two-pass calc code in data source

tab

  as column separator

  as command separator

  as file delimiter

  in names

TABDELIMIT command

  entering in report scripts

  usage

tab-delimited formats

tables. See alias tables; databases

tabs

  in application and database names

tags

  See also properties

  assigning to members

  display options

  usage examples

target outline

  See also targets

targets

  accessing data, (1), (2)

  calculations and, (1), (2)

  changing data in

  changing outlines

  copying from

  defined

  defining

  for multiple partitions

  for replicated partitions

  for transparent partitions, (1), (2)

  displaying

  logging into

  losing connections to

  mapping information

  mapping members to data sources

  linked partitions, (1), (2)

  replicated partitions, (1), (2), (3)

  specifying specific areas

  transparent partitions, (1), (2)

  member names differing from source

  missing data

  partitioning information for

  propagating outline changes, (1), (2), (3)

  process summarized, (1), (2)

  selecting

  specifying shared areas, (1), (2), (3)

  updating changes to, (1), (2), (3)

  viewing data in linked partitions

.TCP files

TCP/IP connections

.TCT files, (1), (2)

.TCU files, (1), (2)

technical support

temporary files

  deleting

temporary values, (1), (2)

terminate

  specific request using MaxL

  user session using MaxL

terminating server connections

  caution

  for specific user

testing

  calculations

  database design

  for missing values

  partitions, (1), (2)

text

  See also annotating; comments

  adding to calc scripts

  adding to empty fields

  attribute dimension type

  attribute type

  case conversions, (1), (2)

  copying and pasting, (1), (2), (3)

  cutting, (1), (2), (3)

  defining as labels

  displaying in Outline Editor

  fields

  finding and replacing

  in formulas

  in data sources

  inserting in formulas

  linked reporting object

  replacing missing values with, (1), (2)

  storing

  strings

  replacing in rules file

TEXT command

  usage, (1), (2)

  usage example

text editors

  calc scripts and

  ESSCMD commands and

  formulas and

  report scripts and

text files

  calc scripts in

  creating, (1), (2)

  cross-platform compatibility

  data sources

  default locations

  dumping security information to

  loading, (1), (2)

  multiple

  opening

text masks, (1), (2)

text strings. See strings

The Beverage Company (TBC), (1), (2)

third-party backup utility

threads

  data load processing, (1), (2)

threshold (transactions)

tildes (~)

  as codes in data source

  in headings

tildes ()

  in names in scripts and formulas

time

  estimated for calculation

time balance first/last properties

  described, (1), (2)

  in combination with skip property

  setting

time balance properties

  described

  examples for usage, (1), (2)

time balance tags

  calculating accounts data

time balanced data

  calculating averages

  missing and zero values

  specifying in data sources

Time dimension

  currency applications

  time series members and, (1), (2), (3)

  usage example

time dimension

  calculating values, (1), (2)

  defining formulas for

  description

  setting

  specifying, (1), (2), (3)

  time balance members and

  two-pass calculations and

  usage example, (1), (2)

time-out errors, (1), (2)

time-out settings

  locks

  transactions

time periods

  budgeting expenses for

  determining first value for, (1), (2)

  determining last value for, (1), (2)

  getting average for, (1), (2)

time-sensitive data

time series reporting

  calculating averages

  calculating period-to-date values

  creating dynamic members for, (1), (2)

  getting first/last values, (1), (2), (3)

  partitioned databases

  retrieving period-to-date values

  skipping missing or zero values

Time Series tags

  Intelligent Calculation and

  listed

time zones

time-out settings

  locks, (1), (2)

timestamps, comparing

TIMINGMESSAGES setting

titles, (1), (2)

@TODATE function, (1), (2)

TODATE command

  usage

tokens

toolbar

  Data Prep Editor

  Formula Editor

  Outline Editor, (1), (2)

  enabling/disabling

  Script Editor

tools for extending Essbase applications

TOP command

  caution for usage

  entering in report scripts, (1), (2), (3)

  precedence

  restrictions

  upper limits

  usage

  usage example

TOP.REP

top-down calculation

top-down ordering

  calculations

  dynamic builds, (1), (2), (3)

top-down partitioning

  defined

totals, (1), (2)

tracing calculations, (1), (2)

trailing spaces

transaction control files

Transaction Control Table (TCT), (1), (2)

Transaction Manager

  overview

Transaction page (Database Settings), (1), (2)

  accessing locked blocks

transactions

  actions triggering

  canceling calculations and

  caution for committed access

  caution for data loads, (1), (2)

  committing, (1), (2)

  defined

  forcing at load completion

  initiating commits, (1), (2)

  locks and, (1), (2), (3)

  managing

  multiple

  predictability

  processing, (1), (2)

  required privileges, (1), (2)

  rolling back

  rolling back after shutdown, (1), (2), (3)

  server crashes and active

  setting isolation levels

  with Application Manager

  with ESSCMD, (1), (2)

  with Hyperion Essbase kernel

  tracking

  updating isolation levels

  wait intervals

transparent members

transparent partition limitations with parallel calculation

transparent partitions

  advantages

  calculating

  clearing values in

  creating, (1), (2), (3), (4)

  currency conversions and, (1), (2), (3)

  data loading and

  defined

  described

  disadvantages

  dynamically calculated values in

  example of

  formulas and, (1), (2)

  guidelines for selecting, (1), (2)

  implementing security measures

  improving performance, (1), (2), (3)

  mapping members, (1), (2)

  port usage

  usage restrictions

  using attributes in

tree icon

trees

  See also branches

  data hierarchies, (1), (2)

  moving members in

  outlines

@TREND function

trends, calculating

troubleshooting, (1), (2)

  calc scripts

  connections

  data loading

  formulas

  partitions

@TRUNCATE function

truncated names

truncating values

two-dimensional

  data blocks

two-dimensional reports, (1), (2)

two-pass

two-pass calculation

  enable

two-pass calculation property

  usage example

two-pass calculations, (1), (2)

  as default

  examples, (1), (2)

  calc scripts and, (1), (2), (3), (4), (5)

  dynamic calculations and, (1), (2)

  Intelligent Calculation and, (1), (2)

  setting up, (1), (2)

  usage examples

.TXT files. See text files

typefaces

types

  setting attribute

  tagging dimensions

typographical conventions


U

UCHARACTERS command

UCOLUMNS command

@UDA function

UDA command

  selecting members with

  usage example

UDA field type

  in header records

  in rules files

  nulls and, (1), (2)

UDAs

  adding to report scripts

  allowing changes

  calc script example

  checking for

  compared with attributes

  creating

  described

  design approach for attributes

  flipping values in data load

  rules for creating

  shared members and

UDATA command

  usage example

UNAME command

UNAMEONDIMENSION command

unary operators, (1), (2)

  usage overview, (1), (2)

unauthorized users, (1), (2)

unavailable server or data sources, (1), (2)

UNCOMMITTED

  and parallel calculation

uncommitted access

  about

  commits and

  handling transactions with

  locks and, (1), (2)

  rollbacks and

  setting, (1), (2), (3)

uncommitted mode

  parallel calculation

UNDERLINECHAR command

  usage

  usage example

underlining

UNDERSCORECHAR command

underscores ( _ )

  converting spaces to, (1), (2)

  in report scripts

underscores (_)

  in array and variable names

undoing

  calc scripts builds

  database operations

unexpected values

Uniform Resource Locators. See URLs

unique data values

  assigning #MISSING values to

  Intelligent Calculation and

UNIX platforms

  basic memory requirements

  file naming conventions

  freeing memory

  monitoring applications

  running batch files

  running Essbase in background

  specifying disk volumes

  starting Essbase server

unknown member errors

unknown values

UNLOADALIAS command

UNLOADAPP command

UNLOADDB command

unloading applications (MaxL)

unlocking databases

  after allotted maximum lock time

  with Application Designer privilege

unlocking objects, (1), (2)

UNLOCKOBJECT command

unspecified members

Untitled report script

update log files

UPDATECALC setting

  system failures and

UPDATEFILE command

updates

  getting information about outline

  troubleshooting

UPDATEVARIABLE command

updating

  alias tables

  cache sizes

  changed blocks only

  data compression

  data sources, (1), (2)

  data targets, (1), (2), (3)

  databases, (1), (2)

  dimensions

  indexes

  logs

  outlines

  partitioned applications, (1), (2), (3), (4)

  guidelines

  with remote data

  references

  reports

  requests. See transactions

  spreadsheets

  substitution variables

  transaction isolation settings

  volume settings

upgrades

upper level blocks, (1), (2)

  dynamically calculating, (1), (2), (3), (4)

  recalculating values in

  restructuring and

URLs

  linking to cells

  manipulating with Application Manager

  maximum character length

  storing

Use Aliases option, (1), (2)

Use Dimension Property Settings option

User Database Access dialog box

user groups

  assigning filters to

  assigning privileges

  creating, (1), (2)

  creating with Administration Services

  creating with Application Manager

  defined, (1), (2)

  defining security settings, (1), (2), (3)

  deleting with Administration Services

  deleting with Application Manager

  editing

  modifying access settings, (1), (2), (3)

  removing members

  renaming

  returning members, (1), (2)

  viewing current settings

user interface

  See also Application Manager

  accessing linked objects and clients

user locks

  viewing and removing with Application Manager

user-management tasks, (1), (2), (3)

user names

  disabling, (1), (2), (3), (4)

  entering, (1), (2), (3)

user types

  Create/Delete Users/Groups

  defined

  ordinary, (1), (2)

  Supervisor

User/Group Application Access dialog box

User/Group Security dialog box

  copying security profiles, (1), (2)

  creating new users

  deleting users and groups

  editing existing groups

  editing user profiles

  managing users and groups

  renaming users and groups

user-defined macros

  validating

users

  accessing locked blocks, (1), (2)

  activating disabled

  assigning

  application access, (1), (2), (3), (4)

  application permission

  filters

  privileges

  to groups, (1), (2)

  changing access privileges, (1), (2)

  changing passwords using MaxL

  changing passwords with Administration Services

  changing passwords with Application Manager

  creating accounts for, (1), (2)

  creating new with Administration Services

  creating new with Application Manager

  defining security, (1), (2), (3)

  deleting user with Application Manager

  deleting using MaxL

  disconnecting from servers

  displaying

  access settings

  defined users

  inactive users

  displaying current, (1), (2)

  displaying in MaxL, (1), (2), (3), (4), (5), (6)

  editing security settings

  limiting login attempts

  limiting maximum number of sessions

  logging out, (1), (2), (3)

  login procedure

  maintaining information for

  removing, (1), (2)

  renaming

  renaming using MaxL

  replicating privileges

  security settings

  security types

  setting global access levels

  unauthorized, (1), (2)

USERS command

  usage overview

USERS command (Agent)


V

V, Dynamic Calc and Store code in data source

VALIDATE command, (1), (2)

  partitioned applications and

Validate page (Partition Wizard)

Validate Rules dialog box, (1), (2)

VALIDATEPARTITIONDEFFILE command

validating

  data integrity

  field names

  partitions

  rules files, (1), (2), (3)

  troubleshooting problems

validity checking

values, (1), (2)

  See also missing values; range of values

  accumulation

  assigning to member combinations

  assigning to variables

  averaging

  for time periods, (1), (2)

  non-zero values and

  reporting examples, (1), (2)

  with formulas, (1), (2)

  changing

  comparing, (1), (2)

  compression and repetitive, (1), (2)

  defined

  displaying specific

  distribution among dimensions

  duplicating

  dynamically calculating, (1), (2), (3)

  entering in empty fields

  example of comparing

  filtering

  flipping

  formatting in reports, (1), (2)

  examples

  identical

  in a database, (1), (2)

  inconsistent

  incorrect

  interdependent

  looking up

  measuring

  member with no

  negative

  flipping

  variance as

  nulls, (1), (2)

  of attributes, (1), (2), (3)

  optimizing in sparse dimensions

  ordering in reports, (1), (2)

  example

  out of range

  overwriting, (1), (2), (3)

  for currency conversions

  placing retrieval restrictions, (1), (2)

  example

  reading multiple ranges

  referencing, (1), (2), (3), (4)

  retrieving dynamically calculated, (1), (2), (3), (4)

  retrieving for reports

  setting maximum rows allowed

  with conditions, (1), (2), (3), (4)

  retrieving from remote databases, (1), (2), (3)

  rolling up

  rounding, (1), (2)

  scaling

  setting maximum number of

  storing, (1), (2)

  temporary, (1), (2)

  truncating

  unable to change

  unexpected

  unique

  assigning #MISSING values to

  Intelligent Calculation and

  unknown

  variables as

  void

@VAR function, (1), (2), (3)

VAR command

variables

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

  assigning values

  creating substitution

  creating using MaxL

  declaring, (1), (2), (3)

  deleting

  deleting using MaxL

  free-form reports and

  inserting in calc scripts, (1), (2)

  naming

  setting configurable variables

  updating

  updating using MaxL

@VARIANCE function

variance

  See also statistical variance, calculating

  dynamically calculating

  returning, (1), (2)

  usage examples, (1), (2), (3), (4)

variance percentages

  calculating

  returning, (1), (2)

variance reporting properties, (1), (2)

  setting

@VARIANCEP function

@VARPER function, (1), (2), (3), (4)

Verify dialog box

verifying

  See also validating

  outline content on save

  outlines

  path information

  values retrieved in loads

VERSION command (Agent)

version compatibility

version numbers

vertical bars ( | )

  in dimension and member names

View Log File dialog box, (1), (2), (3)

view logs

  Log Analyzer

  OLAP Server and application in Administration Services

  OLAP Server and application in Application Manager

  OLAP Server in Application Manager

  OLAP Server logs in Application Manager

View menu, (1), (2)

view user locks

viewing

  access settings

  active filters

  aliases, (1), (2)

  in Calc Script Editor

  in Formula Editor

  application information, (1), (2), (3)

  application logs, (1), (2)

  applications

  available ports, (1), (2)

  changes to outlines

  current users, (1), (2), (3)

  data, (1), (2), (3)

  in targets

  with Data Prep Editor, (1), (2)

  data load error logs

  data sources, (1), (2)

  data targets

  database

  statistics

  database information, (1), (2)

  database statistics

  databases

  dimension build error logs

  dimensions

  in Calc Script Editor

  in Formula Editor

  in outlines

  dynamically calculated members, (1), (2)

  exception logs

  field operations

  formulas, (1), (2)

  inactive users

  informational messages, (1), (2), (3)

  linked objects, (1), (2)

  locked data

  locks

  logs, (1), (2), (3)

  member combinations, (1), (2)

  member names in reports

  members in outlines, (1), (2)

  names for generations and levels

  OLAP Server logs

  outline change logs

  partitions, (1), (2)

  records

  replace operations

  selection/rejection criteria

  Server Agent commands

  server information

  software version

  specific values

  storage information

  text in Outline Editor

  unique values

  user and group lists with Administration Services

viewing the application log

views

  customizing

virtual cubes (in Hyperion MBA). See transparent partitions

virtual memory

void mappings

volume names

volumes

  allocation and

  data files and

  data storage and multiple

  deallocating, (1), (2)

  index files and

  specifying

  with Application Manager

  with ESSCMD

  updating storage settings

.W95 files


W

Wait settings

  locks

  transactions

warnings

  application logs and

  OLAP Server logs and

  partition validation

  report processing, (1), (2)

week-to-date calculations

white space

  as file delimiter

  converting to underscores, (1), (2)

  cross-dimensional operator and

  data entry

  dropping, (1), (2)

  formulas

  in dimension and member names

  in names

  in report layouts

  report scripts

WIDTH command

wildcard matches

wildcards in report scripts

window

  Application Desktop

  Application Services

Windows Explorer

Windows File Manager

Windows platforms

  freeing memory

  monitoring applications

@WITHATTR function, (1), (2)

WITHATTR command, (1), (2), (3)

  usage

wizards

workstations

Write access

write access

Write locks

  described

  with committed access

  with uncommitted access, (1), (2)

Write permission

Write privilege, (1), (2)

writes

  data compression and, (1), (2)

  error logs

  getting number of

  optimizing

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


X

X member code

X operator, (1), (2)

X, Dynamic Calc code in data source

XCHGRATE database

  adding members

  contents described

  displaying outlines

  linking with Application Manager

Xchgrate database

  provided with Hyperion Essbase

XCHGRATE sample database

.XCP files, (1), (2)

.XLL files

.XLS files

@XREF function


Y

year-to-date calculations, (1), (2)

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


Z

Z, time balance codes in data source

zero values

  excluding in time balances

  formatting in reports, (1), (2)

  including in time balances

  replacing with labels

  skipping, (1), (2)

ZEROTEXT command

zoom

  See drill.