MarenC wrote: ↑Fri May 03, 2024 4:16 pm
How did ascheevel overtake Admin in the lead, given he was in the lead the previous week?
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
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...
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: ...
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...
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...
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 ...
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...
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...
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...
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 ...
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...