I have a query

SELECT

{[Measures].[Volume]} ON 0,

[Brand].[Brands].[Brand Family].ALLMEMBERS ON 1

FROM [Cube]

Which gives me

Brand A - 50
Brand B - 75
Brand C - 45
Brand D - 30

I Want an extra column that shows me the Max Value of my Answer so;

Brand A - 50 - 75
Brand B - 75 - 75
Brand C - 45 - 75
Brand D - 30 - 75

Any ideas How I do this?

Thanks

Denver

Depends on how generic a solution you need - here's a sample Adventure
Works query which returns the max value of the measure in the 1st
column, across all rows:

Max(StrToSet("Axis(1)"),
StrToSet("Axis(0)").Item(0))
select {[Measures].[Order Quantity],
[Measures].[MaxRowVal]} on 0,
[Product].[Product Categories].[Category].AllMembers on 1
from [Adventure Works]
---------------------------------------------------------
Order Quantity MaxRowVal
Accessories 61,931 90220
Bikes 90,220 90220
Clothing 73,598 90220
Components 49,027 90220

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

That doesn't seem to work, I'm happy just hard coding it in. It will
alway be the MAX of [order quantity]

Can you help?

DK

Well, since the query is against the standard Adventure Works cube, I'd
be curious to know what error you received
- I copied it from this thread and it seems to run fine.

You can easily modify it to "hard-code" the measure:

Max(StrToSet("Axis(1)"),
[Measures].[Order Quantity])
select {[Measures].[Order Quantity],
[Measures].[MaxRowVal]} on 0,
[Product].[Product Categories].[Category].AllMembers on 1
from [Adventure Works]
---------------------------------------------------------
Order Quantity MaxRowVal
Accessories 61,931 90,220
Bikes 90,220 90,220
Clothing 73,598 90,220
Components 49,027 90,220

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Excuse my ignorance, this does the job nicely,

I am not using Adventure Works and was trying to get it to work with my
own database.

Thanks a lot

Denver