question

RaviShukla-4539 avatar image
0 Votes"
RaviShukla-4539 asked ShaikMaheer-MSFT answered

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

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-servicespartner-center-api
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @RaviShukla-4539 ,

Following up to check is above comment helpful? Please let us know if any queries. Thank you.

0 Votes 0 ·

Hi @RaviShukla-4539 ,

Just checking is above comment helpful? Please let us know if any queries. Thank you.

0 Votes 0 ·

1 Answer

ShaikMaheer-MSFT avatar image
0 Votes"
ShaikMaheer-MSFT answered

Hi @RaviShukla-4539 ,

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.