Post reply

WriteBack in SSAS

  • August 16, 2010 at 3:17 am

    #225839

    Hi ,

    I created the cube . this cube is accessed through Excel . but my problem is if i change any value in Excel the concern Dimension table should get reflected . i heard the concept called "WriteBack" but i never worked on this.

    i need to complete this task End of today. so can anybody guide me how to accomplish this task .

    Thanks in Advance!

    Sabarinathan

  • August 16, 2010 at 3:36 am

    #1207234

    a quick Google and.....

    Based on latest versions of SQL / Excel this article explains how

    http://blogs.msdn.com/b/excel/archive/2009/10/12/excel-2010-pivottable-what-if-analysis.aspx

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • August 16, 2010 at 5:16 am

    #1207274

    Hi Gah,

    Thanks for your quick reply.

    but i like to ask whether the WriteBack Feature will be support in Excel 2003 & 2007 .

    because i created Cube in SSAS2008 and accessing the cube using Excel 2007 .

    tell me first whether the write back functionality will support in Excel 2007 . if , tell me what options i should enable to reflect the changed values to Dimension table.

    Regards,

    Sabarinathan

  • August 16, 2010 at 5:44 am

    #1207280

    sabarichandru (8/16/2010)

    Hi Gah,

    Thanks for your quick reply.

    but i like to ask whether the WriteBack Feature will be support in Excel 2003 & 2007 .

    because i created Cube in SSAS2008 and accessing the cube using Excel 2007 .

    tell me first whether the write back functionality will support in Excel 2007 . if , tell me what options i should enable to reflect the changed values to Dimension table.

    Regards,

    Sabarinathan

    I am sorry but I cant really answer your questions with any degree of certainty...this is an area that I have just started researching myself for a future business project.

    Hopefully others with more experience will chip in with more detailed advice.

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • August 16, 2010 at 7:39 am

    #1207341

    Once more thanks for your reply.

    Another short question . i came to know in Excel we should write Macros to update the values to Dimension Table.

    is it!

    Thanks in Advance!

    Sabarinathan

  • August 17, 2010 at 6:29 am

    #1207804

    Hi,

    Sorry to trouble you .

    i tried in many ways but i can't accomplish the task . but i like to know what kind of Research u did reflecting the changed value to cube from Excel 2010.

    if you give some idea so i can recommend my manager to go ahead with Office2010 to run this project smoothly.

    i read out many documents they told to write macros to refelect the changes to Cubes if we are using Excel2003/07.

    But in Office 2010 they mentioned whatever the value we changed in Excel2010 will directly get reflected to the cube without any settings and manipulation.

    so, anybody guide me . it will be helpfull for my career.

    thanks in Advance!

    Sabarinathan

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply