Today, after I changed the relational database that feeds the cube from compatibility level 100 (2008) to 120 (2014), the cubes no longer process (we had to stop the process after taking 5+ hours instead of the usual 10 minutes). The problem is indeed CL change since after reverting back to 100, it fixes the issue.

I have not seen any documentation regarding this issue or I cannot even understand what is the issue, because SSAS was NOT changed at all... the only change was on the DB for the DB-engine side.

Please note again that I changed the CL , not on the cube/SSAS, but on the database that has the fact and dimensions. Any help is appreciated. Thank you very much in advance.

Today, after I changed the relational database that feeds the cube from compatibility level 100 (2008) to 120 (2014), the cubes no longer process (we had to stop the process after taking 5+ hours instead of the usual 10 minutes). The problem is indeed CL change since after reverting back to 100, it fixes the issue.

I have not seen any documentation regarding this issue or I cannot even understand what is the issue, because SSAS was NOT changed at all... the only change was on the DB for the DB-engine side.

Please note again that I changed the CL , not on the cube/SSAS, but on the database that has the fact and dimensions. Any help is appreciated. Thank you very much in advance.

that is most likely related to the changes on CE engine in 2014 or high CL level. if you are indeed in 2014 you either turn it off or try to change the queries/indexes that are causing the issue - probably the execution plan chosen is bad compared to the previous one - and not always possible to change the queries to behave as it should.

Thank you for your reply. But even if such is the case, there is no way I can interject "CE" changes or any changes to the query. The cube "processing" is very automated - I mean, it's just a click: "Process" if done through SSMS. If I use SSIS , which is what I'm doing now, there are no options to add CE off command.

Thank you for your reply. But even if such is the case, there is no way I can interject "CE" changes or any changes to the query. The cube "processing" is very automated - I mean, it's just a click: "Process" if done through SSMS. If I use SSIS , which is what I'm doing now, there are no options to add CE off command.

yes you can do something about it.- indexes can be changed- direct access to tables can be changed to views where some hints are possible- force query plans can be used.- if views already in used they can be changed