I'm seeing some behavior I just can't explain.

I have a table, call it people. It has First_Name and Last_Name. In the
table, the first name and last name are either formatted in proper case
(John Doe) or all upper (JOHN DOE). Regardless of which way they're
formatted, they first and last name have the *same* formatting. (i.e.
they are either both upper or both proper).

I use this table as a dimension. I do nothing special with it and the
First Name and Last Name fields are used as properties at the lowest
level. Now here's the weird thing. When I display the first and last
name properties from the cube (either via an application or even with
the browser) the name's formatting is off. There are cases where the
name is John DOE. Not every case, just sometimes. Can anyone offer any
explanation for this?

Zach