Planning Analytics

 View Only

 Edit Dimension Subset Alias for Date

Kay Warr's profile image
Kay Warr posted 01/08/25 06:52 PM

Hello 

I keep receiving this error log: Invalid key: Dimension Name: "Time", Element Name (Key): "2025-01"

At first I thought there was an error in the variable formula but I have now realized the issue is with the date or time dimension aliases. I did not start receiving this time dimension error until January 1, 2025, although I made no changes to TM1 or the source data. I reviewed the Time dimension and you can see that after 2024-12, the 2025 months were never converted for YYYY-MM. I just recently assumed this task so I need to know how to correct the 2025 months. Here is a screenshot of the time dimension FY25 which should show all in the format YYYY-MM (but it does not do that after December 2024)

TIME DIMENSION
FYI...We recently upgraded to PAfE/PAW but we still also have Perspectives. The picture shows the time dimension from TM1 Architect but I can also make the change via PAfE (as long as it will update for all instances).
May someone tell me how to fix this so that Jan 2025 is 2025-01. Feb 2025 should be 2025-02 and so on. Is it something I can change in TM1/PAfE/PAW directly or do I need to find or create an upload file. 
Thank you, in advance for your assistance and time!
Kay Warr's profile image
Kay Warr posted 01/09/25 12:38 PM

Hello All

I have resolved the problem. I just needed to edit the element attributes on the dimension. I ran the chores again and no error logs :)

Related Content