Hi,

Our customer has replaced their server and reinstalled everithing from
scratch. Now I have problem with setting up the Analysis service.

I have a virtual cube with a role attached to it that limits the access to
one customer in the customer dimension. When visual totals are enabled it
only shows #Err in the role test. If I disable visual totals it works, but
then it show the total for all customers.

This all worked in the old setup on Win2000, Sql 2000SP3a, Analysis SP3a. The
new server is Win2003, SQL2000SP4 and Analysis SP4.

Please urgent help needed.

Stefan.