Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Location
    Kuala Lumpur, Malaysia
    Posts
    6

    Angry Unanswered: Problem Excel as OLAP Client with large volume of data

    Dear all,

    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.

    Thanks!

    regards,
    Sam

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    You didn't mentioned about the problem you're having i.e., Performance related or query based.

    If its performance based what is the current configuration of server and database information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •