Excel as Frontend to SSAS 2005 Cube

Hi, there,

I am working on Excel as a front-end to a SSAS2005 cube. I intended to create a simple add-in that allows users to write back to the cube. Users will first retrieve data from the cube to pivot table and write back to the cube from the pivot table. I can find some sample source based on adodb and AS2000 but not adomd .net and SSAS2005. For the time being, information on SSAS2005 write-back from Excel seems very little. Not much references that I can refer to.

Anyone can shed some light on this? I would appreciate it if you can provide me some sample source in VBA using adomd .net or others that can demonstrate the write-back to a SSAS2005 cube. It would be great if the sample will be based on the AdventureWorksDW cube.

Thanks in advance.

Regards,
Yong Hwee

You have code that connects Excel 2003 with SSAS2005 for writeback in this book: "MS SQL Server 2005 Analysis Services 2005, Step By Step", chapter 10.

The code saples for writeback I have seen are in books, like this one.

Regards

Thomas Ivarsson

|||

Hi, Thomas,

Thank you for your reply. I will try to look for the book in my local library. One more thing, do you come across any reference on the Excel add-in, Cube Analysis particularly in the What-if Analysis other than the published technical whitepaper?

Thank you.

Regards,

Yong Hwee

|||

Regarding the Excel Add-In. No! I have only downloaded and tried it.

Have you heard that MS is working on a new server for budgeting and financial modelling?

ProClarity and Business Scorecard server will also be a part in this solution.

Regards

Thomas Ivarsson

|||

Hi. Thomas is referring to the new PerformancePoint sevrer from Microsoft. Here's a public posting on the topic.

http://office.microsoft.com/en-au/FX101550371033.aspx

Thomas - we should catch up sometime.

PaulG

|||

Hi, Thomas and Paul,

Thanks for your replies. FYI, I am working on a DW/BI project on SQL Server 2005 Enterprise. Main deliverables are a number of monthly reports. I intended to make use of SSAS 2005 to deliver dynamic reports - users are able to produce reports on their own anytime and they are free to pivot. Of course, one of the requirements is to be able to write back from Excel frontend. I found that there are not much references on this subject.

BTW, thanks for your help and SQL Server 2005 is a great product.

Thank you.

Regards,

Yong Hwee