TM1 Forum

Hi All, I wanted to understand which TI processes are triggered when a user submits a node in the Application web for emails to be sent. We have a situation where the approval hierarchy has leaf level elements which sends email on submit, but we want the emails sent only when the parent level is sub...

Hi Guys, Currently, I'm having issues logging into Architect. I can see the TM1 servers fine, but when I double click on a server and enter the user id & password, it clears the data entered and allows me to enter it again. Basically, the logon screen is available again. When wrong Id/password i...

Basically, what we want accomplished is the dimension should contain only active elements and delete any inactive elements whenever the TI is run. How do we accomplish this without causing the server to crash? I'd do the following: in your dimension update process # in prolog remove the isActive at...

The PROLOG section of TI process is below; ----------------------------------- DimName = 'Project List'; iElm = 0; #Unwind the dimension we are updating iElm = 1; ElmCount = DIMSIZ(DimName); WHILE(iElm < ElmCount); sElm = DIMNM(DimName,iElm); ChildCount = ELCOMPN(DimName,sElm); WHILE(ChildCount > 0...

Thanks for the response Tomok. The TI is only adding "Active" elements back in the metadata step, and not inactive. But, the issue is when the TI is run it crashes the server with the following error message in the log file TM1.Lock Attempt to acquire lock during commit or rollback . Basic...

Oh...I just saw this post & tried the function. This doesn't apply to TM1 ver 10.2.2. But staying on the subject, is there a similar method to achieve this in ver 10.2.2. I am currently facing an issue where the dimension is getting updated from DWH and we need to delete elements that are not re...

Hi, Has anyone been able to get this to work successfully? I'm having issues with using this function DimensionDeleteElements (DimensionName, Subset ) I am unable to save the TI when using DimensionDeleteElements (vDim, vSubset); function. I get the below error message ==============================...

Few additional points - When the TI process is run, it shuts down the server immediately and the log file has only the below entries. The server has to be manually restarted. 15780 [2] ERROR TM1.Lock Attempt to acquire lock during commit or rollback 15780 [2] FATAL TM1.Server Server terminated In or...

This is a simple TI process without any manual manipulation. All codes are system created Prolog #****Begin: Generated Statements*** DIMENSIONDELETEALLELEMENTS(‘Project List’); DIMENSIONSORTORDER('Project List','BYINPUT','ASCENDING','BYHIERARCHY','ASCENDING'); #****End: Generated Statements**** Meta...

Hi TM1 Guru's, I'm having an issue currently where running a TI process to "Recreate" a dimension results in the below error message; 15780 [2] ERROR TM1.Lock Attempt to acquire lock during commit or rollback 15780 [2] FATAL TM1.Server Server terminated This is a stand-alone TI process and...

Thanks Tom! Was thinking if there's a better/easier way of achieving it than writing multiple lines. I understand having employees as a dimension rather than employees lines would work better, but I wanted to check if this is the design how would this be accomplished. We have similar design for capi...

Hi Guys, Wanted to check how best the rule should be written based on the below cube design; Source cube has four dimensions; 1) Employee numbers (rows empl 01, empl 02.......) 2) Employee Input (columns Employee, Type, Location - these are picklist items) 3) Departments 4) Versions Source cube; Ver...