BPC EPM Dynamic Selection for Actual/Budget/Current Estimate in YTD and Annual Format

[smercer]

I've created a report(below) in BPC EPM that shows two main sections:

1) YTD comparing Current YTD Actuals/Current YTD Plan/YTD Prior Year Actuals

2) Annual Total Current Estimate (updated Monthly)/Current Plan/Prev Year Actuals

The columns in Green are excel formulas and grey column headers are direct from BPC. 

The report did what we needed for this past month end and saved time, as the old method was to run the report multiple times-once each for Actuals, Plan and Current Estimate. However, for next month end I'm going to have to Edit the report and swap out the April Current Estimate for the May Current Estimate. I'll also have to update the YTD formulas as they just add up hidden monthly columns. My ideal is to have Dynamic Selections/Variables at the Top of the report where the user would enter:

YTD Selections:

Period Range - Which would control the YTD section for Time. ie Current Month=May, so YTD is 2025.01 - 2025.05.

Plan Version - Can be selected. The Actuals Columns could remain "Hardcoded"

Annual/Total Year Selections:

Current Year- Can be selected. The Previous Year selection could be offset based on this.

Plan and Current Estimate - Can be selected. Actual column probably remains hardcoded.

I have a background in FICO and creating Finance queries in BW Query Designer. I'm confident I could build the report above by using BW Query Designer connected to the BPC infoprovider/"cube"... but my Manager wants it in BPC. I'm new to BPC and i definitely don't have the Dynamic Selections thing figured out yet. Please let me know if you have specific suggestions or point me toward documentation on setting up Dynamic Selections/Variables. I've watched some Youtube videos on BPC, but so far they are fairly basic.

Thanks in advance for any help 🙂