title: MDX Help and tutorial
body: <p>Hello guys again here with my MDX headaches (why does my boss think programmer = solve anything computer related).</p>
  
  <p>The measure of the Filter 
  Productos is compose this way [Casa].[Linea].[Producto] and I am trying to filter by Linea 72 and 74, outside this anyone know a good tutorial online or book for MDX?</p>
  
  <p>Anyways here my MDX so far</p>
  
  <p><code>SELECT 'Dic  1 2010' AS Fecha, A.*<br>
  from (SELECT
  "[Measures].[Piezas Dia]",
  "[Measures].[P Redondeadas]"
  FROM openrowset('MSOLAP'
  ,'DATASOURCE=XXX
  ;Initial Catalog=XXX
  ; User Id=XXX;Password=XXX;',
  'WITH  SET [Lineas] AS ''
  FILTER(DESCENDANTS([PRODUCTOS],[LINEA],SELF),<br>
  ANCESTOR([PRODUCTOS].CURRENTMEMBER,SELF) &lt;&gt; [74 VARIOS] AND<br>
  ANCESTOR([PRODUCTOS].CURRENTMEMBER,SELF) &lt;&gt; [72 VARIOS] )''
  Member [Measures].[Piezas Dia]   AS ''sum([Lineas],[Measures].[|P| Venta Dia Año Actual])''<br>
  Member [Measures].[P Redondeadas] AS ''sum([Lineas],[Measures].[Venta Piezas Redondeadas])''
  SELECT {[Measures].[Piezas Dia], [Measures].[P Redondeadas]} on columns 
  FROM [Venta Gerencial]
  WHERE ([Fecha Diario].[Fecha].&amp;[2010].&amp;[12].&amp;[1])')) as A</code> </p>
  
  <p>Thanks for all help provided.</p>