Forum Discussion

LisaC's avatar
LisaC
New Contributor II
2 years ago

Import Text Comments from Excel to Cube (Cube View)

Dear community, 

We build an Excel import template (XFDRange) for our client's planning process. 

We understand it is possible to load Text Value into Stage; however, we need to retrieve the comments in a cube view for an overview, so the comments need to be stored in the cube.

Currently, we set two different columns for the View dimension, one for Periodic view to import the data and the other for Annotation to import text. 

 

We saw there were some similar questions raised in the community, but solutions are not applicable to our case. 

Hoping to get some more suggestions regarding this!

 

Thank you in advance! 

Data Integration
Data Sources
Import
Transformation
Workflow
  • NickHymes's avatar
    NickHymes
    New Contributor III
    2 years ago

    Hi Lisa,

    so if you create a annotation column in your cube view the comment doesnt show? Also, comments do not get stored in the cube. They get stored in a separate data table. Im not sure if this would help but you could try copy and pasting your comments after the cube view is populated. Or having users add comments directly to the cube view as a final step.

     

    thanks,

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

    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.

     

    • Mattb_0124's avatar
      Mattb_0124
      New Contributor III
      2 years ago

      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.