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 |
|
fotiss13
Starting Member
3 Posts |
 Posted - 2007-11-12 : 08:22:19
|
| Hi guys, This is my first post. Could anyone help me out? I am trying to refresh a cube that i created by using a new script command but i get the following error "the script contains the statement, which is not allowed." On the microsoft page i've read that for refreshing you need to create a new script. Is there another way for refreshing the cube? Cheers |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-12 : 22:54:20
|
| Do you mean processing the cube? Tried it in ssms instead of script? |
 |
|
|
fotiss13
Starting Member
3 Posts |
Posted - 2007-11-13 : 09:29:29
|
| I am adding a new script with the following statementREFRESH CUBE cube_nameand when i am trying to deploy the cube it throws that error. In SSMS if you right click the cube there is an oprion for refresh but when i am doing that it does nothing and the cube still holds the old data. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-13 : 22:50:06
|
| That statement refreshes the client cache for a cube. |
|
|
|
fotiss13
Starting Member
3 Posts |
Posted - 2007-11-14 : 11:36:22
|
| The client cache isn't the data that the cube holds? What i want to do is to include new data from the database... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-14 : 23:35:29
|
| Data are in cube on AS, client cache got data from cube instead of sql db. Sounds you need reprocessing cube. |
|
|
|
|
|
|
SQL Server 2005 SSAS - Refresh Cube