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 |
|
Q
Yak Posting Veteran
76 Posts |
 Posted - 2006-08-03 : 10:27:40
|
| Hey there, I've made a view which executes in about 2 minutes. When using this view to make a cube, the processing seems to take for ever. Are there any guidelines how to process your cube as fast as possible? I've 3 dimensions; date, vendor and item.Don't know what to post here to explain the problem further, but if you have any questions I'll try to answer them as fast as possible! Greetz Q |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2006-08-07 : 06:04:33
|
| In my experience, you're better off building your cubes from tables rather than views. I'd set up a stored proc to populate a cached table with the results of your view, then point AS at this. I've achieved big processing performance improvements this way in the past. |
 |
|
|
Q
Yak Posting Veteran
76 Posts |
Posted - 2006-08-07 : 08:33:23
|
| Used this method and now it works great! Thanx |
|
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2006-08-08 : 06:52:08
|
| No problem Q. Glad it helped!Mark |
|
|
|
|
|
|
performance