-
    see Operators
! (bang). See bang
"" "" quotation marks
    in MaxL Shell
    used with ESSCMD commands
%
    see Operators
& (ampersand). See ampersand
*
    see Operators
/
    see Operators
; semicolon
    in MaxL statements
    used with ESSCMD commands
{ } curly braces (in reports)
+
    see Operators
<
    see Operators
< left angle bracket (in reports)
<=
    see Operators
<>
    see Operators
=
    see Operators
>
    see Operators
>=
    see Operators



ABS
    calculation function
    MDX function
absolute value function
    in calculation scripts or formulas
    in MDX queries
ACCOFF report writer command
ACCON report writer command
accounts tag
    calculation function returning TRUE if present
    MDX function returning TRUE if present
ACCUM
ACTION specification for triggers
AFTER report writer command
AGENTDELAY config setting
AGENTDISPLAYMESSAGELEVEL config setting
AGENTLOGMESSAGELEVEL config setting
AGENTPORT config setting
AGENTTHREADS config setting
AGG calculation command
aggregate storage databases
    configuration settings enabled for
    creating an application
    creating outline formulas
    MaxL data load process
    MaxL statements enabled for
    outline optimization settings
       OPGCACHESIZE
       PRELOADALIASNAMESPACE
       PRELOADMEMBERNAMESPACE
    overview
    tablespaces
aggregations
    performing using MaxL
AGTSVRCONNECTIONS config setting
algorithms
    for data mining
        creating
        deleting
        displaying
    for the @Trend calculation function
        DES
        linear regression
        linear regression with seasonal adjustment
        SES
        TES
ALIAS calculation function
aliases
    in reports
    managing in ESSCMD
    managing in MaxL
ALLANCESTORS calculation function
ALLINSAMEDIM report writer command
ALLOCATE calculation function
allocation functions
ALLSIBLINGS report writer command
alter (MaxL)
ampersand
    calculation command
    report writer command
Analytic Server
    changing system properties in MaxL
    configuration settings
    viewing system information in MaxL
Analytic Server sessions
    displaying in MaxL
    stopping in MaxL
Ancest calculation function
ancestors
    calculation function that returns an ancestor
    calculation function that tests for an ancestor
    calculation functions that return ancestor values
       @ANCESTVAL
       @MDANCESTVAL
       @SANCESTVAL
    calculation functions that return more than an ancestor
       @ALLANCESTORS
       @IALLANCESTORS
       @IANCESTORS
    MDX function that tests for an ancestor
    MDX function that returns one ancestor
    MDX function that returns set of ancestors
    report command that returns ancestors
Ancestors functions
    MDX function
    report writer command
Ancestval calculation function
AND
    calculation operator
    MDX operator
APP-NAME in MaxL
applications
    creating in MaxL
        aggregate storage applications
    deleting in MaxL
    displaying in MaxL
    modifying in MaxL
    sample applications used in this document
ARRAY calculation command
array variables
ASYM report writer command
Attribute-value calculation functions
    for Boolean values
    for numeric or date values
    for text values
Attribute function
    in calculation scripts or formulas
    in MDX queries
ATTRIBUTE report writer command
Attributebval calculation function
attributes
    as MDX properties
    calculation function that returns members with attribute
    calculation function that returns members with type of attribute
    MDX function that returns members with attribute
    MDX function that returns members with type of attribute
Attributesval calculation function
Attributeval calculation function
AUTHENTICATIONMODULE config setting
Average function
    in calculation scripts or formulas
    in MDX queries
averages
    Avg MDX function
    calculation functions
       @AVG
       @AVGRANGE
       @MOVAVG
       CALC AVERAGE
Avgrange calculation function
axis specification in MDX queries



bang command (report writer)
BEFORE report writer command
block locks
    limiting number of locks
    limiting the time a lock is held
BLOCKHEADERS report writer command
blocks
    calculating updated
    clearing/deleting
    locking to calculate
    preventing creation of during calculation
       SET CREATEBLOCKONEQ
       SET CREATENONMISSINGBLK
Boolean functions
    in calculator
    in MDX
bottom-up calculations
BOTTOM report writer command
BottomCount MDX function
BottomPercent MDX function
BottomSum MDX function
BRACKETS report writer command
buffer
    aggregate storage data loads



caches
    cache size for aggregate-storage outlines
    calculator cache, setting size
CALC-NAME in MaxL
CALC-STRING in MaxL
CALC ALL calculation command
CALC AVERAGE calculation command
CALC DIM calculation command
CALC FIRST calculation command
CALC LAST calculation command
CALC TWOPASS calculation command
CALCCACHE config setting
CALCCACHEDEFAULT config setting
CALCCACHEHIGH config setting
CALCCACHELOW config setting
CALCLIMITFORMULARECURSION config setting
CALCLOCKBLOCK config setting
Calcmode calculation function
CALCMODE config setting
CALCNOTICE config setting
CALCOPTFRMBOTTOMUP config setting
CALCPARALLEL config setting
CALCREUSEDYNCALCBLOCKS config setting
CALCTASKDIMS config setting
CALCULATE COLUMN report writer command
CALCULATE ROW report writer command
calculated members in MDX
calculation commands
    groups of
    list of
    overview of
calculation operators
    in calculator syntax
    in MDX syntax
calculations
    average members
    clean data blocks and
    columns and rows in reports
    commands for
    creating in MaxL
    currency conversions
    deleting in MaxL
    dirty blocks
    displaying in MaxL
    entire database
    executing in MaxL
    first members
    formulas and aggregations
    ignoring member formulas
    iterative
    last members
    locking blocks concurrently
    monitoring progress
    optimizing flat database outlines
    optimizing formulas on sparse dimensions
    overview of commands
    parallel
    parents with same defined currency
    restricting to database subset
    rows and columns in reports
    sparse dimensions
    temporary variables
    two-pass members
    types of
calculator cache
CASE MDX function
CCONV calculation command
CCTRACK config setting
characters
    underlining in reports
characters in MaxL
Children function
    in calculation scripts or formulas
    in MDX queries
CHILDREN report writer command
clean status
CLEARALLROWCALC report writer command
CLEARBLOCK calculation command
CLEARCCTRACK calculation command
CLEARDATA calculation command
clearing
    blocks
    data
    exchange rate tracking (CCTRACK)
CLEARLOGFILE config setting
CLEARROWCALC report writer command
ClosingPeriod MDX function
cmd2mxl utility
CoalesceEmpty MDX function
COLHEADING report writer command
column or row calculation commands
COLUMN report writer command
columns
    calculating
    displaying dimensions as
    underlining in a report
commands
    calculations
    reports
COMMAS report writer command
COMMENT-STRING in MaxL
comments in MDX
compaction of security file
Compound calculation function
Compoundgrowth calculation function
Concatenate calculation function
CONDITION specification for triggers
conditional calculation commands
conditional functions
    in MDX
       Case
       Filter
       Generate
       IIF
conditional tests
consolidating
    #MISSING values
    only parents with same currency
constraints on data
   Create Or Replace Trigger
   Defining Triggers
control flow calculation commands
copying data
Correlation calculation function
Count function
    in calculation scripts or formulas
    in MDX queries
count functions in MDX queries
   BottomCount
   Count
   NonEmptyCount
   TopCount
Cousin MDX function
CRASHDUMP config setting
create (MaxL)
create blocks on equation
CrossJoin MDX function
CUBE AREA specification for triggers
cube specification in MDX queries
Curgen calculation function
CURHEADING report writer command
Curlev calculation function
currency conversions
    calculating
    displaying headings of
    performing in a report
    suppressing information in reports
    tracking
currency members
CURRENCY report writer command
CurrentMember MDX function
CurrentTuple MDX function
Currmbr calculation function
Currmbrrange calculation function
custom-defined functions
    creating in MaxL
    deleting in MaxL
    displaying in MaxL
    overview
custom-defined macros
    creating in MaxL
    deleting in MaxL
    displaying in MaxL
    overview


>>