Hi everyone,
I wonder if it is possible to create dynamic selections in a query structure. Here is my scenario:
In the columns section of my query I have a structure with all months of a year. Depending on the time of the year, all past months shall contain "actuals" whilst the upcoming months contain "forecast" data. (As far as I know) Using variables, I should be able to fill and name each month dynamically using variables. If it's March now, I would have the following resulting structure:
- "Jan - Actual" (containing actuals)
- "Feb - Actual" (containing actuals)
- "Mar - Forecast" (containing forecast)
- "Apr - Forecast" (containing forecast)
...
Each month is represented by a selection (if I understand correctly).
Is it possible, to show or hide such a selection dynamically? The reason I ask: for the current period (March) I also want to display the "current" value (besides the forecast). Unfortunately, this selection moves a long the structure as time moves on: this month, the "current" shall be placed right before "Mar - Forecast".
- "Jan - Actual" (containing actuals)
- "Feb - Actual" (containing actuals)
- "Mar - Current" (containing currents)
- "Mar - Forecast" (containing forecast)
- "Apr - Forecast" (containing forecast)
Next month it shall be right before "Apr - Forecast".
- "Jan - Actual" (containing actuals)
- "Feb - Actual" (containing actuals)
- "Mar - Forecast" (containing forecast)
- "Apr - Current" (containing currents)
- "Apr - Forecast" (containing forecast)
Is this possible with BW 3.5? Or otherwise with BI 7? Or is this requirement too dynamic? 😉
Thanks in advance, Dan