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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-06 : 07:38:03
|
| ILHAN writes "I am using SQL SERVER 7.0 OLAP SERVER.I have built a cube and browsed with Excel XP pivot tables.But, everytime when i put new data in the main db table, do i have to rebuilt the cube in OLAP MANAGER? How can I re-process my Olap cube from Excel?Thank you in advance." |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-11-06 : 17:32:05
|
| When you add data, all the aggregates are affected. You will have to rebuild the cube.I'm not aware of any way to provoke a rebuild through a 'front end'. Rebuilding a cube is an administrator function not to be lightly undertaken.A cube with Write Back capabilities may be usefull to you, but I don't know whether EXCEL pivot tables support it. |
 |
|
|
|
|
|
Re-processing Olap Cubes from Excel