Min(Time.CurrentMember.Children) SELECT { [Time].&[1997] } ON COLUMNS , { [Account].[Total Expense] } ON ROWS FROM [Budget] WHERE ( [Category].[Current Year's Actuals], [Measures].[Amount] ) SELECT { [Time].&[1997] } ON COLUMNS , { [Account].[Total Expense].DataMember } ON ROWS FROM [Budget] WHERE ( [Category].[Current Year's Actuals], [Measures].[Amount] ) SELECT { [Time].&[1997] } ON COLUMNS , { [Account].[Total Expense], [Account].[Total Expense].DataMember } ON ROWS FROM [Budget] WHERE ( [Category].[Current Year's Actuals], [Measures].[Amount] ) (Account.CurrentMember.DataMember, Measures.Amount) IIF(IsLeaf(Account.CurrentMember) ,"Leaf" , "Parent") (Time.CurrentMember, Measures.Sales) - (ParallelPeriod(Year,1,Time.CurrentMember), Measures.Sales) (Time.CurrentMember) - (ParallelPeriod(Year,1,Time.CurrentMember)) (Time.CurrentMember, Measures.LagGrowth) - (ParallelPeriod(Year,1,Time.CurrentMember), Measures.LagGrowth)