Hi Nick,
Thanks for sharing!
So is it correct that we cannot import text comments via Excel import?
For now, the closest solution to what we are trying here is to enable the Text Value in the Cube Integration.
Then the text comments can be loaded to Stage.
You have a couple of options.
1. yes, you can load the text to stage and assign the annotation as any of the dimensions or label, just not value. I would set up an import only WF step. You could then create a sql procedure that queries the import table and inserts those values into the annotation table.
2. Process the excel file in a data adopter. You can use an extensibility rule to drop that into a table which you could then use to insert into the annotation table.
3. Create a custom table that houses all of these comments then create a dynamic calc that queries this table that way it can be shown on cube views or quick views.
