TM1 Forum

lotsaram wrote: ↑Wed Nov 08, 2023 6:21 pm You can't.

TM1 will eat up all available memory until it runs out.

And then it is paging, hanging and crashing time.

And the worst part is that TM1 does not release the memory back until next restart, even if you Zero Out some of the data

Formatting your code will go a long way in helping you to read/understand it and posting within a code block will go a long way in helping the rest of us help you. By the CellGetN you posted at the bottom for InvStatus, it appears you're using only the variables defined in the source view to derive...

And if you want to keep Spreading enabled for some of the users, you should consider turning OFF this option

ProportionSpreadToZeroCells=F

By default this is turned on and in my experience this is dangerous

Hi Everyone, A quick explanation of what I want to do: I have a cube of investments with a dimension "invart1", which I want to summarize in a separate cube. I understand I need to use a process to do so, is that correct? Or is there al although a way with a rule? I just want to start in ...

Hi there I am trying to use VBA to change the Server name for multiple actions buttons (in multiple workbooks) in Perspectives There is an article from Wim Gielis which details exactly how to do this: https://www.wimgielis.com/tm1_actionbuttons_EN.htm Unfortunately, I cannot figure out how to add t...

Is the Client Groups membership defined in Cognos or in LDAP (Active Directory)? If it is in Active Directory, you can run some powershell script to extract the User/Group mappings. If they are defined in Cognos, then you can run a SQL against Cognos Content Store database tables ( as suggested by E...

First thing, you need to have an attribute "Next_Month" on your Time/Month dimension. Then in your "Next Month" Action Button, make it Navigate to the same Websheet, but set the "Advanced Options" so the "Next_Month" Value of your Selected Month, for Target Ty...

According to your screenshot, you are connecting through PAX / Pafe. You need to specify the Connection URL (https://servername:port/), but if you did not go through the installation of docker / PAW, Pafe (AKA PAX), will not be able to connect.

Try the following: FILTER(TM1FILTERBYLEVEL(TM1SUBSETALL([Customers]) , 0) , [Client Selections].(STRTOMEMBER("[}Clients].[" + USERNAME + "]"),[MD_Selection].[Suppression Selection]) = "False" OR ([Client Selections].(STRTOMEMBER("[}Clients].[" + USERNAME + &qu...

You need to use round brackets after the OR operator

In my experience, the easiest way is to use RushTI ( a Cubewise python/TM1Py utility). I have used all kind of different approaches in the past, and I always had issues. Even with Flag-files approach, you end up having files being locked from OS and other type of issues. RushTI is easy to use and it...

Try something like this: {FILTER ( {TM1SUBSETALL( [Customer_Dim] )} , [zControlCube].([ControlElements].[Zero Suppression Flag],[zControlCube_m].[Value])=0 OR ( [zControlCube].([ControlElements].[Zero Suppression Flag],[zControlCube_m].[Value])= 1 AND [CustomerCube].([Dim1].[Total_Elem], [Dim2].[Tot...

In my experience, the easiest way is to use RushTI ( a Cubewise python/TM1Py utility). I have used all kind of different approaches in the past, and I always had issues. Even with Flag-files approach, you end up having files being locked from OS and other type of issues. RushTI is easy to use and it...

After upgrading RushTI, the issue has been resolved

RushTI is an amazing tool and it has made our life so much easier

Thank you very much

Hello, We have started using RushTI / TM1Py in our organization, but we are struggling to figure out how to cancel threads launched from RushTI. Our task file is simple, we have 2 blocks of lines separated with a WAIT line, everything works great but when we try to cancel threads in TM1Top, the thre...

You cannot script the creation of the }CubeDrill cubes so I have created a small package with all the objects required (Few dimensions, cubes, TI Process and Rule) Why not ? A cube is a cube and a process is a process. Quote of the day :lol: I have tried to create the }CubeDrill , yes that is a cub...

Thank you Wim, I have a small model that includes all the objects. Part of this package is a }CubeDrill_... cube which has one assignment rule to allow user to access the Execution Logging Related to an User Action. You cannot script the creation of the }CubeDrill cubes so I have created a small pac...

Hi, In this topic, I am going to share with you an approach that I have been using for years in order to implement Enhanced User Action Logging in TM1 Models. I have a cube called User Action Logging with 3 DImensions: User Action, Line Item and a Measure dim: User Action Logging All.PNG Also I crea...

It looks like this is caused by Audit Logging, we have Audit Logging turned on, and every time the dimension is updated, it throws the errors below: 18756 [] ERROR 2022-03-01 22:09:12.586 TM1.Audit.PostProcessor Error copying By Location.dim 18756 [] ERROR 2022-03-01 22:09:12.586 TM1.Audit.PostProce...

Hello, I don't see that behaviour in a more recent version, 2.0.9.9. Your version is 1 year older than that version. Are the files part of the data directory or a subfolder ? What happens in the chore (I assume) that operates on those hierarchies, around 9.35 PM each day ? The files are on the root...