Best approach to fetch data from source on Workday basis

[agni_gold]

Hi Friends, 

I have one question, like, i need to fetch data from some source on the workday basis, one way i know to create a separate qvw which will be a success on that workday and rest of the days, it will fail,

Is there any other approach we have, any connector or something to achieve this?

[Gysbert_Wassenaar]

Put a check in the script:

If  WeekDay(Today()) >4 Then
    Exit Script;
EndIf

// if it's a work day then execution of the script continues below

[agni_gold]

But in this case, other then workday, no data will be loaded in the dashboard , but i want to show the old data till next load is specific workday not came.

[Gysbert_Wassenaar]

Ah, right. Ok, well one way is to have one app that creates the data model and stores all the tables as qvd's (and then drops them for this app) and then have another app that loads the qvd's and contains the charts and other visualisations. You'd put the check I posted above in the qvd generator. That way the front end app can always load the qvd's. The qvd's simply won't be updated in the weeked. No need for failing reloads that way.