I have requirement as follows.
1. I need to Broadcast a report as Excel files in mail weekly twice (I am OK with this)
2. The data that I am sending should be dynamic.
There is one Variable called Forecast Period in Variable Selection screen. It should get Dynamic values depending upon the current Month. (Eg) If current month is September then it should be 09/2016. And if current month is October then it should be 10/2016.
After that I have to apply some selection variables and custom filters. Please Help me with this. I am beginner to BW.
FYI: The Forecast Period in the selection screen of the report is defaultly filled with current month.