Page 1 of 1

Special characters in picklist in Excel

Posted: Thu Nov 11, 2010 9:03 am
by 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

Re: Special characters in picklist in Excel

Posted: Thu Nov 11, 2010 1:13 pm
by tomok
Did you define your attribute as string or numeric?

Re: Special characters in picklist in Excel

Posted: Thu Nov 11, 2010 2:11 pm
by vladino
Hi,
attribute "picklist" is defined as string.