Search found 325 matches

by Elessar
Fri Mar 22, 2024 3:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5119

Re: Ultimate Long TM1 quiz

Correct answer:
I'll give a link to ascheevel's answer: viewtopic.php?p=83320#p83320
Nothing to add


Winner of this week is ascheevel!

Question #12:
What will happen when data is entered to consolidated non-zero cell? For example:

Image 50.png
Image 50.png (8.9 KiB) Viewed 186 times
by Elessar
Wed Mar 20, 2024 7:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
Replies: 18
Views: 900

Re: Performance Implications of Dimension Reordering in Turbo Integrator Processes

It's better to use OptimusPy rather than Architect's automatic dimension reorder: https://code.cubewise.com/open-source/tm1py/optimuspy/

When searching for optimal dimension order, it does not just minimize ram, but finds optimal balance between speed and ram
by Elessar
Tue Mar 19, 2024 12:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance Implications of Dimension Reordering in Turbo Integrator Processes
Replies: 18
Views: 900

Re: Performance Implications of Dimension Reordering in Turbo Integrator Processes

Hello! Returning to the original question: Yes, the case when cube reorder reduces memory but increases load/copy time (for some views/queries, not for entire cube!) is real. To understand this, you need to visualize cube data as a tree (this is how data is stored in TM1. See https://www.youtube.com...
by Elessar
Fri Mar 15, 2024 2:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5119

Re: Ultimate Long TM1 quiz

Correct answer : Blue font - means that value in your selected sandbox is different from [Base] sandbox. This is true both for input cells and calculated cells. Green font - this value is still in your browser cache and is not send to TM1 server. Usually values remain green when you fill cells and ...
by Elessar
Wed Mar 13, 2024 12:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5119

Re: Ultimate Long TM1 quiz

Good! And what about red?
by Elessar
Fri Mar 08, 2024 4:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5119

Re: Ultimate Long TM1 quiz

Correct answer : I'll just put a link to MarenC's answer: https://www.tm1forum.com/viewtopic.php?p=83284#p83284 And yes, PAX is also capable to read DBRWs. So, winner of this week is MarenC again and he takes the first place! Question #10: What does each font and fill mean (assume we are using TM1W...
by Elessar
Tue Mar 05, 2024 1:04 pm
Forum: Enhancements
Topic: PickList to show Alias but store Element Name
Replies: 19
Views: 105117

Re: PickList to show Alias but store Element Name

1234-Desciption vs 1234-Desc r iption It took about 2 minutes for me to try to find difference and give up. I've asked Excel and it said that names are really different. Only after I've decomposed them to letters I've found this "r" :) I'm getting old. Regarding EP_explorer's question: Ye...
by Elessar
Sat Mar 02, 2024 12:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5119

Re: Ultimate Long TM1 quiz

Correct answer : There are many ways to do this. Including: Store element name, not its alias. There are several ways: Websheet or book with button. After user fills picklists, he needs to press button. The button launches process which stores element names in a different cell used in rules. Webshe...
by Elessar
Wed Feb 28, 2024 3:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5119

Re: Ultimate Long TM1 quiz

"Quiz Master" has only questions in mind, not solutions :) So the more (good, working) solutions you provide the better

But yes, <StoreAlias=F> is also in my solutions list, and George could receive half a point if he was not MVP
by Elessar
Tue Feb 27, 2024 7:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Throughs not accepting left Joins SQL- but accept where joins
Replies: 3
Views: 526

Re: Drill Throughs not accepting left Joins SQL- but accept where joins

Hello! Reason here can be ODBC, not TM1. You can check it using Cubewise's ODBC-connect, for example: https://code.cubewise.com/open-source/odbc-connect/ Anyway, I prefer not to write complex queries in TM1, but to make views/functions on SQL-server side and use them in TM1 with simple query. Try th...
by Elessar
Tue Feb 27, 2024 7:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5119

Re: Ultimate Long TM1 quiz

Hi, It is Friday so bear with me but I would have said either change the Job Type in the Employee cube to be the updated alias or use one of the aliases to store the old job type value. Maren Good, but we need something automated and admin-friendly. TM1 administrator can forget to change old alias ...
by Elessar
Fri Feb 23, 2024 4:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5119

Re: Ultimate Long TM1 quiz

Correct answer : Firstly, feeder from numeric "Salary" do not know that Job Type is changed, and feeder will not re-fire after Job type is changed. Secondly, "Trace feeders" do not check if target cell is fed. It checks if current feeder written in rule, with current data (like ...
by Elessar
Thu Feb 22, 2024 6:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5119

Re: Ultimate Long TM1 quiz

Anyone? 1 question is still without answer
by Elessar
Sun Feb 18, 2024 12:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5119

Re: Ultimate Long TM1 quiz

OK! But why does "Trace cell" show "fed" with my feeder?
by Elessar
Sat Feb 17, 2024 8:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5119

Re: Ultimate Long TM1 quiz

Correct answer : SKIPCHECK; ['Current Salary'] = N: IF(DIMIX('JobType', !JobType) = DIMIX('JobType', DB('Employee', !organization, !EmployeeList, !Year, !Version, 'Job Type')), DB('Employee', !organization, !EmployeeList, !Year, !Version, !Employee), 0); Using DIMIXes is better than comparing alias...
by Elessar
Tue Feb 13, 2024 7:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5119

Re: Ultimate Long TM1 quiz

Yes :nerd: Ordinary subset-based picklist "subset:JobType:All leaves', where "All leaves" has alias enabled
by Elessar
Mon Feb 12, 2024 6:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5119

Re: Ultimate Long TM1 quiz

Correct answer : 31 0 0. A is not feeding anything, being consolidated. It's children B and C both feed A1. Winner of this week is ascheevel ! Question #6: We are done with feeders, well done! Now new set of questions. There is "Employee" cube with employees list, their job types and sala...
by Elessar
Fri Feb 02, 2024 6:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5119

Re: Ultimate Long TM1 quiz

Correct answer : CubeUnload before re-saving new feeder - ok, it looks like I'm a looser for whom it does not work on 80% environments... I've also found one customer where it works on 2.0.9.12. There are different interfaces for it: manually in Architect, CubeUnload TI function, tm1py function cub...
by Elessar
Tue Jan 30, 2024 6:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5119

Re: Ultimate Long TM1 quiz

That is not correct. CubeUnload stopped clearing feeders in one of the PA versions (I think it was in PA 2.0.0-2.0.4 period, but might be wrong. Does anybody know?). There are different ways to purge feeders, all should be listed in the most detailed answer edit: It was very hard to decide, but you ...
by Elessar
Fri Jan 26, 2024 4:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 48
Views: 5119

Re: Ultimate Long TM1 quiz

Correct answer : 31 16 15 - if rule was just resaved; 31 0 0 - if rule was written from scratch. If a cell is fed once, it will retain being fed even if we delete the whole "FEEDERS;" section. Server will not run through the whole cube looking for fed cells. Winner of this week are aschee...