Hi All, IN SSRS R2 I have created report based on below mention MDX query ,but it will take more time say of 10 mins to execute.while other report having bulky data in their datset working fine. Kindly suggest how do i optimise the Query so it will take less time,though when i ran the same query in SSAS in gives result in 5 Sec . with member [measures].[A]as iif([Measures].[CALLSHANDLED]=0,0,[Measures].[HANDLETIME]/[Measures].[CALLSHANDLED]) member [measures].[B]as iif([Measures].[Avg After Call Work]=0,0,[Measures].[Avg After Call Work]) member [measures].[C]as iif([Measures].[Staff Time]=0,0,[Measures].[CALLSHANDLED]/[Measures].[Staff Time]) member [measures].[AA] as ((STRTOMEMBER(@EmployeeEMPLOYEENAME)), [Measures].[A] ) member [measures].[BB] as ((STRTOMEMBER(@EmployeeEMPLOYEENAME)), [Measures].[B] ) member [measures].[CC] as ((STRTOMEMBER(@EmployeeEMPLOYEENAME)), [Measures].[C] ) member [measures].[Rank_Avg_Handle]as (filter ([Employee].[EMPLOYEE NAME].[EMPLOYEE NAME].members, iif([Measures].[CALLSHANDLED]=0,0, [Measures].[HANDLETIME]/[Measures].[CALLSHANDLED])>[measures].[AA]).count) member [measures].[Rank_Aft_Avg_Call]as (filter ([Employee].[EMPLOYEE NAME].[EMPLOYEE NAME].members, iif([Measures].[Avg After Call Work]=0,0,[Measures].[Avg After Call Work])>[measures].[BB]).count) member [measures].[Rank_Call_End_Hour]as (filter ([Employee].[EMPLOYEE NAME].[EMPLOYEE NAME].members, iif([Measures].[Staff Time]=0,0,[Measures].[CALLSHANDLED]/[Measures].[Staff Time])>[measures].[CC]).count) member [measures].[Total_Aft_Call_Work] as count(filter({[Employee].[EMPLOYEE ID].children},([Measures].[Avg After Call Work])>0)) member [measures].[Total_Avg_Handle_Time] as count(filter({[Employee].[EMPLOYEE ID].children},([Measures].[HANDLETIME])>0)) member [measures].[Total_Call_End_Hour] as count(filter({[Employee].[EMPLOYEE ID].children},([Measures].[CALLSHANDLED])>0)) SELECT { [Measures].[HANDLETIME], [Measures].[Avg After Call Work],[Measures].[Staff Time], [Measures].[CPH Goal],[Measures].[ACW Goal],[Measures].[AHT Goal], [Measures].[CALLSHANDLED],[measures].[Rank_Avg_Handle], [measures].[Rank_Aft_Avg_Call], [measures].[Rank_Call_End_Hour], [measures].[Total_Aft_Call_Work],[measures].[Total_Avg_Handle_Time],[measures].[Total_Call_End_Hour] } ON COLUMNS, NON EMPTY { (filter({[Client].[PROGRAM NICK].[PROGRAM NICK].ALLMEMBERS}, ([Measures].[Staff Time])>0 ) ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@EmployeeEMPLOYEENAME, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@ClientCLIENTNAME, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@EmployeeSUPNAME, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@DateDate) ) ON COLUMNS FROM [Team Lead])))) WHERE ( IIF( STRTOSET(@ClientCLIENTNAME, CONSTRAINED).Count = 1, STRTOSET(@ClientCLIENTNAME, CONSTRAINED), [Client].[CLIENT NAME].currentmember ),STRTOSET(@EmployeeEMPLOYEENAME) ) Amit