Processing Tabular model; Full vs dataOnly/calculate

Question

Post reply

Processing Tabular model; Full vs dataOnly/calculate

Chrissy321

SSCoach

Points: 15776
More actions
February 7, 2023 at 3:56 pm

#4146625
Thanks if you can provide any insight. I have been performing a full refresh on a model.
```
{
"refresh": {
"type": "full",
"objects": [
{
"database": "Model1"
}
]
}
}
```
I would like to take a more granular approach and perform dataOnly refreshes on certain tables and then perform a calculate on the model.
```
{
"refresh": {
"type": "dataOnly",
"objects": [
{
"database": "Model1",
"table": "Table1"
},
{
"database": "Model1",
"table": "Table2"
}
]
}
}

{
"refresh": {
"type": "calculate",
"objects": [
{
"database": "Model1"
}
]
}
}
```
My question is, are these two methods equivalent? Is the full doing anything that the dataOnly/calculate does not.
Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80332 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

Chrissy321 SSCoach Points: 15776 More actions · Answer 2

This author in the comments seems to indicate that the two methods are equivalent.

https://chris.koester.io/index.php/2017/06/21/process-ssas-tabular-tables-partitions-tmsl/

This documentation suggest starting with a Clearvalues.

https://learn.microsoft.com/en-us/analysis-services/tmsl/sequence-command-tmsl?view=asallproducts-allversions

So my current method is to Refresh-Clearvalues and then Refresh-DataOnly on each dimension. Then do the same for facts in a subsequent process. Then do a Calculate on the entire model.

I may try to do further analysis using profiler and if I find anything interesting I will post back.

This reply was modified 2 years, 1 month ago by Chrissy321.

michael.zanovec@la.gov Newbie Points: 2 More actions · Answer 3

I posted the results of my experiences testing different refresh scenarios. You can view that post here:

https://learn.microsoft.com/en-us/answers/questions/254507/auto-refresh-tabular-model

Processing Tabular model; Full vs dataOnly/calculate

Cookies on SQLServerCentral