Hi Experts,
This qry is taking around 20 sec to execute..Please help me in tuning this
WITH MEMBER [Ca1] AS ([Measures].[Ca])
MEMBER [Sa] AS ([Measures].[Ca],StrToMember(".[b1].[b2].[d2].[O]") )
MEMBER [Ds] AS ([Measures].[Ca], [D].[ID].&[206])
SET [Top 10%]
AS (
[Measures].[Ca],
Nonempty
(
BottomPercent
(
{[D].[OID].Members}
, 10
, [Measures].[Ca]
)
)
)
MEMBER [Top 10% Score] AS AVG ([Top 10%])
SELECT
(
{
[Measures].[Ca1],
[Measures].[Sa],
[Measures].[Ds],
[Measures].[Top 10% Score]
}
) ON COLUMNS,
(
{
[Date].[Calnder].[week].Item(0).Lag(11):
[Date].[Calnder].[week].Item(0)
}
) ON ROWS
from [Cube]
WHERE
(
[D].[Valid].&[Yes],
StrToMember("[aa].&[aa1]")
)
--Chinnu