When you work with dynamic dates as criteria in TARGIT, you use relative references like:
- Year to previous month
- Previous 12 months
- Previous year
- Yesterday
- Previous 3 weeks
- …and many others
All these references are based on the dynamic data origin.
If you don't manipulate dynamic date origin, it will be default set to today, which makes a lot of sense.
In some scenarios though, you might want to "play around with" dynamic date origin.
Maybe you want so simulate that we are on a certain date, and then all your relative filters will move accordingly.
This can be offered as a very flexible option to the consumer using a certain report - by just placing the dynamic date origin in the criteria bar, but it can actually also be passed as a parameter in a URL - you just need to add something like this to the URL
?dateorigin=2021-12-16
So if you have a deep link that opens a certain analysis with a URL like:
https://yourserver/anywhere/#vfs://Global/foldername/documentname.xview
you just need to append the parameter:
https://yourserver/anywhere/#vfs://Global/foldername/documentname.xview?dateorigin=2021-12-16
And then you are simulating that it's the 16th of December 2021, and all your dynamic filters will filter accordingly.
However you choose to manipulate dynamic date origin, you should make it absolutely clear to the consumers of the report, what exactly they are looking at.
This tutorial takes you through all of the above step-by-step:
Comments
Hi Niels
Is it correct this can only be accomplished in browser version of Targit?
If our users only use Desktop version how can similar actions be accomplished like:
https://yourserver/anywhere/#vfs://Global/foldername/documentname.xview?dateorigin=2021-12-16
?
We have analyses for budget where we would like to set the date as end-of-year date for the budget year..... So during this period for the user login: oct, nov, dec 22 and jan - dec 23 the analyse must be set to 31-12-2023
Either call the analyse with a parameter or as saved user dim.
Ole
Hi Ole
Yes you are correct - you can't set dynamic date origin to a different date than the current as default for the windows client.
It is an interesting idea though - so please feel free to add this as a feature request.
br/Niels
Please sign in to leave a comment.