Team , This seems to be a very simple Query and not sure why is it taking too much of time for a single day's date range , any pointers would highly be appreciated !

WITH MEMBER [Measures].[Active Census] AS 
[Measures].[Active Patient Count]

MEMBER [Measures].[Sum Active Patient Days] AS 
SUM(
                [Patient].[Patient].[Patient].MEMBERS,
        IIF( ([Measures].[Death Count]>0 OR [Measures].[Discharge Count]>0 )
                                                , [Measures].[Active Patient Days]
                                                , NULL
                                                )
   )           

MEMBER [Measures].[Active Medicare Census] AS 
SUM(
                [Patient].[Patient].[Patient].MEMBERS * [Insurance].[Insurance Type].&[Medicare],
        IIF( [Measures].[Active Patient Count] >0 , 1, NULL )
   )  

MEMBER [Measures].[Medicare Admits] AS 
SUM(
                [Patient].[Patient].[Patient].MEMBERS * [Insurance].[Insurance Type].&[Medicare],
        IIF( [Measures].[Admission Count] >0 , 1, NULL )
   )  
   
MEMBER [Measures].[Medicare Discharges] AS 
SUM(
                [Patient].[Patient].[Patient].MEMBERS * [Insurance].[Insurance Type].&[Medicare],
        IIF( [Measures].[Discharge Count]>0 , 1, NULL )
    )  
      

MEMBER [Measures].[Medicare Referral Count]  AS
SUM(
                [Patient].[Patient].[Patient].MEMBERS * [Insurance].[Insurance Type].&[Medicare],
        IIF( [Measures].[Referral Count]>0 , 1, NULL )
   )  
      
      
MEMBER [Measures].[Medicare Admits to Referral Ratio]  AS
IIF([Measures].[Medicare Referral Count]=0 OR
	 ISEMPTY([Measures].[Medicare Referral Count]) , NULL ,[Measures].[Medicare Admits]/[Measures].[Medicare Referral Count])

MEMBER [Measures].[Medicare Admits Discharge Ratio] AS
IIF([Measures].[Medicare Discharges]=0 OR
	 ISEMPTY([Measures].[Medicare Discharges]) , NULL ,[Measures].[Medicare Admits]/[Measures].[Medicare Discharges])



SELECT  
		 { 
			  [Measures].[Active Census]		  -- Census
			 ,[Measures].[Active Medicare Census] -- Census #M/C
			 ,[Measures].[Death Count]  		  -- Deaths
			 , [Measures].[Referral Count]		  -- # Referrals
			 ,[Measures].[Admission Count]         -- #Admits
			 ,[Measures].[Medicare Admits]		   -- #Medicare Admits
			 ,[Measures].[Medicare Discharges]     -- Medicare Discharges 
			 ,[Measures].[Medicare Referral Count] -- #Medicare Referral Count
			 ,[Measures].[Medicare Admits Discharge Ratio] --#Medicare Admits to M/C Discharges Ratio
			 ,[Measures].[Medicare Admits to Referral Ratio] -- #Medicare Admits to M/C Referral Ratio 
			 
			 
			
		 } ON COLUMNS,
		 
		NON EMPTY  (
						[Business Unit].[Business Unit].[Business Unit].Members * 
						[Patient Branch].[Patient Branch].[Patient Branch]
					) ON ROWS 


FROM 
(

SELECT 
( STRTOSET(@BusinessUnit), STRTOSET(@PatientBranch) ) ON COLUMNS
FROM [Patient Admissions]  

)
WHERE
IIF ( CDate(@StartDate)>TAIL([Time].[Date].members,1).item(0).member_value, 
{ null : TAIL([Time].[Date].members,1).item(0) }
, 
{ STRTOMEMBER("[Time].[DIM TIME].&[" + Format( CDate( @StartDate ) , "yyyyMMdd") + "]"):
STRTOMEMBER("[Time].[DIM TIME].&[" + Format( CDate( @EndDate ) , "yyyyMMdd") + "]") }
)