Azure Analysis Services Rolling Weekly Partitions

James H. Robinson 161 Reputation points
2021-01-26T02:23:22.61+00:00

What is the best way to create rolling weekly partitions for Azure Analysis Services? We would like to be able to process the most recent week of data.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
439 questions
{count} votes

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 19,381 Reputation points Microsoft Employee
    2021-01-26T20:25:16.833+00:00

    Hello @James H. Robinson ,
    Thank for the ask and using the Microsoft Q&A forum .
    We think you can use the steps called out here .Also I think we can use a query similar to one mentioned below .

    SELECT [dbo].[Sales].* FROM [dbo].[Sales]  
    WHERE (([OrderDateKey] >= WorkDate >= dateadd(day, 1-datepart(dw, getdate()), CONVERT(date,getdate())) )   
    AND ([OrderDateKey] <= dateadd(day, 8-datepart(dw, getdate()), CONVERT(date,getdate()))  
    ))  
    

    Thanks
    Himanshu
    Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members