Filter report with a prompt value and member value

[agante]

I need to filter values for the version dimension in a report. The report should show values for two especific versions. One is the version with actuals and the other sholud be selected by user through a prompt (budget, preview or forecast).

When I create the filter I use the following expressions:
example 1:
[Consolidado de real y reformulación].[ESCENARIO].[ESCENARIO].[ESCENARIO].[ESCENARIO] =[ACTUAL]
or
[Consolidado de real y reformulación].[ESCENARIO].[ESCENARIO].[ESCENARIO].[ESCENARIO] =?p_version?

example 2:
[Consolidado de real y reformulación].[ESCENARIO].[ESCENARIO].[ESCENARIO].[ESCENARIO] in (?p_version, [ACTUAL])


but I get errors when running the report.

I've tried several combinations but haven't been able to get the report running.

 

[novasian]

Are you talking about cascading prompt? Like, you have a source prompt A with a list of values. When a user select a value for prompt A, they see a list of values for prompt B where user can select multiple values for prompt B, then run report.

?