advanced code snippet search

Posted By

qrist0ph on 01/20/09


Tagged

mdx


Versions (?)

get maximum from a cube

 / Published in: Other
 
Expand | Embed | Plain Text 
  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.