I am building an SSAS multidimensional cube where I have to define more than 100 partitions since I am handling a huge volume of data. I want to automate creating these partitions within visual studio.
After searching i found a method to create partitions programmatically using AMO.net and C#, but these will create them directly inside the deployed cube, so when you need to edit anything in the cube within visual studio, it will require deploying the project and overwrite the existing database and remove all defined partitions.
Is there is a way to easily define a lot of partitions within visual studio (analysis project) not the deployed analysis database?
You can perform changes to your cube, and then incorporate the changes into the your Analysis Service Tabular Model using the following steps: