Create monthly cube partition dynamically on azure analysis services using REST API method

Ravi Shukla 1 Reputation point
2021-08-20T08:15:37.903+00:00

Hello Team ,

I am using REST API method for processing the data on azure analysis cube that is working fine .

I need to create new partition for each month and process only particular month partition month only .

i.e. we are running on AUG 2021 hence we need to create the partition as TableName_Aug2021 and query will come as "select * from table name where date between '1-aug-2021' and '31-aug2021'".

once this partition gets created we need to process only this TableName_Aug2021 this partition using REST API method .

Please let me know if you need any information .

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
438 questions
Microsoft Partner Center API
Microsoft Partner Center API
Microsoft Partner Center: A Microsoft website for partners that provides access to product support, a partner community, and other partner services.API: A software intermediary that allows two applications to interact with each other.
316 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee
    2021-08-23T16:01:39.59+00:00

    Hi @Ravi Shukla ,

    Welcome to Microsoft Q&A Platform. Thank you for posting your query here.

    The Automated Partition Management for Analysis Services Tabular Models whitepaper is available for review. It describes how to use the AsPartitionProcessing TOM code sample with minimal code changes. It is intended to be generic and configuration driven.

    Could you please check below blog also,
    https://azure.microsoft.com/en-in/blog/azure-as-automated-partition-management/

    Please let us know if it is useful or any further queries.

    0 comments