Is there any way to optimize this query? the problem is with
performance in lager no of cells. i am trying to compare the value with
last year month.
thanks in advance

Faraz
-------------------------------------------------------------------------------------------------------------
MDX Query
-------------------------------------------------------------------------------------------------------------

With Cell Calculation MY_CELL For
'( { [Measures].[Sales Count]} )' As
'CalculationPassValue(Measures.CurrentMember, -1 ,Relative )',
CONDITION =' (ParallelPeriod ([Time].[Month Of
Year],1,[Time].CurrentMember),Measures.[Sales Count]) <
(CalculationPassValue( [Measures].[Sales Count], -1,Relative ) +
(ParallelPeriod ([Time].[Month Of
Year],1,[Time].CurrentMember),Measures.[Sales Count]) * 0.05)'
, SOLVE_ORDER ='2000', FORE_COLOR ='11005',
CALCULATION_PASS_NUMBER ='2', CALCULATION_PASS_DEPTH ='1'
SELECT
{ CrossJoin({[Customers].[Country].[USA].CHILDREN},{Measures.[Sales
Count]})} ON COLUMNS ,
{{[Time].[Month Of Year].MEMBERS}} ON ROWS
FROM [Sales] CELL PROPERTIES
[VALUE],[FORMATTED_VALUE],[CELL_ORDINAL],[FORE_COLOR]