For just 1 cell you can use 2nd approach.
For example, I usually do not bother and point to "}ElementAttribute_" cube directly, without making VIEW for it
Search found 342 matches
- Thu May 16, 2024 3:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Perf issue : What is more efficient
- Replies: 1
- Views: 12
- Thu May 16, 2024 8:30 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 82
- Views: 14332
Re: Ultimate Long TM1 quiz
Anybody else? I think it's one of the hardest questions in this quiz
@MVPs, @Admins, can you share your thoughts also?
@MVPs, @Admins, can you share your thoughts also?
- Fri May 10, 2024 3:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 82
- Views: 14332
Re: Ultimate Long TM1 quiz
Correct answer:
Winner of this week is MarenC and he shares the lead!
Question #19:
Ok, that was simple. How about that?
Write a feeder for this rule:
Code: Select all
[‘Volume’] => [‘Sales’];
Question #19:
Ok, that was simple. How about that?
Write a feeder for this rule:
Code: Select all
[‘a’] = [‘b’] + 4;
- Mon May 06, 2024 11:09 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 82
- Views: 14332
Re: Ultimate Long TM1 quiz
Leaderboard with points is on the 1st post, you can check there.
There were some errors there (too many of you are starting at "A"! This confused me a bit ), this is now fixed
- Fri May 03, 2024 3:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 82
- Views: 14332
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: 1289
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: 1289
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: 82
- Views: 14332
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: 82
- Views: 14332
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: 82
- Views: 14332
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: 82
- Views: 14332
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: 82
- Views: 14332
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: 82
- Views: 14332
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: 1360
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: 2003
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: 82
- Views: 14332
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: 82
- Views: 14332
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: 82
- Views: 14332
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: 2424
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: 2424
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...