Loading Cell Text as an Annotation Data Attachment

To map cell text comments from a file into OneStream, here are a few tips to get started:

1. On the Cube’s Integration Tab, ensure that the TextValue field is enabled for the desired Scenario Type. This is needed to import the actual text.

2. Create a Data Source to import data for the Scenario Type.

   NOTE: TextValue is one of the mappable Dimensions.

3. Hardcode the View Dimension to import to the Annotation Member, or one of the other View Dimension Comment Members such as VarianceExplanation.

4. Map the comment text to the TextValue Dimension.

5. There may not be an Amount to bring in but select a column that has a decimal value in each row and a comment and link the Data Source to that column. These numbers will come into the Stage but will not end up in the Cube because they are mapped to an Annotation-type View Member.