Create an Analysis Server Scripts project in SQL Server Management Studio(SSMS)

Analysis Services Scripts Project in SQL Server Management Studio

to script Analysis Services objects

Create Analysis Services Scripts in SSMS

It will generate .xmla script with database metadata info:

Clear Analysis Services Caches

Clearing the cache manually is necessary if you are using Management Studio to deploy the model and change the query mode. In contrast, using SQL Server Data Tools to specify DirectQuery on the model and partitions will automatically clear the cache when you switch the model to use that query mode. there is no broad recommendation for clearing tabular model caches. If you are not managing the deployment of a tabular model that contains sensitive data, there is no specific administrative task that calls for clearing the cache.

How to steps: