Tabular Model processing a calculated table (recalc)

Question

I have a calculated table in my SSAS Tabular Model which is getting data load using a dax script. when we are checking the data using evaluate tablename' in ssms , I am getting errror like- table need to be processed or recalc. When we are processing this table in ssms, it complete immediately with 0 rows shows.
How to process / recalc this table. ( If I process the whole cube then this table will be get processed, but its not possible to process the cube as a whole due to huge size.)

Any help will be appreciated.

Thanks,
Avhilash

Answer 1

Hi @Avhilash Kumar ,

Build checks that your project makes sense. Deploy copies your model to the target server but the cubes and dimensions over there are not affected until the deployed model is processed. Process uses the model you've deployed, reads the database(s) and calculates the cubes and dimensions.

Since you keep saying SSMS, I would like to ask you if you have created your Tabular project in Visual Studio (VS)? Because you can Deploy only in VS.
I did the same test in SSMS as you (Process Table on the calculated table). The result is also the same as yours(it complete immediately with 0 rows shows). But there is only Process option in SSMS.

Please see my test in VS. First, I created a calculation table and saved it. At this time, I Process All:

As you can see, this calculated table is not in Process All.

Now, we Deploy this model:

We can see the calculated table.
So that's the reason you see 0 rows shows. Again, there is only Process option in SSMS.

To summarize, Process uses the model you deployed last time. Creating the calculated table has made the model change, and you need to Deploy it once so that you can see it on the server side (that is, in the SSMS-connected server).

Finally, about option Process Recalc, please refer to this document:

This option assumes that you have created the calculated table and have Deploy it to the server. This is where you will see this additional option in SSMS.
Continuing with the previous test, I created a calculated column in that calculated table.

Then choose Process Recalc

You can see the record:

Best regards,
Seeya

---

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.

Answer 2

Hello Seeya,

I had the same issue and went through the steps but even after processing the model using the Recalc option, the calculated metrics are empty:
Executing the query ...

The query referenced calculated table 'HoursByEmployee' which does not hold any data because it needs to be recalculated or refreshed.

Run complete

I redeployed the model, restarted the service, reprocess it in full mode while running a Profiler session.
There are no errors at all however the metrics continue empty.

What else can I do to troubleshoot this?