we have a cube with open,high,low,close as the measures of our cube. This is the stock data. We have time and market sector as dimensions. When the cube is displayed we get the sum of open,high,low close resp, say for the year 1999, we have daily data and when we do rollup on month we get the aggregate of all the days. Instead of aggregate values we want max of the entire month. We tried using Max funtion, but somehow unable to understand how the function works.
Max(set,numberic expression)..... this is the syntax for the max funtion in MDX, can someone please tell what set and numeric expressions to use?
or is there any other way to implement the max funtion in the cube.