Search found 334 matches
- Fri Apr 19, 2024 1:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 68
- Views: 8400
Re: Ultimate Long TM1 quiz
Wow, I'm not aware of this! How?
- Fri Apr 19, 2024 12:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 68
- Views: 8400
Re: Ultimate Long TM1 quiz
Correct answer:
This will put "10" to current cell and all leaf cells to the right.
Winner of this week is Adam! (and nice catch with Enter)
Question #16:
What is the minimum dimension quantity in a cube?
This will put "10" to current cell and all leaf cells to the right.
Winner of this week is Adam! (and nice catch with Enter)
Question #16:
What is the minimum dimension quantity in a cube?
- Sat Apr 13, 2024 4:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 68
- Views: 8400
Re: Ultimate Long TM1 quiz
Correct answer : MDX can be used in: Dynamic subsets MDX views TM1SET function Tm1ellist function (nobody has mentioned it, but it's a very powerful function, check it if you are not using it. For example, here I have described how to make dependent picklist using TM1ELLIST: https://advoynev.wordpr...
- Fri Apr 05, 2024 1:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 68
- Views: 8400
Re: Ultimate Long TM1 quiz
UPD: Thanks John Hobson For the 1st April question idea: viewtopic.php?p=5688#p5688. I've amended it to be more catastrophic.
- Fri Apr 05, 2024 11:22 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 68
- Views: 8400
Re: Ultimate Long TM1 quiz
Correct answer : As you have (hopefully) guessed, it was April fool question. There is no correct question here and it will not score :) I'll just put here my answer: "I've learned very much after this case. And this education was very expensive for Company. So I'm now super-puper experienced ...
- Tue Apr 02, 2024 8:46 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX analysis of what you are feeding
- Replies: 10
- Views: 1036
Re: MDX analysis of what you are feeding
This worked for me, thanks!
This MDX has also removed all overfeeding in my model and cleaned my aura!
This MDX has also removed all overfeeding in my model and cleaned my aura!
- Tue Apr 02, 2024 8:36 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Using VBA Replace to alter DBRW references in PAfE
- Replies: 7
- Views: 1694
Re: Using VBA Replace to alter DBRW references in PAfE
Hello! It updates the forumla fine but the revised formula does not work until I edit the cell with F2 and hit enter, after which things are fine. Is the cell format still General, or is it changed to Text? Try Ctrl + Alt + F9 to recalculate all cells, including the ones with updated formulas. Try t...
- Mon Apr 01, 2024 8:52 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 68
- Views: 8400
Re: Ultimate Long TM1 quiz
Correct answer : Value will be spread to non-leaf cells proportionally if a user has admin rights or if Consolidation TypeIn Spreading is not set to Deny. Winners of this week are ardi and MarenC ! Both are getting 0.5 points Question #13: You are looking at a screen showing the entire budget for y...
- Fri Mar 29, 2024 10:43 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 68
- Views: 8400
Re: Ultimate Long TM1 quiz
I'm on vacation, so next question will be on Monday. Stay tuned
- Fri Mar 22, 2024 3:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 68
- Views: 8400
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:
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:
- 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: 1458
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
When searching for optimal dimension order, it does not just minimize ram, but finds optimal balance between speed and ram
- 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: 1458
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: 68
- Views: 8400
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: 68
- Views: 8400
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: 68
- Views: 8400
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: 107003
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: 68
- Views: 8400
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: 68
- Views: 8400
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: 567
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: 68
- Views: 8400
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 ...