Dear All,

Hope anyone can give me ideas on how to solve this problem.
I have a cube with some calculated measures. The application that access
this cube uses query-scope calculated member, for example to get the the
cancer incidence rate per 100,000 in 3 counties, the query would be:
WITH MEMBER [Geography].[AHierarchy].[NewCommunity] AS
SUM({[Geography].[AHierarchy].[COUNTY].&[Beaver],[Geography].[AHierarchy].[COUNTY].&[Allegheny],[Geography].[AHierarchy].[COUNTY].&[Washington]})
SELECT {[Geography].[AHierarchy].[NewCommunity]} ON COLUMNS ,
      {[Year].[AHierarchy].[Year Id].&[2000]} ON ROWS
FROM [ExtendedDemo]
WHERE [Measures].[Cancer Incidence/100,000]

[Measures].[Cancer Incidence/100,000] is a calculated measure;
[Geography].[AHierarchy].[NewCommunity] is dynamic based on user selection.
Now the question is how to make calculation of member
[Geography].[AHierarchy].[NewCommunity] to be done before the calculation of
[Measures].[Cancer Incidence/100,000]. This query actually worked fine in
earlier beta version of SQL 2005 until we start using June CTP edition. I
tried to use the solve order attribute but it did not work.

Thanks a lot,

Wayan