Unanswered: Problem Excel as OLAP Client with large volume of data
I am using Excel 2000 as my OLAP cube cleint. It's flexible and user friendly when I need to retrive data from cube. However, I am having problem when I need to retrive large volume of data from cube to the excel report (i.e: bank & finance report).
I tried link server but it doesn't make much different.
Can anyone tell me how to solve the problem, if I could only use excel or other license free application as my OLAP Client.