OLAP Modelling An error occurred while parsing EntityName.

unknown

Hi,

I've found an issue with publishing within OLAP Modelling:

Publish properties for dimension 'DIMENSION NAME X' failed. An error occurred while parsing EntityName. Line 1, position 162.

I have a number of dimensions this has failed to publish and they all have a common character; '&'.
Do we now have to rename the dimensions to exclude '&', what are my options?

VID013_SASO_Adding Dropdown, Extend Initiate and Submit.zip

John Robson

In v12 these are the rules:

These characters are not allowed in cube, dimension, and hierarchy:

• Characters with ASCII codes below 32.
• The [ ] / : * ? " < > and | characters.

A hierarchy name cannot start with a number. This is reserved for future use. There is an exception, an implicit hierarchy can start with a number. An implicit hierarchy name is the same as the dimension name. This is allowed for backward compatibility

& is not prohibited but I would never ever use it as in some contexts it will be interpreted as the add symbol for strings. I you stick to A-Z, 0-9 and _ you will never go wrong.

VID052_OEIO_Overview_Tab_Tour of New Features and Extending Tags.zip