Forum Discussion
Incremental Refresh - Future values
hi Anonymous
Here is the extract belowAnd what you would need to do is to change the effectiveDate to be the date in the future you want it to go into.
For example if you wanted it to go until the end of 2020 you would change it to the following:
{ "refresh": { "type": "full", "applyRefreshPolicy": true, "effectiveDate": "12/31/2020", "objects": [ { "database": "IR_AdventureWorks", "table": "FactInternetSales" } ] } }
GilbertQ thank you for the reply. In the documentation it talks about using effective date to pull future values out. Do you know how I can use this?
"effectiveDate – If an incremental refresh policy is being applied, it needs to know the current date to determine rolling window ranges for the historical range and the incremental range. The effectiveDate parameter allows you to override the current date. This is useful for testing, demos, and business scenarios where data is incrementally refreshed up to a date in the past or the future (for example, budgets in the future). The default value is the current date."
hi Anonymous
Here is the extract below
And what you would need to do is to change the effectiveDate to be the date in the future you want it to go into.
For example if you wanted it to go until the end of 2020 you would change it to the following:
{
"refresh": {
"type": "full",
"applyRefreshPolicy": true,
"effectiveDate": "12/31/2020",
"objects": [
{
"database": "IR_AdventureWorks",
"table": "FactInternetSales"
}
]
}
}
Ah I should've read the documentation properly. I had to create a new script then copy and paste the effective code and execute.
Got it working. Thank you
- Awesome thanks for letting us know!