Funções MDX Pentaho

No link abaixo da Microsoft obtemos todas as funções aceitas pelo MDX(Microsoft) que é parecido com o usado no Pentaho, a maioria das funções funcionam no Pentaho(pelo menos as que eu usei e testei): 

O link é: 

https://msdn.microsoft.com/pt-br/library/ms145505(v=sql.120).aspx

Muito interessante esse link, clicando no menu a esquerda sobre a função existe uma explicação das funcionalidades e um exemplo prático de utilização. 

As funções apresentadas no link são(clicando sobre os itens abaixo você abre cada função no site da Microsoft):

·         AddCalculatedMembers

·         Aggregate

·         AllMembers

·         Ancestor

·         Ancestors

·         Ascendants

·         Avg

·         Axis

·         BottomCount

·         BottomPercent

·         BottomSum

·         CalculationCurrentPass

·         CalculationPassValue

·         Instrução CASE

·         Children

·         ClosingPeriod

·         CoalesceEmpty

·         Correlation

·         Count (Dimensão)

·         Count (Níveis de hierarquia)

·         Count (Conjunto)

·         Count (Tupla)

·         Cousin

·         Covariance

·         CovarianceN

·         Crossjoin

·         Current

·         CurrentMember

·         CurrentOrdinal

·         CustomData

·         DataMember

·         DefaultMember

·         Descendants

·         Dimension

·         Dimensions

·         Distinct

·         DistinctCount

·         Dividir

·         DrilldownLevel

·         DrilldownLevelBottom

·         DrilldownLevelTop

·         DrilldownMember

·         DrilldownMemberBottom

·         DrilldownMemberTop

·         DrillupLevel

·         DrillupMember

·         Error

·         Except

·         Exists (MDX)

·         Extract

·         Filter

·         FirstChild

·         FirstSibling

·         Generate

·         Head

·         Hierarchize

·         Hierarchy

·         IIf

·         Instr

·         Intersect

·         IsAncestor

·         IsEmpty

·         IsGeneration

·         IsLeaf

·         IsSibling

·         Item (Membro)

·         Item (Tupla)

·         KPIGoal

·         KPIStatus

·         KPITrend

·         KPIWeight

·         KPICurrentTimeMember

·         KPIValue

·         Lag

·         LastChild

·         LastPeriods

·         LastSibling

·         Lead

·         Leaves

·         Level

·         Levels

·         LinkMember

·         LinRegIntercept

·         LinRegPoint

·         LinRegR2

·         LinRegSlope

·         LinRegVariance

·         LookupCube

·         Max

·         MeasureGroupMeasures

·         Median

·         Members (Conjunto)

·         Membros (cadeia de caracteres)

·         MemberToStr

·         MemberValue

·         Min

·         Mtd

·         Name

·         NameToSet

·         NextMember

·         NonEmpty

·         NonEmptyCrossjoin

·         OpeningPeriod

·         Order

·         Ordinal

·         ParallelPeriod

·         Parent

·         PeriodsToDate

·         Predict

·         PrevMember

·         Propriedades

·         Qtd

·         Rank

·         RollupChildren

·         Root

·         SetToArray

·         SetToStr

·         Siblings

·         Stddev

·         StddevP

·         Stdev

·         StdevP

·         StripCalculatedMembers

·         StrToMember

·         StrToSet

·         StrToTuple

·         StrToValue

·         Subset

·         Sum

·         Tail

·         Esse

·         ToggleDrillState

·         TopCount

·         TopPercent

·         TopSum

·         TupleToStr

·         Union

·         UniqueName

·         UnknownMember

·         Unorder

·         UserName

·         ValidMeasure

·         Value

·         Var

·         Variance

·         VarianceP

·         VarP

·         VisualTotals

·         Wtd

·         Ytd