Ok.. I guess the error I got was not due to the way I was doing it.. the test table I just created to post this worked.. so the data type (on the OLAP) server must be the issue...

Msg 8117, Level 16, State 1, Line 5

Operand data type nvarchar is invalid for sum operator.