Table of Contents
- Title and Copyright Information
- Preface
- 1 Technical Reference Overview
-
2
Calculation Functions
- Calculation Functions Overview
- Function Syntax
- Function Parameters
- Calculation Operators
- Operation Results on #MISSING Values and Zero (0) Values
- Calculation Function Categories
-
Calculation Function List
- @ABS
- @ACCUM
- @ALLANCESTORS
- @ALIAS
- @ALLOCATE
- @ANCEST
- @ANCESTORS
- @ANCESTVAL
- @ATTRIBUTE
- @ATTRIBUTEBVAL
- @ATTRIBUTESVAL
- @ATTRIBUTEVAL
- @AVG
- @AVGRANGE
- @BETWEEN
- @CALCMODE
- @CHILDREN
- @COMPOUND
- @COMPOUNDGROWTH
- @CONCATENATE
- @CORRELATION
- @COUNT
- @CREATEBLOCK
- @CURGEN
- @CURLEV
- @CURRMBR
- @CURRMBRRANGE
- @DATEDIFF
- @DATEPART
- @DATEROLL
- @DECLINE
- @DESCENDANTS
- @DISCOUNT
- @ENUMVALUE
- @EQUAL
- @EXP
- @EXPAND
- @FACTORIAL
- @FORMATDATE
- @GEN
- @GENMBRS
- @GROWTH
- @IALLANCESTORS
- @IANCESTORS
- @ICHILDREN
- @IDESCENDANTS
- @ILANCESTORS
- @ILDESCENDANTS
- @ILSIBLINGS
- @INT
- @INTEREST
- @INTERSECT
- @IRDESCENDANTS
- @IRR
- @IRREX
- @IRSIBLINGS
- @ISACCTYPE
- @ISANCEST
- @ISATTRIBUTE
- @ISCHILD
- @ISDESC
- @ISGEN
- @ISIANCEST
- @ISIBLINGS
- @ISICHILD
- @ISIDESC
- @ISIPARENT
- @ISISIBLING
- @ISLEV
- @ISMBR
- @ISMBRUDA
- @ISMBRWITHATTR
- @ISPARENT
- @ISRANGENONEMPTY
- @ISSAMEGEN
- @ISSAMELEV
- @ISSIBLING
- @ISUDA
- @LANCESTORS
- @LDESCENDANTS
- @LEV
- @LEVMBRS
- @LIKE
- @LIST
- @LN
- @LOG
- @LOG10
- @LSIBLINGS
- @MATCH
- @MAX
- @MAXRANGE
- @MAXS
- @MAXSRANGE
- @MBRCOMPARE
- @MBRPARENT
- @MDALLOCATE
- @MDANCESTVAL
- @MDPARENTVAL
- @MDSHIFT
- @MEDIAN
- @MEMBER
- @MEMBERAT
- @MERGE
- @MIN
- @MINRANGE
- @MINS
- @MINSRANGE
- @MOD
- @MODE
- @MOVAVG
- @MOVMAX
- @MOVMED
- @MOVMIN
- @MOVSUM
- @MOVSUMX
- @NAME
- @NEXT
- @NEXTS
- @NEXTSIBLING
- @NOTEQUAL
- @NPV
- @PARENT
- @PARENTVAL
- @POWER
- @PREVSIBLING
- @PRIOR
- @PRIORS
- @PTD
- @RANGE
- @RANGEFIRSTVAL
- @RANGELASTVAL
- @RANK
- @RDESCENDANTS
- @RELATIVE
- @RELXRANGE
- @REMAINDER
- @REMOVE
- @RETURN
- @ROUND
- @RSIBLINGS
- @SANCESTVAL
- @SHARE
- @SHIFT
- @SHIFTMINUS
- @SHIFTPLUS
- @SHIFTSIBLING
- @SIBLINGS
- @SLN
- @SPARENTVAL
- @SPLINE
- @STDEV
- @STDEVP
- @STDEVRANGE
- @SUBSTRING
- @SUM
- @SUMRANGE
- @SYD
- @TODATE
- @TODATEEX
- @TODAY
- @TREND
- @TRUNCATE
- @UDA
- @VAR
- @VARPER
- @VARIANCE
- @VARIANCEP
- @WEIGHTEDSUMX
- @WITHATTR
- @XRANGE
- @XREF
- @XWRITE
- Functions Supported in Hybrid Aggregation Mode
-
3
Calculation Commands
- Calculation Commands Overview
- Calculation Operators
- Calculation Command Groups
-
Calculation Command List
- & (ampersand)
- AGG
- ARRAY
- CALC ALL
- CALC AVERAGE
- CALC DIM
- CALC FIRST
- CALC LAST
- CALC TWOPASS
- CLEARBLOCK
- CLEARDATA
- DATACOPY
- DATAEXPORT
- DATAEXPORTCOND
- DATAIMPORTBIN
- DATAMERGE
- ELSE
- ELSEIF
- ENDIF
- EXCLUDE…ENDEXCLUDE
- FIX…ENDFIX
- FIXPARALLEL...ENDFIXPARALLEL
- IF
- LOOP...ENDLOOP
- POSTFIXPARALLEL
- SET Commands
- SET AGGMISSG
- SET CACHE
- SET CALCDIAGNOSTICS
- SET CALCPARALLEL
- SET CALCTASKDIMS
- SET CLEARUPDATESTATUS
- SET COPYMISSINGBLOCK
- SET CREATENONMISSINGBLK
- SET CREATEBLOCKONEQ
- SET DATAEXPORTOPTIONS
- SET DATAIMPORTIGNORETIMESTAMP
- SET EMPTYMEMBERSETS
- SET FRMLBOTTOMUP
- SET FRMLRTDYNAMIC
- SET MSG
- SET NOTICE
- SET REMOTECALC
- SET RUNTIMESUBVARS
- SET SCAPERSPECTIVE
- SET TRACE
- SET UPDATECALC
- THREADVAR
- USE_MDX_INSERT
- VAR
-
4
Configuration Settings
-
Configuration Settings Categorical List
- Calculation Configuration Settings
- Data Import and Export Configuration Settings
- Memory Management Configuration Settings
- Logging and Error Handling Configuration Settings
- Miscellaneous Configuration Settings
- Partitioning Configuration Settings
- Ports and Connections Configuration Settings
- Query Management Configuration Settings
- Aggregate Storage and Block Storage Settings Comparison
-
Config Settings List
- AGENTTHREADS
- ASODEFAULTCACHESIZE
- ASODYNAMICAGGINBSO
- ASODYNAMICAGGINBSOFOLDERPATH
- AUDITTRAIL
- AUTOMERGE
- AUTOMERGEMAXSLICENUMBER
- CALCCACHE
- CALCCACHEDEFAULT
- CALCCACHEHIGH
- CALCCACHELOW
- CALCLIMITFORMULARECURSION
- CALCTRACE
- CUSTOMCALCANDALLOCTHRUINSERT
- DATACACHESIZE
- DLSINGLETHREADPERSTAGE
- DLTHREADSPREPARE
- DLTHREADSWRITE
- DYNCALCCACHEMAXSIZE
- ENABLERTSVLOGGING
- FORCEALLDENSECALCON2PASSACCOUNTS
- FORCESHUTDOWNINTERVAL
- GRIDEXPANSION
- GRIDEXPANSIONMESSAGES
- GRIDSUPPRESSINVALID
- HYBRIDBSOINCALCSCRIPT
- IGNORECONSTANTS
- INDEXCACHESIZE
- MAXFORMULACACHESIZE
- MAXLOGINS
- MAXNUMBEROFACTIVEDB
- MAX_REQUEST_GRID_SIZE
- MAX_RESPONSE_GRID_SIZE
- MDXINSERTBUFFERAGGMETHOD
- MDXINSERTREQUESTTIMEOUT
- MDXQRYGOVCOUNT
- NUMBLOCKSTOEXTEND
- QUERYRESULTLIMIT
- QRYGOVEXECBLK
- QRYGOVEXECTIME
- QUERYTRACE
- QUERYTRACETHRESHOLD
- RENEGADELOG
- RESTRUCTURETHREADS
- RTDEPCALCOPTIMIZE
- SERVERTHREADS
- SSANCESTORONTOP
- SSMEMBERIDPROCESSING
- SSOPTIMIZEDGRIDPROCESSING
- SSPROCROWLIMIT
- SUPNA
- SVRIDLETIME
- TARGETASOOPT
- TARGETTIMESERIESOPT
-
Configuration Settings Categorical List
-
5
MaxL
- Overview of MaxL and MDX
- How to Read MaxL Railroad Diagrams
- MaxL Data Definition Language (DDL)
-
MaxL Statements
- Performance Statistics in MaxL
- Listed By Verbs
- Listed by Objects
-
MaxL Statement Reference
- Alter Application
- Alter Database
- Alter Database enable | disable
- Alter Database Set
- Alter Database (Misc)
- Alter Drillthrough
- Alter Filter
- Alter Object
- Alter Partition
- Alter Session
- Alter System
- Alter Tablespace (Aggregate Storage)
- Alter Trigger
- Create Application
- Create Calculation
- Create Database
- Create Drillthrough
- Create Filter
- Create Location Alias
- Create Partition
- Create Replicated Partition
- Create Transparent Partition
- Create Trigger
- Create After-Update Trigger
- Create On-Update Trigger
- Display Application
- Display Calculation
- Display Database
- Display Drillthrough
- Display Filter
- Display Filter Row
- Display Group
- Display Location Alias
- Display Lock
- Display Object
- Display Partition
- Display Privilege
- Display Session
- Display System
- Display Trigger
- Display Trigger Spool
- Display User
- Display Variable
- Drop Application
- Drop Calculation
- Drop Database
- Drop Drillthrough
- Drop Filter
- Drop Location Alias
- Drop Lock
- Drop Object
- Drop Partition
- Drop Trigger
- Drop Trigger Spool
- Execute Calculation
- Execute Aggregate Process (Aggregate Storage)
- Execute Aggregate Build
- Execute Aggregate Selection
- Export Data
- Export LRO
- Export Outline
- Grant
- Import Data
- Import Dimensions
- Import LRO
- Query Application
- Query Archive_File
- Query Database
- Refresh Outline
- Refresh Replicated Partition
-
MaxL Definitions
- MaxL Syntax Notes
- Numbers in MaxL Syntax
-
Terminals
- ACTION
- ALT-NAME-SINGLE
- APP-NAME
- AREA-ALIAS
- BUFFER-ID
- CALC-NAME
- CALC-NAME-SINGLE
- CALC-STRING
- COLUMN-WIDTH
- COMMENT-STRING
- CONDITION
- CUBE-AREA or MDX-SET
- DATE
- DBS-EXPORT-DIR
- DBS-NAME
- DBS-STRING
- DIM-NAME
- EXPORT-DIR
- FILE-NAME
- FILE-NAME-PREFIX
- FILTER-NAME
- FULL-EXPORT-DIR
- GROUP-NAME
- HOST-NAME
- ID-RANGE
- ID-STRING
- IMPORT-DIR
- IMP-FILE
- LOCATION-ALIAS-NAME
- LOC-ALIAS-SINGLE
- LOG-TIME
- ALLOC-NUMERIC
- MEMBER-EXPRESSION
- MEMBER-NAME
- OBJ-NAME
- OBJ-NAME-SINGLE
- OUTLINE-ID
- PASSWORD
- PATHNAME_FILENAME
- PRECISION-DIGITS
- PROPS
- RNUM
- RTSV-LIST
- RULE-FILE-NAME
- SESSION-ID
- SIZE-STRING
- SPOOL-NAME
- STOPPING-VAL
- TABLSP-NAME
- TRIGGER-NAME
- URL-NAME
- USER-NAME
- VARIABLE-NAME
- VIEW-FILE-NAME
- VIEW-ID
- VIEW-SIZE
- Privileges and Roles
- Quoting and Special Characters Rules for MaxL Language
- MaxL Shell Commands
- ESSCMD Script Conversion
- Reserved Words List
- MaxL BNF
-
MaxL Statements (Aggregate Storage)
- Alter Application (Aggregate Storage)
- Alter Database (Aggregate Storage)
- Alter System (Aggregate Storage)
- Create Application (Aggregate Storage)
- Create Database (Aggregate Storage)
- Create Outline (Aggregate Storage)
- Display Tablespace (Aggregate Storage)
- Execute Allocation
- Execute Calculation (Aggregate Storage)
- Export Data (Aggregate Storage)
- Export Query Tracking (Aggregate Storage)
- Import Data (Aggregate Storage)
- Import Query Tracking (Aggregate Storage)
- Query Application (Aggregate Storage)
- Query Database (Aggregate Storage)
- Outline Paging Dimension Statistics
- Aggregate Storage Runtime Statistics
- Aggregate Storage Slice Information Output
- Aggregate Storage Group ID Information Output
- Aggregate Storage Uncommitted Transaction Information Output
- MaxL Use Cases
-
6
MDX
- Overview of MDX
- MDX Query Format
-
MDX Syntax and Grammar Rules
- Understanding BNF Notation
- MDX Grammar Rules
- MDX Syntax for Specifying Duplicate Member Names and Aliases
- MDX Axis Specifications
- MDX Slicer Specification
- MDX Cube Specification
- MDX Set Specification
- MDX With Section
- MDX Dimension Specification
- MDX Layer Specification
- MDX Member Specification
- MDX Hierarchy Specification
- MDX Tuple Specification
- MDX Create Set / Delete Set
- MDX Sub Select
- MDX Insert Specification
- MDX Export Specification
- MDX Operators
- About MDX Properties
- MDX Comments
- MDX Query Limits
- Aggregate Storage and MDX Outline Formulas
-
MDX Function Return Values
- MDX Functions that Return a Member
- MDX Functions that Return a Set
- MDX Functions that Return a Tuple
- MDX Functions that Return a Number
- MDX Functions that Return a Dimension
- MDX Functions that Return a Layer
- MDX Functions that Return a Boolean
- MDX Functions that Return a Date
- MDX Functions that Return a String
-
MDX Function List
- Abs
- Aggregate
- Ancestor
- Ancestors
- Attribute
- AttributeEx
- Avg
- BottomCount
- BottomPercent
- BottomSum
- Case
- CellValue
- Children
- ClosingPeriod
- CoalesceEmpty
- Concat
- Contains
- Count
- Cousin
- CrossJoin
- CrossJoinAttribute
- CurrentAxisMember
- CurrentMember
- CurrentTuple
- DateDiff
- DatePart
- DateRoll
- DateToMember
- DefaultMember
- Descendants
- Distinct
- Dimension
- DrilldownByLayer
- DrilldownMember
- DrillupByLayer
- DrillupMember
- DTS
- EnumText
- EnumValue
- Except
- Exp
- Extract
- Factorial
- Filter
- FirstChild
- FirstSibling
- FormatDate
- Generate
- Generation
- Generations
- GetFirstDate
- GetFirstDay
- GetLastDate
- GetLastDay
- GetNextDay
- GetRoundDate
- Head
- Hierarchize
- IIF
- InStr
- InString
- Int
- Intersect
- Is
- IsAccType
- IsAncestor
- IsChild
- IsEmpty
- IsGeneration
- IsLeaf
- IsLevel
- IsMatch
- IsSibling
- IsUda
- IsValid
- Item
- JulianDate
- Lag
- LastChild
- LastPeriods
- LastSibling
- Lead
- Leaves
- Left
- Len
- Level
- Levels
- LinkMember
- Ln
- Log
- Log10
- Lower
- LTrim
- Max
- Median
- MemberRange
- Members
- Min
- Mod
- NextMember
- NonEmptyCount
- NonEmptySubset
- NTile
- NumToStr
- OpeningPeriod
- Order
- Ordinal
- ParallelPeriod
- Parent
- Percentile
- PeriodsToDate
- Power
- PrevMember
- Rank
- RealValue
- RelMemberRange
- Remainder
- Right
- Round
- RTrim
- Siblings
- Stddev
- Stddevp
- StrToMbr
- StrToNum
- Subset
- Substring
- Sum
- Tail
- Todate
- TodateEx
- Today
- TopCount
- TopPercent
- TopSum
- Truncate
- TupleRange
- Uda
- Union
- UnixDate
- Upper
- Value
- WithAttr
- WithAttrEx
- xTD
- 7 Query Logging Configuration