Search code examples
azureprocesscalculated-columnspartitionazure-analysis-services

Memory allocation troubles SSAS Azure

Hello guys,

I have a cube on Azure and when I want to process the partitions (using SSMS) I have that error message Memory error: You have reached the maximum allowable memory allocation for your tier. Consider upgrading to a tier with more available memory.

The thing is that I still have 20gb free on my instance and one partition is something like 300mb. I think the problem could come from the calculated columns because the process is perfectly working when I don't have those calculated columns.

Any idea on how to solve it ?

Thanks a lot.

Solution

  • Actually my problem has been solved. I used that calculated column [column1]&[column2] to concatenate and it was not working. By changing it into CONCATENATE([column1];[column2]) it worked perfectly. I guess the & was part of the problem for some reason.

    Thanks.