ITA is not recording dates beyond Dec 31 2019. Any data being generated past those dates is being rendered as UNKNOWN in the cube views.
None
IT Analytics for SEP, DLP, CCS, or ITMS
The DateDim table last date entry is December 31, 2019
By running one of the two attached SQL scripts below, you will be able to extend the size of the DateDim (or ITAnalytics_DateDim) table to have date information thru Dec 31, 2025. If you have a SEP or DLP standalone IT Analytics installation, use the ITA Datedim Fix.Sql. If you have an ITMS installation of IT Analytics, use the ITAnalytics_Datedim.Sql file.
For Standalone SEP or DLP IT Analytics:
For Standalone IT Management Suite (ITMS)-based IT Analytics:
If these steps seem unfamiliar, you can contact your DB Admininistrator, or you can raise a case with Support to receive assistance to implement the change.
This was fixed in a later release of IT Analytics standalone (DLP, SEP, CCS, etc) but has not been added to the ITMS version so the scripts will need to be used with ITMS.