Function in FRS Webstudio report to go back on GL Average Daliy Balance Cube on an exact date

Our client wants to run Daily P&L built on GL Average Balance Cube using FRS and compare current date PATD balance to same day PATD balance for last month. This is also true for last date as of last month end / last quarter end and last year end. We had proposed to get such dates as input parameters and control the columns on the grid of the FRS report. However, since the report would be scheduled, the only date input is required is current day of run and the other dates should be automatically calculated based on that date.