we're doing rolling forecasting in IP layout, and there's a need to have dynamic time period in the report. This should be maintained by super user. The question is how the super user could maintain this period without having to open the production system for query maintenance, or transporting the queries?
To give you an example of the actual problem; we need to have key figures divided into two columns, one for the first half of the year, and the other to the second half, with actual and plan data respectively. I.e. if the current period is set for (10) October, we would need to have 'column 1-6' with all actual values and 'column 7-12' with actual values (7-9) and plan values for (10-12). So how can we set the period as a dynamic one so that it always takes the proper actual values and plan values?
Anyone experienced/solved similar issues?