TM1 Forum

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

Correct answer : It's hard to decide! Emixam's answer was a really good catch. This dim:element optimization was measured and described by Cubewise. I have not measured if dim:hier:element is faster than dim:element. So, Adam , if you can prove this, you will also get a point also. For the "MA...

The whole websheet? Is it blank?

Hello,

TM1ELLIST does work in websheets. And all other TM1 worksheet functions should work in websheets. You can find a list of supported and unsupported Excel functions here: https://www.ibm.com/docs/en/planning-an ... ctions-tm1

Agree, nice catch!

I doubt somebody can make anything better, so here is a side exercise while we are waiting for Friday: can we rewrite such rule without IF and MAX/MIN?

Correct answer:
Yes, you can encrypt DATA folder using TM1Crypt utility: https://www.ibm.com/docs/en/planning-an ... encryption

Winner of this round is Adam!

Question #43:
Optimize this rule: ['Y'] = IF(['X'] < 0, 0, ['X']);

Which out-of-the-box encryption do you mean?