What's new in Customer Journeys?

Connect and learn more! ×
Clear Cube with Variable — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Clear Cube with Variable

Accepted answer
edited Mar 8, 2019 9:30AM in Planning 17 comments


Error on trying to create clear cube with variable on scenario




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


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!