Hi Durga

FYI - I've moved your query in to the Server & Online area of the COmmunity as it's likely to attract more responses there.

The Community Canvas area is for posting queries relating to the functionality/features of the forum itself (eg if you're having difficulting posting something etc)

Regards

Donna

Durga,

I don't think you need to go down the path you're describing--and I don't believe it's really possible on Tableau Server anyway.

If your underlying database refreshes once per week and is stale, you just need to set your extract to refresh as close to after the refresh process of your underlying database completes as possible.

Maybe I'm missing something in your requirements.

Extracts and Refresh Schedules

Yes, you would need to first change your datasource in the Tableau Workbook to become an extract as opposed to a live query.

Tableau will query the database and build a .tde file immediately.

Then, when publishing a workbook with a .tde source, you have the option to set the refresh schedule of the .tde extract file(s).

You can also publish a .tde as a datasource independently to Tableau Server (and set it on a refresh schedule) and then point one or more Tableau workbooks directly to it via a Tableau Server connection for your data source.