WriteBack in SSAS

Question

Post reply

WriteBack in SSAS

sabarichandru

SSCommitted

Points: 1704
More actions
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

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

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

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 1

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

sabarichandru SSCommitted Points: 1704 More actions · Answer 2

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

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 3

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

sabarichandru SSCommitted Points: 1704 More actions · Answer 4

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

sabarichandru SSCommitted Points: 1704 More actions · Answer 5

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