Tabular Model Processing

Avhilash Kumar 21 Reputation points

If a large Tabular Model cube processing in progress and I stopped it manually or it got failed, what will be the impact of it in the exisint cube there. will all the data in the existing cube be dropped. What's the logic behind it . Can any of you experts plz explain.


SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,208 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 27,066 Reputation points

    Hi @Avhilash Kumar ,

    When you click the process full command for a cube that has already been processed, Analysis Services checks to see whether any design changes have been made to the cube. If changes have been made, the server processes the changes before processing the cube. The SSAS server then generates a set of temporary fiess containing replacement data for the cube. As soon as processing has been completed successfully, the sever deletes the current cube and renames the temporary cube with th permanent names.

    So during processing period, there will need double memory size to store a single cube.

    In your scenario, if you stop the cube processing manually or it got failed, the old cube will remain. If you issue a process clear before processing full, then all the data will be cleared out.



    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments