I have a time SYS module that has the last month of the next years forecast (12/1/2022). When I use the PERIOD() formula and reference this line item it returns nothing. The module where I am referencing does not have time as a dimension. Could this be why?
Time SYS:
The module where I am attempting to reference:
Thanks in advance!
Solved!去解决方案。
Hi@zdlee,
Yes, it's not reflecting value because of time dimension, Looks like you want to for Dec month only,
Create a SYS time module without time dimension
Yes you are correct. It is because you do not have the time dimension. If you update your formula to select a specific time dimension such as PERIOD('SYS02_Calendar Settings'.'1 + Current Year End Month'[SELECT: TIME.'Jan 21']) then it will return a value.
Hi@zdlee,
Yes, it's not reflecting value because of time dimension, Looks like you want to for Dec month only,
Create a SYS time module without time dimension
Is Dec 22 part of your model calendar? Try adding one future year to your model calendar
Hi@zdlee,
First of all, few observations from my side:
Having said that, you are on the correct path - just two changes needed and all good:
源模块(公式前actly that you have):
Destination Line Item:
Formula:
PERIOD('SYS01: Time Settings'.'1 + Current Year End Month'[SELECT: TIME.All Periods])
Hope this helps