Query Performance Tuning - Expert Cube Development with SSAS Multidimensional Models - page 233

[Measures].[Internet Tax Amount]
/
Count
(
TopPercent
(
{
[Scenario].[Scenario].&[1]
,[Scenario].[Scenario].&[2]
}*
[Account].[Account].[Account].MEMBERS*
[Date].[Date].[Date].MEMBERS*
[Department].[Departments].[Department Level 02].MEMBERS
,10
,[Measures].[Amount]
)
)
SELECT
{
[Measures].TEST1
,[Measures].TEST2
} ON 0
,[Customer].[Gender].[Gender].MEMBERS ON 1
FROM [Adventure Works]
A quick glance over the code shows that a large section of it occurs twice in both
calculations - everything inside the Count function. If we remove that code to its
own calculated member as follows:
WITH
MEMBER [Measures].Denominator AS
Count
(
TopPercent
(
{
[Scenario].[Scenario].&[1]
,[Scenario].[Scenario].&[2]
}*