Tabular Model Processing

Question

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.

Regards,
Avhi

Answer 1

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.

Regards，

Zoe

---

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.