Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  Provide access to predefined Excel sheets & SSAS

Author  Topic  dirklx Starting Member 13 Posts Posted - 2007-12-01 : 05:47:31 I wonder if I'm the only one that likes to get this done? 1. I have setup a SQL server and SSAS instance providing my analysis capabilities. 2. I also created a set of Excel spreadsheets that show the various views my customer requires. 3. Ideally I would like to provide a link to my customer that automatically resolves in a Pivot table report that I prepared beforehand. All my customer has to do is to click it. All data will be drown from the underlying OLAP cube. 4. I don't want to use SSRS, I don't want to use Excel service. Question: is something like this possible? I do have all the MDX queries that are used. Multiple links would be fine, too. If not possible, how are you serving your clients? Thanks and regards, Dirk