How to summerize Calculated Member in SQL2000

[Anote Sangkunakupt]

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!

[Erland Sommarskog]

Re: How to summerize Calculated Member in SQL2000

Anote Sangkunakupt (anote_un@hotma il.com) writes:[color=blue]
> 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![/color]

You might get better response in a group like
microsoft.sqlse rver.public.ola p.



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

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp