Dynamic SSAS Tabular cube partition by using power shell script

sudheer 1 Reputation point
2021-09-23T02:26:27.43+00:00

Hi,

I am trying to develop a code for dynamic SSAS Cube partition automation by using windows power shell script. Could you please somebody help me how can we achieve it.

Do we have any other option than power shell scripting could you please let me know (Except SSIS Package) for dynamic cube partition automation.

Best regards,
Sudheer Babu.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,452 questions
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,243 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,359 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CarrinWu-MSFT 6,851 Reputation points
    2021-09-23T06:10:10.19+00:00

    Hi @sudheer ,

    Thanks for your posting.

    Except SSIS Package, you can also try TOM to achieve the same, it works for both Azure Analysis Services and SQL Server Analysis Services tabular models. Here has a similar issue that tabular model table partitioning unable to do using Powershell script on SSAS 2016 1200 compatibility.

    For more information, please refer to below links:
    Tabular Object Model (TOM)
    Automated Partition Management for Analysis Services Tabular Models

    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.

    0 comments