Clear Cube with Variable
Summary
Error on trying to create clear cube with variable on scenarioContent
Hi,
I used the advanced options to create the below clear cube logic;
Crossjoin(Crossjoin({[&curryear]},{[Forecast F1]}),{[Working]})
It works fine.
However, I need the specific forecast scenario to be dynamic based on a variable.
We currently have a variable currforc which drives the same 'filter' for various business rules and forms.
When I try to use it in the above, it tells me that Forecast F1 does not exist.
The variable does have that text in speech marks.
The scenario does exist as I get no such error in the first instance when Forecast F1 is 'hard coded'.
Tagged:
0