Import TextValue from Matrix-Excel
Hi, I have an Excel template file to import via the stage. This Excel is using a matrix-style for the values (time in columns) and also one column with a text commentary. As I have to change the vi...
Forum Discussion
Please use the TV#:[Annotation] in the Excel and leave the View as YTD.
Remember that Annotation is not loaded in the cube.
Look at the help below
Thank you Nicolas, this response greatly helped me figure out a solution to my issue. I want to include two additional steps / reminders that I had to take in order for my imported Annotation data to show up in a cube view.
1. Make sure the Text Value field is enabled in your cube's integration settings so the data will be imported to the stage (as Nicolas is showing in his screenshot above) - kudos to this post for that tip
2. Make sure your cube view Origin member for the annotation data is O#Import - I had to change mine from what I usually use, O#BeforeAdj, because text data does not roll up from O#Import or O#Forms into O#BeforeAdj.