Share via

SSAS Cube dynamic Partition and process without using SSIS is there any other approach.?

bhavani uppala 1 Reputation point
2021-07-06T07:24:53.527+00:00

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

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,263 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Darren Gosbell 2,376 Reputation points
    2021-07-06T23:23:11.79+00:00

    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

    0 comments
  2. CarrinWu-MSFT 6,866 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.