! (bang).. See bang
"" "" quotation marks
%. See Operators
& (ampersand).. See ampersand
*. See Operators
+. See Operators
-. See Operators
/. See Operators
; semicolon
<. See Operators
< left angle bracket (in reports)
<=. See Operators
<>. See Operators
=. See Operators
>. See Operators
>=. See Operators
ABS
absolute value function
in calculation scripts or formulas
accounts tag
calculation function returning TRUE if present
MDX function returning TRUE if present
ACTION specification for triggers
AGENTDELAY configuration setting
AGENTDESC configuration setting
AGENTDISPLAYMESSAGELEVEL configuration setting
AGENTLEASEEXPIRATIONTIME configuration setting
AGENTLEASEMAXRETRYCOUNT configuration setting
AGENTLEASERENEWALTIME configuration setting
AGENTLOGMESSAGELEVEL configuration setting
AGENTPORT configuration setting
AGENTSECUREPORT configuration setting
AGENTTHREADS configuration setting
aggregate storage databases
outline optimization settings, (1), (2), (3), (4)
aggregations
AGGRESSIVEBLKOPTIMIZATION configuration setting
AGTMAXLOGFILESIZE configuration setting
AGTSVRCONNECTIONS configuration setting
algorithms
for the @Trend calculation function
linear regression with seasonal adjustment
aliases
ALLANCESTORS calculation function
ALLINSAMEDIM report writer command
allocations
ALLSIBLINGS report writer command
ampersand
ancestors
calculation function that returns an ancestor
calculation function that tests for an ancestor
calculation functions that return ancestor values, (1), (2), (3)
calculation functions that return more than an ancestor
MDX function that returns one ancestor
MDX function that returns set of ancestors
MDX function that tests for an ancestor
report command that returns ancestors
ancestors calculation function
Ancestors functions
Ancestval calculation function
AND
applications
aggregate storage applications
sample applications used in this document
APPMAXLOGFILESIZE configuration setting
APSRESOLVER configuration setting
ASOLOADBUFFERWAIT configuration setting
ASOSAMPLESIZEPERCENT configuration setting
Attribute function
in calculation scripts or formulas
ATTRIBUTE report writer command
Attribute-value calculation functions
Attributebval calculation function
AttributeEx function
attributes
calculation function that returns base members of attributes
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
ATTRIBUTEVA report writer command
Attributeval calculation function
AUTHENTICATIONMODULE configuration setting
Average function
in calculation scripts or formulas
averages
block locks
limiting the time a lock is held
block storage databases
BLOCKHEADERS report writer command
blocks
preventing creation of during calculation, (1), (2)
Boolean functions
BRACKETS report writer command
buffer
buffers
caches
aggregate storage formula cache
calculator cache, setting size
CALC AVERAGE calculation command
CALC FIRST calculation command
CALC TWOPASS calculation command
CALCCACHE configuration setting
CALCCACHEDEFAULT configuration setting
CALCCACHEHIGH configuration setting
CALCCACHELOW configuration setting
CALCLIMITFORMULARECURSION configuration setting
CALCLOCKBLOCK configuration setting
CALCMODE configuration setting
CALCNOTICE configuration setting
CALCOPTFRMBOTTOMUP configuration setting
CALCPARALLEL configuration setting
CALCREUSEDYNCALCBLOCKS configuration setting
CALCTASKDIMS configuration setting
CALCULATE COLUMN report writer command
CALCULATE ROW report writer command
calculation commands
calculation operators
calculations
optimizing formulas on sparse dimensions
parents with same defined currency
restricting to database subset
varying attributes perspective command
characters
Children function
in calculation scripts or formulas
CHILDREN report writer command
CLEARALLROWCALC report writer command
CLEARBLOCK calculation command
CLEARCCTRACK calculation command
clearing
data by region (aggregate storage)
exchange rate tracking (CCTRACK)
CLEARLOGFILE configuration setting
CLEARROWCALC report writer command
CLIENTPREFERREDMODE configuration setting
clusters
COLHEADING report writer command
column or row calculation commands
columns
commands
Compoundgrowth calculation function
Concatenate calculation function
CONDITION specification for triggers
conditional calculation commands
conditional functions
consolidating
only parents with same currency
control flow calculation commands
Correlation calculation function
Count function
in calculation scripts or formulas
count functions in MDX queries, (1), (2), (3), (4)
CRASHDUMP configuration setting
cube
CUBE AREA specification for triggers
cube specification in MDX queries
CURHEADING report writer command
currency conversions
suppressing information in reports
CURRENCY report writer command
CurrentAxisMember MDX function
Currmbrrange calculation function
custom-defined functions
custom-defined macros
data
data blocks.. See blocks
data declaration calculation commands
data slices (aggregate storage)
database objects
databases
consolidating parent/child relationships only
modifying in MaxL, (1), (2), (3)
DATACACHESIZE configuration setting
DATAERRORLIMIT configuration setting
DATAEXPORT calculation command
DATAEXPORTCOND calculation command
DATAEXPORTENABLEBATCHINSERT configuration setting
DATAFILECACHESIZE configuration setting
DATAIMPORTBIN calculation command
date
get rounded date in MDX queries
date (Julian)
date (UNIX)
DATEFORMAT report writer command
DEFAULTLOGLOCATION configuration setting
defragmentation of security file
DELAYEDRECOVERY configuration setting
DELIMITEDMSG configuration setting
DELIMITER configuration setting
delimiters
deploying cube from Essbase Studio, (1), (2)
Descendants function
descendants function
in calculation scripts or formulas
DESCENDANTS report writer command
DEXPSQLROWSIZE configuration setting
DIMBOTTOM report writer command
DIMBUILDERRORLIMIT configuration setting
DIMBUILDSTATSINTERVAL configuration setting
dimensions
calculation functions that work on multiple dimensions, (1), (2), (3), (4)
DIRECTIO configuration setting
DISABLEREPLMISSINGDATA configuration setting
disk volumes
DISPLAYMESSAGELEVEL configuration setting
DLSINGLETHREADPERSTAGE configuration setting
DLTHREADSPREPARE configuration setting
DLTHREADSWRITE configuration setting
drill-through URLs
DrillDown MDX functions
DrillUp MDX functions
DUPLICATE report writer command
DYNCALCCACHEBLKRELEASE configuration setting
DYNCALCCACHEBLKTIMEOUT configuration setting
DYNCALCCACHECOMPRBLKBUFSIZE configuration setting
DYNCALCCACHEMAXSIZE configuration setting
ENABLE_DIAG_TRANSPARENT_PARTITION configuration setting
ENABLECLEARMODE configuration setting
ENABLESECUREMODE configuration setting
ENABLESWITCHTOBACKUPFILE configuration setting
ENDHEADING report writer command
EnumValue function
in calculation scripts or formulas
Essbase
changing system properties in MaxL
viewing system information in MaxL
Essbase sessions
ESSBASEFAILOVERTRACELEVEL configuration setting
ESSBASESERVERHOSTNAME configuration setting
EUROPEAN report writer command
EXCEPTIONLOGOVERWRITE configuration setting
EXCLUDE...ENDEXCLUDE calculation command
EXCLUSIVECALC configuration setting
Exp (exponent) function
in calculation scripts or formulas
Factorial function
in calculation scripts or formulas
FAILOVERMODE configuration setting
FILELOCKINGMODE configuration setting
files
filters
FIX...ENDFIX calculation command
FIXCOLUMNS report writer command
flattened sets
flow commands.. See control flow calculation commands
FORCEGRIDEXPANSION configuration setting
format commands in report writer
FORMATCOLUMNS report writer command
formulas
cache size for (aggregate storage)
MDX formulas for aggregate storage databases
fragmentation of security file
functional calculation commands
functions (custom defined)
generations
calculation functions pertaining to, (1), (2), (3), (4), (5)
MDX functions pertaining to, (1), (2), (3)
GetFirstDay
GetLastDay
GetNextDay
GetRoundDate
GRIDEXPANSION configuration setting
GRIDEXPANSIONMESSAGES configuration setting
groups
HAENABLE configuration setting
HAMAXNUMCONNECTION configuration setting
HAMAXNUMSQLQUERY configuration setting
HAMAXQUERYROWS configuration setting
HAMAXQUERYTIME configuration setting
HAMEMORYCACHESIZE configuration setting
HARAGGEDHIERARCHY configuration setting
HARETRIEVENUMROW configuration setting
HASOURCEDSNOS390 configuration setting
headings of report pages.. See page headings
HISLEVELDRILLTHROUGH configuration setting
Hybrid Analysis
enabling/disabling query logging
limiting connections to relational source
limiting number of rows, (1), (2)
limiting number of SQL queries
iallancestors calculation function
iancestors calculation function
IANCESTORS report writer command
IBHFIXTHRESHOLD configuration setting
Ichildren calculation function
ICHILDREN report writer command
idescendants calculation function
IDESCENDANTS report writer command
iIancestors calculation function
ildescendants calculation function
ILsiblings calculation function
IMMHEADING report writer command
IMPLIED_SHARE configuration setting
IN. See Operators (MDX)
INCEMPTYROWS report writer command
INCFORMATS report writer command
INCMISSINGROWS report writer command
INCRESTRUC configuration setting
INCZEROROWS report writer command
INDENTGEN report writer command
INDEXCACHESIZE configuration setting
Int (integer) function
in calculation scripts or formulas
intelligent calculation
Irdescendants calculation function
Irsiblings calculation function
IS. See Operators (MDX)
Isacctype function
in calculation scripts or formulas
Isattribute function
in calculation scripts or formulas
Ischild function
in calculation scripts or formulas
Isiancest calculation function
isiblings calculation function
Isiparent calculation function
Isisibling calculation function
Ismbrwithattr function
in calculation scripts or formulas
Issamegen calculation function
Issamelev calculation function
Issibling function
in calculation scripts or formulas
Isuda function
lancestors calculation function
layers in MDX
ldescendants calculation function
leading &.. See ampersand
leaf members
levels
calculation functions pertaining to, (1), (2), (3), (4), (5)
MDX functions pertaining to, (1), (2), (3)
limits
linked reporting object (LRO) operations in MaxL
LinkMember function
Ln function
in calculation scripts or formulas
location aliases
locks
limiting number of blocks that can be locked
limiting the time users can hold
LOCKTIMEOUT configuration setting
log files
of calculation progress, (1), (2)
of spreadsheet updates, (1), (2)
Log function
in calculation scripts or formulas
Log10 function
in calculation scripts or formulas
logging in
LOGINFAILUREMESSAGEDETAILED configuration setting
LOGMESSAGELEVEL configuration setting
LOOP...ENDLOOP calculation command
macros (custom defined)
mathematical functions
Max (maximum value) function
in calculation scripts or formulas
MAX_REQUEST_GRID_SIZE configuration setting
MAX_RESPONSE_GRID_SIZE configuration setting
MAXACTIVEUPDATETRANSACTIONS configuration setting
MAXERRORMBRVERIFYREPORT configuration setting
MAXFORMULACACHESIZE configuration setting
maximums
calculation functions, (1), (2), (3), (4), (5)
MaxL
MaxL data definition language
MaxL Shell
MAXLOGINS configuration setting
Maxsrange calculation function
MAXTOTALACTIVETRANSACTIONS configuration setting
mbrcompare calculation function
mbrparent calculation function
Mdallocate calculation function
Mdancestval calculation function
Mdparentval calculation function
MDX
MDXLIMITFORMULARECURSION configuration setting
MEANINGLESSTEXT report writer command
member formula calculation commands
member formulas.. See formulas
members
formulas in calculation scripts
MEMSCALINGFACTOR configuration setting
merging data slices (aggregate storage)
messaging
metaread access in filters, (1), (2)
Min (minimum value) function
in calculation scripts or formulas
minimums
calculation functions, (1), (2), (3), (4), (5)
Minsrange calculation function
missing values
determining whether a value is empty in MDX queries
displaying empty rows in Report Writer
displaying missing rows in Report Writer
substituting with a text label in Report Writer
missing values (#MISSING)
displaying empty rows in reports
displaying missing rows in reports
how they are treated in calculation scripts or formulas
setting calculated row name as
substituting with text label in reports
MISSINGTEXT report writer command
Mod (modulus) function
in calculation scripts or formulas
NAMESCOL report writer command
NAMEWIDTH report writer command
Netbinretrydelay configuration setting
NETDELAY configuration setting
NETRETRYCOUNT configuration setting
NETSSLHANDSHAKETIMEOUT configuration setting
NETTCPCONNECTRETRYCOUNT configuration setting
nextsibling calculation function
NOINDENTGEN report writer command
NOMSGLOGGINGONDATAERRORLIMIT configuration setting
NOPAGEONDIMENSION report writer command
NOROWREPEAT report writer command
NOSKIPONDIMENSION report writer command
NOUNAMEONDIM report writer command
NUMBEROFSECFILEBACKUPS configuration setting
NUMBLOCKSTOEXTEND configuration setting
numeric value expressions as arguments to MDX functions, (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22), (23), (24), (25), (26), (27)
numeric value functions in MDX
objects (database files)
OFFCOLCALCS report writer command
OFFROWCALCS report writer command
OFSAMEGEN report writer command
ON COLUMNS/ON ROWS/ON PAGES etc
ONCOLCALCS report writer command
ONROWCALCS report writer command
ONSAMELEVELAS report writer command
operators
OUTALTMBR report writer command
OUTALTNAMES report writer command
OUTALTSELECT report writer command
OUTFORMATTEDMISSING report writer command
OUTFORMATTEDVALUES report writer command
outline
conversion to aggregate storage
MDX formulas for aggregate storage outlines
synchronization of partitioned outlines
OUTLINECHANGELOG configuration setting
OUTLINECHANGELOGFILESIZE configuration setting
OUTMBRALT report writer command
OUTMBRNAMES report writer command
OUTMEANINGLESS report writer command
output
OUTPUT command
page breaks in reports
when PAGELENGTH is exceeded, (1), (2)
page headings in reports
suppressing with other formatting
PAGEHEADING report writer command
PAGELENGTH report writer command
PAGEONDIMENSION report writer command
pages in report writer
PARCALCMULTIPLEBITMAPMEMCHECK configuration setting
Parent function
in calculation scripts or formulas
parents
Parentval calculation function
partitions
using port numbers in host names
percent functions in MDX queries, (1), (2)
performance statistics
period-to-date calculation function
periods (in MDX queries), (1), (2), (3), (4), (5)
PERSISTUSERATLOGIN configuration setting
PERSPECTIVE report writer command
PIPEBUFFERSIZE configuration setting
port numbers
PORTUSAGELOGINTERVAL configuration setting
Power function
in calculation scripts or formulas
Preloadaliasnamespace configuration setting
Preloadmembernamespace configuration setting
PRELOADUDANAMESPACE configuration setting
prevsibling calculation function
PRINTROW report writer command
privileges
PTD function
QRYGOVEXECBLK configuration setting
QRYGOVEXECTIME configuration setting
queries
against relational databases.. See Hybrid Analysis.
for data and metadata using MDX
query limits
quotation marks
railroad diagrams in MDX documentation
Rdescendants calculation function
RealValue function
relationship functions
in MDX queries, (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12)
Remainder function
in calculation scripts or formulas
REMOVECOLCALCS report writer command
REPALIAS report writer command
REPALIASMBR report writer command
REPLAYSECURITYOPTION configuration setting
REPLICATIONASSUMEIDENTICALOUTLINE configuration setting
REPMBRALIAS report writer command
report scripts
Report Writer
reports
REPQUALMBR report writer command
RESTRICT report writer command
RESTRUCTURETHREADS configuration setting
restructuring
retrieval buffer
Round function
in calculation scripts or formulas
ROWREPEAT report writer command
Sancestval calculation function
SAVEANDOUTPUT report writer command
SECFILEBACKUPINTERVAL configuration setting
security file compaction
triggering by defragmentation percent
security privileges
Securityfilecompactionpercent configuration setting
semicolon
SERVERLEASEEXPIRATIONTIME configuration setting
SERVERLEASEMAXRETRYCOUNT configuration setting
SERVERLEASERENEWALTIME configuration setting
SERVERPORTBEGIN configuration setting
SERVERPORTEND configuration setting
SERVERTHREADS configuration setting
sessions
SET AGGMISSG calculation command
SET CALCPARALLEL calculation command
SET CALCTASKDIMS calculation command
SET CCTRACKCALC calculation command
SET CLEARUPDATESTATUS calculation command
SET COPYMISSINGBLOCK calculation command
SET CREATEBLOCKONEQ calculation command
SET CREATENONMISSINGBLK calculation command
SET DATAEXPORTOPTIONS calculation command
SET DATAIMPORTIGNORETIMESTAMP calculation command
SET EMPTYMEMBERSETS calculation command
SET FRMLBOTTOMUP calculation command
SET FRMLRTDYNAMIC calculation command
SET LOCKBLOCK calculation command
SET NOTICE calculation command
SET REMOTECALC calculation command
SET SCAPERSPECTIVE calculation command
SET UPDATECALC calculation command
SET UPTOLOCAL calculation command
SETCENTER report writer command
SETROWOP report writer command
shared members
Shiftminus calculation function
Shiftplus calculation function
shiftsibling calculation function
Siblings function
siblings function
in calculation scripts or formulas
Silentotlquery configuration setting
SINGLECOLUMN report writer command
SKIPONDIMENSION report writer command
SORTALTNAMES report writer command
SORTDESC report writer command
SORTLEVEL report writer command
SORTMBRNAMES report writer command
SORTNONE report writer command
Sparentval calculation function
sparse dimensions, calculating
SPLITARCHIVEFILE configuration setting
spreadsheet
SQLFETCHERRORPOPUP configuration setting
SSAUDITR configuration setting
SSINVALIDTEXTDETECTION configuration setting
SSL configuration settings
SSLCIPHERSUITES configuration setting
SSLOGUNKNOWN configuration setting
SSOPTIMIZEDGRIDPROCESSING config setting
SSPROCROWLIMIT configuration setting
STARTHEADING report writer command
Stdevrange calculation function
substitution variables
deleting in MaxL, (1), (2), (3)
setting in MaxL, (1), (2), (3), (4)
using "&" character with, (1), (2)
Substring calculation function
Sum function
in calculation scripts or formulas
sum functions in MDX queries, (1), (2), (3)
SUPBRACKETS report writer command
SUPCOLHEADING report writer command
SUPCOMMAS report writer command
SUPCURHEADING report writer command
SUPEMPTYROWS report writer command
SUPEUROPEAN report writer command
SUPFORMATS report writer command
SUPHEADING report writer command
SUPMISSINGROWS report writer command
SUPNAMES report writer command
SUPOUTPUT report writer command
SUPPAGEHEADING report writer command
SUPSHARE report writer command
SUPSHAREOFF report writer command
SUPZEROROWS report writer command
syntax
TABDELIMIT report writer command
tablespaces
TARGETASOOPT configuration setting
TARGETTIMESERIESOPT configuration setting
temporary variables in calculations
threads
time balance members, calculating
in MDX queries, (1), (2), (3), (4), (5), (6)
TIMINGMESSAGES configuration setting
Todate function
in calculation scripts or formulas
TRANSACTIONLOGDATALOADARCHIVE configuration setting
TRANSACTIONLOGLOCATION configuration setting
transactions
limiting active number, (1), (2)
triggers
TRIGMAXMEMSIZE configuration setting
Truncate function
UCHARACTERS report writer command
UCOLUMNS report writer command
UDA function
in calculation scripts or formulas
UDAs
using in calculation scripts or formulas, (1), (2)
using in MDX queries, (1), (2), (3)
UNAMEONDIMENSION report writer command
UNDERLINECHAR report writer command
underlining in reports
changed row member names in same dimension
turning off for new member names in same dimension
UNDERSCORECHAR report writer command
UNICODEAGENTLOG configuration setting
UNIX
UnixDate
UPDATECALC configuration setting
updates
limiting active number of transactions
user sessions
users
value without attribute association
variables
variance function
in calculation scripts or formulas
Variancep calculation function
varying attributes
calculation function that returns base members with varying attributes
calculation function that returns members with type of attribute
calculation function that returns members with type of varying attribute
defining perspective in calculation scripts
MDX function that returns members with attribute based on perspective
MDX function that returns members with type of varying attribute
WALLETPATH configuration setting
wild card search
Withattr function
in calculation scripts or formulas
WITHATTR report writer command
WithattrEx function
XML configuration
XOLAPMAXINCLAUSESIZE configuration setting
XOLAPMAXNUMCONNECTION configuration setting
XOLAPSCHEMAVERIFICATION configuration setting, (1), (2)