How to deploy SSAS CUBE using XMLA

Question

Hi

In my development environment, I can able to create and process/deploy SSAS CUBE using SSDT.
And in production environment, CUBE deployment is a manual process, where in we will execute .xmla script directly in analysis server.

Looking for guidance/options to execute .xmla script using script task in SSIS or using powershell script?

Thanks in advance.

Answer 1

Hey,
The below MSFT doc should help:

https://learn.microsoft.com/en-us/analysis-services/tmsl/tabular-model-scripting-language-tmsl-reference?view=asallproducts-allversions
Contains both powershell and SSIS details

Answer 2

Hi @Ganesh Sundaresan ,

Thank you for your post.

May I ask which model did you create, tabular model or multidimensional model? By using the Analysis Services Deployment Wizard, which can generate a deployment XMLA script that you can forward to an administrator who can execute the script directly in SSMS, by ASCMD, or by scheduling it in SQL Server Agent, provided he or she has the required administrative rights. If it is tabular model, please refer to Tabular model solution deployment. If it is multidimensional model, please refer to Multidimensional model solution deployment.

Best regards,
Carrin

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.