Question Status

Unanswered
MBrown1185 asked a question on 6 Jul 2013 12:42 AM

Hi All,

When we deploy SSAS cubes using SQL Server Analysis Services Wizard, it takes a lot of time to compile the project and deploy to SSAS instance.

The Wizard is being  run on AOS machine and SQL+SSAS is deployed on a different box. SQLversion is SQL Server 2008 R2 and OS is Windows Server 2008 R2 on both boxes.

Any tips on reducing this time period??

Are there any techniques of checking how the cube will look like, before running Wizard? I am already opening Views in AOT for checking correctness of data.

Best Regards,

Michael Brown

Reply
MBrown1185 responded on 8 Jul 2013 4:27 AM

Anyone.....?

Best Regards,

Michael Brown

Reply