TM1 Forum

It is related to classical three-body problem, so no magic here.
https://www.imdb.com/title/tt20242042/

Also, George, you need to stop installing TM1 on quantum computers.

Ok, too much time has passed. Correct answer : Stargate views do not work with ConsolidatedXXX functions (they will just not created when a cell with ConsolidatedXXX is used). BTW, I could not find a proof, but I've learned this from Andreas Kugelmeier on one of his best practices webinars. I am not...

Hello,

I cannot see "N:" here. So I assume this rule is needed to override calculations on C: level

Correct answer : Is here: https://www.tm1forum.com/viewtopic.php?p=84295#p84295 Thanks Lotsa for detailed answer. I think we can now remove "MVPs will not receive points" rule, as 1-year-quiz is over So, winner of this round is lotsaram ! Question #54: Gurus advise to avoid using Consolid...

Well, it was a good rest, let us continue this super-long quiz.

Question #53:
Gurus say that you need to use ConsolidateChildren very carefully. Why?

Hello, this was asked many times on this forum: viewtopic.php?t=16766

Wellllll, Finally, at long last, the Year-Long-Quiz is over! it was very interesting experience. It looks like this topic has the most answers on TM1forum.com. Thanks to all participants! I have re-checked the leaderboard and fixed some points, but the leader was already known a month ago. Super-pup...

Correct answer:
As we've discussed before, stargates are very fragile. Each time process makes CellPutN, stargate view is deleted. When we use an export process, stargate view is calculated once for the whole view.

Winner of this round is ascheevel!

Correct answer : Well, it was more a PAfE user's question, and I've expected answer with "Insert user column" + DBRW(}ElementAttributes). Image 1.png But, Maren has proved his MDX knowledge again, so: Winner of this round is MarenC ! !LAST! Question #52: I need to copy data from "Wor...

Correct answer : Is here: https://www.tm1forum.com/viewtopic.php?p=84204#p84204 Question idea is taken from here: http://www.tm1forum.com/viewtopic.php?p=43103 And i like Duncan's answer also: ['roundup'] = - INT( - ['value'] ); winner of this round is ascheevel ! Question #51: I have an Exploratio...

Correct answer : Is here: https://www.tm1forum.com/viewtopic.php?p=84186#p84186 And it is more than I've expected! I like your math answers, Andrew! winner of this round is ascheevel ! Question #50: Is there a rule function - analog to Excel's CEILING ? If not, how can we calculate it?

Correct answer : The question is from this thread, thanks Marioler for question idea: https://www.tm1forum.com/viewtopic.php?f=3&t=15786 Ty and Wim have provided a good solution there: PERIODSTODATE( [Manad].[Total Year].Level, TM1MEMBER( TAIL( FILTER( [Manad].[Total Year].children, [cubename]....

Heeey, that was one of my quiz questions! Maren could have earned another point

Correct answer : ProcessError or ProcessRollback. @Maren: I have not used "ProcessExitByProcessRollback" before and checked it on different environments: it does not terminate process and does not cancel changes. It looks like either the function itself, or it's description in TM1 Referen...

Correct answer:
Yes

Winner of this round is ascheevel! (Well, it was again 50% to guess, and both were correct! You are lucky!)

Question #47:
Which TI function will terminate process and cancel all changes it has done?

Correct answer:
Yes, they will.

Winner of this round is ascheevel!

Question #46:
ADMIN, SecurityAdmin, DataAdmin have NONE access for all applications in }ApplicationSecurity cube. Will a user from ADMIN role see applications?

Rules: Good old .xru in perspectives (Yes, I'm dinosaur!)
TI: PAW
MDX: PAW

Correct answer : Is in great stab by lotsaram: https://www.tm1forum.com/viewtopic.php?p=84096#p84096 But I need to add my 50 cents: CubeDestroy will also delete cube's control cubes (}Picklist, }CellSecurity) But you will not get a point, being MVP ;) So, winner of this round is MarenC ! Question #...

Ok guys, let's close #44. I repeat question #45:

What are the differences between this methods of data clear?
ViewZeroOut (view covering the whole cube)
CubeClearData
CubeDestroy+CubeCreate

2 days left

Of course, you cannot avoid all IFs. But you should minimize them.

As an example:
vs