Special characters in picklist in Excel
Posted: Thu Nov 11, 2010 9:03 am
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
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