Search found 338 matches
- Fri May 03, 2024 3:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 73
- Views: 11942
Re: Ultimate Long TM1 quiz
Correct answer : In "}ElementAttributes_<DimensionName>" cube (Yes, I've meant element's attributes, thanks) Winner of this week is ascheevel and he takes the lead! Question #18: Write a feeder for this rule. Note that Volumes are more frequently zeroes than Prices: [‘Sales’] = N: [‘Volum...
- Wed May 01, 2024 1:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Practical experience of PAW AI forecasting / performance
- Replies: 5
- Views: 744
Re: Practical experience of PAW AI forecasting / performance
One question - regarding your '"READ on C: level" comment - just to be clear; Are you saying that you've disabled 'Consolidation TypeIn Spreading', but this needs to be enabled for the forecast spreading function to work for end users? Well, any option forbids forecasting on C: elements: ...
- Mon Apr 29, 2024 3:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Practical experience of PAW AI forecasting / performance
- Replies: 5
- Views: 744
Re: Practical experience of PAW AI forecasting / performance
One my client uses it. Not just users "by themselves", as it is stated in descriptions: you need to provide them a cube with continuous one-dimension timeline, rolling actuals+forecast data, copy and supporting processes. Many users+many time series: works fine. It's just 9 ES implementati...
- Fri Apr 26, 2024 2:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 73
- Views: 11942
Re: Ultimate Long TM1 quiz
Correct answer: 2
Winner of this week is Adam and he takes the lead!
Question #17:
Where are dimension attributes stored?
Winner of this week is Adam and he takes the lead!
Question #17:
Where are dimension attributes stored?
- Fri Apr 19, 2024 1:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 73
- Views: 11942
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: 73
- Views: 11942
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: 73
- Views: 11942
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: 73
- Views: 11942
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: 73
- Views: 11942
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: 1128
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: 1766
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: 73
- Views: 11942
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: 73
- Views: 11942
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: 73
- Views: 11942
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: 2303
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: 2303
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: 73
- Views: 11942
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: 73
- Views: 11942
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: 73
- Views: 11942
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: 108496
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...