Tabular Model processing a calculated table (recalc)

Avhilash Kumar 21 Reputation points
2022-11-11T12:31:36.253+00:00

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

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,258 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Seeya Xi-MSFT 16,461 Reputation points
    2022-11-16T09:37:26.093+00:00

    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:
    260144-image.png
    As you can see, this calculated table is not in Process All.

    Now, we Deploy this model:
    260134-image.png
    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:
    260892-image.png
    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.
    260912-image.png
    Then choose Process Recalc
    260858-image.png
    You can see the record:
    260837-image.png

    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.

    0 comments
  2. Ricardo Silva 6 Reputation points
    2024-01-02T22:24:26.51+00:00

    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?

    0 comments