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 |
|
Zul
Starting Member
17 Posts |
 Posted - 2009-06-24 : 02:28:15
|
Hi AllI want to ask again now i want make projecet Businnes Inteligent using SQl 2005.i all ready have database.i,ve try to make analyst servive to make dimension and cube.i want to ask is how can analyst service can update my data?or analyst service always update data if data in my database has change then the data in analsyt service has change too.thanks for the answerZul |
|
|
VipulM
Starting Member
9 Posts |
Posted - 2009-06-24 : 06:09:25
|
| Data in the analysis cube have to be updated if the table data is changed and you want the changes to reflect in cube.you can take help of SSIS to process the SSAS cube.(i don't have much idea how !! )Cheers !!--Vipul Mochi |
 |
|
|
|
|
|
Update Analyst Service