Forum Discussion

Winniethewinner's avatar
Winniethewinner
Icon for Helper IV rankHelper IV
4 years ago
Solved

Query changes for scheduled refresh in Service

Hello All,  I have a report with scheduled refresh in Service. If I make changes with the query (which is the SQL statement connected to Teradata) in the Desktop version and save it, do I need to re...
Need Help
  • collinq's avatar
    collinq
    4 years ago

    Hey Winniethewinner ,

     

    When you publish from the desktop it SHOULD refresh on the Service but that is not always a given.  If you want to be sure, what I do (unless the query is massive) is to refresh in desktop, then publish and then update app and I know all is well.  

    However, worst case scenario, you are right that the Service can potentially have some data that is "newer" than the other.  But, that only lasts until the next scheduled refresh when everything gets caught up.

collinq's avatar
collinq
Icon for Super User rankSuper User
4 years ago

Hey Winniethewinner ,

 

When you publish from the desktop it SHOULD refresh on the Service but that is not always a given.  If you want to be sure, what I do (unless the query is massive) is to refresh in desktop, then publish and then update app and I know all is well.  

However, worst case scenario, you are right that the Service can potentially have some data that is "newer" than the other.  But, that only lasts until the next scheduled refresh when everything gets caught up.

Winniethewinner's avatar
Winniethewinner
Icon for Helper IV rankHelper IV
4 years ago

Thanks. Yeah I think for the query change the "safer" way would be to refresh in the desktop first and then publish -> update app.