I am trying to calculate the Standard Deviation for 200,000 Student scores
in a fact table.

When I create a measure using Cube Editor called 'MathScore' for the 200,000
Students, I cannot use the Stdev aggregate function.

Nor can I create a student dimension for the 200,000 student members. I get
the error that you cannot create a dimension with more than 64,000 members.
If I could do that, I would be able to use MDX and call the Stdev function
in my query.

I don't want a dimension larger than 1000 members, but I have to get the
standard deviation of 200,000 scores. How can I do this in a cube?

thank you,
tim