Help IN MDX

Here is my basic MDX looks like

I want to order by this query by

order by [ACCOUNT_HEAD.ACCOUNT_HEAD], [AC_NO.AC_NO], [SEQ.SEQ]

Code Snippet

select NON EMPTY {[Measures].[OPENING]

,[Measures].[TRAN_AMT]

,[Measures].[CLOSING]} ON COLUMNS,

NON EMPTY Hierarchize

({([ACCOUNT_HEAD.ACCOUNT_HEAD].[All account_head]

,[AC_NO.AC_NO].[All ac_no]

,[TRAN_DATE.TRAN_DATE].[All tran_date]

,[PARTY_NAME.PARTY_NAME].[All party_name]

,[SEQ.SEQ].[All seq])}) ON ROWS

from [TRIAL_BALANCE]

In this drill down report [SEQ.SEQ] is special column created in query to get the Running totals.

So basicaly I want the order of the query should be

order by [ACCOUNT_HEAD.ACCOUNT_HEAD].[All account_head],[AC_NO.AC_NO] and SEQ.

even though the [PARTY_NAME.PARTY_NAME] is before the [SEQ.SEQ] result should be orderdby [SEQ.SEQ] column.

Currently it is ordering first by PARTY_NAME and then BY SEQ.

In simple sql I know how to do it, But I dont know muchabout the MDX.

Or is there any way putting the SEQ column in before the PARTY_NAME and hiding it from the output IN MDX as I don't want SEQ column it is there just for getting the data in correct order.

November 17th, 2008 7:38am

Hi,

Please try this,

http://www.mssqltips.com/sqlservertip/3129/order-and-sort-with-mdx-in-sql-server-analysis-services/

Regards,

Manish

Free Windows Admin Tool Kit Click here and download it now
July 2nd, 2015 3:39am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics