I'm new to the world of olap and cubes, so please excuse the basic question.
I am working on converting a legacy VB application that generates an excel
report. All calculations are performed directly within excel cells in a
loop. The single sql query takes under 2 mins, but the report takes 4 hrs to
generate.
I have already created a cube and in SSAS browser, I can essentially
reproduce the report.

What I would like to know is that what is the best practice to automate
creating an excel workbook from the cube. The workbook has about 8 sheets
for different "categories" which can be created by applying filters to the
same cube. I'd like to do this with minimum coding.

Thanks in advance.
Asim.

you can use the integrated pivottable
or this plugin:
http://www.microsoft.com/downloads/d...DisplayLang=en

there is no code, only cube usage.
(expect if you need to create advanced interaction)

you can also create reporting services reports.
then the user can export it.


"Asim" <saahmed (AT) gmail (DOT) com> wrote