Write back data comments to SSAS cube


  • 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?

    Saturday, August 24, 2013 10:16 AM


  • 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