Hello,
I need help understanding how to address the following error:
Error: Prolog procedure line (21): Dimension element "2025-01" not found in dimension "Time"
I think it is triggered because my time dimension format is MonthFiscalYear (for ex. Jan 2025) but the current Process Variable Formula is as follows:
vTime=subst(Today(1),1,5)|subst(Today(1),6,2);
so it produces 2025-01.
If my understanding of the error log is correct, I think I need to change the formula so that it provides month first and then fiscal year. If so, I came up with this edited formula
vTime=subst(Today(1),6,2)|'-'|subst(Today(1),1,4); to return 01-2025
Is my understanding of the error log correct or should I be looking at a different issue to eliminate the error log? I provided images of the variable detail and time dimension details. Thank you, in advance!