TM1 Forum

Please re-write your process using that and I promise you’ll get me and others to go through it. Hint: Certain Rule functions also work in Processes! It’s also part of the documentation. Lots of luck! Hello, yes, I did use an AI site for it but it was not done out of laziness, though I can see how ...

Here are some good readings that will help you build what you need: https://www.wimgielis.com/tm1_cellchange_EN.htm https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=developers-security-overlay Adam, thank you very much for these helpful sites. I will definitely start using them and readin...

You would just lock the year element, hence for all cubes involved. The year is over and will not be touched again, in none of the cubes. That being said, we often have different Year dimensions, like Stg_Year for staging cubes, Rpt_Year for reporting cubes, etc. Hello, yes we do have some month di...

Steve Rowe wrote: ↑Fri Jan 24, 2025 9:13 am You need to check the content of the TIs listed in the Prolog and try and understand what they do.

Hello, yes, I am doing that also. I am working to understand the TI, piece by piece. I appreciate your response.

In summary, if I create this new process with only detail in the prolog, should this work as expected? Thank you! Checking my calendar, it's not yet April first :lol: The code is literally full of functions that even do not exist in TM1 and you expect the code to be doing something ? Did you write ...

Check out TM1py for generating a report of this sort of TI process metadata. Hello and thank you for the helpful response. If it is not obvious, I am very new in TM1 and trying to learn with limited resources. I would never make any material changes at my job but I use this forum to get feedback on...

Hello everyone, I want to create a mapping of the processes we have and I want the mapping to include data source type, data source name and the chore involved (if applicable). I do not see an easy way to do this in TM1 so I am going to try creating a new process and posting the below in the prolog....

Hello everyone I am curious, what is everyone doing at the close of fiscal year to protect the cubes from being overwritten? I know there is an option to lock at the element level for fy and that would impact all cubes using that element. Supposed you did not want to lock every cube in that fiscal y...

Hello everyone...update, please disregard this post. It is no longer relevant.

Hello It appears a dbsend has stopped working in a file and I can't determine the cause. It seems to work just fine on the FY24 file (we run Sept-October and recently finalized). The only change we make for the new fy file is to update the fy and the current month. We change the DBSEND column from N...

Ascheevel your detailed and easy to follow response was exactly what I was looking for! I did right click on the dimension yesterday but I was too scared to make any changes to the attributes for fear that I would break something! Also, I do not take offense at your suggestion for training. I did co...

Hello I need to make corrections to a subset of Time Dimension. I started getting Time Dimension error notices on Jan. 1, 2025 because the YYYY-MM alias is displayed as Jan 2025, instead of 2025-01. Feb 2025 should be 2025-02 and so on. I did not create this subset and I am a baby in TM1. May someon...