Hello all,

I am implementing a OLAP solutions in SQL 2000. I created my Fact Table with
the necessary member keys and measures; the member keys are data type of
uniqueidentifier. When I created my Cube and all the dimensions, I received
the following:

Unable to count the members of the "Member Key i.e. Account ID" level.
Unable to open the record set
Error: The count-unique aggregate operation cannot take a uniqueidentifier
data type as an argument.

Is there a way to work around this? GUID is implemented through the entire
database schema.