Supported MDX Syntax
If you are working with MDX, you must be aware of the syntax that IBM®
Cognos® Analytics - Reporting supports. Cognos
Analytics - Reporting supports the MDX grammar as specified in Microsoft Data Access Software Developer Kit version 2.8.
Cognos Analytics - Reporting supports the following MDX functions. This is a partial list and applies only when you are working with the following data sources:
- cubes
- SAP BW
- IBM Cognos TM1®
- IBM Db2® OLAP
- IBM Cognos Consolidation
- IBM Cognos Contributor
For these data sources, IBM Cognos Analytics uses a variation of the Microsoft SQL Server Analysis Services syntax.
-
Acos -
Aggregate -
Ancestor -
Ancestors -
Asin -
Atan -
Avg -
BottomCount -
BottomPercent -
BottomSum -
Children -
ClosingPeriod -
CoalesceEmpty -
Convert -
Cos -
Cosh -
Count -
Cousin -
Crossjoin -
CurrentMember -
DefaultMember -
Descendants -
Dimension -
Distinct -
Except -
Exp -
Filter -
FirstChild -
FirstSibling -
Generate -
Head -
Hierarchize -
Hierarchy -
IIf -
Intersect -
Is -
IsAncestor -
IsEmpty -
Item -
Lag -
LastChild -
LastPeriods -
LastSibling -
Lead -
Level -
Levels -
LinkMember -
Ln -
Log10 -
Max -
Median -
Members -
Min -
Mtd -
Name -
NextMember -
OpeningPeriod -
Order -
Ordinal -
ParallelPeriod -
Parent -
PeriodsToDate -
PrevMember -
PreviousMember -
Properties -
Qtd -
Rank -
Siblings -
Sin -
Sinh -
Stddev -
Subset -
Sum -
Tail -
Tan -
Tanh -
TopCount -
TopPercent -
TopSum -
Union -
Value -
Var -
Wtd -
Ytd