Unicode References

HI Folks,

Can we use Unicode Characters in Anaplan? As of my knowledge, we shouldn't use as it might reduce the performance of the model. Is that true? (I have access to One APP which itself built by Anaplan and I can see Unicode characters over there)

If we can use it, can someone give or suggest the source where to get those from (Standard resource that Anaplan is using, not from Google search 😃)?

Regards,

Kavin.

Accepted answers

All comments

usman.zia

Hi @kavinkumar

Please see the link below:

https://help.anaplan.com/anapedia/Content/Import_and_Export/Get_Started_with_Imports/Tips_for_Importing_Special_Characters.html

I hope this helps!

Thanks,

Usman

DavidSmith

This is the advice we got from Michael Gould himself on the use of Emojis some years ago which is still valid

"Aside from the visual impact, these characters will almost certainly cause integration problems at some point with unusual characters being imported/exported from other systems, or names of actions not coming through properly in API calls etc. Many of these characters are not in the Unicode base plane"

Some of the visual impact issues are:

Emojis don’t render properly and look like a binary file icon
Characters render differently on different operating systems/browsers
Bad spacing – icons can be too close to the text, not centered in the space
Icons can be too small to see clearly
Causing unnecessary clutter in status fields that make it harder to read the text
Gratuitous characters in buttons that don’t mean anything

Hope this helps

David

ben_speight

Anaplan represents Unicode text internally using UTF-16 - the only limitation I know of concerns the use of code points in the supplementary plane (that is, those above 65535) - these are represented by a so-called "surrogate pair" of two code units. So whilst Anaplan has no problem accepting them, if you have formulae that manipulate them (eg LEFT/RIGHT/MID/LENGTH) then they can cause those pairs to be split, or the length in code units can be larger than the length in code points. Supplementary code points are usually very rarely used, but they do include the emojis mentioned by David.

When importing text, it is important to know which encoding is being used by the system producing the file to map the characters into bytes, and to ensure that this encoding is specified when uploading to Anaplan. Some encodings can only represent a subset of Unicode, so I'd recommend using UTF-8 if possible.

When importing data, Anaplan will perform normalization of text when performing matching on name/code. This means that where there are more than one way of representing some text, they are considered the same. Once imported, other operations (such as manual addition of items) do not perform this normalization so some care may be needed.

Non-breaking and other spaces can also cause problems when people aren't aware of them. So in summary supporting Unicode is one thing (and is itself not a simple yes/no question), being able to manage the complexity it introduces can be another. I don't know of any model performance issues related to Unicode, though.

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385