$ (dollar sign) in MaxL Command Shell variables
AGENTDELAY configuration setting
AGENTLOGMESSAGELEVEL configuration setting
AGENTPORT configuration setting
AGENTTHREADS configuration setting
#MISSING values
only parents with same currency
values
AGTSVRCONNECTIONS configuration setting
in reports
managing
aliases. See Also alias tables or location aliases
ALLSIBLINGS report writer command
ALLSINAMEDIM report writer command
application
database
group
system
user
based on shared ancestor value of current member
from multiple dimensions
selecting a member and a range of its ancestors
selecting a member and all of its ancestors
selecting a range of the member's ancestors excluding the member
selecting all ancestors of a member excluding the member
selecting one ancestor of a member exclusing the member
ANCESTORS report writer command
error message controls
limiting data load messages
sample files used in this document
APPLYOTLCHANGEFILE ESSCMD command
archiving with log files. See log files
for a member
for application and database
ATTRIBUTE report writer command
audience for Technical Reference
AUTHENTICATIONMODULE configuration setting
of all values of expList
of specified member across a range
and report scripts
definition
examples
handling command errors in ESSCMD
running
writing in ESSCMD
command line syntax for
creating scripts for
error handling
BEGININCBUILDDIM ESSCMD command
limiting number of locks
limiting the time a lock is held
BLOCKHEADERS report writer command
calculating updated
clearing
deleting
limiting number of
locking to calculate
BRACKETS report writer command
enabling/disabling (ESSCMD)
enabling/disabling (MaxL "cache pinning")
getting information for a database
CALC AVERAGE calculation command
CALC FIRST calculation command
CALC TWOPASS calculation command
CALCCACHE configuration setting
CALCCACHEDEFAULT configuration setting
CALCCACHEHIGH configuration setting
CALCCACHELOW configuration setting
CALCCACHTBLMEMORY configuration setting
CALCLOCKBLOCK configuration setting
CALCMODE configuration setting
CALCNOTICE configuration setting
CALCOPTCALCHASTBL configuration setting
CALCOPTFRMLBOTTOMUP configuration setting
CALCPARALLEL configuration setting
CALCTASKDIMS configuration setting
CALCULATE COLUMN report writer command
CALCULATE ROW report writer command
and locking blocks concurrently
and optimizing flat database outlines
and restricting to a database subset
and types of calculations
average members
columns and rows in reports
concurrently in the same database
currency conversions
dirty blocks
entire database
first members
formulas and aggregations
last members
member formulas
missing values
monitoring progress while
optimizing formulas on sparse dimensions while
parents with same defined currency
rows and columns in reports
specifying clean data blocks
specifying how many iterations
subsets of the database
temporary variables
two-pass members
using Boolean functions
using computational commands
using conditional formulas
using control flow commands
using data declaration commands
using default calc scripts
using financial functions
using Intelligent Calculation
using interdependent formulas
using mathematical functions
using mathematical operators
using MaxL
using member set functions
using range functions
using relationship functions
using SET calculation commands
conditional commands
control flow commands
data declaration commands
functional (computation) commands
member formulas
calculation command types. See calculation command groups
groups
list
creating (MaxL)
deleting (MaxL)
displaying information about the calculations
executing (MaxL)
granting (MaxL)
setting the default (MaxL)
default size
setting the size
whether Essbase uses
canceling operations in ESSCMD
case-sensitivity of member names
CASESENSITIVE configuration setting
cash flow's internal rate of return
cells, replicated. See partitioning
characters: underlining in a report
applying
creating
purging after changes have been applied
resetting time stamp
CHILDREN report writer command
CLEARALLROWCALC report writer command
CLEARBLOCK calculation command
blocks
data
CLEARLOGFILE configuration setting
CLEARROWCALC report writer command
COLHEADING report writer command
column or row calculation commands
calculating
displaying dimensions as
underlining in a report
calculation
computation
control flow
data declaration
reiterating
report
COMMITBLOCKS configuration setting
completion notices for calculations
compounded interest calculation
conditional and logical operators
configuration file (ESSBASE.CFG)
creating
settings
application
calculation
database
filter
function
group
location alias
macro
partition
user
MaxL equivalent (application-wide variable)
MaxL equivalent (database-wide variable)
MaxL equivalent (system-wide variable)
cross-dimensional operator (->)
(if needed) with member sets
CURHEADING report writer command
CURRENCY report writer command
calculating
currency database informational commands
displaying headings of
modifying behavior of
performing in a report
suppressing currency information in a report
tracing system
custom-defined macro functions
appearance in reports
clearing sections of
copying
exporting and reporting (MaxL)
importing (MaxL)
loading (import in MaxL)
loading, clearing, and exporting commands (ESSCMD)
ordering
restricting ranges
data load messages in application log
aggregating
aggregating parent-child relationships
altering (MaxL)
calculating
calculating (MaxL)
clearing sections of data from
consolidating values
creating (MaxL)
deleting (MaxL)
exporting (MaxL)
loading (MaxL)
managing (ESSCMD)
managing (MaxL)
restructuring incrementally
DATACACHESIZE onfiguration setting
DATACOMPRESS configuration setting
DATACOMPRESSIONTYPE configuration setting
DATAERRORLIMIT configuration setting
DATAFILECACHESIZE configuration setting
DDB (partition definition) file
default values for function parameters
deleting in MaxL. See drop in MaxL
DELIMITEDMSG configuration setting
DELIMITER configuration setting
depreciation calculation methods
declining balance
straight line
sum of year's digits
DESCENDANTS report writer command
DIMBOTTOM report writer command
aggregating sparse
building
calculating and tracking exchange rates
roots and leaves
row: in reports
specifying as report page members
DIRECTIO configuration setting
DISKVOLUMES configuration setting
application
calculation
database
disk volume
filter
filter row
function
group
location alias
macro
partition
privilege
system
user
variable
DLSINGLETHREADPERSTAGE configuration setting
DLTHREADSPREPARE configuration setting
DLTHREADSWRITE configuration setting
document conventions for Technical Reference
application
calculation
database
filter
function
group
location alias
macro
partition
user
DUPLICATE report writer command
DYNCALCCACHEBLKRELEASE configuration setting
DYNCALCCACHEBLKTIMEOUT configuration setting
DYNCALCCACHECOMPRBLKBUFSIZE configuration setting
DYNCALCCACHEMAXSIZE configuration setting
echo in MaxL
ENDHEADING report writer command
equations in calculation scripts
determining how many records can be written during a data load
determining where data is written
ERROR macro function
in ESSCMD
in MaxL
spreadsheet error messages
with unknown member names
Essbase Perl Module (ESSBASE.PM)
ESSBASE.CFG (configuration file)
creating for client
creating for server
settings
command groups
multi-user considerations
operating system platforms
quitting
starting
syntax guidelines
batch processing
handling command errors in batch files
importing and calculating data (sample)
scheduling report printing (sample)
updating a SQL script (sample)
writing batch files
canceling operations in interactive mode
entering commands
logging into the server
EUROPEAN report writer command
EXCEPTIONLOGOVERWRITE configuration setting
EXCLUSIVECALC configuration setting
exporting data in parallel. See parallel export
first: calculating members tagged as
FIX and ENDFIX calculation commands
FIXCOLUMNS report writer command
format commands in report writer
FORMATCOLUMNS report writer command
formatting conventions in this document
formulas for members in calc scripts
conditional
interdependent
function parameters used in this document
custom-defined function examples
and levels, described
determining generation of member
determining generation of member in relation to top member
determining whether a member is of a certain generation
determining whether members are of the same generation
selecting all members with a shared generation
GETALLREPLCELLS ESSCMD command
GETATTRIBUTESPECS ESSCMD command
GETPARTITIONOTLCHANGES ESSCMD command
GETPERFSTATS configuration setting
GETUPDATEDREPLCELLS ESSCMD command
GRIDEXPANSION configuration setting
HAENABLE configuration setting
HAMAXNUMCONNECTION configuration setting
HAMAXNUMSQLQUERY configuration setting
HAMAXQUERYROWS configuration setting
HAMAXQUERYTIME configuration setting
HAMEMORYCACHESIZE configuration setting
HARETRIEVENUMROW configuration setting
headings of pages in reports. See page headings using report writer
Hybrid Analysis configuration settings
HAENABLE
HAMAXNUMCONNECTION
HAMAXNUMSQLQUERY
HAMAXQUERYROWS
HAMAXQUERYTIME
HAMEMORYCACHESIZE
HARETRIEVENUMROW (not a query governor)
IANCESTORS report writer command
ICHILDREN report writer command
IDESCENDANTS report writer command
IFSTRCMP directive (@@IFSTRCMP)
IMMHEADING report writer command
data
dimensions
lro
importing and calculating data in ESSCMD (sample)
INCEMPTYROWS report writer command
INCFORMATS report writer command
INCMISSINGROWS report writer command
INCRESTRUC configuration setting
INCZERROWS report writer command
INDENTGEN report writer command
INDEXCACHESIZE configuration setting
INDEXPAGESIZE configuration setting
specifying default setting
turning it on or off
last: calculating members tagged as
and generations described
determining level of a member
determining level of member in relation to the bottom-most descendant
determining whether a member is of a certain level
determining whether members are of the same level
selecting all members with a shared level
LISTLINKEDOBJECTS ESSCMD command
loading data (MaxL). See importing in MaxL, data
creating (ESSCMD)
creating (MaxL)
deleting (ESSCMD)
deleting (MaxL)
listing (ESSCMD)
listing (MaxL)
limiting number of blocks
limiting time users can hold
viewing and removing
LOCKTIMEOUT configuration setting
determining overwrite
MaxL
outline changes
spreadsheet updates
timing queries and reports
logging into the server in ESSCMD
logical and conditional operators
login in MaxL
LOGMESSAGELEVEL configuration setting
logout in MaxL
LOOP and ENDLOOP calculation commands
macro functions. See member set functions
BNF Diagrams
command shell
definitions
help with diagrams in this document
nesting scripts
Perl Module
security
starting
statements
stopping
variables
MAXLOGINS configuration setting
case-sensitivity of names
descendants
determining location of
formulas in calculation scripts
mbrName
names and aliases in report writer
selecting and sorting in report writer
aggregating
clearing blocks
clearing data
displaying empty rows in report writer
displaying missing rows in report writer
resetting name of a calc row in report writer to #MISSING
substituting with a text label in report writer
MISSINGTEXT report writer command
multiple-user considerations in ESSCMD
ancestor-level data return
parent-level data return
shifting data values across
NAMESCOL report writer command
NAMEWIDTH report writer command
NETDELAY configuration setting
NETNPCONNECTTIMEOUT configuration setting
NETRETRYCOUNT configuration setting
delay time
Named Pipes
retry connections
NODENAME configuration setting
NOINDENTGEN report writer command
NOMSGLOGGINGONDATAERRORLIMIT configuration setting
NOPAGEONDIMENSION report writer command
NOROWREPEAT report writer command
NOSKIPONDIMENSION report writer command
notices for calculation progress
NOUNAMEONDIM report writer command
OFFCOLCALCS report writer command
OFFROWCALCS report writer command
OFSAMEGEN report writer command
ONCOLCALCS report writer command
ONROWCALCS report writer command
ONSAMELEVELAS report writer command
operating system platforms in ESSCMD
conditional and logical
cross-dimensional (->)
mathematical
OUTALTMBR report writer command
OUTALTNAMES report writer command
OUTALTSELECT report writer command
OUTLINECHANGELOG configuration setting
OUTLINECHANGELOGSIZE configuration setting
OUTMBRALT report writer command
OUTMBRNAMES report writer command
exporting in MaxL
generating a report
in MaxL
resuming in a report
suppressing while running a report
zero values as text in a report
enabling when maximum number of lines is exceeded
inserting
suppressing when maximum number of lines is exceeded
page headings using report writer
defining in place of current
displaying
displaying before next row
displaying immediately
ending definition of
suppressing
suppressing with other formatting
PAGEHEADING report writer command
PAGELENGTH report writer command
PAGEONDIMENSION report writer command
column formatting
inserting
row formatting
setting center lines
setting maximum number of lines per page
identifying sparse dimensions
using more than one sparse dimension
forcing to single thread per stage
setting number of threads in preparation stage
setting number of threads in write stage
ESSCMD
MaxL
based on shared parent value of current member
from multiple dimensions
adding to reports
returning values of
correcting results with two-pass calculations
partitioning (ESSCMD)
getting all replicated cells from the source (target is current)
getting updated replicated cells from the source (target is current)
partition definition (.DDB) file
putting all replicated cells into the target (source is current)
putting updated replicated cells into the target (source is current)
partitioning (MaxL)
creating partitions
displaying partition information
dropping a partition
refreshing replicated partition
getting
resetting
PIPEBUFFERSIZE configuration setting
precision digits used for numerical comparison
PRINTPARTITIONDEFFILE ESSCMD command
PRINTROW report writer command
granting
PURGELINKEDOBJECTS ESSCMD command
PURGEOTLCHANGEFILE ESSCMD command
PUTALLREPLCELLS ESSCMD command
attributes
functions
maximum value across a range
returning a member range list
standard deviation across a range
summation across a range
refresh replicated partition in MaxL
REMOVECOLCALCS report writer command
replicated cells. See partitioning
command groups
syntax and abbreviations
alias and member name display
column or row calculation
data ordering
data range
delimiters { } <
format
layout
member selection and sorting
output
query timing
syntax
writing reports in MaxL
REPTKBYTEBUF configuration setting
REPTKBYTESORTBUF configuration setting
RESETOTLCHANGETIME ESSCMD command
RESTRICT report writer command
restructuring databases incrementally
CALCULATE ROW report writer command
CLEARALLROWCALC report writer command
CLEARROWCALC report writer command
OFFROWCALCS report writer command
ONROWCALCS report writer command
PRINTROW report writer command
SAVEANDOUTPUT report writer command
SAVEROW report writer command
SETROWOP report writer command
SAVEANDOUTPUT report writer command
scheduling report printing in ESSCMD (sample)
handling command errors
running
samples
writing
security privileges and roles in MaxL
granting
server essbase.cfg file, creating
SERVERPORTBEGIN configuration setting
SERVERPORTEND configuration setting
SERVERTHREADS configuration setting
SET AGGMISSG calculation command
SET CALCHASHTBL calculation command
SET CALCPARALLEL calculation command
SET CALCTASKDIMS calculation command
SET CLEARUPDATESTATUS calculation command
SET FRMLBOTTOMUP calculation command
SET LOCKBLOCK calculation command
SET NOTICE calculation command
SET UPDATECALC calculation command
SET UPTOLOCAL calculation command
SETCENTER report writer command
SETDEFAULTCALCFILE ESSCMD command
SETROWOP report writer command
shifting data values across multiple-dimension ranges
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
error messages
query timing
specifying maximum number of rows processed
SQL script, updating in ESSCMD (sample)
suppressing grid messages
update logging
SSAUDIT, SSAUDITR configuration settings
SSLOGUNKNOWN configuration setting
SSPROCROWLIMIT configuration setting
across a range
based on population
based on sample
STARTHEADING report writer command
resetting
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
TABDELIMIT report writer command
conventions
introduction
what you should know before reading this document
who should read this document
containing a single value
one-dimensional array
listed
data load, overriding
preparation stage of data load
server, how many allowed
write stage of data load
time dimension, period-to-date values in
TIMINGMESSAGES configuration setting
UCHARACTERS report writer command
UCOLUMNS report writer command
UNAMEONDIMENISON report writer command
UNDERLINECHAR report writer command
changed row member names in same dimension
characters in preceding row
data columns only
default
name and data columns
name columns only
turning off for new member names in same dimension
UNDERSCORECHAR report writer command
UPDATECALC configuration setting
navigating
searching