Tagging Sub Variable in Clear Cube job in EPCM
Summary:
Hi,
Can we pass variable holding range of value (FY25:FY26) to Clear Cube Job?
Content (please ensure you mask any confidential information):
I have a variable "RollingFcst" which holds value of "FY25:FY26", when I am trying to refer the same variable under Clear Cube (Overview→Clear Cube), it throws an error saying "Cannot Verify MDX Expresssion. Essbase Error(1260046): Unknown Member FY25:FY26 used in query". However, this works fine when referenced under Data Maps, business rules etc. Does the job allow to refer a variable holding range of value or should we need to just include a single value?