Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-12 : 08:07:59
|
| Sarfaraz writes "HiI have a cube which consist of Dimension (Year, Quarter,Month, WEEk, day, and interval). I have measure spl maxocwtime which is calculated in each interval. Now I want to maximum of measure "spl maxocwtime" each day. But when I write a query it finds it finds sum. When I try to write max function it find max value for one particular day and show same for all the days in month. can some plz explain me how to provide set to max function that it will find max value of one field. Base on drill downYearquartermonthweekdayintervalI am new.Thank sarfaraz" |
|
|
|
|
|
MAx function