Posted By

qrist0ph on 01/20/09


Tagged

mdx


Versions (?)

get maximum from a cube


 / Published in: Other
 

  1. WITH
  2. MEMBER Measures.SalesAmount AS StrToValue([Measures].[Internet Sales Amount])
  3.  
  4. MEMBER Measures.norm AS Max
  5. (([Customer].[Customer Geography].[All].Children, [Customer].[Education].Members,[Ship Date].[Day of Week].Members),
  6. Measures.SalesAmount)
  7.  
  8. Select Measures.norm on Axis(0)
  9. from [Adventure Works]

Report this snippet  

You need to login to post a comment.