The easiest way to dynamically add or remove partitions is to use AMO which is a .net library. Technically you could also write raw XMLA commands, but that would be massively complex and error prone and I would not recommend attempting this. A lot of people use SSIS because it is a way of hosting a script component, that can run .net code. But you could also write a custom console application or you could use a PowerShell script
SSAS Cube dynamic Partition and process without using SSIS is there any other approach.?
Scenario is below:
I have SSAS multidimensional cube. Need to create partitions dynamically for each quarter and should process only current quarter data.
Gone through many searches can see using SSIS tool with using AMO or store procedures using different tasks inside SSIS.
Is there any other approach without using SSIS tool for dynamic partitions and process?
Any suggestions please.
Hi @bhavani uppala , we have not get a reply from you. Did any answers could help you? If there have any answers helped you, please do "Accept Answer". If not, please let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!
Sign in to comment
Sort by: Most helpful
Hi @bhavani uppala ,
Welcome to Microsoft Q&A!
Except the methods mentioned by dgosbell, you can also try TOM to achieve the same, it Works for both Azure Analysis Services and SQL Server Analysis Services tabular models.
Please refer to below URL for more detailed information:
Tabular Object Model (TOM)
If the answer is helpful, please click "Accept Answer" and upvote it.
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.