Forum Discussion

Greg_S's avatar
Greg_S
New Contributor II
4 years ago

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 an "Amount".  Is this case I have no amount so when I Ioad the data file, I get an error that "No Valid Data Keys in File".  It seems that this should be possible.  Maybe I should do this via Excel loads.

 

Data Sources
  • Greg_S's avatar
    Greg_S
    4 years ago

    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.

  • Greg_S's avatar
    Greg_S
    New Contributor II
    4 years ago

    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.

    • WernerN's avatar
      WernerN
      Contributor
      3 years ago

      Thanks Greg. Saved me some hours of issue analysis 😁

    • EricWW's avatar
      EricWW
      New Contributor
      3 years ago

      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!

      • Oscarvelasquez's avatar
        Oscarvelasquez
        New Contributor II
        2 years ago

        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

    • T_Kress's avatar
      T_Kress
      Contributor III
      23 hours ago

      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!