Skip to main content

logoCorrectSize.png

Workday Adaptive Planning KB

Reserved characters

This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release. 

Question

Are there any characters that cannot be used for account, level, and dimension names?

Answer

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")
  • Was this article helpful?