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