.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

MDX Max value across set

Posted By:      Posted Date: October 07, 2010    Points: 0   Category :Sql Server
Hi All,

I've a question around the use of the MAX() function in MDX.

What I want to do is to configure a calculated measure named [Peak Value] which is the maximum value of another measure across the shown set of Months.


Month    Measure    Peak Value
Jan        15            27
Feb        19            27
Mar        27            27
Apr        10            27

The issue I have is that the max value will be taken across all members at the current member level and not just the set being viewed in the browser or Excel. I.e. if Novemeber has a measure value of 30 this will be displayed instead of the requied value of 27.

I'm hoping there is a simple solution to this, so any help would be greatly appreciated.

Thanks in advance,


View Complete Post

More Related Resource Links

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend