Welcome in Dinesh Patel Blog

http://www.mssqltips.com/sqlservertip/2565/ssas--best-practices-and-performance-optimization--part-1-of-4/ 

WITH MEMBER  [Measures].[ParameterCaption]  AS  [ReInsurer].[Re  Insurer Name ]. CURRENTMEMBER . MEMBER_CAPTION MEMBER  [Measures].[ParameterValue]  AS  [ReInsurer].[Re Insurer Name]. CURRENTMEMBER . UNIQUENAME MEMBER  [Measures].[ParameterLevel]  AS  [ReInsurer].[Re Insurer Name]. CURRENTMEMBER . LEVEL . ORDINAL SELECT  {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]}  ON   COLUMNS ,  ORDER ([ReInsurer].[Re Insurer Name]. CHILDREN ,[Measures].[ParameterCaption], BASC )  ON ROWS FROM   [CBProcedeReporting]

http://www.reckeweg-india.com/

DECLARE  @Country  VARCHAR ( 20 )  SET  @Country  =  'US'     SELECT  *      FROM  Sales.SalesOrderHeader h ,  Sales.Customer c ,           Sales.SalesTerritory t      WHERE  h.CustomerID  =  c.CustomerID          AND  c.TerritoryID  =  t.TerritoryID          AND  CountryRegionCode  =  @Country     OPTION  ( OPTIMIZE  FOR  ( @Country  =  'US' ))

Clear the procedure cache between runs you can use the DBCC FREEPROCCACHE command

Link:  http://www.mssqltips.com/tip.asp?tip=1429

Link:  http://www.mssqltips.com/tip.asp?tip=1474&ctc