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.
Regards,
Bhavani
2 answers
Sort by: Most helpful
-
-
CarrinWu-MSFT 6,891 Reputation points
2021-07-07T05:48:01.013+00:00 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:
Analysis-Services/AsPartitionProcessing/
Tabular Object Model (TOM)Best regards,
Carrin
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.