How to summerize Calculated Member in SQL2000 -- sql server (alternate)

anote_un NO[at]SPAM hotmail.com
7/7/2003 11:31:02 PM

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

Erland Sommarskog
7/8/2003 10:15:48 PM

Anote Sangkunakupt (anote_un@hotmail.com) writes:
[quoted text, click to view]

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

sql server (alternate) : How to summerize Calculated Member in SQL2000