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.
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.