TM1 Forum

I had the same problem couple months ago. You can read this technote from IBM for more information: https://www.ibm.com/support/pages/exception-computing-feeders-base-cube-cubename-ix-locking-prohibited-nested-transactions I hate to say that but you'll have to review all your feeders to find the cul...

Our infrastructure team told us the new update of Chrome will break the extension and IBM told us starting 2.0.88, the extension will no longer be needed to copy-paste.. and it's working as expected !

Unfortunately, I cannot find any tech note from IBM

I remember reading somewhere it can impact performance but I don't know why. I always avoid this function because c-level rule does not impact higher-lever consolidations and it messes up the natural consolidation of elements. TM1 always calculate consolidations first THEN override consolidation val...

Someone called me out on another post for not replying. :D I drank a lot of coffee and reviewed and optimized the feeders one by one. Mistakes were made on the 'Next Period' feeders and the feeders on consolidation. There was a "Day" dimension (ex: 2024-01-01, 2024-01-02, ...) and the feed...

Hello, We all know TM1 can almost do everything. However, for non-tm1 expert, it can be really complicated to implement and maintain. Because of that, one of my client is considering switching to OneStream (or maybe Anaplan) and I would like to know what are the limitations of these platforms ? Have...

TI/Rule with Arc but query cube view with PAW

No comment, no debate. How do you write TI and Rules ? I'm also curious how you get cube data ?

How optimised are these alternative solutions, what does the empirical evidence show? As per Cubewise, including the dimension reference is faster because this constrains the element search to a single dimension instead of searching over all dimensions. https://code.cubewise.com/blog/7-tips-to-writ...

What you are looking at is }CellSecurity.
Here's a useful link but there is a lot more: https://exploringtm1.com/cell-security- ... ete-guide/

You can use tm1runti or use ProcessService class from tm1py.

Hello, I inherit a model with a cube of +/- 400 rules & feeders and the feeder file is 13gb. I suspect a lot of overfeed as there is not a lot of data in the cube. The server takes forever to start when the feeders are reprocess (they are using persistent feeders). I will review the feeders but ...

On which client you took this screenshot?
Adam is right.

Even if you are ReadOnlyUser, you can still create and execute TI. Simply create and execute a TI with the following command:

You can make all users read only using the }ClientProperties and put a 1 under ReadOnlyUser but it will prevent them from doing input on other cubes that are not impacted by this data load. Another option could be: lock the cube (}CubeProperties) and use CubeLockOverride(1) in your TI and allow writ...

That's what we are doing. TM1py is connected to both server and we do something like this: mdx_server1 = "my_mdx1" mdx_server2 = "my_mdx2" df_server1 = tm1_server1.cells.execute_mdx_dataframe(mdx_server1) df_server2 = tm1_server2.cells.execute_mdx_dataframe(mdx_server2) if df_ser...

Hello, I started a project and one of the requirement was to be able to ViewZeroOut a very large data set (100,000,000+ cells). I never had to ViewZeroOut such a large data set and I noticed it takes around 10min. I was wondering if there is a rule of thumb in term of number of cell per seconds that...

Hi, I've never done any testing but during server startup, can you see the cube dependency being created ? 12345 [] INFO 1900-01-01 00:00:00:00 TM1.Cube.Dependency Adding cube dependency: Cube 'Cube A' depends on cube 'Cube B' You could also use log4j.logger.TM1.Cube.Dependency=DEBUG in tm1s-log.pro...

Hello,
With TM1 REST API becoming more and more popular, I was wondering if anybody ever created a model using only the TM1 REST API without any TI ? And what about only using TM1py ?

Thanks and have a good day !

Thanks lotsaram. This is our plan but I was more curious about why it is not available in Workspace/Arc and why querying transaction from TM1py seems to be slower than Architect.