AX 2012 SSAS Cubes Deployment Wizard running slow

This question is not answered

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

All Replies
  • Anyone.....?

    Best Regards,

    Michael Brown