Special characters in picklist in Excel

[vladino]

Hi all,
we have to use special characters in picklist attribute. One of our picklists should look like this:
static:1-:1:1+:2-:2:2+...

From cube viewer it is working correctly, but in Perspectives i can see only numbers without "-" and "+" signs. We have tried quotes but then we saw zeros instead of numbers, ie. when used "1-":"1":"1+" in picklist, in Excel there were three zeros.

How to fix this?

Thanks,
Vladino

[tomok]

Did you define your attribute as string or numeric?

[vladino]

Hi,
attribute "picklist" is defined as string.