InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 01:50:04 GMT20http://www.sqlservercentral.com/Forums/Topic1365614-17-1.aspxHi Guys,any thoughts about this post!can help would be appreciatedThank youTue, 02 Oct 2012 20:04:47 GMT8reat1shttp://www.sqlservercentral.com/Forums/Topic1365614-17-1.aspxHi guys,I am new to complex MDX queriesI have managed to write these queries but now i need to combine them all together so that I get 4 columns of result set instead of one columns in every result set.Can you please help me with this requestCan you please use the comment heading for the column names//=======================================================================================// Latest Bill//=======================================================================================WITH SET [Row Axis] AS NONEMPTY( {[Dim Customer].[Party Name].[Party Name].MEMBERS} * {[Insert Datetime].[Date].[Date].MEMBERS} ,([Measures].[New Charge Amount]) )MEMBER [Measures].[RowNumber] AS RANK ( ( [Dim Customer].[Party Name].CurrentMember, [Insert Datetime].[Date].CurrentMember ), [Row Axis] )SELECT { [Measures].[New Charge Amount] } ON COLUMNS,TOPCOUNT( [Row Axis], 1, ([Measures].[RowNumber]) ) ON ROWSFROM [ACCOUNT_LEVEL]//=======================================================================================// Oldest Bill//=======================================================================================WITH SET [Row Axis] AS NONEMPTY( {[Dim Customer].[Party Name].[Party Name].MEMBERS} * {[Insert Datetime].[Date].[Date].MEMBERS} ,([Measures].[New Charge Amount]) )MEMBER [Measures].[RowNumber] AS RANK ( ( [Dim Customer].[Party Name].CurrentMember, [Insert Datetime].[Date].CurrentMember ), [Row Axis] )SELECT { [Measures].[New Charge Amount] } ON COLUMNS,BottomCOUNT( [Row Axis], 1, ([Measures].[RowNumber]) ) ON ROWSFROM [ACCOUNT_LEVEL]//=======================================================================================// Biggest Invoices//=======================================================================================SELECT {[Measures].[New Charge Amount]} ON COLUMNS,TOPCOUNT( {[Dim Customer].[Party Name].CHILDREN}* {([Insert Datetime].[Date].CHILDREN)}, 1, ([Measures].[New Charge Amount]) ) ON ROWSFROM [ACCOUNT_LEVEL]//=======================================================================================// Lowest Invoices//=======================================================================================WITHMEMBER [Measures].[Invoice Rank] AS RANK( [Insert Datetime].[Date].CurrentMember, [Insert Datetime].[Date].CurrentMember.Siblings, ([Measures].[New Charge Amount]) )SELECT{ ([Measures].[New Charge Amount])} ON COLUMNS,TOPCOUNT(FILTER ( {[Dim Customer].[Party Name].CHILDREN}* {[Insert Datetime].[Date].CHILDREN}, ([Measures].[New Charge Amount])>0 ), 1, ([Measures].[Invoice Rank])) ON ROWSFROM [ACCOUNT_LEVEL]Thank you in advanceThu, 27 Sep 2012 23:29:51 GMT8reat1s