with member[Measures].[A]as([Account].[Accounts].parent,[Measures].[Amount])
member[Measures].[X]as[Account].[Accounts].level.ordinal
member[Measures].[Y]as[Account].[Accounts].level.name
member[Measures].[Z]as[Account].[Accounts].parent.name
select{[Measures].[Amount],[Measures].[A],[Measures].[X],[Measures].[Y],[Measures].[Z]}on 0,
non empty[Account].[Accounts].allmembers
having isnumeric([Measures].[Amount])and not isempty([Measures].[Amount])
on 1from[Adventure Works]where([Date].[Calendar Year].&[2013],[Department].[Departments].&[3]
,[Organization].[Organizations].&[14],[Destination Currency].[Destination Currency Code].&[100]
,[Scenario].[Scenario].&[1])cell properties value