Hybrid Analysis sets the following limitations on transformation rules:
A database value cannot have a separator character that is the same as the one used for the prefix or suffix.
A member name cannot be more than 80 characters (excluding blanks).
A prefix or suffix must always have a separator associated with it.
If spaces are converted to underscores during a transformation, then the Hybrid Analysis Manager assumes there are no underscores present in the database value.
The use of all ancestors as a prefix or as a suffix is not supported.