Wednesday, June 30, 2010

TopCount() & Sum() function MDX samples



[Top 5 Leavetype over Leavetyperatio]

TOPCOUNT([Leave Type].[Leave Type].[Leave Type],5,([Measures].[Leavetype ratio])
)
Measures creation for the particular range like [Salary Cost]

SUM( { [Accounts].[Account Name].&[5505 - Basic+DA - Direct]: [Accounts].[Account Name].&[5955 - Directors Remuneration] }, [Measures].[Amount]
)