! report writer command
Essbase Report Writer Commands#!
" " ' ' (quotation marks)
in the MaxLCommand Shell
used with ESSCMD commands
$ (dollar sign) in MaxL Command Shell variables
in the MaxL Command Shell
& (ampersand)
& (calculation command)
& (report writer command)
; (semicolon)
and ESSCMD commands
in the MaxL Command Shell
@functions are alphabetized by name
BLANK
{ } (curly braces) in reports
Report Writer Syntax#delimiters
< (left angle bracket) in reports
Report Writer Syntax#delimiters
ABS function
Essbase List of Functions#@abs
absolute value
Essbase List of Functions#@abs
accounts tag
Essbase List of Functions#@isacctype
ACCUM function
Essbase List of Functions#@accum
ADDUSER ESSCMD command
ESSCMD Commands List#adduser
AFTER report writer command
Essbase Report Writer Commands#after
AGENTDELAY configuration setting
Essbase Configuration Settings#agentdelay
AGENTLOGMESSAGELEVEL configuration setting
Essbase Configuration Settings#agentlogmessagelevel
AGENTPORT configuration setting
Essbase Configuration Settings#agentport
AGENTTHREADS configuration setting
Essbase Configuration Settings#agentthreads
AGG calculation command
Calculation Commands List#agg
aggregating
Blank
aggregating: #MISSING values
Calculation Commands List#set_aggmissg
aggregating: only parents with same currency
Calculation Commands List#set_uptolocal
aggregating: values
Calculation Commands List#set_aggmissg
AGTSVRCONNECTIONS configuration setting
Essbase Configuration Settings#agtsvrconnections
alias function
Essbase List of Functions#@alias
alias tables
Blank
alias tables: in reports
Report Writer Command Groups#alias
alias tables: managing
ESSCMD Command Groups#alias
aliases. See Also alias tables or location aliases
ESSCMD Command Groups#localias
ALLANCESTORS function
Essbase List of Functions#@allancestors
ALLOCATE function
Essbase List of Functions#@allocate
allocation functions
Types of Functions#allocate
ALLSIBLINGS report writer command
Essbase Report Writer Commands#allsiblings
ALLSINAMEDIM report writer command
Essbase Report Writer Commands#allinsamedim
alter in MaxL
Blank
alter in MaxL: application
MaxL Language Reference: Statements#altapp
alter in MaxL: database
MaxL Language Reference: Statements#altdb
alter in MaxL: group
MaxL Language Reference: Statements#altgrp
alter in MaxL: system
MaxL Language Reference: Statements#altsys
alter in MaxL: user
MaxL Language Reference: Statements#altusr
ANCEST function
Essbase List of Functions#@ancest
ancestor-level data return
Blank
ancestor-level data return: based on shared ancestor value of current member
Essbase List of Functions#@ancestval
ancestor-level data return: from multiple dimensions
Essbase List of Functions#@mdancestval
ancestor functions
Blank
ancestor functions: selecting a member and a range of its ancestors
Essbase List of Functions#@iancestors
ancestor functions: selecting a member and all of its ancestors
Essbase List of Functions#@iallancestors
ancestor functions: selecting a range of the member's ancestors excluding the member
Essbase List of Functions#@ancestors
ancestor functions: selecting all ancestors of a member excluding the member
Essbase List of Functions#@allancestors
ancestor functions: selecting one ancestor of a member exclusing the member
Essbase List of Functions#@ancest
ANCESTORS function
Essbase List of Functions#@ancestors
ancestors in reports
ancestors: adding a member's ancestors only
iancestors: adding a member and its ancestors
ANCESTORS report writer command
Essbase Report Writer Commands#ancestors
ANCESTVAL function
Essbase List of Functions#@ancestval
application log
Blank
application log: error message controls
Essbase Configuration Settings#sslogunknown
application log: limiting data load messages
Essbase Configuration Settings#nomsgloggingondataerrorlimit
applications
Blank
applications: sample files used in this document
Technical Reference Introduction#sample
APPLYOTLCHANGEFILE ESSCMD command
ESSCMD Commands List#applyotlchangefile
ARCHIVE ESSCMD command
ESSCMD Commands List#archive
archiving with log files. See log files
Blank
ARRAY calculation command
Calculation Commands List#array
arrays
Calculation Commands List#array
ASYM report writer command
Essbase Report Writer Commands#asym
ATTRIBUTE function
Essbase List of Functions#@attribute
attribute information
Blank
attribute information: for a member
ESSCMD Commands List#getattrinfo
attribute information: for application and database
ESSCMD Commands List#getattributespecs
ATTRIBUTE report writer command
Essbase Report Writer Commands#attribute
ATTRIBUTEBVAL function
Essbase List of Functions#@attributebval
ATTRIBUTESVAL function
Essbase List of Functions#@attributesval
ATTRIBUTEVAL function
Essbase List of Functions#@attributeval
audience for Technical Reference
Technical Reference Introduction
AUTHENTICATIONMODULE configuration setting
Essbase Configuration Settings#authenticationmodule
average
Blank
average: of all values of expList
Essbase List of Functions#@avg
average: of specified member across a range
Essbase List of Functions#@avgrange
AVG function
Essbase List of Functions#@avg
AVGRANGE function
Essbase List of Functions#@avgrange
batch files
Blank
batch files: and report scripts
ESSCMD Batch Processing#reports
batch files: definition
ESSCMD Batch Processing#batch
batch files: examples
ESSCMD Batch Processing#samples
batch files: handling command errors in ESSCMD
ESSCMD Batch Processing#errors
batch files: running
ESSCMD Batch Processing#running
batch files: writing in ESSCMD
ESSCMD Batch Processing#writebatch
batch mode
Blank
batch mode: command line syntax for
ESSCMD Syntax Guidelines#commandline
batch mode: creating scripts for
ESSCMD Batch Processing#scripts
batch mode: error handling
ESSCMD Batch Processing#errors
batch processing in ESSCMD
ESSCMD Batch Processing#overview
BEFORE report writer command
Essbase Report Writer Commands#before
BEGINARCHIVE ESSCMD command
ESSCMD Commands List#beginarchive
BEGININCBUILDDIM ESSCMD command
ESSCMD Commands List#beginarchive
block locks
Blank
block locks: limiting number of locks
Essbase Configuration Settings#calclockblock
block locks: limiting the time a lock is held
Essbase Configuration Settings#locktimeout
BLOCKHEADERS report writer command
Essbase Report Writer Commands#blockheaders
blocks
Blank
blocks: calculating updated
Calculation Commands List#set_updatecalc
blocks: clearing
Calculation Commands List#clearblock
blocks: deleting
Calculation Commands List#clearblock
blocks: limiting number of
Essbase Configuration Settings#calclockblock
blocks: locking to calculate
Calculation Commands List#set_lockblock
Boolean functions
Types of Functions#boolean
BOTTOM report writer command
Essbase Report Writer Commands#bottom
BRACKETS report writer command
Essbase Report Writer Commands#brackets
buffer size for network communication
Essbase Configuration Settings#pipebuffersize
BUILDDIM ESSCMD command
ESSCMD Commands List#builddim
building dimensions
ESSCMD Command Groups#dimbuild
cache memory locking
Blank
cache memory locking: enabling/disabling (ESSCMD)
ESSCMD Commands List#setdbstateitem
cache memory locking: enabling/disabling (MaxL "cache pinning")
MaxL Language Reference: Statements#altdb
cache memory locking: getting information for a database
ESSCMD Commands List#getdbstate
CALC ESSCMD command
ESSCMD Commands List#calc
CALC ALL calculation command
Calculation Commands List#calc_all
CALC AVERAGE calculation command
Calculation Commands List#calc_average
CALC DIM calculation command
Calculation Commands List#calc_dim
CALC FIRST calculation command
Calculation Commands List#calc_first
CALC LAST calculation command
Calculation Commands List#calc_last
CALC TWOPASS calculation command
Calculation Commands List#calc_twopass
CALCCACHE configuration setting
Essbase Configuration Settings#calccache
CALCCACHEDEFAULT configuration setting
Essbase Configuration Settings#calccachedefault
CALCCACHEHIGH configuration setting
Essbase Configuration Settings#calccachehigh
CALCCACHELOW configuration setting
Essbase Configuration Settings#calccachelow
CALCCACHTBLMEMORY configuration setting
Essbase Configuration Settings#calchashtblmemory
CALCDEFAULT ESSCMD command
ESSCMD Commands List#calcdefault
CALCLINE ESSCMD command
ESSCMD Commands List#calcline
CALCLOCKBLOCK configuration setting
Essbase Configuration Settings#calclockblock
CALCMODE configuration setting
Essbase Configuration Settings#calcmode
CALCMODE function
Essbase List of Functions#@calcmode
CALCNOTICE configuration setting
Essbase Configuration Settings#calcnotice
CALCOPTCALCHASTBL configuration setting
Essbase Configuration Settings#calcoptcalchashtbl
CALCOPTFRMLBOTTOMUP configuration setting
Essbase Configuration Settings#calcoptfrmlbottomup
CALCPARALLEL configuration setting
CALCPARALLEL configuration setting
CALCTASKDIMS configuration setting
CALCTASKDIMS configuration setting
CALCULATE COLUMN report writer command
Essbase Report Writer Commands#calculate_column
CALCULATE ROW report writer command
Essbase Report Writer Commands#calculate_row
calculating
ESSCMD Command Groups#calc
calculating: and locking blocks concurrently
Calculation Commands List#set_lockblock
calculating: and optimizing flat database outlines
Calculation Commands List#set_calchashtbl
calculating: and restricting to a database subset
Calculation Commands List#fix_endfix
calculating: and types of calculations
Calculation Command Groups#comp
calculating: average members
Calculation Commands List#calc_average
calculating: columns and rows in reports
Report Writer Command Groups#calc
calculating: concurrently in the same database
Essbase Configuration Settings#exclusivecalc
calculating: currency conversions
Calculation Commands List#cconv
calculating: dirty blocks
Calculation Commands List#set_updatecalc
calculating: entire database
Calculation Commands List#calc_all
calculating: first members
Calculation Commands List#calc_first
calculating: formulas and aggregations
Calculation Commands List#calc_dim
calculating: last members
Calculation Commands List#calc_last
calculating: member formulas
Calculation Command Groups#formulas
calculating: missing values
Calculation Commands List#set_aggmissg
calculating: monitoring progress while
Calculation Commands List#set_notice
calculating: optimizing formulas on sparse dimensions while
Calculation Commands List#set_frmlbottomup
calculating: parents with same defined currency
Calculation Commands List#set_uptolocal
calculating: rows and columns in reports
Report Writer Command Groups#calc
calculating: specifying clean data blocks
Calculation Commands List#set_clearupdatestatus
calculating: specifying how many iterations
Calculation Commands List#loop_endloop
calculating: subsets of the database
Calculation Commands List#fix_endfix
calculating: temporary variables
Calculation Commands List#var
calculating: two-pass members
Calculation Commands List#calc_twopass
calculating: using Boolean functions
Types of Functions#boolean
calculating: using computational commands
Calculation Command Groups#comp
calculating: using conditional formulas
Calculation Command Groups#condition
calculating: using control flow commands
Calculation Command Groups#control
calculating: using data declaration commands
Calculation Command Groups#datadeclar
calculating: using default calc scripts
Calculation Commands Overview#overview
calculating: using financial functions
Types of Functions#financial
calculating: using Intelligent Calculation
Calculation Commands List#set_updatecalc
calculating: using interdependent formulas
Calculation Command Groups#interdep
calculating: using mathematical functions
Types of Functions#mathfunc
calculating: using mathematical operators
Calculation Operators#math
calculating: using MaxL
MaxL Language Reference: Statements#excalc
calculating: using member set functions
Types of Functions#function
calculating: using range functions
Types of Functions#financial
calculating: using relationship functions
Types of Functions#index
calculating: using SET calculation commands
Calculation Commands List#set
calculation command groups
Calculation Command Groups
calculation command groups: conditional commands
Calculation Command Groups#condition
calculation command groups: control flow commands
Calculation Command Groups#control
calculation command groups: data declaration commands
Calculation Command Groups#datadeclar
calculation command groups: functional (computation) commands
Calculation Command Groups#comp
calculation command groups: member formulas
Calculation Command Groups#formulas
calculation command types. See calculation command groups
Calculation Command Groups
calculation commands
Calculation Commands Overview
calculation commands: groups
Calculation Command Groups
calculation commands: list
alist
calculation operators
Calculation Operators
calculations
Blank
calculations: creating (MaxL)
MaxL Language Reference: Statements#crecalc
calculations: deleting (MaxL)
MaxL Language Reference: Statements#drpcalc
calculations: displaying information about the calculations
Calculation Commands List#set_msg
calculations: executing (MaxL)
MaxL Language Reference: Statements#excalc
calculations: granting (MaxL)
MaxL Language Reference: Statements#grant
calculations: setting the default (MaxL)
MaxL Language Reference: Statements#altdb
calculator caches
Blank
calculator caches: default size
Essbase Configuration Settings#calccachehigh
calculator caches: setting the size
Calculation Commands List#set_cache
calculator caches: whether Essbase uses
Essbase Configuration Settings#calccache
canceling operations in ESSCMD
ESSCMD Interactive Mode#cancel
case-sensitivity of member names
Essbase Configuration Settings#casesensitive
CASESENSITIVE configuration setting
Essbase Configuration Settings#casesensitive
cash flow's internal rate of return
Essbase List of Functions#@irr
CCONV calculation command
Calculation Commands List#cconv
CCTRACK configuration setting
Essbase Configuration Settings#cctrack
cells, replicated. See partitioning
Blank
CFG client file
Creating a Configuration File for the Client
CFG server file
Configuration File Overview
characters: underlining in a report
Essbase Report Writer Commands#ucharacters
CHG (outline change) file
Blank
CHG (outline change) file: applying
ESSCMD Commands List#applyotlchangefile
CHG (outline change) file: creating
ESSCMD Commands List#getpartitionotlchanges
CHG (outline change) file: purging after changes have been applied
ESSCMD Commands List#purgeotlchangefile
CHG (outline change) file: resetting time stamp
ESSCMD Commands List#resetotlchangetime
CHILDREN function
Essbase List of Functions#@children
CHILDREN report writer command
Essbase Report Writer Commands#children
clean status
Calculation Commands List#set_clearupdatestatus
CLEARALLROWCALC report writer command
Essbase Report Writer Commands#clearallrowcalc
CLEARBLOCK calculation command
Calculation Commands List#clearblock
CLEARDATA calculation command
Calculation Commands List#cleardata
clearing
Blank
clearing: blocks
Calculation Commands List#clearblock
clearing: data
Calculation Commands List#cleardata
CLEARLOGFILE configuration setting
Essbase Configuration Settings#clearlogfile
CLEARROWCALC report writer command
Essbase Report Writer Commands#clearrowcalc
client ESSBASE.CFG file
Creating a Configuration File for the Client (
COLHEADING report writer command
Essbase Report Writer Commands#colheading
column or row calculation commands
Report Writer Command Groups#calc
COLUMN report writer command
Essbase Report Writer Commands#column
columns
Blank
columns: calculating
Essbase Report Writer Commands#calculate_column
columns: displaying dimensions as
Essbase Report Writer Commands#calculate_column
columns: underlining in a report
Essbase Report Writer Commands#ucolumns
commands
Blank
commands: calculation
Calculation Commands List
commands: computation
Calculation Command Groups#comp
commands: control flow
Calculation Command Groups#control
commands: data declaration
Calculation Command Groups#datadeclar
commands: reiterating
Calculation Commands List#loop_endloop
commands: report
Essbase Report Writer Commands
COMMAS report writer command
Essbase Report Writer Commands#commas
COMMITBLOCKS configuration setting
Essbase Configuration Settings#commitblocks
COMMITDB ESSCMD command
ESSCMD Commands List#commitdb
completion notices for calculations
Calculation Commands List#set_notice
COMPOUND function
Essbase List of Functions#@compound
compounded growth calculation
Essbase List of Functions#@compoundgrowth
compounded interest calculation
Essbase List of Functions#@compound
COMPOUNDGROWTH function
Essbase List of Functions#@compoundgrowth
CONCATENATE function
Essbase List of Functions#@concatenate
concurrent calculations
Essbase Configuration Settings#exclusivecalc
conditional and logical operators
Calculation Operators#condition
conditional tests
Calculation Command Groups#condition
configuration file (ESSBASE.CFG)
Configuration File Overview
configuration file (ESSBASE.CFG): creating
Creating a Configuration File for the Client
Creating a Configuration File for the Server
configuration file (ESSBASE.CFG): settings
Essbase Configuration Settings
control flow commands
Calculation Command Groups#control
COPYAPP ESSCMD command
ESSCMD Commands List#copyapp
COPYDB ESSCMD command
ESSCMD Commands List#copydb
COPYFILTER ESSCMD command
ESSCMD Commands List#copyfilter
COPYOBJECT ESSCMD command
ESSCMD Commands List#copyobject
CORRELATION function
Essbase List of Functions#@correlation
COUNT function
Essbase List of Functions#@count
create in MaxL
Blank
create in MaxL: application
MaxL Language Reference: Statements#creapp
create in MaxL: calculation
MaxL Language Reference: Statements#crecalc
create in MaxL: database
MaxL Language Reference: Statements#credb
create in MaxL: filter
MaxL Language Reference: Statements#crefilt
create in MaxL: function
MaxL Language Reference: Statements#crefunc
create in MaxL: group
MaxL Language Reference: Statements#cregrp
create in MaxL: location alias
MaxL Language Reference: Statements#creloc
create in MaxL: macro
MaxL Language Reference: Statements#cremacro
create in MaxL: partition
MaxL Language Reference: Statements#crepart
create in MaxL: user
MaxL Language Reference: Statements#creusr
CREATEAPP ESSCMD command
ESSCMD Commands List#createapp
CREATEDB ESSCMD command
ESSCMD Commands List#createdb
CREATEGROUP ESSCMD command
ESSCMD Commands List#creategroup
CREATELOCATION ESSCMD command
ESSCMD Commands List#createlocation
CREATEUSER ESSCMD command
ESSCMD Commands List#createuser
CREATEVARIABLE ESSCMD command
ESSCMD Commands List#createvariable
CREATEVARIABLE ESSCMD command: MaxL equivalent (application-wide variable)
MaxL Language Reference: Statements#altapp
CREATEVARIABLE ESSCMD command: MaxL equivalent (database-wide variable)
MaxL Language Reference: Statements#altdb
CREATEVARIABLE ESSCMD command: MaxL equivalent (system-wide variable)
MaxL Language Reference: Statements#altsys
cross-dimensional operator (->)
Calculation Operators#Cross
cross-dimensional operator (->): (if needed) with member sets
Types of Functions#function
CURGEN function
Essbase List of Functions#@curgen
CURHEADING report writer command
Essbase Report Writer Commands#curheading
CURLEV function
Essbase List of Functions#@curlev
CURRENCY report writer command
Essbase Report Writer Commands#currency
currency conversions
Blank
currency conversions: calculating
Calculation Commands List#cconv
currency conversions: currency database informational commands
ESSCMD Command Groups#currency
currency conversions: displaying headings of
Essbase Report Writer Commands#curheading
currency conversions: modifying behavior of
Essbase Configuration Settings#cctrack
currency conversions: performing in a report
Essbase Report Writer Commands#currency
currency conversions: suppressing currency information in a report
Essbase Report Writer Commands#supcurheading
currency conversions: tracing system
Essbase Configuration Settings#cctrack
CURRMBR function
Essbase List of Functions#@currmbr
CURRMBRRANGE function
Essbase List of Functions#@currmbrrange
custom-defined functions
Custom-Defined Function Examples
custom-defined macro functions
Custom-Defined Macro Functions
custom-defined macro input parameters
Custom-Defined Macro Input Parameters
custome defined macros
Custom-Defined Macros
customing Essbase configuation
Creating a Configuration File for the Server (
data
Blank
data: appearance in reports
Report Writer Command Groups#format
data: clearing sections of
Calculation Commands List#cleardata
data: copying
Calculation Commands List#datacopy
data: exporting and reporting (MaxL)
MaxL Language Reference: Statements#hexport
data: importing (MaxL)
MaxL Language Reference: Statements#imp_data
data: loading (import in MaxL)
MaxL Language Reference: Statements#imp_data
data: loading, clearing, and exporting commands (ESSCMD)
ESSCMD Command Groups#data
data: ordering
Essbase Report Writer Commands#orderby
data: restricting ranges
Report Writer Command Groups#datarange
data declaration commands
Calculation Command Groups#datadeclar
data load messages in application log
Essbase Configuration Settings#nomsgloggingondataerrorlimit
data ordering commands
Report Writer Command Groups#dataorder
data range commands
Report Writer Command Groups#datarange
databases
Blank
databases: aggregating
Calculation Commands List#calc_all
databases: aggregating parent-child relationships
Calculation Commands List#agg
databases: altering (MaxL)
MaxL Language Reference: Statements#altdb
databases: calculating
Calculation Commands List#calc_all
databases: calculating (MaxL)
MaxL Language Reference: Statements#excalc
databases: clearing sections of data from
Calculation Commands List#cleardata
databases: consolidating values
Calculation Commands List#agg
databases: creating (MaxL)
MaxL Language Reference: Statements#credb
databases: deleting (MaxL)
MaxL Language Reference: Statements#drpdb
databases: exporting (MaxL)
MaxL Language Reference: Statements#hexport
databases: loading (MaxL)
MaxL Language Reference: Statements#imp_data
databases: managing (ESSCMD)
ESSCMD Command Groups#appdb
databases: managing (MaxL)
MaxL Language Reference: Statements#altdb
databases: restructuring incrementally
Essbase Configuration Settings#increstruc
DATACACHESIZE onfiguration setting
Essbase Configuration Settings#datacachesize
DATACOMPRESS configuration setting
Essbase Configuration Settings#datacompress
DATACOMPRESSIONTYPE configuration setting
Essbase Configuration Settings#datacompressiontype
DATACOPY calculation command
Calculation Commands List#datacopy
DATAERRORLIMIT configuration setting
Essbase Configuration Settings#dataerrorlimit
DATAFILECACHESIZE configuration setting
Essbase Configuration Settings#datafilecachesize
DDB (partition definition) file
ESSCMD Commands List#printpartitiondeffile
DECIMAL report writer command
Essbase Report Writer Commands#decimal
DECLINE function
Essbase List of Functions#@decline
default values for function parameters
Function Parameters and Syntax
DEFRAG ESSCMD command
ESSCMD Commands List#defrag
DELETEAPP ESSCMD command
ESSCMD Commands List#deleteapp
DELETEDB ESSCMD command
ESSCMD Commands List#deletedb
DELETEGROUP ESSCMD command
ESSCMD Commands List#deletegroup
DELETELOCATION ESSCMD command
ESSCMD Commands List#deletelocation
DELETELOG ESSCMD command
ESSCMD Commands List#deletelog
DELETEUSER ESSCMD command
ESSCMD Commands List#deleteuser
DELETEVARIABLE ESSCMD command
ESSCMD Commands List#deletevariable
deleting in MaxL. See drop in MaxL
Blank
DELIMITEDMSG configuration setting
Essbase Configuration Settings#delimitedmsg
DELIMITER configuration setting
Essbase Configuration Settings#delimiter
depreciation calculation methods
Blank
depreciation calculation methods: declining balance
Essbase List of Functions#@decline
depreciation calculation methods: straight line
Essbase List of Functions#@sln
depreciation calculation methods: sum of year's digits
Essbase List of Functions#@syd
DESCENDANTS function
Essbase List of Functions#@descendants
DESCENDANTS report writer command
Essbase Report Writer Commands#descendants
DIMBOTTOM report writer command
Essbase Report Writer Commands#dimbottom
DIMEND report writer command
Essbase Report Writer Commands#dimend
dimensions
Blank
dimensions: aggregating sparse
Calculation Commands List#agg
dimensions: building
ESSCMD Command Groups#dimbuild
dimensions: calculating and tracking exchange rates
Essbase Configuration Settings#cctrack
dimensions: roots and leaves
Hyperion Essbase Overview of Functions#genlev
dimensions: row: in reports
Essbase Report Writer Commands#row
dimensions: specifying as report page members
Essbase Report Writer Commands#page
DIMTOP report writer command
Essbase Report Writer Commands#dimtop
DIRECTIO configuration setting
Essbase Configuration Settings#directio
dirty status
Calculation Commands List#set_updatecalc
DISABLELOGIN ESSCMD command
ESSCMD Commands List#disablelogin
DISCOUNT function
Essbase List of Functions#@discount
DISKVOLUMES configuration setting
Essbase Configuration Settings#diskvolumes
DISPLAYALIAS ESSCMD command
ESSCMD Commands List#displayalias
display in MaxL
Blank
display in MaxL: application
MaxL Language Reference: Statements#dispapp
display in MaxL: calculation
MaxL Language Reference: Statements#dispclc
display in MaxL: database
MaxL Language Reference: Statements#dispdb
display in MaxL: disk volume
MaxL Language Reference: Statements#dispdvol
display in MaxL: filter
MaxL Language Reference: Statements#dispfilt
display in MaxL: filter row
MaxL Language Reference: Statements#dspfltrw
display in MaxL: function
MaxL Language Reference: Statements#dispfunc
display in MaxL: group
MaxL Language Reference: Statements#dispgrp
display in MaxL: location alias
MaxL Language Reference: Statements#disploca
display in MaxL: macro
MaxL Language Reference: Statements#dispmacr
display in MaxL: partition
MaxL Language Reference: Statements#disppart
display in MaxL: privilege
MaxL Language Reference: Statements#disppriv
display in MaxL: system
MaxL Language Reference: Statements#dispsys
display in MaxL: user
MaxL Language Reference: Statements#dispuser
display in MaxL: variable
MaxL Language Reference: Statements#dispvarb
DLSINGLETHREADPERSTAGE configuration setting
Essbase Configuration Settings#dlsinglethreadperstage
DLTHREADSPREPARE configuration setting
Essbase Configuration Settings#dlthreadsprepare
DLTHREADSWRITE configuration setting
Essbase Configuration Settings#dlthreadswrite
document conventions for Technical Reference
Technical Reference Introduction
drop in MaxL
Blank
drop in MaxL: application
MaxL Language Reference: Statements#drpapp
drop in MaxL: calculation
MaxL Language Reference: Statements#drpcalc
drop in MaxL: database
MaxL Language Reference: Statements#drpdb
drop in MaxL: filter
MaxL Language Reference: Statements#drpfilt
drop in MaxL: function
MaxL Language Reference: Statements#drpfunc
drop in MaxL: group
MaxL Language Reference: Statements#drpgrp
drop in MaxL: location alias
MaxL Language Reference: Statements#drploc
drop in MaxL: macro
MaxL Language Reference: Statements#drpmacro
drop in MaxL: partition
MaxL Language Reference: Statements#drppart
drop in MaxL: user
MaxL Language Reference: Statements#drpusr
DUPLICATE report writer command
Essbase Report Writer Commands#duplicate
DYNCALCCACHEBLKRELEASE configuration setting
Essbase Configuration Settings#dyncalccacheblkrelease
DYNCALCCACHEBLKTIMEOUT configuration setting
Essbase Configuration Settings#dyncalccacheblktimeout
DYNCALCCACHECOMPRBLKBUFSIZE configuration setting
Essbase Configuration Settings#dyncalccachecomprblkbufsize
DYNCALCCACHEMAXSIZE configuration setting
Essbase Configuration Settings#dyncalccachemaxsize
DYNCALCCACHEONLY configuration setting
Essbase Configuration Settings#dyncalccacheonly
DYNCALCCACHEWAITFORBLK configuration setting
Essbase Configuration Settings#dyncalccachewaitforblk
echo in MaxL
MaxL Language Reference: Command Shell#hecho
ELSE calculation command
Calculation Commands List#else
ELSE directive (@@ELSE)
@@ELSE
ELSEIF calculation command
Calculation Commands List#elseif
ENABLELOGIN ESSCMD command
ESSCMD Commands List#ENABLELOGIN
ENDARCHIVE ESSCMD command
ESSCMD Commands List#ENDARCHIVE
ENDHEADING report writer command
Essbase Report Writer Commands#endheading
ENDIF calculation command
Calculation Commands List#endif
ENDIF directive (@@ENDIF)
@@ENDIF
ENDINCBUILDDIM ESSCMD command
ESSCMD Commands List#ENDINCBUILDDIM
entering commands in ESSCMD
ESSCMD Interactive Mode#enter
equations in calculation scripts
Calculation Command Groups#formulas
ERROR directive (@@ERROR)
@@ERROR
error handling and logging
Blank
error handling and logging: determining how many records can be written during a data load
Essbase Configuration Settings#dataerrorlimit
error handling and logging: determining where data is written
Essbase Configuration Settings#exceptionlogoverwrite
error handling and logging: ERROR macro function
@@ERROR
error handling and logging: in ESSCMD
ESSCMD Command Groups#errlog
error handling and logging: in MaxL
MaxL Language Reference: Command Shell#hspool
error handling and logging: spreadsheet error messages
Essbase Configuration Settings#sslogunknown
error handling and logging: with unknown member names
Essbase Configuration Settings#sslogunknown
Essbase functions
Hyperion Essbase Overview of Functions
Essbase Perl Module (ESSBASE.PM)
MaxL Language Reference: Perl Extension
Essbase settings
Creating a Configuration File for the Server (
ESSBASE.CFG (configuration file)
Configuration File Overview
ESSBASE.CFG (configuration file): creating for client
Creating a Configuration File for the Client (
ESSBASE.CFG (configuration file): creating for server
Creating a Configuration File for the Server
ESSBASE.CFG (configuration file): settings
Essbase Configuration Settings
ESSCMD
ESSCMD Overview
ESSCMD: command groups
ESSCMD Command Groups
ESSCMD: multi-user considerations
ESSCMD Overview#multi
ESSCMD: operating system platforms
ESSCMD Overview#os
ESSCMD: quitting
ESSCMD Getting Started#quit
ESSCMD: starting
ESSCMD Getting Started#start
ESSCMD: syntax guidelines
ESSCMD Syntax Guidelines
ESSCMD batch mode
ESSCMD Batch Processing
ESSCMD batch mode: batch processing
ESSCMD Batch Processing#overview
ESSCMD batch mode: handling command errors in batch files
ESSCMD Batch Processing#errors
ESSCMD batch mode: importing and calculating data (sample)
ESSCMD Batch Processing#batch
ESSCMD batch mode: scheduling report printing (sample)
ESSCMD Batch Processing#reports
ESSCMD batch mode: updating a SQL script (sample)
ESSCMD Batch Processing#sql
ESSCMD batch mode: writing batch files
ESSCMD Batch Processing#write
ESSCMD interactive mode
ESSCMD Interactive Mode
ESSCMD interactive mode: canceling operations in interactive mode
ESSCMD Interactive Mode#cancel
ESSCMD interactive mode: entering commands
ESSCMD Interactive Mode#enter
ESSCMD interactive mode: logging into the server
ESSCMD Interactive Mode#logging
essmsh (MaxL shell)
MaxL Language Reference: Command Shell
EUROPEAN report writer command
Essbase Report Writer Commands#european
EXCEPTIONLOGOVERWRITE configuration setting
Essbase Configuration Settings#exceptionlogoverwrite
EXCLUSIVECALC configuration setting
Essbase Configuration Settings#exclusivecalc
execute calculation in MaxL
MaxL Language Reference: Statements#excalc
EXIT ESSCMD command
ESSCMD Commands List#exit
EXP function
Essbase List of Functions#@exp
expList
Function Parameters and Syntax#expl
EXPORT ESSCMD command
ESSCMD Commands List#export
export in MaxL
MaxL Language Reference: Statements#hexport
exporting data in parallel. See parallel export
Blank
EXPORTTHREADS configuration setting
Essbase Configuration Settings#exportthreads
expression
Function Parameters and Syntax#exp
external authentication
Essbase Configuration Settings#authenticationmodule
FACTORIAL function
Essbase List of Functions#@factorial
FEEDON report writer command
Essbase Report Writer Commands#feedon
filters
ESSCMD Command Groups#filters
financial functions
Types of Functions#financial
first: calculating members tagged as
Calculation Commands List#calc_first
FIX and ENDFIX calculation commands
Calculation Commands List#fix_endfix
FIXCOLUMNS report writer command
Essbase Report Writer Commands#fixcolumns
forecasting functions
Types of Functions#forecast
format commands in report writer
Report Writer Command Groups#format
FORMATCOLUMNS report writer command
Essbase Report Writer Commands#formatcolumns
formatting conventions in this document
Technical Reference Introduction
formulas for members in calc scripts
Calculation Command Groups#formulas
formulas for members in calc scripts: conditional
Calculation Command Groups#condition
formulas for members in calc scripts: interdependent
Calculation Command Groups#interdep
function parameters used in this document
Function Parameters and Syntax#fmparam
functions
Hyperion Essbase Overview of Functions
functions: custom-defined function examples
Custom-Defined Function Examples
GEN function
Essbase List of Functions#@gen
generations
Blank
generations: and levels, described
Hyperion Essbase Overview of Functions#genlev
generations: determining generation of member
Essbase List of Functions#@genmbrs
generations: determining generation of member in relation to top member
Essbase List of Functions#@curgen
generations: determining whether a member is of a certain generation
Essbase List of Functions#@isgen
generations: determining whether members are of the same generation
Essbase List of Functions#@issamegen
generations: selecting all members with a shared generation
Essbase List of Functions#@genmbrs
GENMBRS function
Essbase List of Functions#@genmbrs
GETALLREPLCELLS ESSCMD command
ESSCMD Commands List#getallreplcells
GETAPPACTIVE ESSCMD command
ESSCMD Commands List#getappstate
GETAPPINFO ESSCMD command
ESSCMD Commands List#getappinfo
GETAPPSTATE ESSCMD command
ESSCMD Commands List#getappstate
GETATTRIBUTESPECS ESSCMD command
ESSCMD Commands List#getattributespecs
GETATTRINFO ESSCMD command
ESSCMD Commands List#getattrinfo
GETCRDB ESSCMD command
ESSCMD Commands List#getcrdb
GETCRDBINFO ESSCMD command
ESSCMD Commands List#getcrdbinfo
GETCRRATE ESSCMD command
ESSCMD Commands List#getcrrate
GETCRTYPE ESSCMD command
ESSCMD Commands List#getcrtype
GETDBACTIVE ESSCMD command
ESSCMD Commands List#getdbactive
GETDBINFO ESSCMD command
ESSCMD Commands List#getdbinfo
GETDBSTATE ESSCMD command
ESSCMD Commands List#getdbstate
GETDBSTATS ESSCMD command
ESSCMD Commands List#getdbstats
GETDEFAULTCALC ESSCMD command
ESSCMD Commands List#getdefaultcalc
GETMBRCALC ESSCMD command
ESSCMD Commands List#getmbrcalc
GETMBRINFO ESSCMD command
ESSCMD Commands List#getmbrinfo
GETMEMBERS ESSCMD command
ESSCMD Commands List#getmembers
GETPARTITIONOTLCHANGES ESSCMD command
ESSCMD Commands List#getpartitionotlchanges
GETPERFSTATS configuration setting
Performance Statistics#getperfstats
GETUPDATEDREPLCELLS ESSCMD command
ESSCMD Commands List#getupdatedreplcells
GETUSERINFO ESSCMD command
ESSCMD Commands List#getuserinfo
GETVERSION ESSCMD command
ESSCMD Commands List#getversion
GOTO ESSCMD command
ESSCMD Commands List#getversion
grant in MaxL
MaxL Language Reference: Statements#grant
GRIDEXPANSION configuration setting
Essbase Configuration Settings#gridexpansion
GRIDEXPANSIONMESSAGES configuration setting
Essbase Configuration Settings#gridexpansionmessages
GROWTH function
Essbase List of Functions#@growth
HAENABLE configuration setting
Essbase Configuration File Settings#haenable
HAMAXNUMCONNECTION configuration setting
Essbase Configuration File Settings#hamaxnumconnection
HAMAXNUMSQLQUERY configuration setting
Essbase Configuration File Settings#hamaxnumsqlquery
HAMAXQUERYROWS configuration setting
Essbase Configuration File Settings#hamaxqueryrows
HAMAXQUERYTIME configuration setting
Essbase Configuration File Settings#hamaxquerytime
HAMEMORYCACHESIZE configuration setting
Essbase Configuration File Settings#hamemorycachesize
HARETRIEVENUMROW configuration setting
Essbase Configuration File Settings#haretrievenumrow
HEADING report writer command
Essbase Report Writer Commands#heading
headings of pages in reports. See page headings using report writer
Blank
HELP ESSCMD command
ESSCMD Commands List#help
Hybrid Analysis configuration settings
Blank
Hybrid Analysis configuration settings: HAENABLE
Essbase Configuration File Settings#haenable
Hybrid Analysis configuration settings: HAMAXNUMCONNECTION
Essbase Configuration File Settings#hamaxnumconnection
Hybrid Analysis configuration settings: HAMAXNUMSQLQUERY
Essbase Configuration File Settings#hamaxnumsqlquery
Hybrid Analysis configuration settings: HAMAXQUERYROWS
Essbase Configuration File Settings#hamaxqueryrows
Hybrid Analysis configuration settings: HAMAXQUERYTIME
Essbase Configuration File Settings#hamaxquerytime
Hybrid Analysis configuration settings: HAMEMORYCACHESIZE
Essbase Configuration File Settings#hamemorycachesize
Hybrid Analysis configuration settings: HARETRIEVENUMROW (not a query governor)
Essbase Configuration File Settings#haretrievenumrow
IALLANCESTORS function
Essbase List of Functions#@iallancestors
IANCESTORS function
Essbase List of Functions#@iancestors
IANCESTORS report writer command
Essbase Report Writer Commands#iancestors
ICHILDREN function
Essbase List of Functions#@ichildren
ICHILDREN report writer command
Essbase Report Writer Commands#ichildren
IDESCENDANTS function
Essbase List of Functions#@idescendants
IDESCENDANTS report writer command
Essbase Report Writer Commands#idescendants
IF calculation command
Calculation Commands List#if
IFERROR ESSCMD command
ESSCMD Commands List#iferror
IFSTRCMP directive (@@IFSTRCMP)
@@IFSTRCMP
ILSIBLINGS function
Essbase List of Functions#@ilsiblings
IMMHEADING report writer command
Essbase Report Writer Commands#immheading
IMPORT ESSCMD command
ESSCMD Commands List#import
import in MaxL
blank.htm
import in MaxL: data
MaxL Language Reference: Statements#imp_data
import in MaxL: dimensions
MaxL Language Reference: Statements#imp_dims
import in MaxL: lro
MaxL Language Reference: Statements#imp_lros
importing and calculating data in ESSCMD (sample)
ESSCMD Batch Processing#import
INCBUILDDIM ESSCMD command
ESSCMD Commands List#incbuilddim
INCEMPTYROWS report writer command
Essbase Report Writer Commands#incemptyrows
INCFORMATS report writer command
Essbase Report Writer Commands#incformats
INCMASK report writer command
Essbase Report Writer Commands#incmask
INCMISSINGROWS report writer command
Essbase Report Writer Commands#incmissingrows
incremental restructuring
Essbase Configuration Settings#increstruc
INCRESTRUC configuration setting
Essbase Configuration Settings#increstruc
INCZERROWS report writer command
Essbase Report Writer Commands#inczerorows
INDENT report writer command
Essbase Report Writer Commands#indent
INDENTGEN report writer command
Essbase Report Writer Commands#indentgen
INDEXCACHESIZE configuration setting
Essbase Configuration Settings#indexcachesize
INDEXPAGESIZE configuration setting
Essbase Configuration Settings#indexpagesize
INT function
Essbase List of Functions#@int
integer values
Essbase List of Functions#@int
intelligent calculation
Blank
intelligent calculation: specifying default setting
Essbase Configuration Settings#updatecalc
intelligent calculation: turning it on or off
Calculation Commands List#set_updatecalc
interactive mode in ESSCMD
ESSCMD Interactive Mode
interdependent formulas
Calculation Command Groups#interdep
INTEREST function
Essbase List of Functions#@interest
internal rates of return
Essbase List of Functions#@irr
IPARENT report writer command
Essbase Report Writer Commands#iparent
IRDESCENDANTS function
Essbase List of Functions#@irdescendants
IRR function
Essbase List of Functions#@irr
IRSIBLINGS function
Essbase List of Functions#@irsiblings
ISACCTYPE function
Essbase List of Functions#@isacctype
ISANCEST function
Essbase List of Functions#@isancest
ISCHILD function
Essbase List of Functions#@ischild
ISDESC function
Essbase List of Functions#@isdesc
ISGEN function
Essbase List of Functions#@isgen
ISIANCEST function
Essbase List of Functions#@isiancest
ISIBLINGS function
Essbase List of Functions#@isiblings
ISICHILD function
Essbase List of Functions#@isichild
ISIDESC function
Essbase List of Functions#@isidesc
ISIPARENT function
Essbase List of Functions#@isiparent
ISISIBLING function
Essbase List of Functions#@isisibling
ISLEV function
Essbase List of Functions#@islev
ISMBR function
Essbase List of Functions#@ismbr
ISPARENT function
Essbase List of Functions#@isparent
ISSAMEGEN function
Essbase List of Functions#@issamegen
ISSAMELEV function
Essbase List of Functions#@issamelev
ISSIBLING function
Essbase List of Functions#@issibling
ISUDA function
Essbase List of Functions#@isuda
JVMMODULELOCATION configuration setting
Essbase Configuration Settings#jvmmodulelocation
keywords in MaxL
MaxL Language Reference: Definitions#alphabet
last: calculating members tagged as
Calculation Commands List#calc_last
LATEST report writer command
Essbase Report Writer Commands#latest
LEV function
Essbase List of Functions#@lev
levels
Blank
levels: and generations described
Hyperion Essbase Overview of Functions#genlev
levels: determining level of a member
Essbase List of Functions#@lev
levels: determining level of member in relation to the bottom-most descendant
Essbase List of Functions#@curlev
levels: determining whether a member is of a certain level
Essbase List of Functions#@islev
levels: determining whether members are of the same level
Essbase List of Functions#@issamelev
levels: selecting all members with a shared level
Essbase List of Functions#@levmbrs
LEVMBRS function
Essbase List of Functions#@levmbrs
LINK report writer command
Essbase Report Writer Commands#link
LIST function
Essbase List of Functions#@list
LISTALIASES ESSCMD command
ESSCMD Commands List#listaliases
LISTAPP ESSCMD command
ESSCMD Commands List#listapp
LISTDB ESSCMD command
ESSCMD Commands List#listdb
LISTFILES ESSCMD command
ESSCMD Commands List#listfiles
LISTFILTERS ESSCMD command
ESSCMD Commands List#listfilters
LISTGROUPS ESSCMD command
ESSCMD Commands List#listgroups
LISTGROUPUSERS ESSCMD command
ESSCMD Commands List#listgroupusers
LISTLINKEDOBJECTS ESSCMD command
ESSCMD Commands List#listlinkedobjects
LISTLOCATIONS ESSCMD command
ESSCMD Commands List#listlocations
LISTLOCKS ESSCMD command
ESSCMD Commands List#listlocks
LISTLOGINS ESSCMD command
ESSCMD Commands List#listlogins
LISTOBJECTS ESSCMD command
ESSCMD Commands List#listobjects
LISTUSERS ESSCMD command
ESSCMD Commands List#listusers
LISTVARIABLES ESSCMD command
ESSCMD Commands List#listvariables
LMARGIN report writer command
Essbase Report Writer Commands#lmargin
LN function
Essbase List of Functions#@ln
LOADALIAS ESSCMD command
ESSCMD Commands List#loadalias
LOADAPP ESSCMD command
ESSCMD Commands List#loadapp
LOADDATA ESSCMD command
ESSCMD Commands List#loaddata
LOADDB ESSCMD command
ESSCMD Commands List#loaddb
loading data (MaxL). See importing in MaxL, data
blank.htm
location aliases
ESSCMD Command Groups#localias
location aliases: creating (ESSCMD)
ESSCMD Commands List#createlocation
location aliases: creating (MaxL)
MaxL Language Reference: Statements#creloc
location aliases: deleting (ESSCMD)
ESSCMD Commands List#deletelocation
location aliases: deleting (MaxL)
MaxL Language Reference: Statements#drploc
location aliases: listing (ESSCMD)
ESSCMD Commands List#listlocations
location aliases: listing (MaxL)
MaxL Language Reference: Statements#disploca
locks
Blank
locks: limiting number of blocks
Essbase Configuration Settings#calclockblock
locks: limiting time users can hold
Essbase Configuration Settings#locktimeout
locks: viewing and removing
ESSCMD Command Groups#filters
LOCKTIMEOUT configuration setting
Essbase Configuration Settings#locktimeout
log delimiter
Essbase Configuration Settings#delimitedmsg
log files
Blank
log files: determining overwrite
Essbase Configuration Settings#clearlogfile
log files: MaxL
MaxL Language Reference: Command Shell#hspool
log files: outline changes
Essbase Configuration Settings#outlinechangelog
log files: spreadsheet updates
Essbase Configuration Settings#ssaudit
log files: timing queries and reports
Essbase Configuration Settings#timingmessages
LOG function
Essbase List of Functions#@log
LOG10 function
Essbase List of Functions#@log10
logging into the server in ESSCMD
ESSCMD Interactive Mode#logging
logical and conditional operators
Calculation Operators#condition
LOGIN ESSCMD command
ESSCMD Commands List#login
login in MaxL
MaxL Language Reference: Command Shell#hlogin
LOGMESSAGELEVEL configuration setting
Essbase Configuration Settings#logmessagelevel
LOGOUT ESSCMD command
ESSCMD Commands List#logout
logout in MaxL
MaxL Language Reference: Command Shell#hlogout
LOGOUTALLUSERS ESSCMD command
ESSCMD Commands List#logoutallusers
LOGOUTUSER ESSCMD command
ESSCMD Commands List#logoutuser
LOOP and ENDLOOP calculation commands
Calculation Commands List#loop_endloop
LROONSHAREDMBR configuration setting
Essbase Configuration Settings#lroonsharedmbr
LSIBLINGS function
Essbase List of Functions#@lsiblings
Lx directive (@@Lx)
@@Lx
macro functions. See member set functions
Types of Functions#function
macros: custom-defined
Custom-Defined Macros
MASK report writer command
Essbase Report Writer Commands#mask
MATCH function
Essbase List of Functions#@match
MATCH report writer command
Essbase Report Writer Commands#match
mathematical functions
Types of Functions#mathfunc
mathematical operators
Calculation Operators#math
MAX function
Essbase List of Functions#@max
maximum value of expessions
function that retrieves maximum value
function that retrieves maximum value, with skipping enabled
MaxL
MaxL: Home
MaxL: BNF Diagrams
MaxL Language Reference: BNF Diagrams
MaxL: command shell
MaxL Language Reference: Command Shell
MaxL: definitions
MaxL Language Reference: Definitions
MaxL: help with diagrams in this document
MaxL Language Reference: BNF Diagrams
MaxL: nesting scripts
MaxL Language Reference: Command Shell#hinclude
MaxL: Perl Module
MaxL Language Reference: Perl Extension
MaxL: security
MaxL Language Reference: Definitions#privileges
MaxL: starting
MaxL Language Reference: Command Shell#hinvoke
MaxL: statements
MaxL Language Reference: Statements
MaxL: stopping
MaxL Language Reference: Command Shell#hlogout
MaxL: variables
MaxL Language Reference: Command Shell#hsyntax
MAXLOGINS configuration setting
Essbase Configuration Settings#maxlogins
MAXRANGE function
Essbase List of Functions#@maxrange
MAXS function
Essbase List of Functions#@maxs
MAXSRANGE function
Essbase List of Functions#@maxsrange
mbrList
Function Parameters and Syntax#mbrlst
mbrName
Function Parameters and Syntax#mbr
MDALLOCATE function
Essbase List of Functions#@mdallocate
MDANCESTVAL function
Essbase List of Functions#@mdancestval
MDPARENTVAL function
Essbase List of Functions#@mdparentval
MDSHIFT function
Essbase List of Functions#@mdshift
MEDIAN function
Essbase List of Functions#@median
MEMBER function
Essbase List of Functions#@member
member set functions
Types of Functions#function
members
Blank
members: case-sensitivity of names
Essbase Configuration Settings#casesensitive
members: descendants
Essbase List of Functions#@descendants
members: determining location of
Hyperion Essbase Overview of Functions#genlev
members: formulas in calculation scripts
Calculation Command Groups#formulas
members: mbrName
Function Parameters and Syntax#mbr
members: names and aliases in report writer
Report Writer Command Groups#alias
members: selecting and sorting in report writer
Report Writer Command Groups#selectsort
MERGE function
Essbase List of Functions#@merge
MIN function
Essbase List of Functions#@min
minimum value of expressions
@min function
@mins function
MINRANGE function
Essbase List of Functions#@minrange
MINS function
Essbase List of Functions#@mins
MINSRANGE function
Essbase List of Functions#@minsrange
missing values (#MISSING)
Blank
missing values (#MISSING): aggregating
Calculation Commands List#set_aggmissg
missing values (#MISSING): clearing blocks
Calculation Commands List#clearblock
missing values (#MISSING): clearing data
Calculation Commands List#cleardata
missing values (#MISSING): displaying empty rows in report writer
Essbase Report Writer Commands#incemptyrows
missing values (#MISSING): displaying missing rows in report writer
Essbase Report Writer Commands#incmissingrows
missing values (#MISSING): resetting name of a calc row in report writer to #MISSING
Essbase Report Writer Commands#clearrowcalc
missing values (#MISSING): substituting with a text label in report writer
Essbase Report Writer Commands#missingtext
MISSINGTEXT report writer command
Essbase Report Writer Commands#missingtext
MOD function
Essbase List of Functions#@mod
MODE function
Essbase List of Functions#@mode
MOVAVG function
Essbase List of Functions#@movavg
MOVMAX function
Essbase List of Functions#@movmax
MOVMED function
Essbase List of Functions#@movmed
MOVMIN function
Essbase List of Functions#@movmin
multiple-user considerations in ESSCMD
ESSCMD Overview#multi
multiple dimensions
Blank
multiple dimensions: ancestor-level data return
Essbase List of Functions#@mdancestval
multiple dimensions: parent-level data return
Essbase List of Functions#@mdparentval
multiple dimensions: shifting data values across
Essbase List of Functions#@mdshift
MULTIPLESITEMAPMEMCHECK configuration setting
Essbase Configuration Settings#multiplebitmapmemcheck
n, integer value
Function Parameters and Syntax#n
NAME function
Essbase List of Functions#@name
names in MaxL
MaxL Language Reference: Definitions#alphabet
NAMESCOL report writer command
Essbase Report Writer Commands#namescol
NAMESON report writer command
Essbase Report Writer Commands#nameson
NAMEWIDTH report writer command
Essbase Report Writer Commands#namewidth
nested IF statements
Calculation Commands List#if
net present value
Essbase List of Functions#@npv
NETDELAY configuration setting
Essbase Configuration Settings#netdelay
NETNPCONNECTTIMEOUT configuration setting
Essbase Configuration Settings#netnpconnecttimeout
NETRETRYCOUNT configuration setting
Essbase Configuration Settings#netretrycount
network
Blank
network: delay time
Essbase Configuration Settings#netdelay
network: Named Pipes
Essbase Configuration Settings#netnpconnecttimeout
network: retry connections
Essbase Configuration Settings#netretrycount
NEWPAGE report writer command
Essbase Report Writer Commands#newpage
NEXT function
Essbase List of Functions#@next
NEXTS function
Essbase List of Functions#@nexts
NODENAME configuration setting
Essbase Configuration Settings#nodename
NOINDENTGEN report writer command
Essbase Report Writer Commands#noindentgen
NOMSGLOGGINGONDATAERRORLIMIT configuration setting
Essbase Configuration Settings#nomsgloggingondataerrorlimit
NOPAGEONDIMENSION report writer command
Essbase Report Writer Commands#nopageondimension
NOROWREPEAT report writer command
Essbase Report Writer Commands#norowrepeat
NOSKIPONDIMENSION report writer command
Essbase Report Writer Commands#noskipondimension
notices for calculation progress
Calculation Commands List#set_notice
NOUNAMEONDIM report writer command
Essbase Report Writer Commands#nounameondim
NPV function
Essbase List of Functions#@npv
numbers in MaxL
MaxL Language Reference: Definitions#alphabet
numerical precision used in comparing digits
Essbase Configuration Settings#nodename
NUMERICPRECISION configuration setting
Essbase Configuration Settings#numericprecision
objects: database
ESSCMD Command Groups#objects
OFFCOLCALCS report writer command
Essbase Report Writer Commands#offcolcalcs
OFFROWCALCS report writer command
Essbase Report Writer Commands#offrowcalcs
OFSAMEGEN report writer command
Essbase Report Writer Commands#ofsamegen
ONCOLCALCS report writer command
Essbase Report Writer Commands#oncolcalcs
ONROWCALCS report writer command
Essbase Report Writer Commands#onrowcalcs
ONSAMELEVELAS report writer command
Essbase Report Writer Commands#onsamelevelas
operating system platforms in ESSCMD
ESSCMD Overview#os
operators
calculation operators
operators: conditional and logical
Calculation Operators#condition
operators: cross-dimensional (->)
Calculation Operators#cross
operators: mathematical
Calculation Operators#math
ORDER report writer command
Essbase Report Writer Commands#order
ORDERBY report writer command
Essbase Report Writer Commands#orderby
OUTALT report writer command
Essbase Report Writer Commands#outalt
OUTALTMBR report writer command
Essbase Report Writer Commands#outaltmbr
OUTALTNAMES report writer command
Essbase Report Writer Commands#outaltnames
OUTALTSELECT report writer command
Essbase Report Writer Commands#outaltselect
outline changes
Essbase Configuration Settings#outlinechangelog
outline information, viewing
ESSCMD Command Groups#otlinfo
outline synchronization
ESSCMD Command Groups#otlsync
OUTLINECHANGELOG configuration setting
Essbase Configuration Settings#outlinechangelog
OUTLINECHANGELOGSIZE configuration setting
Essbase Configuration Settings#outlinechangelogfilesize
OUTMBRALT report writer command
Essbase Report Writer Commands#outmbralt
OUTMBRNAMES report writer command
Essbase Report Writer Commands#outmbrnames
output
Blank
output: exporting in MaxL
MaxL Language Reference: Statements#hexport
output: generating a report
Essbase Report Writer Commands#!
output: in MaxL
MaxL Language Reference: Command Shell#hspool
output: resuming in a report
Essbase Report Writer Commands#output
output: suppressing while running a report
Essbase Report Writer Commands#supoutput
output: zero values as text in a report
Essbase Report Writer Commands#zerotext
OUTPUT ESSCMD command
ESSCMD Commands List#output
OUTPUT report writer command
Essbase Report Writer Commands#output
page breaks in report writer
Blank
page breaks in report writer: enabling when maximum number of lines is exceeded
Essbase Report Writer Commands#feedon
page breaks in report writer: inserting
Essbase Report Writer Commands#newpage
page breaks in report writer: suppressing when maximum number of lines is exceeded
Essbase Report Writer Commands#supfeed
page headings using report writer
Blank
page headings using report writer: defining in place of current
Essbase Report Writer Commands#startheading
page headings using report writer: displaying
Essbase Report Writer Commands#heading
page headings using report writer: displaying before next row
Essbase Report Writer Commands#pageheading
page headings using report writer: displaying immediately
Essbase Report Writer Commands#immheading
page headings using report writer: ending definition of
Essbase Report Writer Commands#endheading
page headings using report writer: suppressing
Essbase Report Writer Commands#supheading
page headings using report writer: suppressing with other formatting
Essbase Report Writer Commands#supall
PAGE report writer command
Essbase Report Writer Commands#page
PAGEHEADING report writer command
Essbase Report Writer Commands#pageheading
PAGELENGTH report writer command
Essbase Report Writer Commands#pagelength
PAGEONDIMENSION report writer command
Essbase Report Writer Commands#pageondimension
pages using report writer
Blank
pages using report writer: column formatting
Essbase Report Writer Commands#column
pages using report writer: inserting
Essbase Report Writer Commands#newpage
pages using report writer: row formatting
Row report writer commands
pages using report writer: setting center lines
Essbase Report Writer Commands#setcenter
pages using report writer: setting maximum number of lines per page
Essbase Report Writer Commands#pagelength
parallel calculation
Blank
parallel calculation: identifying sparse dimensions
CALCTASKDIMS configuration setting
parallel calculation: using more than one sparse dimension
CALCPARALLEL configuration setting
parallel data load
Blank
parallel data load: forcing to single thread per stage
Essbase Configuration Settings#dlsinglethreadperstage
parallel data load: setting number of threads in preparation stage
Essbase Configuration Settings#dlthreadsprepare
parallel data load: setting number of threads in write stage
Essbase Configuration Settings#dlthreadswrite
parallel export
Blank
parallel export: ESSCMD
ESSCMD Commands List#parexport
parallel export: MaxL
MaxL Language Reference: Statements#hexport
parameters in functions
Function Parameters and Syntax#fmparam
parent-level data return
Blank
parent-level data return: based on shared parent value of current member
Essbase List of Functions#@sparentval
parent-level data return: from multiple dimensions
Essbase List of Functions#@mdparentval
PARENT function
Essbase List of Functions#@parent
PARENT report writer command
Essbase Report Writer Commands#parent
parents
Blank
parents: adding to reports
Essbase Report Writer Commands#parent
parents: returning values of
Essbase List of Functions#@parentval
PARENTVAL function
Essbase List of Functions#@parentval
PAREXPORT ESSCMD command
ESSCMD Commands List#parexport
partial calculations
Calculation Commands List#fix_endfix
partitioning
Blank
partitioning: correcting results with two-pass calculations
Essbase Configuration Settings#gridexpansion
partitioning: partitioning (ESSCMD)
Blank
partitioning: partitioning (ESSCMD): getting all replicated cells from the source (target is current)
ESSCMD Commands List#getallreplcells
partitioning: partitioning (ESSCMD): getting updated replicated cells from the source (target is current)
ESSCMD Commands List#getupdatedreplcells
partitioning: partitioning (ESSCMD): partition definition (.DDB) file
ESSCMD Commands List#printpartitiondeffile
partitioning: partitioning (ESSCMD): putting all replicated cells into the target (source is current)
ESSCMD Commands List#putallreplcells
partitioning: partitioning (ESSCMD): putting updated replicated cells into the target (source is current)
ESSCMD Commands List#putallreplcells
partitioning: partitioning (MaxL)
Blank
partitioning: partitioning (MaxL): creating partitions
MaxL Language Reference: Statements#crepart
partitioning: partitioning (MaxL): displaying partition information
MaxL Language Reference: Statements#disppart
partitioning: partitioning (MaxL): dropping a partition
MaxL Language Reference: Statements#drppart
partitioning: partitioning (MaxL): refreshing replicated partition
MaxL Language Reference: Statements#refrpart
performance statistics
Blank
performance statistics: getting
Performance Statistics
performance statistics: resetting
Performance Statistics#RESETPERFSTATS
period-to-date values
Essbase List of Functions#@ptd
PIPEBUFFERSIZE configuration setting
Essbase Configuration Settings#pipebuffersize
PORTINC configuration setting
Essbase Configuration Settings#portinc
POWER function
Essbase List of Functions#@power
precision digits used for numerical comparison
Essbase Configuration Settings#numericprecision
PRINTPARTITIONDEFFILE ESSCMD command
ESSCMD Commands List#printpartitiondeffile
PRINTROW report writer command
Essbase Report Writer Commands#printrow
PRIOR function
Essbase List of Functions#@prior
PRIORS function
Essbase List of Functions#@priors
privileges in MaxL
MaxL Language Reference: Definitions#privileges
privileges in MaxL: granting
MaxL Language Reference: Statements#grant
PTD function
Essbase List of Functions#@ptd
PURGELINKEDOBJECTS ESSCMD command
ESSCMD Commands List#purgelinkedobjects
PURGEOTLCHANGEFILE ESSCMD command
ESSCMD Commands List#purgeotlchangefile
PUTALLREPLCELLS ESSCMD command
ESSCMD Commands List#putallreplcells
PUTUPDATEDREPLCELLS ESSCMD command
ESSCMD Commands List#putupdatedreplcells
PYRAMIDHEADERS report writer command
Essbase Report Writer Commands#pyramidheaders
QRYGOVEXECBLK configuration setting
Essbase Configuration Settings#qrygovexecblk
QRYGOVEXECTIME configuration setting
Essbase Configuration Settings#qrygovexectime
query governor configuration settings
blank.htm
query governor configuration settings: HAMAXNUMSQLQUERY
Essbase Configuration File Settings#hamaxnumsqlquery
query governor configuration settings: HAMAXQUERYROWS
Essbase Configuration File Settings#hamaxqueryrows
query governor configuration settings: HAMAXQUERYTIME
Essbase Configuration File Settings#hamaxquerytime
query governor configuration settings: QRYGOVEXECBLK
Essbase Configuration Settings#qrygovexecblk
query governor configuration settings: QRYGOVEXECTIME
Essbase Configuration Settings#qrygovexectime
QUICKLOGIN configuration setting
Essbase Configuration Settings#quicklogin
quitting ESSCMD
ESSCMD Getting Started#quit
QUOTEMBRNAMES report writer command
Essbase Report Writer Commands#quotembrnames
RANGE function
Essbase List of Functions#@range
ranges
Blank
ranges: attributes
ESSCMD Commands List#getattributespecs
ranges: functions
Types of Functions#financial
ranges: maximum value across a range
Essbase List of Functions#@maxrange
ranges: returning a member range list
Essbase List of Functions#@currmbrrange
ranges: standard deviation across a range
Essbase List of Functions#@stdevrange
ranges: summation across a range
Essbase List of Functions#@sumrange
RANK function
Essbase List of Functions#@rank
RDESCENDANTS function
Essbase List of Functions#@rdescendants
referencing files in ESSCMD
ESSCMD Syntax Guidelines#ref
refresh replicated partition in MaxL
MaxL Language Reference: Statements#refrpart
reiterating commands
Calculation Commands List#loop_endloop
relationship functions
Types of Functions#index
relationsips between members
Hyperion Essbase Overview of Functions#genlev
RELATIVE function
Essbase List of Functions#@relative
REMAINDER function
Essbase List of Functions#@remainder
remainder value
Essbase List of Functions#@remainder
REMOVE function
Essbase List of Functions#@remove
REMOVECOLCALCS report writer command
Essbase Report Writer Commands#removecolcalcs
REMOVELOCKS ESSCMD command
ESSCMD Commands List#removelocks
REMOVEUSER ESSCMD command
ESSCMD Commands List#removeuser
RENAME report writer command
Essbase Report Writer Commands#rename
RENAMEAPP ESSCMD command
ESSCMD Commands List#renameapp
RENAMEDB ESSCMD command
ESSCMD Commands List#renamedb
RENAMEFILTER ESSCMD command
ESSCMD Commands List#renamefilter
RENAMEOBJECT ESSCMD command
ESSCMD Commands List#renameobject
RENAMEUSER ESSCMD command
ESSCMD Commands List#renameuser
repeating commands
Calculation Commands List#loop_endloop
replicated cells. See partitioning
Blank
REPORT ESSCMD command
ESSCMD Commands List#report
report layout commands
Report Writer Command Groups#layout
report writer
Report Writer Overview
report writer: command groups
Report Writer Command Groups
report writer: syntax and abbreviations
Report Writer Syntax
REPORTLINE ESSCMD command
ESSCMD Commands List#reportline
reports
Blank
reports: alias and member name display
Report Writer Command Groups#alias
reports: column or row calculation
Report Writer Command Groups#calc
reports: data ordering
Report Writer Command Groups#dataorder
reports: data range
Report Writer Command Groups#datarange
reports: delimiters { } <
Report Writer Syntax#delimiters
reports: format
Report Writer Command Groups#format
reports: layout
Report Writer Command Groups#layout
reports: member selection and sorting
Report Writer Command Groups#selectsort
reports: output
Essbase Report Writer Commands#!
reports: query timing
Essbase Configuration Settings#timingmessages
reports: syntax
Report Writer Syntax
reports: writing reports in MaxL
MaxL Language Reference: Statements#hexport
REPTKBYTEBUF configuration setting
Essbase Configuration Settings#reptkbytebuf
REPTKBYTESORTBUF configuration setting
Essbase Configuration Settings#reptkbytesortbuf
RESETDB ESSCMD command
ESSCMD Commands List#resetdb
RESETOTLCHANGETIME ESSCMD command
ESSCMD Commands List#resetotlchangetime
RESETPERFSTATS ESSCMD command
Performance Statistics#resetperfstats
RESETSTATUS ESSCMD command
ESSCMD Commands List#resetstatus
RESTORE ESSCMD command
ESSCMD Commands List#restore
RESTRICT report writer command
Essbase Report Writer Commands#restrict
restructuring databases incrementally
Essbase Configuration Settings#increstruc
ROUND function
Essbase List of Functions#@round
row calculation commands
Blank
row calculation commands: CALCULATE ROW report writer command
Essbase Report Writer Commands#calculate_row
row calculation commands: CLEARALLROWCALC report writer command
Essbase Report Writer Commands#clearallrowcalc
row calculation commands: CLEARROWCALC report writer command
Essbase Report Writer Commands#clearrowcalc
row calculation commands: OFFROWCALCS report writer command
Essbase Report Writer Commands#offrowcalcs
row calculation commands: ONROWCALCS report writer command
Essbase Report Writer Commands#onrowcalcs
row calculation commands: PRINTROW report writer command
Essbase Report Writer Commands#printrow
row calculation commands: SAVEANDOUTPUT report writer command
Essbase Report Writer Commands#saveandoutput
row calculation commands: SAVEROW report writer command
Essbase Report Writer Commands#saverow
row calculation commands: SETROWOP report writer command
Essbase Report Writer Commands#setrowop
row processing limit
Essbase Configuration Settings#ssprocrowlimit
ROW report writer command
Essbase Report Writer Commands#row
ROWREPEAT report writer command
Essbase Report Writer Commands#rowrepeat
RSIBLINGS function
Essbase List of Functions#@rsiblings
RUNCALC ESSCMD command
ESSCMD Commands List#runcalc
RUNREPT ESSCMD command
ESSCMD Commands List#runrept
S directive @@S)
@@S
sample applications
Technical Reference Introduction#sample
SANCESTVAL function
Essbase List of Functions#@sancestval
SAVEANDOUTPUT report writer command
Essbase Report Writer Commands#saveandoutput
SAVEROW report writer command
Essbase Report Writer Commands#saverow
SCALE report writer command
Essbase Report Writer Commands#scale
scheduling report printing in ESSCMD (sample)
ESSCMD Batch Processing#reports
script files, ESSCMD
Blank
script files, ESSCMD: handling command errors
ESSCMD Batch Processing#errors
script files, ESSCMD: running
ESSCMD Batch Processing#running
script files, ESSCMD: samples
ESSCMD Batch Processing#samples
script files, ESSCMD: writing
ESSCMD Batch Processing#write
searching in this document
About the Documentation#search
security
ESSCMD Command Groups#usrsec
security privileges and roles in MaxL
MaxL Language Reference: Definitions#privileges
security privileges and roles in MaxL: granting
MaxL Language Reference: Statements#grant
SELECT ESSCMD command
ESSCMD Commands List#select
semicolons in functions
Function Parameters and Syntax
server essbase.cfg file, creating
Creating a Configuration File for the Server
server identification
Essbase Configuration Settings#nodename
server threads
Essbase Configuration Settings#serverthreads
SERVERPORTBEGIN configuration setting
Essbase Configuration Settings#serverportbegin
SERVERPORTEND configuration setting
Essbase Configuration Settings#serverportend
SERVERTHREADS configuration setting
Essbase Configuration Settings#serverthreads
SET AGGMISSG calculation command
Calculation Commands List#set_aggmissg
SET CACHE calculation command
Calculation Commands List#set_cache
SET CALCHASHTBL calculation command
Calculation Commands List#set_calchashtbl
SET CALCPARALLEL calculation command
Calculation Commands List#set_calcparallel
SET CALCTASKDIMS calculation command
Calculation Commands List#set_calctaskdims
SET calculation command
Calculation Commands List#set
SET CLEARUPDATESTATUS calculation command
Calculation Commands List#set_clearupdatestatus
Set commands
Calculation Commands List#set
SET FRMLBOTTOMUP calculation command
Calculation Commands List#set_frmlbottomup
SET LOCKBLOCK calculation command
Calculation Commands List#set_lockblock
SET MSG calculation command
Calculation Commands List#set_msg
SET NOTICE calculation command
Calculation Commands List#set_notice
SET UPDATECALC calculation command
Calculation Commands List#set_updatecalc
SET UPTOLOCAL calculation command
Calculation Commands List#set_uptolocal
SETALIAS ESSCMD command
ESSCMD Commands List#setalias
SETAPPSTATE ESSCMD command
ESSCMD Commands List#setappstate
SETCENTER report writer command
Essbase Report Writer Commands#setcenter
SETDBSTATE ESSCMD command
ESSCMD Commands List#setdbstate
SETDBSTATEITEM ESSCMD command
ESSCMD Commands List#setdbstateitem
SETDEFAULTCALC ESSCMD command
ESSCMD Commands List#setdefaultcalc
SETDEFAULTCALCFILE ESSCMD command
ESSCMD Commands List#setdefaultcalcfile
SETHELP ESSCMD command
ESSCMD Commands List#sethelp
SETLOGIN ESSCMD command
ESSCMD Commands List#setlogin
SETMSGLEVEL ESSCMD command
ESSCMD Commands List#setmsglevel
SETPASSWORD ESSCMD command
ESSCMD Commands List#setpassword
SETROWOP report writer command
Essbase Report Writer Commands#setrowop
SH x directive (@@SHx)
@@SHx
SHIFT function
Essbase List of Functions#@shift
shifting data values across multiple-dimension ranges
Essbase List of Functions#@mdshift
SHUTDOWNSERVER ESSCMD command
ESSCMD Commands List#shutdownserver
SIBLINGS function
Essbase List of Functions#@siblings
simple interest calculation
Essbase List of Functions#@interest
SINGLECOLUMN report writer command
Essbase Report Writer Commands#singlecolumn
SKIP report writer command
Essbase Report Writer Commands#skip
SKIPONDIMENSION report writer command
Essbase Report Writer Commands#skipondimension
SLEEP ESSCMD command
ESSCMD Commands List#sleep
SLN function
Essbase List of Functions#@sln
SORTALTNAMES report writer command
Essbase Report Writer Commands#sortaltnames
SORTASC report writer command
Essbase Report Writer Commands#sortasc
SORTDESC report writer command
Essbase Report Writer Commands#sortdesc
SORTGEN report writer command
Essbase Report Writer Commands#sortgen
SORTLEVEL report writer command
Essbase Report Writer Commands#sortlevel
SORTMBRNAMES report writer command
Essbase Report Writer Commands#sortmbrnames
SORTNONE report writer command
Essbase Report Writer Commands#sortnone
SPARENTVAL function
Essbase List of Functions#@sparentval
sparse-dimension calculation
Calculation Commands List#agg
SPARSE report writer command
Essbase Report Writer Commands#sparse
SPLINE function
Essbase List of Functions#@spline
spreadsheet
Blank
spreadsheet: error messages
Essbase Configuration Settings#sslogunknown
spreadsheet: query timing
Essbase Configuration Settings#timingmessages
spreadsheet: specifying maximum number of rows processed
Essbase Configuration Settings#ssprocrowlimit
spreadsheet: SQL script, updating in ESSCMD (sample)
ESSCMD Batch Processing#sql
spreadsheet: suppressing grid messages
Essbase Configuration Settings#gridexpansionmessages
spreadsheet: update logging
Essbase Configuration Settings#ssaudit
SSAUDIT, SSAUDITR configuration settings
Essbase Configuration Settings#ssaudit
SSLOGUNKNOWN configuration setting
Essbase Configuration Settings#sslogunknown
SSPROCROWLIMIT configuration setting
Essbase Configuration Settings#ssprocrowlimit
standard deviation
Blank
standard deviation: across a range
Essbase List of Functions#@stdevrange
standard deviation: based on population
Essbase List of Functions#@stdevp
standard deviation: based on sample
Essbase List of Functions#@stdev
STARTHEADING report writer command
Essbase Report Writer Commands#startheading
starting ESSCMD
ESSCMD Getting Started#start
statements in MaxL
MaxL Language Reference: Definitions#alphabet
static member definition
Report Writer Syntax#static
statistical functions
Types of Functions#stats
statistics for performance
Performance Statistics#getperfstats
statistics for performance: resetting
Performance Statistics#resetperfstats
status, clean or dirty
Calculation Commands List#set_clearupdatestatus
STDEV function
Essbase List of Functions#@stdev
STDEVP function
Essbase List of Functions#@stdevp
STDEVRANGE function
Essbase List of Functions#@stdevrange
strings in MaxL
MaxL Language Reference: Definitions#alphabet
SUBSTRING function
Essbase List of Functions#@substring
SUM function
Essbase List of Functions#@sum
SUMRANGE function
Essbase List of Functions#@sumrange
SUPALL report writer command
Essbase Report Writer Commands#supall
SUPBRACKETS report writer command
Essbase Report Writer Commands#supbrackets
SUPCOLHEADING report writer command
Essbase Report Writer Commands#supcolheading
SUPCOMMAS report writer command
Essbase Report Writer Commands#supcommas
SUPCURHEADING report writer command
Essbase Report Writer Commands#supcurheading
SUPEMPTYROWS report writer command
Essbase Report Writer Commands#supemptyrows
SUPEUROPEAN report writer command
Essbase Report Writer Commands#supeuropean
SUPFEED report writer command
Essbase Report Writer Commands#supfeed
SUPFORMATS report writer command
Essbase Report Writer Commands#supformats
SUPHEADING report writer command
Essbase Report Writer Commands#supheading
SUPMASK report writer command
Essbase Report Writer Commands#supmask
SUPMISSINGROWS report writer command
Essbase Report Writer Commands#supmissingrows
SUPNA configuration setting
Essbase Configuration Settings#supna
SUPNAMES report writer command
Essbase Report Writer Commands#supnames
SUPOUTPUT report writer command
Essbase Report Writer Commands#supoutput
SUPPAGEHEADING report writer command
Essbase Report Writer Commands#suppageheading
SUPSHARE report writer command
Essbase Report Writer Commands#supshare
SUPSHAREOFF report writer command
Essbase Report Writer Commands#supshareoff
SUPZEROROWS report writer command
Essbase Report Writer Commands#supzerorows
SYD function
Essbase List of Functions#@syd
SYM report writer command
Essbase Report Writer Commands#sym
synchronizing outlines
ESSCMD Command Groups#otlsync
syntax for calculation functions
Function Parameters and Syntax
syntax for ESSCMD commands
ESSCMD Syntax Guidelines
syntax for report writer commands
Report Writer Syntax
TABDELIMIT report writer command
Essbase Report Writer Commands#tabdelimit
tabs in report output
Essbase Report Writer Commands#tabdelimit
tag
Function Parameters and Syntax#tag
Technical Reference
Blank
Technical Reference: conventions
conventions
Technical Reference: introduction
introduction
Technical Reference: what you should know before reading this document
Technical Reference Introduction#whatknow
Technical Reference: who should read this document
Technical Reference Introduction#whoread
temporary variables
Blank
temporary variables: containing a single value
Calculation Commands List#var
temporary variables: one-dimensional array
Calculation Commands List#array
terminals in MaxL syntax
MaxL Language Reference: Definitions#alphabet
terminals in MaxL syntax: listed
MaxL Language Reference: Definitions#terminals
TEXT report writer command
Essbase Report Writer Commands#text
threads
Blank
threads: data load, overriding
Essbase Configuration Settings#dlsinglethreadperstage
threads: preparation stage of data load
Essbase Configuration Settings#dlthreadsprepare
threads: server, how many allowed
Essbase Configuration Settings#serverthreads
threads: write stage of data load
Essbase Configuration Settings#dlthreadswrite
time dimension, period-to-date values in
Essbase List of Functions#@ptd
TIMINGMESSAGES configuration setting
Essbase Configuration Settings#timingmessages
TODATE function
Essbase List of Functions#@todate
TODATE report writer command
Essbase Report Writer Commands#todate
tokens in MaxL
MaxL Language Reference: Definitions#alphabet
TOP report writer command
Essbase Report Writer Commands#top
tracing calculations
Calculation Commands List#set_msg
transaction threads, how many allowed
Essbase Configuration Settings#serverthreads
TREND function
Essbase List of Functions#@trend
TRUNCATE function
Essbase List of Functions#@truncate
two-pass calculation
Calculation Commands List#calc_twopass
UCHARACTERS report writer command
Essbase Report Writer Commands#ucharacters
UCOLUMNS report writer command
Essbase Report Writer Commands#ucolumns
UDA function
Essbase List of Functions#@uda
UDA report writer command
Essbase Report Writer Commands#uda
UDATA report writer command
Essbase Report Writer Commands#udata
UNAME report writer command
Essbase Report Writer Commands#uname
UNAMEONDIMENISON report writer command
Essbase Report Writer Commands#unameondimension
UNDERLINECHAR report writer command
Essbase Report Writer Commands#underlinechar
underlining in a report
Blank
underlining in a report: changed row member names in same dimension
Essbase Report Writer Commands#unameondimension
underlining in a report: characters in preceding row
Essbase Report Writer Commands#ucharacters
underlining in a report: data columns only
Essbase Report Writer Commands#udata
underlining in a report: default
Essbase Report Writer Commands#underlinechar
underlining in a report: name and data columns
Essbase Report Writer Commands#ucolumns
underlining in a report: name columns only
Essbase Report Writer Commands#uname
underlining in a report: turning off for new member names in same dimension
Essbase Report Writer Commands#nounameondim
UNDERSCORECHAR report writer command
Essbase Report Writer Commands#underscorechar
UNLOADALIAS ESSCMD command
ESSCMD Commands List#unloadalias
UNLOADAPP ESSCMD command
ESSCMD Commands List#unloadapp
UNLOADDB ESSCMD command
ESSCMD Commands List#unloaddb
UNLOCKOBJECT ESSCMD command
ESSCMD Commands List#unlockobject
UPDATE ESSCMD command
ESSCMD Commands List#update
UPDATECALC configuration setting
Essbase Configuration Settings#updatecalc
UPDATEFILE ESSCMD command
ESSCMD Commands List#updatefile
UPDATEVARIABLE ESSCMD command
ESSCMD Commands List#updatevariable
using the Technical Reference
About the Documentation
using the Technical Reference: navigating
About the Documentation#navigate
using the Technical Reference: searching
About the Documentation#search
VALIDATE ESSCMD command
ESSCMD Commands List#validate
VALIDATEPARTITIONDEFFILE ESSCMD command
ESSCMD Commands List#validatepartitiondeffile
VAR calculation command
Calculation Commands List#var
VAR function
Essbase List of Functions#@var
variables, temporary
Blank
variables, temporary: containing a single value
Calculation Commands List#var
variables, temporary: one-dimensional array
Calculation Commands List#array
variance
Blank
variance: between members
Essbase List of Functions#@var
variance: percentage between members
Essbase List of Functions#@varper
variance: statistical, based on population
Essbase List of Functions#@variancep
variance: statistical, based on sample
Essbase List of Functions#@variance
VARIANCE function
Essbase List of Functions#@variance
VARIANCEP function
Essbase List of Functions#@variancep
VARPER function
Essbase List of Functions#@varper
what you should know before you use this document
Technical Reference Introduction#whatknow
who should read this document
Technical Reference Introduction#whoread
WIDTH report writer command
Essbase Report Writer Commands#width
WITHATTR function
Essbase List of Functions#@withattr
WITHATTR report writer command
Essbase Report Writer Commands#withattr
x directive (@@ x)
@@x
XREF function
Essbase List of Functions#@xref
zero values, replacing in output with text
Essbase Report Writer Commands#zerotext
ZEROTEXT report writer command
Essbase Report Writer Commands#zerotext