How to summerize Calculated Member in SQL2000

I have created a virtual cube in SQL2000. Then, I have generated a
Calculated Member. When I did rollup into a higher level, SQL2000 did
re-calculate the member. However, I want to summerize the Calculated
member. The Solve Order could not be worked in this situation since a
measure, which is used to generate the Calculate Member, will be
available only in the lowerest level of the dimension. Please help me!Anote Sangkunakupt (anote_un@.hotmail.com) writes:
> I have created a virtual cube in SQL2000. Then, I have generated a
> Calculated Member. When I did rollup into a higher level, SQL2000 did
> re-calculate the member. However, I want to summerize the Calculated
> member. The Solve Order could not be worked in this situation since a
> measure, which is used to generate the Calculate Member, will be
> available only in the lowerest level of the dimension. Please help me!

You might get better response in a group like
microsoft.sqlserver.public.olap.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp