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 |
|
prashantpatil
Starting Member
5 Posts |
 Posted - 2010-04-19 : 09:06:00
|
Hi All,For the continuous support every day I need to full process one out of 2 cubes(SSSA Database) I have & swap them. To swap (Renaming SSAS Database) I am using XMLA code. The code is running under SSIS package .XMLA is getting generated Using auto generated script , as below<Alter AllowCreate="true" ObjectExpansion="ObjectProperties" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Object> <DatabaseID>BI-SSAS-3BP</DatabaseID> </Object> <ObjectDefinition> <Database xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100"> <ID>BI-SSAS-Live</ID> <Name>BI-SSAS-temp</Name> -- Change the Name here <Language>1033</Language> <Collation>Latin1_General_CI_AS</Collation> <DataSourceImpersonationInfo> <ImpersonationMode>Default</ImpersonationMode> </DataSourceImpersonationInfo> </Database> </ObjectDefinition></Alter>but frequently i am error i.e "The connection either timed out or was lost. " |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-04-19 : 10:01:51
|
| I am curious as to why you need to do a Full process each day?______________________________________________Talk sense to a fool and he calls you foolish. |
 |
|
|
prashantpatil
Starting Member
5 Posts |
Posted - 2010-04-20 : 10:17:00
|
| Actually for some custom hierarchies , we have created dimensions from fact tables that have huge data. In case of process update/Incremental , the time taken by the cube was a bit less than time it is taking for process full(which is even safer).If you have any idea about the error we are facing , please let us know. |
|
|
|
savior faire
Posting Yak Master
194 Posts |
|
|
prashantpatil
Starting Member
5 Posts |
Posted - 2010-04-22 : 03:22:26
|
| Hi , Thanks for the links.All these article are talking about is, Synchronization on two SSAS Databases between two servers.Is there any way of doing it for Single server ?I am following it as 1) Have two database suppose Name DB_LIVE , DB_OFFLINE2) All reports/Dashboard always point to DB_LIVE(created separate querying, processing windows).3) Process DB_OFFLINE daily & SWAP it with DB_LIVE(By renaming it as DB_LIVE->Temp, DB_OFFLINE->DB_LIVE, Temp->DB_OFFLINE) |
|
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-04-22 : 12:00:50
|
| You may be able to use the Attach/Detach feature in SSMS for Analysis services.I'm thinking you have DB_Offline on a different instance of Analysis Services, you process it, then Detach the database.Connect to the production server, Detach DB_Live, then Attach DB_Offine and change the name.Go to the other server and Attach DB_Live to the back up instance.http://technet.microsoft.com/en-us/library/cc280670.aspxYour installation may also be a candidate for failover clustering, per this link:http://technet.microsoft.com/en-us/library/bb500217.aspx______________________________________________Talk sense to a fool and he calls you foolish. |
|
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-04-25 : 08:01:50
|
| I was just reading some material on synchronization in a text I recently purchased. They say synchronization can be thought of as replication. I also read some material on Books Online.You may want to read this documentation.Just a suggestion.Good luck....______________________________________________Talk sense to a fool and he calls you foolish. |
|
|
|
|
|
|
|
|
SSAS cube renaming - time out issue