I have the following user requirement and would be interested to here expert ideas on how to solve it:-
Our users have hundreds of queries containing budget/forecast versions which each month they have to update to look at the current version and last months version. With so many queries to update it is a very time consuming process for them.
How can we load the data so that they can have a variable in the query which is "This months version" and "Last months version"? As well as keeping all the historical versions as the months roll on?
Many thanks in advance for your ideas. Points awarded!