export OLAP in SSAS 2005 to excel pivot table
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Hi genius, Nice to meet you here! When developing BI programs with SQL Server 2005, I got this problem: Users want the report should be exported in office excel 2003 format, and stored in PIVOT TABLE. We have decided to use OLAP tech in SSAS(SQL Server2005 Analysis Services) to generate cubes. If we just use excel as a client tool, and create a pivot table which connects to the cube database, it's ok. But, the users want to download the excel file from a web page, further more , they want to filter the data through the web page. How can I do? Wait inline. Thank you!