TM1 Forum

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...

UPD: Thanks John Hobson For the 1st April question idea: viewtopic.php?p=5688#p5688. I've amended it to be more catastrophic.

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 ...

This worked for me, thanks!
This MDX has also removed all overfeeding in my model and cleaned my aura!

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...

I'm on vacation, so next question will be on Monday. Stay tuned

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:

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

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 ...

Good! And what about red?

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...

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...

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...

"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

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...

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 ...

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 ...

Anyone? 1 question is still without answer