Problem with Analysis Services

Hi all,

Wasn't sure where to post this since it encompasses more than just SQL Server.

Anyway, I'm trying to set the SliceValue for the time dimension of a partition. The problem I have is that a Carriage Return is being added to each level so when I try to process the Partition I get the following error: -

Processing error [Object does not exist] 'All Year
1998
Quarter 2'

My code is shown below: -

Dim dsoServer As New DSO.Server
Dim dsoDB As DSO.MDStore
Dim dsoCube As DSO.MDStore