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
Search found 344 matches
- 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: 2465
- 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: 2465
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...
- Fri Mar 15, 2024 2:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15122
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 ...
- Wed Mar 13, 2024 12:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15122
Re: Ultimate Long TM1 quiz
Good! And what about red?
- Fri Mar 08, 2024 4:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15122
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...
- Tue Mar 05, 2024 1:04 pm
- Forum: Enhancements
- Topic: PickList to show Alias but store Element Name
- Replies: 19
- Views: 109159
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...
- Sat Mar 02, 2024 12:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15122
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...
- Wed Feb 28, 2024 3:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15122
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
But yes, <StoreAlias=F> is also in my solutions list, and George could receive half a point if he was not MVP
- 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: 619
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...
- Tue Feb 27, 2024 7:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15122
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 ...
- Fri Feb 23, 2024 4:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15122
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 ...
- Thu Feb 22, 2024 6:57 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15122
Re: Ultimate Long TM1 quiz
Anyone? 1 question is still without answer
- Sun Feb 18, 2024 12:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15122
Re: Ultimate Long TM1 quiz
OK! But why does "Trace cell" show "fed" with my feeder?
- Sat Feb 17, 2024 8:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15122
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...
- Tue Feb 13, 2024 7:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15122
Re: Ultimate Long TM1 quiz
Yes Ordinary subset-based picklist "subset:JobType:All leaves', where "All leaves" has alias enabled
- Mon Feb 12, 2024 6:21 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15122
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...
- Fri Feb 02, 2024 6:08 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15122
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...
- Tue Jan 30, 2024 6:38 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15122
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 ...
- Fri Jan 26, 2024 4:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15122
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...
- Sat Jan 20, 2024 1:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15122
Re: Ultimate Long TM1 quiz
No additional actions were announced Just changed the feeder and saved the rule