none
Write back data comments to SSAS cube

    Question

  • I was wondering whether there is any way that users can create a pivot table using an SSAS cube as a connection and adding comments to specific rows which are then written back to the cube.</p>
    
    The reason why I ask is because when users create an adhoc report through excel they may need to comment specific rows. The issue is not creating a comment but writing the comment back into the cube or underlying data model.</p>
    
    Any suggestions?
    
    Thanks

    Saturday, August 24, 2013 10:16 AM

Answers

  • Hi Kurt,

    Thanks for your post.

    Currently, we can only update OLAP cube data by using Excel "What-If Analysis" functionality. It's not support writeback custom comment to OLAP cube. Thanks for your understanding.

    Best Regards,


    Elvis Long
    TechNet Community Support

    Tuesday, August 27, 2013 9:48 AM
    Moderator