Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tyme
Starting Member
10 Posts |
 Posted - 2007-05-20 : 09:06:57
|
| 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..anybody out there please help me...thank you.. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-20 : 09:29:13
|
| maybe because you have heavy aggreation in your cubes?also i moved this to the Analysis Services (2000) forumif that's not to your liking please say where it should go.thanx._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
tyme
Starting Member
10 Posts |
Posted - 2007-05-20 : 10:16:14
|
| well,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?..actually i'm new to Olap...hope u can help me.. |
|
|
|
tyme
Starting Member
10 Posts |
Posted - 2007-05-20 : 10:22:53
|
| yes..u can move this topic to the Analysis Services (2000) forum |
|
|
|
|
|
|
refresh data in olap report