Hi all,

I have a [Defaults] Dimension with 2 levels below [Adjusted New Operating
Income] and [Adjusted Real Estate], to return a profitability %, I do some
division. There are 3 top level members on the [Defaults] dimension. Here
is the calculated member I have. Query execution is very slow, is there a
way to optimize this that would make it faster?

Thanks

IIF ([Defaults].[Hierarchy].CurrentMember.name = "All Accounts",
IIF(Abs(CoalesceEmpty(([Defaults].[Hierarchy].[Defaults].&[All
Accounts].&[Adjusted Real Estate],[Measures].[AmountToDate]),0)) < 1,
0,
([Defaults].[Hierarchy].[Defaults].&[All Accounts].&[Adjusted
Net Operating Income], [Measures].[AmountToDate]) /
([Defaults].[Hierarchy].[Defaults].&[All Accounts].&[Adjusted
Real Estate],[Measures].[AmountToDate])
),
IIF([Defaults].[Hierarchy].CurrentMember.name = "FFO Default",
IIF(Abs(CoalesceEmpty(([Defaults].[Hierarchy].[Defaults].&[FFO
Default].&[Adjusted Real Estate],[Measures].[AmountToDate]),0)) < 1,
0,
([Defaults].[Hierarchy].[Defaults].&[FFO
Default].&[Adjusted Net Operating Income], [Measures].[AmountToDate]) /
([Defaults].[Hierarchy].[Defaults].&[FFO
Default].&[Adjusted Real Estate],[Measures].[AmountToDate])
),
IIF([Defaults].[Hierarchy].CurrentMember.name = "NOI
Default",
IIF(Abs(CoalesceEmpty(([Defaults].[Hierarchy].[Defaults].&[NOI
Default].&[Adjusted Real Estate],[Measures].[AmountToDate]),0)) < 1,
0,
([Defaults].[Hierarchy].[Defaults].&[NOI
Default].&[Adjusted Net Operating Income], [Measures].[AmountToDate]) /
([Defaults].[Hierarchy].[Defaults].&[NOI
Default].&[Adjusted Real Estate],[Measures].[AmountToDate])
),0)))