TM1 Forum

What's your actual requirement?

I never in 25 years so far working with TM1 found something that can't be solved with cell security. I see no need for the overlay cubes TBH.

Most of what you comment on occurs in the Process 3, which was not part this thread. The request for assistance guidelines do say to include the full context of what you have done. Only providing half of what you have done isn't helpful, it just leaves people trying to help guessing. I had a quick ...

I think the problem is not in the computer but the organic interface between screen and keyboard ;) You talk about a "Week" hierarchy and a "ITD" hierarchy, but both your TI process snippets are acting on Week, no action on ITD. In Process 1: leaf days are inserted in the hierarc...

Like any time using rules in security cubes the rule calculated values will only take effect after performing a security refresh function.

Rules in security cubes (with the exception of cell security) is not normally seem as a good practice and not generally recommended.

Yes there is one helluva downside, namely a security refresh would need to be run in order to achieve the desired element security differences between any 2 users who were otherwise in the same groups but who should have differing element security. Or put another way don't do this, it's a really bad...

We get this same error occasionally on Linux instances where there has been a shutdown without SaveDataAll and there's some corruption in the tm1s.log file. The only solution it to manually delete the malformed records from the transaction log or delete the whole log file and restart. (Doesn't help ...

You can just select another alias to display or switch off alias in the GUI?!

From a query perspective the MDX always returns the member names (without alias). The display of an alias is a function of the GUI. If you are looking in MDX to disable alias display you're looking in the wrong place.

I think the answer depends if the STET is actually needed. As in; is the purpose of the STET to make the value 0, or to open the cell to data entry? If there are conditions where data entry is required then you need STET, otherwise I would avoid the IF and write like you did as [ 'Forecast Flag' ] *...

We can write N: right instead of S : for string element 'comment' Can you please write a proper question ? So Wim made a very reasonable request since your question made little, if any sense. okay got it. this was the full ques actually. thanks!! And you responded with something completely irreleva...

We can write N: right instead of S : for string element 'comment' So is that a question? Or a statement of fact? Do you have an issue with writing a string rule? You can use N: it won't be a syntax error, but it also won't do anything! If you want to assign a string value to a rule calculated cell,...

Wim Gielis wrote: ↑Thu Feb 06, 2025 10:26 am Or, child weights in the parent are not all 1 for some reason (different cube maybe) and here you need the sum where weights equal 1.

But this you could resolve just with another rollup with different weights.

People c'mon! I expect a bit better! Q: What makes rule calculations in TM1 efficient? A: The sparse consolidation algorithm. (Or colloquially "feeders".) Sparse consolidation is not applied to ConsolidateChildren. There is no jump straight from populated leaf cells to the calculation bein...

Or just use Arc.

You really haven't given any specific information which would help anyone diagnose the issue but it sounds like you should be checking the cell security for the cube where FY25 doesn't send and element security for the time dimension.

I also used to be really excited to put everything in a variable, sCube=this and sCube=that etc. just in case you need to update it later. Never happens as the likelihood of the process switching cubes is almost zero, and if you do, search and replace. All it has seemed to do is frustrate the debug...

Rules - Arc
TI - Arc
MDX - Apliqo

I don't much participate here but as I finish my lunch I might have a quick stab at this one. A : ViewZeroout (whole cube) will: - clear all data from the cube - take a variable amount of time depending on the volume of data in the cube (could take quite a while of cube is large) - assuming logging ...

I would like to bet there isn't a model out there that doesn't use an if somewhere, be it a TI or a rule. There will always be IF statements. The point is that a Boolean test is one of the most, if not the most expensive functions you can use in a rule. If you can write a rule with a pure mathemati...

I agree. Much easier done in the lookup cube itself. Then simply call the "next year" value from the cube in the MDX.

write some data to the cube. It doesn't matter where in the cube. It can be an unused portion which doesn't actually flow or consolidate anywhere. Just as long as some leaf level data is changed. The caching mechanism in TM1 is very non-granular and doesn't track calculation dependency. As soon as a...