Filtering DMR using a conditional date filter - promptmany in slicer

[nikfalla]

My reporting requirement is to build a report that allows user to select fiscal or calendar year and based on the calendar choice, events and event counts by fiscal month or calendar month.

A screenshot of my date hierarchies is attached.

I have therefore build a prompt page that prompts user for fiscal or calendar year and based on their choice then allow them to select fiscal or calendar years. I then prompt them for cut-off period which is the next page of the prompt and user can choose a year (fiscal or calendar) and maybe the month (fiscal or calendar).

Since I am trying to keep this all dynamic, I am setting the
[Selected Month Hrchy] to #prompt( 'pMonthCalType', 'token', '[Month]')#

And [Selected Calendar Hrchy] to #prompt( 'pCal', 'token', '[Calendar]' )#

And the [Years] to descendants ([Selected Calendar Hrchy], 1)

Also, I use a slicer to apply the cut-off date:
lastPeriods(999,[Registry Events (Analysis)].[Date].[Calendar]->?pCutOff?)

My problem (and this is where I need help from you), is to filter the Years for the selected Years (fiscal or calendar).
I know that the best approach for this would be to use a promptmany slicer filter; but considering the fact that my date is dynamic based on fiscal or calendar year, I have a hard time getting the correct syntax for the promptmany slicer filter.

Thanks for your help in advance.

[navissar]

it's a tad difficult to give a proper solution without seeing how your prompts are constructed. Let's assume you have a prompt for calendar type: [Calendar] or [Fiscal Calendar].
Now, consider the following statement:
#'[Registry Events].[Date].'+prompt('pCal','token','[Calendar]')#->?pDate?
This syntax as a  slicer will create a tree prompt (Which will allow your users to select year and month on one go).
If you're keen on separating the year and month prompts and using value prompts, you can use the same technique to try and work out the All member and go from there.

[nikfalla]

Thanks for your response and help, Nimrod.
My issue is resolved, thanks to your help!

[nikfalla]

Update: I used the technique suggested by Nimrod (Thanks again) and used it as a set to filter, and it it working like a charm.

If anyone has any questions, please post them and I will gladly answer them. I owe it to the community!