This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.
Are there any characters that cannot be used for account, level, and dimension names?
The pipe character (the vertical line symbol | ) should not be used in used in element names or memo/note fields because it is a reserved character in the Adaptive Insights API that acts a delimiter to separate data. Pipe characters are not supported in the Integration for Planning tool, and their inclusion in element names or source data can cause columns to be delimited incorrectly resulting in values being posted to the wrong columns.
We recommend completely avoiding/removing the use of pipe characters from the fields in your source system that you will be importing into Adaptive Insights.
You can also create a SQL column in your Data Source that removes pipe characters from the staging table. Please see an example SQL expression below:
REPLACE('|' WITH '' IN "ExampleField")