How do I dynamically select a member based on date?

[ghart]

I'm a newbie using RS 8.3.

My data source is an Essbase 6.5 cube which in it's time dimension has a hierarchy year -> half year - > quarter -> month. The 12 leaf nodes effectively slice the cube in monthly views.

My objective is to create an automated, non-prompting scheduled report that will report data from the correct slice based on the current month.

An explicit slice filter on the report has the precise effect I'm looking for but this requires manual intervention on the report at month end to update the slice filter (or at least I haven't figured out how to automate the slice selection). Standard filter approaches can't be used as I have no datestamp values in the source on which to filter.

Appreciate any suggestions...George