title: MDX query taking time
body: <p>I have MDX query as mentioned which is taking too much time to execute. vendor dimensions have ~90k data.</p>
  
  <pre>
  
      SELECT NON EMPTY { [Measures].[Amt] } on Columns
  FROM ( SELECT ({ Filter([Vendor].[Hr_Vendor].[Vendor],
                  [Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUINTILES TRANSNATIONAL KOREA CO LTD'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO INC'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO BA'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO AGT SA'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO BEL NV'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO CAN INC'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO AGENCIA EN'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO PHARM'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO COMMERCIAL GMBH'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO COMMERCIAL PTY LTD'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO COMMERCIAL LTD'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO TE LTD'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO HK'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO IMS'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO MIS INC'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO MIS IRE LTD'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='CONG TY TNHH QUNTICO NAM'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO PT'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO LAB'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO LTD'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO MI INC'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO S DE RL DE CV'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO DEV CO LTD'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO SERVICES'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO SERVICES'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO PROF SRV CTR'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO LTD'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO SL'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO SPA'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO TRA LTD'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTICO K K'),
                  Filter([Vendor].[Hr_Vendor].[Vendor],[Vendor].[Hr_Vendor].CURRENTMEMBER.Name='QUNTIC`CO UK')}
      ) ON COLUMNS 
  from [Cube])
  
  </pre>