Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1558
  • Last Modified:

Excel Writeback

Hi !

I created writeback enabled cube and dimension in BIDS. How can I writeback dimension and cube measure in Excel?

Thanks
Fiona
0
iFiona
Asked:
iFiona
  • 2
1 Solution
 
Ardhendu SarangiSr. Project ManagerCommented:
HI Fiona,
Are you using Excel 2003 or Excel 2007? I dont think at this time Excel 2007 supports writeback.  Your best bet would be use VBA and code it in.
There is a very good online resource written by Charlie Maitland (see attached link) http://charliem.wordpress.com/2006/07/03/writebacks-to-ssas-2005/ which would be helpful to you.
I am sorry that I cannot help you further on this,
 
 
0
 
Ardhendu SarangiSr. Project ManagerCommented:
If you are using Excel 2003, then I can point you to the following resource http://office.microsoft.com/en-us/excel/HA011265551033.aspx
 
0
 
iFionaAuthor Commented:
Thank you so much! You have been a great help!

I did try the Excel 2003 Add-in. It supports the writeback for cube but not for dimension. Dimension writeback is what I'm looking for.

I am looking for writeback solution for Excel 2007 as well. Any thoughts?

The Charlie Maitland's link you provided, I 'm totally new in the VBA or ADO, do you have reference how to use Charlie's sample code? a starting point?

Thanks
Fiona
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now