Forum Discussion
Solved
Loading Annotations Only via a Workflow
Is it possible to create a data source to load annotations only from a flat file. I am tagging the annotations in the flat file with the View dimension. It seems like the data source always wants a...
Found the issue. For future reference, on the Cube’s Integration Tab, ensure that the TextValue field is enabled for the desired Scenario Type. Lookup "Loading Cell Text as an Annotation Data Attachment" in the Design and Reference Guide.
Found the issue. For future reference, on the Cube’s Integration Tab, ensure that the TextValue field is enabled for the desired Scenario Type. Lookup "Loading Cell Text as an Annotation Data Attachment" in the Design and Reference Guide.
Thanks Greg. Saved me some hours of issue analysis 😁
Hi - I was able to load annotations from a data source into Stage, but it's not loading to the cube. Is there a way to load annotations so that it loads to the cube? As background, we have a form to capture some statistical data along with text and we have a user that wants to load the data via an Excel import vs typing the data into the form. As noted above, the data loads to Stage, but when we load to the cube, only the amounts show up in the form; the annotations are not loading to the cube.
Any help is much appreciated!
Dear Eric
Did you discover the answer to this? I'm also trying to figure out how to import text fields from a spreadsheet that uses the XFSetCell feature into an annotation view. I would really welcome any updates on this subject.
Regards
RobDessureaultOneStream Employee
I'm able to import and load cell text (V#Annotations) through an Import workflow profile.
Please note that cell text can be entered into any POV (including parent members). Depending on how you are using/displaying cell text, you can only load to the O#Import origin member. So if you are trying to migrate cell text from one app to another, the Origin member could vary. Meaning, if you entered cell text in one app (most likely at O#Forms or O#BeforeAdj), when you go to load into another app, the import process will only load to O#Import. so that might be an issue.
Here are the different Data Source setup you need to consider when loading in cell text (Annotations):
For the "Amount", you need to reference a column that contains data values - it can be any column, nothing happens with this, we just need to "fool" the system.
Hope that helps out.
- T_Kress
Ditto, I was able to use this solution on a customer this morning and it worked like a charm! They even had a matrix data load with comments only in M12 and we got it all working!
