If JavaScript is disabled, please continue to the
sitemap
.
Infor Enterprise Performance Management OLAP XMLA Provider Developer Guide (On-premises)
Home
Home
Back
Back
Forward
Forward
Search
Help
Copy URL
PDF
Print this page
Help
Help
Copy URL
Copy URL
Topic URL copied to clipboard
PDF
PDF
Print
Hide the Table of Contents
Show the Table of Contents
Overview of XMLA Provider
Alternate hierarchies in MDX and schema requests
Default elements
Member keys
Reduced unique names
Caption support
Supported schema rowsets
Parallel XMLA requests
Connecting to the XMLA Provider
Basic authentication
Repository ticket authentication
Windows authentication
Infor Federated Services authentication
2.11 End-of-Line Handling
API service to service security
Session time-out
Discover requests
MDX syntax elements
Methods/expressions
Operators
Dimension properties
Working with empty cells: NON EMPTY keyword
Working with hidden cells: NON HIDDEN keyword
Tabular format response format for MDX statements
MDX functions
Abs
AddCalculatedMembers
Aggregate
AllMembers
Ancestor
Ascendants
Avg
BottomCount
BottomPercent
BottomSum
Children
ClosingPeriod
Count
Cousin
Crossjoin
CStr
CurrentMember
DefaultMember
Descendants
Dimension
Dimensions
Distinct
DistinctNative
DrillDownInSet
DrilldownLevel
DrilldownMember
DrillupMember
Element_Type
Except
ExpandLevels
Filter
FilterEQ
FilterGE
FilterGT
FilterHS
FilterLE
FilterLT
FilterNE
FilterNS
FilterZS
FirstChild
Generate
HasNote
Head
Hierarchize
Hierarchy
IIf
InStr
Intersect
IS
IsAncestor
IsEmpty
IsGeneration
IsLeaf
IsSibling
Item
Lag
LastChild
LastPeriods
Lead
Left
Level
Levels
LinRegIntercept
LinRegPoint
LinRegSlope
Max
Median
Members
Mid
Min
Mode
Mtd
Name
Nest
NextMember
OpeningPeriod
Order
Ordinal
ParallelPeriod
Parent
PeriodsToDate
PrevMember
Properties
Qtd
Rank
RegExp
Right
Rnd
RollUpInSet
RootMembers
Siblings
Solve_Order
SplashValue
Standardize
Stddev (Alias: Stdev)
StddevP (Alias: StdevP)
StripCalculatedMembers
StrToMember
StrToSet
StrToValue
Subset
Sum
Tail
ToggleDrillState
TopCount
TopPercent
TopSum
Union
UnionSort
UniqueName
UserName
Val
Variance (Alias: Var)
VarianceP (Alias: VarP)
Wildcard
WriteComment
WriteProperty
WriteValue
Wtd
Ytd
WriteCells
SQL interface
Hierarchies in the SQL interface
SQL view
DBSchema columns
Supported requests
Open link in new tab
Open link in new window
Copy link to clipboard