SQL Server Performance

problem with refreshing data in olap report

Discussion in 'Analysis Services/Data Warehousing' started by biru, May 21, 2007.

  1. biru New Member

    hi...i have a question here..why does it take so long for me to refresh the data in an OLAP report?...when i want to refresh the data it will take about nearly 1 hour...for your infomation, i'm using SQL server 2000 and MS Excel 2000..my fact table contain a lot of data and i have about 7 dimension...it just take a few minutes to process the cube compared to 1 hour to refresh the data in the report...so what should i do to reduce the the time to refresh that data in the report?..anybody out there please help me...thank you..
  2. satya Moderator

    Are you asking the data refresh on the excel or on cube itself?
    What version of Office tools you are using?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. biru New Member

    hi..i'm asking about refreshing data on the excel...i'm using MS Office Professional Edition 2003...sorry coz in the ealier question i provided you with wrong info where by i said i'm using MS Excel 2000...is the refreshing data performance is slow because the excel is trying to get a lot of data from the cube?....
  4. satya Moderator

    I believe this is something you have check on connectivitiy & network contention from SQL Server to the cleint office component. I don't see anything we can do on OLAP server side to fine tune.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page