August 31, 2005 at 7:51 am
Dear Forum,
I am looking to allow redistribution via a website running IIS5 of an Excel Spreadsheet containing a link to an analysis services OLAP cube. This should be made so that users cannot download the sheet locally but have to view it from the server.
Ideas I had were :
1. To use ASP to open the sheet and its OLAP connection using a password supplied in the server-side VBS. This would mean that saving the file locally would make it useless as this password would be needed to open it.
2. To script out the contents of the Excel sheet using asp. This would be unimaginably difficult considering the pivot-tables and charts contained in it.
3. Open an excel sheet that contains a link to the analysis services cube. This would be the preferred route but I don't know how or if it would be possible to enforce the cube roles from the web to restrict users to certain functionality.
Does anyone have any experience in this or comments on these ideas?
Thanks, Bill
September 1, 2005 at 12:34 am
Hi, You could use the office web component to deploy the excel pivot table sheet on IIS.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply