Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


how to get Maximum value

how to get Maximum value

how to get Maximum value

I have the following MDX query :

SELECT NON EMPTY { [Measures].[Maximum Duration - Fact Event Duration] } ON COLUMNS, NON EMPTY { ([Dim Event Processing].[Case].[Case].ALLMEMBERS * [Dim Event Processing].[Dim Event Processing].[Dim Event Processing].ALLMEMBERS ) }  ON ROWS  FROM [FISDW] WHERE ( [Dim Date View].[Date].&[2008/12/21] )

This gives me a result like this:

Resolution 89    27
Resolution 90     27
Resolution 93    18
Resolution 98    0
Resolution 102    18
Resolution 105    0
Resolution 112    0
Resolution 113    48
Response   254    11
Response   255    14
Response   974    20
Response   978    381
Response   979    11
Response   989    21
Response   992    526
Response   993    13
Response   1038    14
Response   1039    24

The first column being the Case, the second column is the [event processing] and the last column is the [Maximum Duration - Fact Event Duration].

Can anyone help me find a way to retrieve the maximum value of the last column within the first group: basically what's the MDX query in order to have the following result:
Resolution 113    48
Response   992    526



Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close