SQL Server Performance Forum – Threads Archive
problem with refreshing data in olap report
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..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.
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?….
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.
]]>